T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
It’s that time of the month again, and once again, I’m late and I’m hosting. I was traveling a lot in October and didn’t sort out hosting for this...
2025-11-07
32 reads
Blog Posts
Back at Small Data SF in 2025
Today I’m in San Francisco at Small Data SF 2025. I went to the conference last year and thought it was a great event. Watching people talk about data...
2025-11-05
15 reads
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
For decades, enterprises have thought about data like plumbers think about water: you build pipelines, connect sources to sinks, and hope the pipes do not burst under pressure. That...
2025-11-05 (first published: 2025-10-17)
448 reads
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server
Transient failures happen — in the cloud (Azure SQL) and on-prem. A resilient connection strategy lets your app recover gracefully instead of...
2025-11-05 (first published: 2025-10-13)
429 reads
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton of fun writing these, and I hope you’re enjoying the ride through SQL Server’s haunted...
2025-11-03 (first published: 2025-10-17)
306 reads
SQL Server Alerts
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until they don’t. By the time someone notices an application outage or a failed backup, you’re...
2025-11-03 (first published: 2025-10-15)
336 reads
A New Word: Foilsick
foilsick – adj. feeling ashamed after revealing a little too much of yourself to someone – allowing them too clear a view of your pettiness, your anger, your cowardice,...
2025-10-31
37 reads
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help that," said the Cat: "we’re all mad here. I’m mad. You’re mad.""How do you know...
2025-10-31 (first published: 2025-10-13)
309 reads
Prompt AI helping with Auditing
I had a conversation with a customer asking this question: how can I tell who called a stored procedure so I can audit the action? I decided to see...
2025-10-31 (first published: 2025-10-15)
292 reads
Measuring What Matters: Operationalizing Data Trust for CDOs
Trust is the currency of the data economy. Without it, even the most advanced platforms and the most ambitious strategies collapse under the weight of doubt. For Chief Data...
2025-10-30
16 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers