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...

Book Plug: Say Goodbye

I read a lot, and often marvel at the effort that goes into writing them, and I think I get...

SSIS to SQL Server Data Type Translations

I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS...