SQL Server 2012 AlwaysOn Availability Groups – Part 1

In the last weeks and months I have prepared tons of SQL Server 2012 content for my
own SQL Server 2012...

SQL Server 2012 Special Ops Tour - NYC

Tomorrow, Thursday, March 22, 2012, the official Microsoft SQL Server 2012 Special Ops Tour continues its 12-city trek around  the...

SQL Server Crossword #4

To mark my 31st Birthday today(gifts are of course most welcome) here’s a SQL Server Crossword for you to enjoy. You...

SQL Server Database Mirroring Tips and Tricks, Part 2

If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common...

SQL Tribal Knowledge needs editors!

A while back I invited the unpublished masses to submit abstracts for a new-author-written SQL book – called Tribal SQL – and the...

STOP! Consolidate and Listen

I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance,...

Whitepaper: Demystify Tempdb Performance & Management

Whitepaper: Demystify Tempdb Performance & Management
Demystify Tempdb Performance & Management

There are many misconceptions and myths about tempdb and purported best practices are...

Wish you were here

When I was growing up, we used to sit round the t.v. (families only had one in those days) and...

Debugging query timeouts by sampling blocking – part 2

In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...

Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)

Free E-Book: Introduction to SQL Server 2012

Ross Mistry and Stacia Misner have again done a wonderful job on this free...