• Carpe Datum

    Free T-SQL Beautifier

    • 5 Comments
    I do love me some good-looking code. Sure, the syntax has to be there, and the code has to be correct and all that, but I'm old-school, and I think pretty code is easier to read. I'd love to have a "code beautifier" built right in to SQL Server...
  • Carpe Datum

    Versioning the Database

    • 2 Comments
    If you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entire...
  • Carpe Datum

    Another Reason to Use A Special Service Account

    • 1 Comments
    When I'm asked what the least-used feature of SQL Server is, I often have to reply that it is "good security". Many installations take all the default settings, and most use programmatic security rather than the features built in to SQL Server...
  • Carpe Datum

    Quote of The Day - Salt Water Cures Everything

    • 1 Comments
    Just got back (late last night) from our Florida vacation. I really miss "home" - Safety Harbor, Florida - and while I was there I saw a quote from my favorite author, Isak Denison: "Anything can be cured with Saltwater - Tears, Sweat,...
  • Carpe Datum

    PowerShell Provider for SQL Server Script of the Day - Script all objects

    • 1 Comments
    If you're using the PowerShell provider for SQL Server, you can quickly script out all of the objects in a "directory" using a simple method. Just navigate to the directory of objects you're interested in, say the "Views" of a certain...
  • Carpe Datum

    SQL Server 2008 System Views Poster

    • 1 Comments
    The new poster is here! The new Poster is here!  Get your's while they are hot: http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en
  • Carpe Datum

    Quote of the Day - Warren Buffet on Risk

    • 2 Comments
    Another one of my favorite quotes comes from Warren Buffet - I think about it every time I start a new project: "Risk comes from not knowing what you're doing. " -- Warren Buffet
  • Carpe Datum

    Top Queries DMV

    • 0 Comments
    I spoke at the Pacific Northwest SQL Server User Group last night, and we covered Performance tuning. I promised to blog a script that uses the "query_stats" DMV and a CROSS APPLY to find the top queries - there are lots of these on the web, so here's...
  • Carpe Datum

    Have You Backed Up Your Database Master Key?

    • 1 Comments
    If you have encrypted columns in a database or certificates used to create them, you need to make sure that you back up the Database Master Key as part of your maintenance, and then protect that backup file. Here's the short version of the command: BACKUP...
  • Carpe Datum

    Quote of the Day - The Inevitability of Change

    • 0 Comments
    The last (incredibly long) election was touted as being all about "change". I think with all the news today, people are finding out that not all change is good change - but it is in fact inevitable: "Change is the price of survival"...
  • Carpe Datum

    Set The Owner Of all Objects Using SQL Server PowerShell Provider

    • 0 Comments
    I'm going to standardize a bit - or at least try - in this blog. On Monday's I'll share something new that I've learned to do with PowerShell - sometimes with the PowerShell Provider for SQL Server 2008, and sometimes just using PowerShell and the SMO...
  • Carpe Datum

    Data Retention Strategies and Server Consolidation

    • 1 Comments
    I deal with a lot of folks that are going through server consolidation exercises. These days everyone immediately thinks of Virtualization - which will consolidate servers onto a single instance. But in many cases it's actually smarter to evaluate the...
  • Carpe Datum

    Posting Comments to MSDN Blogs

    • 2 Comments
    I had a ready respond to my post yesterday via e-mail. He asked why I didn't have "Anonymous" comments enabled on the blog, and told me that I would get a lot more responses if I did. And he is correct - I did have the settings on this blog...
  • Carpe Datum

    PowerShell Unleashed

    • 2 Comments
    I just finished reading the latest version of PowerShell Unleashed last night. Although there are some really great chapters (like the discussion on security), I don't recommend this book as your first introduction to PowerShell. To be fair, the authors...
  • Carpe Datum

    This is NOT a New Year’s Resolution Blog Entry

    • 1 Comments
    I read a lot of blogs, as I’m sure you do. Many of them lately tell me about the author’s New Year’s resolutions – and I’m sure those are important. But I don’t think you care about mine. Neither do I. In fact, as a...
  • Carpe Datum

    Is a Comprehensive Data Map Possible?

    • 2 Comments
    Most of us design a "CRUD" (Create, Read, Update and Delete) matrix for an application's database. And if you are really thorough, you create a data dictionary that shows what data goes where and why. The problem with these documents is that...
  • Carpe Datum

    Service Accounts Redux

    • 1 Comments
    The other day I made a post that mixed a couple of concepts. I mentioned that you should always use a separate set of Windows accounts for the SQL Server Engine and Agent services. I also mentioned security ramifications. The fact that the SQL Server...
  • Carpe Datum

    Are You Archiving Your Data?

    • 1 Comments
    Computer technology has been a fixture of business now for several decades - but I'm not sure it's a "mature" industry yet. Sure, we have a few standards, and some dominant vendors and a strong workforce - all earmarks of a mature industry ...
  • Carpe Datum

    Finding the "Real" Problem

    • 2 Comments
    I think half of what I do as a DBA is "spelunking" - exploring the situation at hand to see what the real problem is. Nine times out of ten, the thing that was presented to me isn't the thing I end up working on. So where do you start with this...
  • Carpe Datum

    Which Edition is Right for Me?

    • 1 Comments
    I had a discussion the other day with someone who had some questions about Enterprise Edition of SQL Server 2008. In many cases, I've seen someone not using the "right size" of SQL Server. Many installations really call for Enterprise Edition...
  • Carpe Datum

    Quote of the Day - Trusting the Government to Get Things Done

    • 1 Comments
    Because, hey, they have such a great track record, right?   "We could certainly slow the aging process down if it had to work its way through Congress." -- Will Rogers
  • Carpe Datum

    Quote of the Day - The Best Method of Learning

    • 0 Comments
    Most people know a lot - but they could know a lot more: "Generally speaking, you aren't learning much when your mouth is moving." -- My Mother
Page 1 of 1 (22 items)