Stress Thoughts–Part 1
If I had to tell you that one thing I’ve gotten better at in the past 5 years it would...
2012-03-26
722 reads
Blog Posts
Building the Enterprise DW/BI System with SQL Server PDW
Building the Enterprise DW/BI System with SQL Server PDW
Most readers considering a Parallel Data Warehouse already have a data warehouse...
2012-03-25
4,422 reads
Coming to Dallas: Something for Everyone
Everybody loves the carnival. It only comes around every few years, but when it does, it brings in a variety...
2012-03-23
891 reads
Dell Quickstart Data Warehouse Appliance for SQL Server 2012
As a follow-up to my blog Microsoft SQL Server Reference Architecture and Appliances, Dell recently announced the future availability of Dell Quickstart...
2012-03-23
1,321 reads
Google Research
Interesting to see someone talking about all the research Google is spending money on, which aren’t directly related to their...
2012-03-23
1,284 reads
Re-blog – March 16 – March 22
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-23
787 reads
SQL Server RESTORE DIFFERENTIAL BACKUP WITH SIMPLE RECOVERY
First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database...
2012-03-23
15,881 reads
Trim Functions in SSIS
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In...
2012-03-23
2,020 reads
Change your Windows path
When you run something from the start menu or in a Windows command prompt, you type the program name to...
2012-03-22
1,864 reads
Event ID 7026 and i8042prt troubleshooting
Event ID 7026 and i8042prt is a recurring error in the Windows Event Logs. I usually see this error on...
2012-03-22
7,332 reads
Blogs
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