SQL Server 2012 AlwaysOn Availability Groups – Part 1
In the last weeks and months I have prepared tons of SQL Server 2012 content for my
own SQL Server 2012...
2012-03-21
18,805 reads
Blog Posts
SQL Server 2012 Special Ops Tour - NYC
Tomorrow, Thursday, March 22, 2012, the official Microsoft SQL Server 2012 Special Ops Tour continues its 12-city trek around the...
2012-03-21
1,747 reads
SQL Server Crossword #4
To mark my 31st Birthday today(gifts are of course most welcome) here’s a SQL Server Crossword for you to enjoy. You...
2012-03-21
983 reads
SQL Server Database Mirroring Tips and Tricks, Part 2
If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common...
2012-03-21
1,508 reads
SQL Tribal Knowledge needs editors!
A while back I invited the unpublished masses to submit abstracts for a new-author-written SQL book – called Tribal SQL – and the...
2012-03-21
659 reads
STOP! Consolidate and Listen
I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance,...
2012-03-21
916 reads
Whitepaper: Demystify Tempdb Performance & Management
Whitepaper: Demystify Tempdb Performance & Management
Demystify Tempdb Performance & Management
There are many misconceptions and myths about tempdb and purported best practices are...
2012-03-21
1,561 reads
Wish you were here
When I was growing up, we used to sit round the t.v. (families only had one in those days) and...
2012-03-21
765 reads
Debugging query timeouts by sampling blocking – part 2
In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...
2012-03-20 (first published: 2012-03-15)
2,919 reads
Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)
Free E-Book: Introduction to SQL Server 2012
Ross Mistry and Stacia Misner have again done a wonderful job on this free...
2012-03-20
2,418 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