SQL Servers Black Box Recorder – system_health
Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can...
2018-12-29
358 reads
Adding a database running in a docker container to SQLTest
in my previous post I wrote about how easy it is to add the tSQLt unit test framework to your...
2018-12-29
459 reads
How to use tSQLt unit test framework with a SQL Server database in a docker container
This blog post describes how to add the tSQLt unit testing framework to a database running in a docker container....
2018-12-29
1,470 reads
How to install the tSQLt unit test framework to start unit testing your database code
This blog post describes how easy it is to install the tSQLt framework.
Don’t know much about tSQLt? If you are...
2018-12-29
516 reads
How to Cluster MaxDB on Windows in the Cloud #Azure #AWS #GCP #SAP
Recently I have had a number of customers looking for a high availability solution for MaxDB on Windows in the...
2018-12-28
466 reads
Shrinking Tempdb in SQL Server won’t work?
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly larger and I didn’t have much space on the...
2018-12-28
22 reads
Shrinking Tempdb in SQL Server won’t work?
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly...
2018-12-28
1,013 reads
Webcast: Data Modeling Scenarios and Best Practices
On January 17, 2019, I will be giving a webcast with MSSQLTips on data modeling best practices. It’s scheduled for...
2018-12-28
1,337 reads
Testing SQL in the Advent of Code
I like participating in the Advent of Code each year, though my participation often varies wildly as life gets in...
2019-01-09 (first published: 2018-12-28)
2,155 reads
Azure – Creating a storage account
Azure offers a lot of features that enable IT professionals to really enhance their environment. One feature that I really...
2019-01-08 (first published: 2018-12-28)
2,509 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
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