Relational Types.

As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...

Should I have AutoGrowth enabled on my SQL Server Database

I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...

Thanksgiving Bloopers

I'm slow to get this out, but I finally rendered the raw bloopers from November. Enjoy.

Part 1

Part 2

Part 3

The iPad, So Far

In the front yard, using the iPad & SQL Monitor
After a great deal of unseemly begging, I managed to acquire an...

Tis the Season

This month has been quite the month for change in my family.  The changes that we are experiencing did not...

Tis the Season

This month has been quite the month for change in my family.  The changes that we are experiencing did not end with the birth of our baby girl two...

Two Digit Year Cutoff

I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link...

Viewing RING_BUFFER_OOM Errors

Onion Ring Buffer?
A client asked a co-worker to take a look at a query for reviewing  RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. ...

Busy Week

It’s going to be a busy week for me. At last count, I had over 40 comments for my T-SQL...

Can You Dig It? – Missing Indexes

She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...