Change Package Properties Using Parameters–SSIS 2012
In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced...
2012-04-24
14,293 reads
Blog Posts
List of Sharepoint Blogs
I ran across this list of Sharepoint blogs by Rene Modery while doing some Sharepoint reading. He has an OPML...
2012-04-24
685 reads
OPASS April Meeting Recap
Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting. I spoke on Extending...
2012-04-24
1,142 reads
Oracle Tips for MSBI Devs #3: Choosing Drivers
When working with Oracle, drivers are truly a pain to get working correctly. I will discuss my preferred choice and...
2012-04-24
923 reads
SQL Backup 7
What more could you add to a SQL Server backup product? It seems that many software products, including Red Gate’s...
2012-04-24
1,256 reads
SQL Server 2005 backups in a hung state because of full text search process
I came across an issue today where a backup process was in a blocked state with a wait type of...
2012-04-24
624 reads
Who are the sysadmins in this sql server?
Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...
2012-04-24 (first published: 2012-04-23)
33,114 reads
Denali – Blog a Day Series : May, 2012
Denali
Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is...
2012-04-23
636 reads
Do You Know These Free Events?
I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may...
2012-04-23
734 reads
Intel Ivy Bridge Release Coverage
Web sites, blogs and media outlets in Europe and the U.K. are starting to post some early Ivy Bridge stories,...
2012-04-23
1,067 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