An Identity Crisis: Is it Profiler or is it Extended Events?
Despite it being new, it seems there are a handful of "facts" already published about it that may or may not be accurate. Due to that, I want to...
2017-12-22
15 reads
Blog Posts
An Identity Crisis: Is it Profiler or is it Extended Events?
I have been working on this article for far longer than one might think is necessary for something of this...
2017-12-22
122 reads
Creating and Using Failover Groups in Azure DBaaS – Part 1
Introduction
Hello everybody! Welcome back! One of my favorite features in Azure SQL DBaaS is Failover Groups. I have been working...
2017-12-22
170 reads
Design Concepts For Better Power BI Reports Part 4: The Squint Test
Data visualization should be iterative. You should get a good initial draft put together and then check to make sure...
2017-12-22
799 reads
Is the traditional data warehouse dead?
There have been a number of enhancements to Hadoop recently when it comes to fast interactive querying with such products...
2017-12-22
106 reads
Is the traditional data warehouse dead?
There have been a number of enhancements to Hadoop recently when it comes to fast interactive querying with such products...
2017-12-22
1,762 reads
Live on Channel 9 with ReadyRoll
I was interviewed in Redmond a couple months ago and the video was just published. I show and demo some...
2017-12-22 (first published: 2017-12-07)
1,743 reads
More Beginner / Fundamentals Content
Not surprisingly, there are folks who want beginner / fundamentals presentations and blog posts.
I put up the poll based on a...
2017-12-22 (first published: 2017-12-05)
1,899 reads
Using SQL Server Management Studio Projects
One of the most underutilized assets in SQL Server Management Studio is the SSMS project. Within Management Studio, one can...
2017-12-22
548 reads
A Business Lesson from an Oil Change
When I first moved to the city where I now live, I found an oil change place just a couple...
2017-12-21
387 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