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
47 reads
Blog Posts
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server in 2025 and your sa login is still usable, you’re giving attackers a giant, blinking...
2025-11-10 (first published: 2025-10-21)
1,486 reads
Microsoft Purview: The Key Benefits of Data Governance
I still see a lot of confusion about the functionality of Microsoft Purview ever since multiple products were combined into it, so I wanted to write this blog to...
2025-11-10 (first published: 2025-10-15)
650 reads
Becoming a creator, my website experience
Over the past few months, I have debated starting a new blog to discuss our ALS journey. I realized we were writing about ALS on the Data on Wheels...
2025-11-08
19 reads
Creating a Striped Backup Set with AI
I needed to test a striped backup, so I decided to ask the AI’s for help. This is part of a series of experiments with AI systems. The Problem...
2025-11-07 (first published: 2025-10-22)
263 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
19 reads
Trace Flag 1448 – Lessons from a Technical Interview
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs), DBAs sometimes face a frustrating scenario: replication stalls when a secondary replica or subscriber is...
2025-11-07 (first published: 2025-10-21)
543 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
32 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
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
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers