Server Side trace

Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using...

Filling in Data Potholes with Recursive CTEs

Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....

Get SQL Scripts Manager for Free

Red Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes...

How To Choose A Topic For Speaking

“The human brain starts working the moment you are born and never stops until you stand up to speak in...

Interlude: SSMS tips

Introduction

I know I said I was going to add more information about the CDC system in this post, but I...

Lunch Story #3–No Free Sandwiches

This time the plan was to go to Arby’s because it was close and my friend Rob had coupons for...

PASS Summit 2010 Session Eval Results

Speakers and bloggers alike crave feedback (good or bad) so I was excited to see my session evaluations from the...

PASS Summit 2010 Survey Results

As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit....

PASS Summit Speaker Evals – THE ANALYSIS

Rule: No Sushi with Adam within 24 hours of session
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS...

Spreading the DBA Gospel (from Old English, god spell "good news")

 
There are times when I wonder why I get so few comments on this blog, however there are assumptions I...