Blueprint for consulting riches
As a business intelligence architect consultant, I have met many people out there who are as good or better than...
2012-07-09
1,533 reads
Back Across the Pond
This coming weekend is SQL in the City – London 2012. Friday, July 13, and Saturday, July 14, I’ll be at...
2012-07-09
1,003 reads
SQL Audit 101 – Creating a basic audit
SQL Audit was introduced in SQL 2008, and for the first time auditing was treated as a “first-class” object in...
2012-07-09
2,392 reads
First SQL Server UG Meeting in Harrisburg, PA
If you work with SQL Server and live in the Harrisburg area I have some great news for you. The...
2012-07-09
670 reads
Group Think (or Groupthink)
I’ve thought about writing on this topic a couple times and was reminded of it again when I read a...
2012-07-09
1,208 reads
Speaker Selection for SQLSaturday Orlando-Group #5
Three more added to the stellar slate of speakers for SQLSaturday Orlando, we look forward to seeing you soon!
Ira Whiteside
Devin...
2012-07-09
512 reads
Parallel Data Warehouse (PDW) Lesson 1: – Basic Architecture Overview
I’ll begin my coverage of Microsoft’s Parallel Data Warehouse (PDW) architecture / appliance with a brief overview of the Massively Parallel...
2012-07-09
1,118 reads
Writing About SQL Server
I. Introduction I recently submitted my entry for a writing competition as part of my continuing education. While I was...
2012-07-09
1,435 reads
Speaking at SQL Saturday 122 - Louisville
It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been...
2012-07-09
885 reads
Lost in Translation – Deprecated System Tables – sysdatabases
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-09
1,335 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