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 where I felt bit uneasy – and wanted to address those concerns.  Recoverability Since I am […]

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 2008.  In order to utilize Data Compression, you must be running Enterprise Edition or above (and […]

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 the original blog announcement from CSS). Let me be clear: this tool is not just for […]

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); and for stored procedures, I am partial to the Entity_Action naming convention (e.g. dbo.Customer_Create, dbo.Customer_Update).  I […]

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.  Over this past weekend he also updated the error handling to get around some blocking issues.  […]