In 1999 I released my first commercial software product. ShutOff 2000 was a Windows application that could log off or shut down Windows in multiple ways. It was successful...
2026-10-30
108 reads
This month I want to look at a few of the things I’ve seen posted about cars during the last month. These are a few headlines, as well as...
2026-10-30
235 reads
SQL Server 2016 Has Reached End of Support. Now What?
On July 14, 2026, SQL Server 2016 reached the end of extended support. That means regular...
2026-11-09 (first published: 2026-10-30)
325 reads
(This post starts a three-part series on how AI is changing the way we build solutions in Microsoft Fabric. First, we’ll explore how the new unified Copilot in Fabric...
2026-11-04 (first published: 2026-10-29)
1,220 reads
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)
449 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)
314 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,080 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)
279 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)
268 reads
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
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