SQL Server – Using Tools to Analyze Query Performance

Here is the session I gave for the techies at Microsoft about in-built tools available in SQL Server to analyze...

The Genealogy of Baseball Teams

The Genealogy of Baseball Teams chronicles the origin and evolution of baseball teams from every major league from the inception...

Today’s an lol kind of day #lol2day

T-SQL Tuesday #051: Always Hedge Your Bets

  
It's time for T-SQL Tuesday again and this month's host is my former co-worker, the @SQLRNNR himself, Jason Brimhall.  Jason's...

T-SQL Tuesday #51 – Place Your Bets

It’s T-SQL Tuesday time again and Jason Brimhall is hosting this month’s event. He used to live in Las Vegas,...

T-SQL Tuesday#51 - Place Your Bets - In-Place Upgrade.

I’m not much of a
betting man, but if I had to bet that I would participate in this month’s T-SQL
Tuesday...

Using PowerQuery with Email

At our last MVP summit, I sat in on a session on PowerQuery. Our presenter, who is pretty passionate about...

Who are your victims?

Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...

Why I just became a Microsoft Employee

I have been an independent consultant (IC) for quite a while now.  In an amazing number of coincidences, or just plain...

Why is Your SQL Server Slow? Here’s a Hint

I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server....