The Twelve Days of (SQL) Christmas

Once upon a time a group of twelve bloggers agreed to each pick a post (or posts)  they found interesting...

Why I’m All For 24HOP Showcasing 24 Women Speakers

This is not the HOP you are looking for.
I’ve been thinking about the upcoming 24HOP event planned for March 15...

PBM and PowerShell

The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...

Merry Christmas

This is just a short post for a Friday and not just any old Friday either, Santa is on his...

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