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

Setting Goals for 2010

Most people set their New Year resolutions for the new year at this time. We know from history that many...

Would Third-party Product Driven/Vendor Sessions Benefit User Groups and Community Events?

In the the couple of years I have been involved in the SQL Server community I have noticed that there...