XQuery for the SQL Server DBA: XPath
“I don’t always query XML, but when I do; I drink dos equis” – Dan Sorensen. This is the first tutorial in a complete series on XPath/XQuery. The master post for … Continue reading
What I Learned as a Sql Sat Presenter
DBA = awesome at improv As a brand new presenter I was a little worried that I would be talking to an empty room. I had passed a friendly invite … Continue reading
T-SQL Tuesday #48 – Cloud that Broke the Camel’s Back
One of my regrets of not having started blogging sooner is missing all the great T-SQL Tuesday blog parties that have been hosted in the past. That is something I plan to … Continue reading
SQL Saturday #265 – Protect the database
I’ve been spending the last couple days refining my presentation for SQL Saturday #265 in Portland. I’m really excited to return to PDX as it’s where being a DBA started … Continue reading
Change Data Capture – Lessons Learned
I like where Microsoft is going with Change Data Capture (CDC). In a data warehousing scenario where you only need what’s changed since the last load it’s a magical solution. There is a … Continue reading
Debrief, it’s important (part two)
In part one I shared personal history in an attempt to identify the goal of a “post incident debrief” – we also used to call them “after actions” or “AAR”. My current company calls … Continue reading
Debrief, it’s important (part one)
Recently I attended a Red Gate SQL In The City event. Steve Jones gave an excellent session filled with good stuff but my favorite quote of the day was “debrief, it’s important”. I wanted to … Continue reading
Seriously bro, you gotta learn to triage
Ah the French. We like to poke fun at those guys. Even now I struggle to write seriously without breaking into a line from dumb and dumber… “I don’t know, Lloyd. … Continue reading
Database administration isn’t an art
A few years ago I was reading up on SQL DTA in a Microsoft Press book by Mike Hotek. In it, he breaks for a moment to make the point that he’s tired of people … Continue reading
Russ Thomas - SQL Judo 