Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification...
2010-12-16
885 reads
Select * from dbo.FAIL: invalid metadata in views and user defined functions
This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I...
2010-12-16
1,147 reads
1.5 Years in, U.K. Information Commissioner Christopher Graham, Delivers on the Data Protection Act
A year after the Telegraph reported that Information Commissioner Graham would pledge a fierce approach to the stonewalling approach of...
2010-12-16
1,497 reads
Giving Thanks
I often say I am where I am in the community because of other folks. As we approach the close...
2010-12-16
729 reads
SQL Server Storage Internals Part 2 - Partitions and Allocation Units
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
2010-12-16
15,212 reads
Insert_Identity Permissions
Despite my joking with Aaron Bertrand on Twitter that his suggestion on Connect got voted down because he’s Canadian, I...
2010-12-16
1,046 reads
Number of sessions per database
Sometimes when we need to do some maintenance on a SQL server, you need to verify which users are connected...
2010-12-16
1,452 reads
SQLRally Session Submissions
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of...
2010-12-16
543 reads
Pragmatically Thankful
This season, as we continue to grow and partner with some of the best of the best in the industry....
2010-12-15
516 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not end with the birth of our baby girl two...
2010-12-15
15 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