One Easy Strategy for the Database Enterprise
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...
2015-09-09
710 reads
SQL Server Data Tools is now a separate installer – Things to know!
Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I...
2015-09-08
1,306 reads
Learning Extended Events in 60 Days
Want to Learn Extended Events over the course of your lunch break for a couple of months? This is the Table of Contents for learning Extended Events over the...
2015-09-08
63 reads
Learning Extended Events in 60 Days
This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The...
2015-09-08
775 reads
TSQL2SDAY #70: Strategies for managing an enterprise
Thanks to MidnightDBA (b/t) for hosting this month’s #tsql2sday.
Strategies for managing an enterprise.
What do you think of when you...
2015-09-17 (first published: 2015-09-08)
1,067 reads
T-SQL Tuesday #70 – The Enterprise
It’s hard to believe this is the 70th edition of T-SQL Tuesday. I haven’t missed many, and I’ve enjoyed them...
2015-09-16 (first published: 2015-09-08)
1,311 reads
Unusual errors with Distributed Replay
I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale...
2015-09-08
1,177 reads
High Availability and Disaster Recovery Training in Dallas
I’ll be doing a precon for SQLSaturday #447 in my home town of Dallas on October 2nd, 2015 titled “Creating a High...
2015-09-17 (first published: 2015-09-08)
1,054 reads
Building Better SSIS Packages Class in Dallas
I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better...
2015-09-15 (first published: 2015-09-08)
1,615 reads
Extended Events Objects
Today I want to start diving into some of this data a little deeper as we progress some of the of the core concepts surrounding Extended Events.
Related Posts:
Correlate SQL...
2015-09-08
13 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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