Take The Survey from the SQL Server Connection Team

Saw this today, a survey posted to the SQL Protocols blog by Principal Group Program Manager Raghu Ram. I took...

Tools I Use to Scan for SQL Servers

I was having a Twitter conversation on this yesterday and naturally Aaron Nelson (blog | twitter) popped in with "PowerShell!"  I like PowerShell,...

Return of Index Analysis Part 3

Let’s Anaylze An Index!Time for part three of my continued Index Analysis query.  The previous posts in this series are:...

SQLSaturday#59 Interview Series Continues...with Steve Jones

 SQLSaturday#59 Speaker Interview Series #2
Yesterday, on the PearlKnows Blog, I kicked off the SQLSaturday#59 Speaker Interview Series, with a bit...

Common SQL Server Mistakes – Equals NULL

One thing that I don’t see a lot, but it still happens with people new to SQL Server is the...

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

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

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

Slides and Demo from Midlands PASS Presentation - October 12, 2010

 Here are the slides and demo script from the presentation on Understanding SQL Server Query Processing.
 

Lightening Talk On Covering Indexes Ka-chow! Ka-chow!

“I’m a precision instrument of speed and aerodynamics.” That’s what Lightning McQueen tells Mater when they first meet in Cars....