SQLSaturday#59 - Interview with Robert Pearl (1st in series)

SQLSaturday#59 - Interview with Robert Pearl (1st in series) - Say what? 
As we get the countdown under way, I caught up...

TSQL Tuesday #11: Messages and the Clammy Seduction of the Print Statement

Note: Updated 10/28 based on conversation in the comments, and 12/10 with Denali info.

TSQL Tuesday #11: Misconceptions in SQL Server
This...

T-SQL Tuesday #12 - Misconceptions

It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...

TSQL Tuesday Misconceptions in SQL Server

I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting...

Why do I contribute to the SQL Server Community?

As an active speaker and volunteer in the SQL Server community I am often asked why do I do it? ...

Forgotten T-SQL Cheat Sheet

You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!
Yessir,...

Listing members of a group in SQL Server.

In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...

PASS Update #44 (Budget)

I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...

Return Values from XP_CMDSHELL

Let’s be clear: I don’t recommend the use of xp_cmdshell as a general tool. It ought to be used when...

Running Totals for Each Group

A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...