Reblog: The Magic Alt Button
SQLKover update: I love this trick! I use it daily, no kidding (except in weekends). Want to see it in live...
2015-09-17
651 reads
Voting in the PASS Election 2015
Another year, another set of elections. It’s that time where those who care about their industry and the future of...
2015-09-17
652 reads
#ITDevCon15 Conner Cunningham Keynote
On Wednesday morning, Conner Cunningham from Microsoft was the keynote speaker for IT/DevConnections in Las Vegas. His talk focused on...
2015-09-17
419 reads
#MDXMonday: Finding the Current Day
This week I’m teaching the Pragmatic Works Intro to MDX virtual training class. A student in the class asked how...
2015-09-16
469 reads
PASS Election Questions Answered
As we continue through the campaign period for this year’s PASS Board of Directors Election (Voting opens tomorrow morning), I...
2015-09-16
519 reads
PASS Summit Precon – The Complete Primer to SQL Server Virtualization – UPDATE
I am very pleased to announce that Argenis Fernandez, (now including)Jimmy May, and I will be presenting a new precon...
2015-09-16
574 reads
SQL Prompt 7 by RedGate
RedGate unleashed their newest version of SQL Prompt recently. It is no secret to those of you who know me...
2015-09-16
298 reads
SQL Prompt 7 by RedGate
RedGate unleashed their newest version of SQL Prompt recently. It is no secret to those of you who know me...
2015-09-16
2,177 reads
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data.
Related Posts:
How to: File Target use in Extended Events December 27, 2018
Dynamics...
2015-09-16
7 reads
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data. When an event fires, it...
2015-09-16
788 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