March 2010 - Posts

• Document, Document, Document

  A while back I blogged about using Checklists , but there's another task you want to incorporate into your workflow - documentation. Now, I'm not just talking about documenting the logic, system flow and data and structure changes, I'm also talking about Read More... Posted Saturday, March 13, 2010 2:43 PM by AllenMWhite | 1 Comments Filed under: Database Administration

• Keep Your Data Clean

  In working with client data you start to notice trends that raise flags in your mind. In my case I'm looking at data and seeing a lot of columns that have NULL in the column where a NULL doesn't mean "I don't know", it means "I was too lazy to put something Read More... Posted Friday, March 05, 2010 11:44 AM by AllenMWhite | 8 Comments Filed under: Database Administration

• Speaking at SQLSaturday #33 in Charlotte

  I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather SQL Server Performance Data with PowerShell . The event takes place at the Microsoft Charlotte Offices on 8050 Microsoft Read More... Posted Thursday, March 04, 2010 11:33 AM by AllenMWhite | 0 Comments Filed under: Database Administration, PowerShell, Speaking, SQL Server 2008, User Group Meetings

• Bookstores and Databases

  My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at dinner celebrating my wife's birthday she was telling me about setting up the shelves in the new bookstore they're opening this week in our Read More... Posted Wednesday, March 03, 2010 9:36 AM by AllenMWhite | 2 Comments Filed under: Database Administration