Joe Fleming wants to know how I solve weird problems. I’m not sure I’m actually qualified to answer this question since I, myself, am a weird problem, but I’ll...
2025-06-30 (first published: 2025-06-10)
330 reads
A while ago I was looking into some odd errors that were cropping up in an application, when I spotted that all the columns in a table were defined...
2025-06-30
35 reads
Today is my last day of work for six weeks. I start my sabbatical Monday, or maybe this afternoon, and will be gone. I may or may not blog,...
2025-06-27
51 reads
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by the urgent of any sort. Focus on the important. The urgent is a tyrant. –...
2025-06-27 (first published: 2025-06-13)
434 reads
I’m really excited to share some new functionality in SQL Server 2025 combined with some innovations in FlashArray’s REST API.
In this post, I’m going to show you how to...
2025-06-27
102 reads
I will be back in Seattle this year attending the 2025 PASS Data Community Summit. This will mark my fourth year attending the Summit (I also attended one year...
2025-06-27
37 reads
I didn't have these in my slides for the Techno Security & Digital Forensics Conference, but brought them up the web browser during the presentation. If you're looking at...
2025-06-27 (first published: 2025-06-09)
363 reads
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight and the threat of punishment are incompatible with great, fulfilling work. We believe in creating...
2025-06-27
61 reads
Brent had a query exercise recently about train stations moving in some order and having overrides to this order in emergencies. I suppose he’s been traveling a lot lately...
2025-06-27
15 reads
When I watched the following video from Justin Sung, I realized that I am often guilty of the two problems he cites with regards to making my schedule work...
2025-06-26
15 reads
Setting page visibility and the active page are often overlooked last steps when publishing...
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers