Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking. Those posts work well in conjunction with a post...
2011-03-17
15 reads
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking....
2011-03-17
4,460 reads
SQL Lunch #51–SQL U Presents Women in Technology
This week I am happy to announce the second SQL University SQL Lunch presentation. What’s makes this exciting is that...
2011-03-17
1,153 reads
DevWeek 2011 – A DBAs view
The title itself would lead you to believe this conference was only for the those looking to master the art...
2011-03-17
829 reads
There’s A New North Central Regional Mentor
What has two thumbs and just signed on to be a PASS Regional Mentor? This guy!
Over the past couple weeks,...
2011-03-17
698 reads
SQL Server Denali CTP1 Diagnostic Information Queries
Here is the first SQL Server Denali–specific version of my Diagnostic Information Queries. There are actually only two queries (which...
2011-03-16
1,019 reads
Balancing Work and Life
Balancing work and home life is nothing new; we’ve had this challenge for a long time. But in recent months when so many companies are streamlining operations and asking...
2011-03-16
10 reads
Balancing Work and Life
Balancing work and home life is nothing new; we’ve had this challenge for a long time. But in recent months...
2011-03-16
1,034 reads
SQL Server Standard Reports Winforms
In SQL Server, there is a good set of preloaded reports to help you monitor the Instance. These reports can be found under the Standard Reports and can be...
2011-03-16
14 reads
SQL Server Standard Reports Winforms
In SQL Server, there is a good set of preloaded reports to help you monitor the Instance. These reports can...
2011-03-16
2,788 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
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