Unit Testing & Intelligent Query Processing
Actually, these two topics don’t have anything to do with one another. I just ran out of days to promote everyone individually who was taking part in putting on...
2020-03-31
16 reads
The Scary DBA
Extended Events: Queries and Waits
Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query...
2020-03-30
25 reads
Figuring Out How To Hide Production Data
There’s a really simple conundrum that we go through all the time. The best data for development is production You can’t have production data for development You have to...
2020-03-27
148 reads
Time To Learn Git
I love this quote from Kevin Hill (and not because he mentions me): 3 things I can no longer justify ignoring: #dbatools Git and #Docker for my dev SQL work@cl@sqldbawithbeard@Kendra_Little and @unclebiguns@GFritchey, I blame you...
2020-04-03 (first published: 2020-03-26)
1,102 reads
DB Automation with Azure DevOps
I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do...
2020-03-31 (first published: 2020-03-25)
456 reads
Being an Efficient DBA
Or database developer, report writer, whatever. SQL Server, SQL Server Management Studio, and all the tools provide a bunch of ways to get things done. However, some ways are...
2020-03-24
53 reads
Extended Events: Live Data Explorer, Grouping
Of all the things that Extended Events does, I’ve found the ability to quickly and easily gather a little bit of data and then use the Data Explorer window...
2020-03-23
103 reads
Containers and DevOps
Over the last couple of years, one of these single most exciting technologies to come out around the Data Platform has been containers. You may not see them change...
2020-03-27 (first published: 2020-03-20)
308 reads
Missing #SQLFamily? Check This Out.
I am an introvert. Lots of people don’t believe it, but it’s true. However, I really do love getting to see my #SQLFamily all over the world in my...
2020-03-19
25 reads
Extended Events: Live Data Explorer, Getting Started
One reason a lot of people don’t like Extended Events is because the output is in XML. Let’s face it, XML is a pain in the bottom. However, there...
2020-03-24 (first published: 2020-03-16)
267 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