Sort – Is it Really a Blocking Iterator?

SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.
A non-blocking iterator gets rows in and sends rows...

PASS Summit: Things to Do, People to See

PASS Summit is nearly upon us. I’m excited to be attending my second Summit in Seattle and cannot wait to get there to see everyone. With one Summit and...

Quick Schema Auditing

I was working on a demo recently and needed to show that a little monitoring can help you catch schema...

SQLSaturday Tampa Announced For February 28, 2015

SQLSaturday Tampa is the first SQLSaturday in Florida for 2015, scheduled for February 28th, 2015. The event is held at...

Headed to the PASS Summit 2014

I can hardly believe how fast this year has flown by. My favorite SQL Server conference of the year, the...

PASS Summit 2014

Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we...

Managing Geeks – A journey of leading by doing

I am proud to share that my good friend Andy Leonard has just released a new book. This is also...

Add Database File on Database invloved in DB Mirroring

Add Database File on Database invloved in DB Mirroring

Add Database File on Database invloved in DB Mirroring.

SQL Server 2014 Backup and Recovery

In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my...