Who’s My Agent?
Alright, I’m not famous, even though I share the name of a famous Jazz pianist. So, obviously I am NOT...
2011-02-23
732 reads
FileSystemHelper Update and Release
About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients. As...
2011-02-23
491 reads
New SQL Server 2005 Cumulative Updates
Microsoft has released two new Cumulative Updates for SQL Server 2005. The first one is SQL Server 2005 SP3 CU14,...
2011-02-23
592 reads
PASS Election Review Committee: NomCom Process
Over on the ERC forums, Bill Graziano (blog | twitter) has posted the proposed NomCom selection process. We would really like...
2011-02-23
608 reads
SQLskills Immersion Event on Internals and Performance – Day 2
Overview
Day two of the SQLskills Immersion Event is over and I have listed the interesting parts below. The food, again,...
2011-02-23
711 reads
PowerShell Script for Paul’s Survey: how is your tempdb configured?
Paul Randal (b | t) posted a survey how is your tempdb configured? Since I just happen to be at a...
2011-02-23
754 reads
February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you may know, I have moved from Vegas back to...
2011-02-22
7 reads
February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you...
2011-02-22
452 reads
SQLDIY: Manage and Monitor SQL Server Yourself
As an old school DBA and always having cheap frugal employers, I have rolled my own management and monitoring solutions....
2011-02-22
584 reads
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-22
1,584 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