SQLServer

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

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