SQL Server Storage Internals Part 2 - Partitions and Allocation Units

 
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...

SQLRally Session Submissions

Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of...

2010: The Year In Review

“Quitting smoking is easy; I’ve done it dozens of times.” the great American writer Mark Twain once said.

Although I’ve never...

Dashboard and KPI Design–the Definitive Industry Standard

First of all, the title is intended to be
a little tongue-in-cheek – just a little bit.  I’ll explain.  Last week
while I...

Email Pruning

Email consumes a pretty significant chunk for me. Email for my day job, email for my blog, email from friend...

Generating RING_BUFFER_OOM Errors

Onion Ring Buffer?
Ever think to yourself, “hmm, I wish I could generate me some RING BUFFER_OOM errors”?  This request happened...

Last Call SQLRally Call for Presenters

Go SQL! Go SQL! It’s the last day and the last chance (last dance?) to submit a session for the...

PASS Election Review Committee - We Need Your Input!

The PASS Election Review Committee has geared up and we've started looking at the process of the entire election process...

Pragmatically Thankful

This season, as we continue to grow and partner with some of the best of the best in the industry....

Preventing Subscriptions from Blocking Interactive Report Executions

A consulting client recently asked how they could resolve a capacity-planning issue
on their production report server.  They manage a busy...