SQL Tact

On Tuesday I'm looking forward to presenting again at GroupBy Americas on a topic that was voted on by the attending public. This presen...

Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014 , thanks very much for atten...

Here is the downloadable file with all my sample scripts and slidedeck from my  SQL Admin Best Practices with DMV's   presentation from ...

This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit for easy improvements...

A colleague of mine was understandably confused when using the almost-perfect missing index engine in SQL 2008. The engine recommended he in...

Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night!  I hope everyone enjoyed "everyone gets ...

It is a pleasure meeting everyone today at Houston Tech Fest!  The new facility is miles away - literally and figuratively - from the previo...

Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of scripts I've picke...

Thanks for joining me for a standing room only presentation this morning at 9:45am at SQL Saturday #150 Houston.  This is the second year sp...

I work with a motley crowd of developers and have the opportunity to give lunch and learn training sessions on SQL Development. Most recen...

As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving. I've added the following features...

About 3 weeks to go until SQLSaturday #107 at YES Prep Public Schools - North Central Campus, 13703 Aldine-Westfield, Houston, TX, 77039!  ...

Got stored procedure problems?  I feel sorry for you son. Here's a quick query to pull the cached execution plan out of memory. I it...

This news may be a few months old, but it is worth noting that there is now a column called open_transaction_count in the sys.dm_exec_sessio...

A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's toolbox.  A simp...

Here's my official blog page for my presentation on SQL Server Admin Best Practices with DMV's from the Houston TechFest 2011 on Oc...

First off, big thanks to the 375+ people who showed up for SQL Saturday 64 in Baton Rouge on August 6. It was a fantastic event. Major t...

Here's the link to a .zip file of my slidedeck and all sample demo files from today's SQL Saturday Pensacola.  This is my DMV Overvi...

Thanks to a great room at 8:30AM at SQL Saturday Houston in Bammel, TX on January 29, 2011. I had to leave town before lunch but it was a ...

Here's the .Zip file link to slide deck and scripts (including the scripts I didn't get to) for my talk on DMV's from Houston T...