Becoming a DBA: How to gain experience
Last week I had an interesting telephone call from a someone who I connected with on linkedin.com. On Linkedin I’m...
2011-03-16
1,695 reads
SQL University Lecture Series: Women in Tech
This week SQL University is on Spring Break but we’ve lined up some activities to help keep students busy (you...
2011-03-16
663 reads
24 Hours of PASS: Day 1
Yesterday was the first day of PASS’ 24 Hours of PASS event. For those not familiar, 24 Hours of PASS is...
2011-03-16
770 reads
Disaster Recovery Exposure - Part Two
In part one, I gave a general overview of some of the things that may affect IT services in the...
2011-03-15
545 reads
Disaster Recovery Exposure. - Part One
G'day,
I've just readPaul Randal's sqlmag article about the need to test your disaster recovery strategy. In that article Paul mentions...
2011-03-15
1,169 reads
The MCM is Worldwide
Well, not everywhere, but as long as Prometric sites meet some security requirements, they can offer the MCM tests. I...
2011-03-15
841 reads
Has Microsoft Desktop Virtualization Reached The End Of The Road?
I'm a big proponent of using Virtual Machines for development on your local machine. It just doesn't make sense to...
2011-03-15
616 reads
24 Hours of PASS Spring 2011 Code Sins
Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring...
2011-03-15
677 reads
Boulder SQL Server User’s Group Meeting
I will be presenting at the Boulder SQL Server User’s Group (BSSUG) on March 15, 2011. My presentation will be...
2011-03-15
526 reads
March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good news – we had just about as many person...
2011-03-15
12 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