August 2009 - Posts

• A Couple of Invoke-SQLCMD Issues

  In working on a PowerShell script to load data into SQL Server, I decided to use the Invoke-SQLCMD cmdlet included in the snapins provided with SQL Server 2008, and found a couple of issues you should know about. First, as a matter of best practices, Read More... Posted Friday, August 14, 2009 1:33 PM by AllenMWhite | 6 Comments Filed under: PowerShell, SQL Server 2008

• User Group Presentation: Essential Database Management - Top Ten Recommendations

  In the August 13th 2009 meeting of the Ohio North SQL Server Users Group (ONSSUG), Paul Randal and his wife Kimberly Tripp , will run you through their top-ten database maintenance recommendations, with a lot of tips and tricks along the way. This top Read More... Posted Friday, August 07, 2009 8:56 AM by AllenMWhite | 2 Comments Filed under: Database Administration, User Group Meetings

• The Basic Truths about Data

  In reviewing database development best practices recently I'm reminded of an attitude I've found prevalent in many development shops, that the database is just "a place to put stuff". As much as I've come to expect this attitude, it continues to upset Read More... Posted Monday, August 03, 2009 2:30 PM by AllenMWhite | 3 Comments