Webcast: How to Secure SQL Server – End to End Security
On April 16, 2024, I will be giving another webcast; this one will be on SQL Server security. Sign up link As always, the registration is free. Here’s the...
2024-03-29
115 reads
Blog Posts
Working with ALS – Insights from the Ability Summit
The 14th annual Ability Summit is a global event that I attended a few weeks ago. It is hosted by Microsoft, and it presents the latest technology innovations and...
2024-03-29 (first published: 2024-03-27)
41 reads
DevOps: It’s About the Team, Not Just the Tech
In November 2023 I did a session at PASS Summit and one of my sessions was voted https://passdatacommunitysummit.com/about/news/have-you-watched-some-of-the-most-popular-sessions-from-summit-2023/ That session was called DevOps is about Growing People rather than...
2024-03-27 (first published: 2024-03-20)
213 reads
What Does Redgate Test Data Manager Do?
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM), which was a new product for us. You can watch the video linked above to...
2024-03-27 (first published: 2024-03-18)
157 reads
Change Notebook Spark Session Time-Out in Microsoft Fabric
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric and suddenly you have to leave your workstation for a while. Someone ran the doorbell...
2024-03-25 (first published: 2024-03-16)
142 reads
Extracting PostgreSQL database metadata for presentation in Excel format
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks for more than half of my life. I believe it's the most widely used spreadsheet...
2024-03-25 (first published: 2024-03-16)
303 reads
Tomorrow – Webcast on SQL Server Administration
I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...
2024-03-25
33 reads
A New Word: Rubatosis
rubatosis– n. the unsettling awareness of your own heartbeat, whose tenuous muscular throbbing feels less like a metronome than a nervous ditty your heart is tapping to itself, as...
2024-03-22
367 reads
Friday Flyway Tips – Inserting Column in the Middle of a Table
I had a customer question whether Flyway Desktop (FWD) would cause problems if developers were adding columns into the middle of tables. It’s a valid concern, and this post...
2024-03-22 (first published: 2024-03-15)
443 reads
New Pluralsight Course - Certified Kubernetes Administrator - Using kubeadm to Install a Basic Cluster
We’re kicking off a major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The second course “Certified Kubernetes Administrator: Using kubeadm to Install a Basic Cluster” in the updated...
2024-03-22 (first published: 2024-03-12)
163 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