I built a free library of runnable SQL Server demos. Each reproduces a real production problem on purpose, measures the fixes, and checks its own predictions on SQL Server...
2026-11-09 (first published: 2026-10-29)
420 reads
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is one of those technologies that I want to understand better. As AI becomes part of...
2026-11-06 (first published: 2026-10-23)
144 reads
For me, the objective is straightforward: have a backup strategy that is reliable, understandable, maintainable, and, most importantly, restorable. A successful backup job is good news. A successful restore...
2026-11-03
35 reads
The STIG is detailed, which is a good thing, but I found myself wanting something a little more practical for day-to-day DBA work. Something I could open, work through...
2026-10-05 (first published: 2026-09-22)
535 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what kind of stories would come out of it.
The topic was simple:
That one SQL Server outage...
2026-09-25 (first published: 2026-09-15)
256 reads
I am excited to host T-SQL Tuesday for the first time. I want to hear about that one outage that stands out in your memory. We all have incidents...
2026-09-01
188 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo subscription cost. This was meant for a private demo so I can learn more about...
2026-08-24 (first published: 2026-08-13)
624 reads
No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work in another because every SQL Server instance has different...
2026-08-21 (first published: 2026-08-04)
735 reads
Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or...
2026-08-14 (first published: 2026-07-30)
436 reads
I needed to do some research because there is more to #temp tables than simply creating one and using it. As I started digging into the topic, I realized...
2026-08-11
345 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers