Keeping your SQL Server DDL Trigger Audit Table in Check
Tip : Keeping your SQL Server DDL Trigger Audit Table in Check
Monthly Archive: August 2010
More info on Red Gate SQL Storage Compress 5.0
The other day I wrote a blog post about my initial trials with SQL Storage Compress 5.0. For the most part my experience with the product was fantastic, however there were a few areas...
First Look : Red Gate SQL Storage Compress 5.0
Recently, Red Gate Software released a new version of their product called SQL Storage Compress 5.0. This is an alternative to using the native Data Compression and Backup Compression features introduced in SQL Server...
SQL Server 2008 R2 Best Practices Analyzer
Maybe I'm a little late to the party, but I thought I would share with you the most recent release of Microsoft's Best Practices Analyzer for SQL Server 2008 R2 (you can also read...
Bad Habits to Kick : Inconsistent naming
Your naming scheme isn't important, but being consistent is crucial.
SQL Server updates – from Microsoft and from 3rd parties
Ola's Index Maintenance scripts On August 3rd, Ola Hallengren (blog) released a substantial update to his Backup, Integrity Check and Index Optimization scripts – allowing you to more finely tune the object selection process. ...
SQL Server DDL Triggers to Track All Database Changes
Tip : SQL Server DDL Triggers to Track All Database Changes