Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

I’m excited to announce the release of a new open-source project that fully automates HammerDB benchmarking for SQL Server using Docker. If you’ve ever needed to run TPC-C or...

Creating a Local Model Chatbot on Windows

After my session at VSLive last week, I had a few questions from the audience. I’m adding some of these into blogs, and this was one: How do I...

To refer and to be referred

Referrals have never been more important in the job market. They’re no longer nice to have; in many cases, they’re what gets your résumé through the door. I’ve been...

T-SQL Snapshot Backups on Availability Group Secondary Replicas

One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups. The ability to leverage the snapshot capabilities of modern storage arrays to take application consistent...

A New Word: Dorgone

dorgone– adj. wondering if you could slip away from an event or group conversation without anyone noticing your absence. I’m not often concerned about announcing my arrival or departure...

Advice I Like: Lots of Ideas

“A multitude of bad ideas is necessary for one good idea” – from Excellent Advice for Living Whenever we read about the success of someone or something, we often...

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

This is the companion to Why sys.fn_dblog...

Tell It Once: Setting Up Claude With Skills and MCP Servers

Many of us use AI the same way every single day. Open a tab. Paste in a question. Copy the answer out. Fix what it got wrong. Then tomorrow,...

T-SQL Tuesday #202: The Two Outages I Won't Ever Forget

My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages. Two nights I still remember minute by minute, and what I do differently because of...

Using the Data API Builder–VS Live San Diego Resources

Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo:  https://github.com/way0utwest/DAB-Experiments