Presenting in West Palm Beach on March 22, 2011
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
894 reads
The Power And Pain of Process–Part 1
Part of why I love IT is finding patterns and creating new ones. Patterns by themselves are interesting, but when...
2011-03-04
1,157 reads
Resource database
Today learned new thing about Resource database, as everybody knows resource database is the system database introduced in sql server...
2011-03-04
1,051 reads
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Sometimes, folks come to me, and ask for...
2011-03-04
5,061 reads
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the comparison of some methods and MS provided stored procs...
2011-03-03
23 reads
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the...
2011-03-03
466 reads
Differences between Merge and Union All transformations in SSIS
What are the differences between Merge and Union All transformations in SSIS ?
The first and most obvious difference is that Merge...
2011-03-03
1,610 reads
SSRS – Creating and Using Shared Schedules Part 3
In my two previous blogs in this series, I discussed shared schedules and walked you through step by step instructions...
2011-03-03
975 reads
SQL Lunch #50 - Solitary Containment (An Overview of SSIS Containers)
Join us tomorrow on the SQL Lunch for a little SSIS.
Topic: #50-Solitary Containment - An Overview of SSIS Containers
If you’ve ever...
2011-03-02
766 reads
I Give Up: What IS an MVP?
I’m so glad you asked!
Here’s how it works: Microsoft makes products. (The one I talk about the most is SQL...
2011-03-02
513 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