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...
2011-03-15
713 reads
3rd Simple-Talk.com Article: 'The Polyglot of Databases: How Knowledge of MySQL and Oracle Can Give SQL Server DBAs an Advantage'
After revising the popular Blog post, Developing Your DBA Skills Futher Thanks to Experience with Multiple RDBMS, of just over a year...
2011-03-15
855 reads
SSRS: Empty dataset and Tablix Control
The behaviour of the tablix is that whenever the associated dataset is empty, it will not show any detail row....
2011-03-15
2,662 reads
SQL Server Quiz - Answer the questions, win a prize.....
It's March Madness, and we're not just talking about basketball. We're not just talking about Women's History Month, which is...
2011-03-15
2,111 reads
Beginner Sessions at SQL Saturday #70 - Columbia, SC
A very good question was asked about the SQL Saturday #70 session track, and that's "What courses are best suited...
2011-03-15
858 reads
To Script or Not To Script
When approaching an automation problem the first questions you must answer is whether you should even invest the time to...
2011-03-15
701 reads
STS-134 Rollout
If you follow me on Twitter or talk to me in person you'll come to realize I'm a space enthusiast....
2011-03-15
518 reads
Waiting For Superman
This site really is about business intelligence, but it is good to mix things up a bit every now and...
2011-03-15
719 reads
The Lighter Side of Technical Interview Questions
I hate those puzzle type interview questions. I am sure that they show some level of aptitude about something, but...
2011-03-14
1,021 reads
Passing Values into an SSIS Package at Runtime from Outside the Package
SSIS provide several methods for passing values into your packages at runtime.The benefit of doing so allows you to change...
2011-03-14
34,705 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