Question of the Day: Check, Please
This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on....
2015-12-03
560 reads
Changing Course On Learning
With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...
2015-12-03
504 reads
What Do You Mean There is No Current Database Backup?!?
Yet another late night/early morning tale...
The LOG backups for multiple databases on a server failed overnight (not all databases, but...
2015-12-03
981 reads
Atlanta BI Edition SQL Saturday Precon
The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...
2015-12-03
920 reads
Goodness-of-Fit Testing with SQL Server, part 3.1: Skewness, Kurtosis and the Jarque-Bera Test
By Steve Bolton
…………In the last installment of this series of amateur self-tutorials on using SQL Server to identify probability distributions,...
2015-12-02
1,688 reads
Why I Joined Microsoft
If you follow me in social media, you may have seen my announcement that I’ve joined Microsoft. Late in October...
2015-12-02
608 reads
Idera #SQLChat with John Morehouse
Please join Idera tomorrow for a #SQLChat on Twitter. The December #SQLChat will take place Tuesday, December 9 at 11...
2015-12-02
505 reads
Webinar – Lowering SQL Server Licensing Costs
On Tuesday, December 15th, Bala Narasimhan and I are presenting a webinar where we will walk through real-world examples that...
2015-12-02
460 reads
Ending My Loop in PowerShell Early
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I...
2015-12-02
780 reads
Sentiment Analysis with Power BI
I was recently asked by a customer to help them do some Text analysis of course evaluation data. They wanted...
2015-12-09 (first published: 2015-12-02)
4,240 reads
Blogs
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...
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