#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
Ryan Adams For PASS 2016-2018 Board
Ladies and Gentlemen, I would love to announce my support for Ryan Adams running for the PASS Board in 2016-2018....
2015-09-16
493 reads
Using @@ROWCOUNT can be a bit tricky
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...
2015-09-16
724 reads
Blogs
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, which is...
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