5 Tools Every DBA Should Know About
After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day...
2014-04-03 (first published: 2014-03-25)
7,359 reads
Encryption in Las Vegas – SQL Saturday #295
I enjoy Las Vegas, usually trying to see a show of some sort when I’m there. I’ll have the chance...
2014-03-28 (first published: 2014-03-25)
1,544 reads
Book: Reporting with Microsoft SQL Server 2012
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012...
2014-04-04 (first published: 2014-03-25)
3,870 reads
Save Money On Your Training Server
You can spend less money. Some of us are lucky. We work for very large corporations who can easily set...
2014-03-31 (first published: 2014-03-25)
2,202 reads
What is Microsoft Management Reporter for Dynamics AX?
It is a collaborative and interactive reporting solution from Microsoft for finance data. View more here: Management Reporter 2012 Overview...
2014-03-25
774 reads
Grant View Server State
There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...
2014-04-02 (first published: 2014-03-25)
95,658 reads
Backup Checksums and Trace Flag 3023
One of the items I always flag when performing a health check on a server is whether backups are being...
2014-03-28 (first published: 2014-03-25)
3,613 reads
Introducing Microsoft Dynamics AX 2012 with SSRS Reports
Hi all, I’ve started a new job with eBECS which is a Microsoft Gold Partner in the ERP Business. Since...
2014-03-25
795 reads
The Illusion of Updateable Clustered ColumnStore Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-31 (first published: 2014-03-25)
2,370 reads
Speaking at Luxembourg SQL Server User Group
Tomorrow evening I have the honour of speaking at Microsoft’s office in Clausen, Luxembourg. The session I will be presenting...
2014-03-25
794 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