How To Call APIs From SQL Server
Calling an API has been in Azure SQL since 2022, but it was only recently added to SQL Server 2025 Preview. This new feature...
2025-07-01
7 reads
Salesforce CDC Data Integration
(2025-June-30) Working with different abbreviations or acronyms can speed up communication, but at the same time, it can exclude those who are not familiar with them. Sometimes this exclusion happens...
2025-07-01 (first published: 2025-06-30)
118 reads
EightKB 2025 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2025 Edition has been announced! We’re kicking off at 1pm UTC on August 21st…here’s the schedule: – N.B. – If...
2025-06-30
67 reads
Why Not Just Use VARCHAR(MAX)?
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
60 reads
Quick Wins with GenAI
The more I look to GenAI to save me minutes, short periods of time, the better it works. Here’s an example of something I do regularly where AI helps....
2025-06-30
257 reads
Speaking at the 2025 PASS Data Community Summit
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
46 reads
The Book of Redgate: Motivation
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
77 reads
A Six Week Break
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
67 reads
Build a Snapshot Backup Catalog in Pure Storage with SQL Server 2025’s Native REST API
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
119 reads
Using a GenAI to Help Brent
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
25 reads
Blogs
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers