Monthly Archive: August 2010

More info on Red Gate SQL Storage Compress 5.0

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

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

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...

What's in a name?

What's in a name?

In a lot of my projects, the issue of naming/coding conventions comes up.  I am a big fan of PascalCase/plural for tables and views (e.g. dbo.CustomerAddresses, dbo.OrderDetails), PascalCase for column names (e.g. FirstName, HomePhone);...

SQL Server updates – from Microsoft and from 3rd parties

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. ...