Filling in Data Potholes with Recursive CTEs

Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....

Spreading the DBA Gospel (from Old English, god spell "good news")

 
There are times when I wonder why I get so few comments on this blog, however there are assumptions I...

Updated SQLRally Flyer

We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...

Lunch Story #3–No Free Sandwiches

This time the plan was to go to Arby’s because it was close and my friend Rob had coupons for...

How To Choose A Topic For Speaking

“The human brain starts working the moment you are born and never stops until you stand up to speak in...

Strange issue while using IDENTITY values in INSTEAD OF triggers

Found an interesting issue last week....it goes like this:

If you are using INSTEAD OF triggers on views (in SQL 2005)...

Interlude: SSMS tips

Introduction

I know I said I was going to add more information about the CDC system in this post, but I...

Intel Sandy Bridge Processor Machines Coming Soon!

If you are in the market to buy or build a new laptop or desktop computer, you might want to...

SQL Server 2005 SP3 Cumulative Update 13 Released

Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday,...

SQL Server Scripts Manager From Redgate Software

Redgate Software has released a useful free tool called SQL Server Scripts Manager. I was happy to be included as...