Using a Symmetric Key
In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...
2012-06-27
3,016 reads
Microsoft Data Quality Services in SQL Server 2012
SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012. The...
2012-06-27
5,206 reads
Last Week to Enter the Exceptional DBA Contest
Just a reminder: you have until this Friday to enter the 2012 Exceptional DBA awards. I’m judging, and looking forward...
2012-06-27
1,623 reads
How to Create Reporting Services 2012 Report Templates
When I started writing this blog I realized it has been several months since my last post. I guess that...
2012-06-27
9,458 reads
How to Create Reporting Services 2012 Report Templates
When I started writing this blog I realized it has been several months since my last post. I guess that...
2012-06-27
1,746 reads
The New Phone Book Is Here!
I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....
2012-06-27
1,611 reads
The report execution has expired or cannot be found. [rsExecutionNotFound]
I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:
The report execution has expired or...
2012-06-27
12,455 reads
Guest Post – DBAvolution
One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it...
2012-06-27
2,015 reads
How Local Variable or Optimize for Unknown Resolve Parameter Sniffing
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible...
2012-06-27
3,437 reads
Down and Dark
I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly...
2012-06-26
1,570 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