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 timing out. Viewing the Estimated Execution Plan
SQLServer
A collection of 13 posts
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 easier to provide this application to end
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 concerned about the data recovery options available
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 of the techie books that I bought
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 series of articles on this subject by
Inside Microsoft SQL Server 2005: The Storage Engine
During 2007, I unexpectedly achieved a long-held ambition by increasing the number of books I regularly read (as opposed to merely buying, then leaving them to languish on the bookcase!). I read plenty of techie books of course, but also
SQL 2005 Unleashed
Many moons (and about four jobs) ago, a wise DBA by the name of David Hanson once recommended to me a book called Microsoft SQL Server 2000 Unleashed. I took his advice, bought a copy, and it rapidly became one
MSDN-a-Go-Go
Last week I had the pleasure of attending a two-day MSDN event in Harrogate focusing on the upcoming Visual Studio 2005 and SQL Server 2005 releases. It was one of the better and more enjoyable MSDN roadshows I've been on,