Power BI in SSRS – T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-02-21 (first published: 2017-02-14)
6,959 reads
The Database Avenger
GitLab for SQL Server Projects
This is the seventh part in the series: SQL Server and Continuous Integration. This post demonstrates the use of GitLab to build...
2017-02-06 (first published: 2017-02-02)
7,856 reads
Forcing Parallelism – T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-01-09
561 reads
ReadyRoll Development
This is the sixth part in the series: SQL Server and Continuous Integration. This post will illustrate the power of ReadyRoll when...
2017-01-03 (first published: 2016-12-23)
1,297 reads
Restoring a SQL Server backup on Linux
Last Wednesday I got very excited by Microsoft’s announcements about the addition of features to standard edition and the public preview...
2016-11-23
926 reads
SQL Server on Ubuntu
They finally did it! Finally SQL Server for Linux was announced. I’ve been waiting for this for quite a while, so...
2016-11-16
1,300 reads
Starting a ReadyRoll Project
This is part 5 in the series named SQL Server and Continuous Integration. This post will cover the steps I follow...
2016-10-26
1,222 reads
ReadyRoll for Database Deployments
This is the 4th post in the series named SQL Server and Continuous Integration. The first 3 posts covered the need...
2016-10-03 (first published: 2016-09-21)
1,360 reads
The Non-Replicated Backup Mystery
I recently configured a backup job to run on the principal server of a mirrored pair. The idea was to backup...
2016-09-08 (first published: 2016-09-05)
2,124 reads
Visual Studio Basics for use with ReadyRoll
This is the 3rd post in the series: SQL Server and Continuous Integration. This time I’ll cover the prerequisites of using ReadyRoll...
2016-08-16
803 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