Catching Up On SQLOrlando
Somehow two years have elapsed since my last update; hopefully it won’t be that long before the next one. My last post was about SQLSaturday Orlando 2023. Since then,...
2026-01-16 (first published: 2026-01-03)
254 reads
Blog Posts
Flyway Tips: AI Generating Migration Script Names
AI is a big deal in 2026, and at Redgate, we’re experimenting with how AI can help developers and DBAs become better at their jobs. One of the areas...
2026-01-16
60 reads
The Book of Redgate: Get the right stuff done
Another of our values: The facing page has this quote: “We admire people who get stuff done. While there’s a place for planning, thinking and process it is better...
2026-01-16
34 reads
Using Prompt AI for a Travel Data Analysis
I was looking back at my year and decided to see if SQL Prompt could help me with some analysis. I was pleasantly surprised by how this went. This...
2026-01-16 (first published: 2025-12-31)
346 reads
2026-01-14 (first published: 2026-01-05)
479 reads
SQL Server 2025 Developer Edition – One size fits all
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine. This version focuses on AI features and better performance, aiming to meet the needs of...
2026-01-14 (first published: 2026-01-05)
931 reads
How to Troubleshoot a Runaway Transaction Log File
Part of being a DBA is dealing with transaction logs that grow uncontrolled for some reason. This often gets raised to the DBA in the form of a drive...
2026-01-13
71 reads
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for running containerized workloads. While Kubernetes is one of the best orchestration tools, it also presents...
2026-01-12 (first published: 2025-12-31)
210 reads
Setting PK Names in Redgate Data Modeler
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names. I had to test and discover if I could make things better, and I could....
2026-01-12
67 reads
Streamlining Azure VM Moves Into Availability Zones
One of the more frustrating aspects about creating an Azure virtual machine is that if you do not place it into an availability zone at deployment time, you’ve traditionally...
2026-01-12 (first published: 2025-12-15)
161 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers