DenverSQL UG Meeting: Tim Mitchell presents Dirty Data? Clean it up!
Denver SQL Server User Group - Thursday, February 17, 2011
Main Presentation
"Dirty Data? Clean It Up! By Tim Mitchell"Dirty Data? Clean It...
2011-02-17
465 reads
Who Is This Super Hero?
We recently switched from Brighthouse to DirectTV and of the first things we did was to find the kids channels...
2011-02-17
567 reads
How to Interpret SELECT @@VERSION in SQL Server
One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly...
2011-02-17
1,562 reads
VSone session material
As I have announced in both of my sessions at the VSone conference in Munich, you
can find the session material...
2011-02-17
565 reads
SQL Rally
I believe I’ve been far too quiet about this event.
In May, in Orlando Florida, there will be a two...
2011-02-17
652 reads
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You can read about that here. Of all of the...
2011-02-17
11 reads
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You...
2011-02-17
495 reads
Windows Server 2008 R2 SP1 Released and Installed
Microsoft has made Windows Server 2008 R2 Service Pack 1 (and Windows 7 SP1) available on MSDN and TechNet earlier...
2011-02-16
1,648 reads
Introducing Kalen Delaney’s SQL Server Stairways Tutorial Series
In case you haven’t noticed, there is a new link on SQLServerCentral.com for a new series of tutorial articles called...
2011-02-16
1,119 reads
PASS Summit Volunteers Needed
Well, we are coming around into a new year. With this new year there is once again PASS Summit preparations that are well under way. Time has come again...
2011-02-16
14 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, which is...
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