Virtual Box is TOO Small
I have been working on upgrading my laptop. Since my laptop housed a bunch of my virtual machines for various presentations and labs, that means also upgrading and/or converting...
2014-08-05
6 reads
Virtual Box is TOO Small
I have been working on upgrading my laptop. Since my laptop housed a bunch of my virtual machines for various...
2014-08-05
1,366 reads
Export XML Columns to Individual Files
I was reading SqlServerCentral.com Articles Requested forum and saw this request.
Looking for an article that takes data from an XML...
2014-08-14 (first published: 2014-08-04)
9,612 reads
Presenting at PSSUG
Coming up this week, I have been given the opportunity to do something I enjoy doing. I have been invited to present to the folks in Philadelphia. Sebastian...
2014-08-04
11 reads
Presenting at PSSUG
Coming up this week, I have been given the opportunity to do something I enjoy doing. I have been invited...
2014-08-04
727 reads
Last Weeks Top “Reading” Links #95
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-08-04
469 reads
Building The SQLSaturday Orlando Marketing Plan–Part 30
First, a quick update on the LinkedIn advetising campaign. One click so far, no registrations. More views than I expected...
2014-08-04
610 reads
Writing Parametrized MDX for Reporting Services
Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all...
2014-08-13 (first published: 2014-08-04)
8,694 reads
Murder in Raleigh
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-08-04
9 reads
Murder in Raleigh
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-08-15 (first published: 2014-08-04)
7,929 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