• Carpe Datum

    quote of the day - not focusing on the past

    • 0 Comments
    "My interest is in the future because I'm going to spend the rest of my life there."  - Charles F. Kettering
  • Carpe Datum

    Object Search - Search Only What You Need

    • 1 Comments
    At the top of the Object Explorer Details (OED) pane in SQL Server Management Studio 2008 there is a box to type in a search term for database objects. You can use the exact name, or use standard T-SQL wildcards to find an object such as a table or a...
  • Carpe Datum

    Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance

    • 12 Comments
    Microsoft likes for its people to be certified in as many technologies as possible. Personally, I find certifications useful since they help me focus my study, but I don't think that certification = expert. It's just one part of the puzzle. To that end...
  • Carpe Datum

    Using PowerShell to Discover Login Failures on SQL Server

    • 1 Comments
    If you have PowerShell installed (even if it isn’t the SQL Server 2008 provider), you can and should check your servers each day to see if you have login failures. This is very useful to help ensure that your server is safe and secure. Whenever someone...
  • Carpe Datum

    SQL Server Chargeback?

    • 1 Comments
    Whenever economic situations change, the IT department has to adapt. The situation in many shops is that IT is a recurring cost, carried by the entire business. What that means is that your IT department is asked to service the entire organization, no...
  • Carpe Datum

    Quote of the Day - on Being Careful with Free Gifts

    • 1 Comments
    No commentary needed, I think: There is always free cheese in a mousetrap. - Anonymous
  • Carpe Datum

    SQL Server Background Picture

    • 1 Comments
    I use a particular background in my presentations that I've been asked about a lot. I thought I would share that here: http://blogs.msdn.com/photos/buck_woody_-_msft/images/9286756/original.aspx
  • Carpe Datum

    "Kitchen Drawer" Databases

    • 2 Comments
    Almost everyone I know has a drawer in the kitchen that ends up overstuffed, containing rubber bands, homework, pencils, a non-matching butter-knife, some string, a dog leash and whatever else. And in a lot of companies you'll see the same thing, only...
  • Carpe Datum

    Free User Group Support

    • 1 Comments
    As you know, I'm a big proponent of User Groups. I've been in charge of many, and I still present at them and attend my local PASS chapter. I just found a fantastic free resource for user groups - free content, advice, and even money!  Check it out...
  • Carpe Datum

    Of Mainframes and Rivers

    • 1 Comments
    I started working with technology a long time ago - long enough to remember the mainframe way of life. Back then, a select group of folks controlled access to "the computer". On certain desks stood terminals, and programs were all custom-written...
  • Carpe Datum

    Quote of the Day: Negative Recursion

    • 1 Comments
    Happy Friday the 13th!  Remember: "It is bad luck to be superstitious."
  • Carpe Datum

    Portland User Group

    • 2 Comments
    I spoke at the Portland User Group in Oregon last night, and what a great group of folks! I spoke for over two hours on the improvements in SQL Server 2008 for the Developer. As I spoke it reminded me that all over the world, people meet to talk about...
  • Carpe Datum

    Scripts, Blogs, and Learning

    • 5 Comments
    I received an e-mail from a reader asking if I could post a link to a script he's documented in an article. I'm always happy to do that, but there are some things you should know about ANY script you find on the web, and while I'm at it, for how you read...
  • Carpe Datum

    Of Patterns and Practices

    • 1 Comments
    Does the data professional need to know about Patterns and Practices? Well, if you're on the development side of things, you're more than likely already familiar with this term. At the bottom it's a list of "best practices" that you use to solve...
  • Carpe Datum

    PowerShell Script of the Week - Script and Compare Permissions

    • 2 Comments
    One of the biggest issues in compliance is finding out who has permissions to what. And once you're done with that, you need to track when that changes. PowerShell to the rescue!  Here's what I'm using for that: 1: # Scripting database objects: ...
  • Carpe Datum

    Quote of the Day - Software Development and Miracles

    • 4 Comments
    I was sent this week's quote by my good friend Chris Pelley. Not sure who it is attributed to, but it sure sounds right to me: "Walking on water and developing software from a specification are easy if both are frozen."
  • Carpe Datum

    Building Your Toolbox

    • 1 Comments
    Years ago, "finish" carpenters would travel from job to job to find work. When they showed up on site, they would speak with the foreman, who would ask to see their toolbox. See, in those days, there were no power tools, so the carpenter carried...
  • Carpe Datum

    Server Consolidation Done Right

    • 1 Comments
    Consolidating your servers is all the rage, especially since you can save money by doing it. You can save not only on the hardware, but the licenses. To do that properly, you need a strategy. You start by detailing what you have, and then lay out the...
  • Carpe Datum

    Service Broker and the Need for Planning

    • 1 Comments
    I mentioned yesterday about the database I was using implemented Service Broker. I wanted to mention (again) the incredible need for planning when you're setting up a project. Whenever you're working on something as distributed as Service Broker, you...
  • Carpe Datum

    Check that database before you restore it...

    • 1 Comments
    I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as...
Page 1 of 1 (20 items)