Advice I Like: Failure
If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...
2025-11-28 (first published: 2025-11-14)
410 reads
The Voice of the DBA
SQL Server 2025 RegEx and AI
One of the language changes in SQL Server 2025 that I’ve seen a lot of people mention is the addition of RegEx functions to T-SQL. I decided to take...
2025-11-12
151 reads
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
I hosted this month, but I decided to put my own entry in as well. There are more things in this release than I expected, probably because of the...
2025-11-11
38 reads
Monday Monitor Tips: ServiceNow Integration
Earlier this year I visited a customer that was using the Redgate Monitor webhook to integrate with ServiceNow. However, they were also trying to integrate in a richer way...
2025-12-01 (first published: 2025-11-10)
283 reads
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
30 reads
The Book of Redgate: What Our Customers Say
This is from 2010, but I loved that people felt this way about Redgate Software. A lot of these words are things that we aim to express to each...
2025-11-07
17 reads
Finding and Killing Blockers with Redgate AI Tech
Redgate has a research arm, called the Foundry, that has been experimenting with AIs and DBA tasks. This post shows how GenAI tech can be helpful to DBAs in...
2025-11-24 (first published: 2025-11-05)
288 reads
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
12 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
27 reads
A Small LLM Fail
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This one surprised me. This is part of a series of experiments with AI systems. Looking...
2025-10-29
17 reads
Blogs
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers