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)
427 reads
I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included....
2026-11-06 (first published: 2026-10-28)
304 reads
Here is another short video (~ 15 minutes). This is by the author of The Power of Habit, Charles Duhigg. In this video, he delves into why we procrastinate...
2026-10-30 (first published: 2026-10-27)
1,076 reads
I had a briefing for the 2026 PASS Data Community Summit, which is just a couple of weeks away. Amongst a bunch of admin type stuff, there was a...
2026-10-27
26 reads
Your AI is busy. But do you know what it's worth? Most companies can tell you how much AI they use. Few can say what it's worth. Here's how...
2026-11-02 (first published: 2026-10-26)
277 reads
I wear many hats in technology, and one of those is as a (cyber)security professional. Needless to say, the timeline around the PHP2Shell vulnerabilities has me interested. SecurityWeek has...
2026-11-04 (first published: 2026-10-26)
264 reads
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of the improvements. Here’s one that’s been around quite awhile, but while discussing the product with...
2026-11-02 (first published: 2026-10-26)
249 reads
Founded in 2014 by three data enthusiasts, Joyful Craftsmen has grown into an international Data & AI company. Explore our journey, the principles behind our work, and the next...
2026-10-26
30 reads
The following came across my YouTube feed today. It’s an interview with General James Mattis, USMC, Retired, talking about lifelong learning, the expectations of learning in the Marine Corps,...
2026-10-28 (first published: 2026-10-23)
163 reads
“You don’t need more time because you already have all the time that you will ever get; you need more focus.” – from Excellent Advice for Living Boy, I...
2026-10-30 (first published: 2026-10-23)
162 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...
Telp/Wa 628217555651 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Telp/Wa 62817825533 Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
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