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

Video Featured on SQLShare

I didn’t have a chance to blog this yesterday (January 11, 2010), but my most recent video, Dynamic SQL Using...

T-SQL Tuesday #2 – Data Conversions

Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...

January OPASS Meeting Tonight

Tonight is the January meeting for OPASS and we have a great schedule for the evening.
Robert Hurwitz a developer for...