Number of sessions per database

Sometimes when we need to do some maintenance on a SQL server, you need to verify which users are connected...

Powershell, Me and the MCM

If you haven’t heard yet, Microsoft has made some significant changes to the MCM program.  The changes make the certification...

Powershell, Me and the MCM

If you haven’t heard yet, Microsoft has made some significant changes to the MCM program.  The changes make the certification more accessible to the masses. You can read more...

Select * from dbo.FAIL: invalid metadata in views and user defined functions

This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I...

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