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
Blog Posts
Purging MSDB Backup and Restore History Tables
Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...
2012-07-09
2,506 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
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
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
SQL Internals Reading Data Records Part 6: Variable Length Data
Welcome back Dear Reader to Part 6 on our series of how to read a Data Record. In Part 1...
2012-07-09
1,257 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
A Pattern for PIVOT
Use of the PIVOT operator in T-SQL has always been tantalizing yet confounding to me. It offers the promise of...
2012-07-08
2,064 reads
Baton Rouge SQLSaturday #150 & Tech Day–DBA 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got...
2012-07-08
1,479 reads
Identifying Long Running SQL Agent Jobs Script
I’m usually pretty hesitant to share scripts I write because inevitably it will get torn to pieces, but in this...
2012-07-08
4,081 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