SQL 2008 - Missing Indexes Hints
Improvements to the Execution Plan UI in SQL Server Management Studio 2008 sure do make it a doddle to improve query execution time.
A client just reported that a particular stored procedure kept
SQLServer
SQL Server 2008 SP1
SQL Server 2008 SP1 has been released! The big news as far as I can tell is that SSRS Report Builder 2.0 can now be deployed via ClickOnce, which should make it
SQL Server Point-in-Time Restore
One of the multiple hats that I’m currently wearing for a client is that of SQL Server DBA. In this guise, I have recently fielded a couple of email queries from users
Tech Book Round-Up 2008
Despite the plethora of blogs, podcasts, and online videos that currently abound, I still prefer to get most of my technical learning via the trusty old dead-tree format.
Here’s a quick round-up
Versioning Databases
IM received this morning:
Morning young man. Do you know of anywhere that I can get hold of best practices for stored procedure source control?
My response was to recommend checking out the