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
9 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)
123 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
70 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
63 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
259 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
48 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
79 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
28 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers