SQL Rally 2011 Voting - Reporting Services Boot Camp
All,
Since SQL Server Reporting Services 2005 came out, I have been working very close within the BIDS environment and every...
2011-01-31
1,545 reads
SQL Saturday #57 – Houston
SQL Saturday #57 was this weekend! Sean and I went, talked, webshow-ed, and then presented a total of SIX sessions!
Travel
Sean and...
2011-01-31
1,647 reads
Powershell to Automate SQL Compare
A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...
2011-01-31
4,303 reads
PASS Update #50-January 2010 Board Meeting
This post is my thoughts on the Board meeting, and my views on related topics. I encourage you to read...
2011-01-31
1,961 reads
Presentations Materials From Last Week
Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS...
2011-01-31
1,380 reads
SQLSaturday, Rocky, and a CheeseSteak - Upcoming Event
As you know, the SQLSaturday sensation has exploded all over the nation. So many events scheduled this year, there is...
2011-01-31
2,112 reads
Microsoft Support Policies for Windows Server and SQL Server
Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack...
2011-01-31
4,851 reads
31 Days of SSIS – Importing Execution Plans (30/31)
31 Days of SSIS
Almost time to wrap up the 31 Days of SSIS. We are down to just two more...
2011-01-31
2,870 reads
SQL Saturday #57 Slides, Code & Video
This past weekend I spoke at SQL Saturday #57 in Houston, TX.
I want to thank the local PASS chapter HASSUG,...
2011-01-30
1,633 reads
31 Days of SSIS – Exporting Execution Plans (29/31)
31 Days of SSIS
A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still...
2011-01-30
2,380 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