The Advantage of GUIDs

I never liked GUIDs, not really using them in most of my development until I had a conversation many years...

Comments on the Bamboo Touch

I bought a Bamboo Touch over the holiday break, it’s a multi-touch pad with stylus. Easy install, basically plug in...

Primary Key Discovery II

In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...

Installing SQL Server 2008 and 2008 R2 on Windows Server 2008 R2

There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and...

PASS Summit Survey – Check Your Email

Not sure if it went to the entire PASS mailing list or just those that have attended a Summit, but...

Service Broker Basics - Part Deux

Last week I introduced the Service Broker Basics . Today I'd like to cover some of the "plumbing" - the components that...

Webcast Tomorrow - Dynamic SSIS: Using Expressions and Configurations

Join me tomorrow at 1:00pm CST as I present "Dynamic SSIS: Using Expressions and Configurations" for the PASS DBA virtual...

TSQL Tuesday #2

I’ve wracked my brain for some bit of puzzle that I could present as part of TSQL Tuesday #2 and I...

IN vs INNER JOIN

Often in forum threads discussing query performance I’ll see people recommending replacing an INNER JOIN with an IN (or recommending...

We Interrupt Your Regular SQL Blogging For This Announcement…

EXEC sys.sp_addextendedproperty 
   @name = N'IsWifePregnant', 
   @value = N'True',
   @level0type = N'USER',
   @level0name = N'Kendal.VanDyke' ;

EXEC sys.sp_addextendedproperty 
   @name = N'ExpectedDueDate',
   @value = N'August 2010',
   @level0type = N'USER',
   @level0name...