Archives: August 2009
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)
0 comments, 517 reads
Posted in Allen White on 14 August 2009
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)
0 comments, 284 reads
Posted in Allen White on 7 August 2009
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)
0 comments, 367 reads
Posted in Allen White on 3 August 2009