Take-aways from the 2011 Microsoft MVP Summit
Every year, Microsoft brings a couple thousand specialists from every corner of the globe together for a few days to...
2011-03-07
633 reads
In summary - SQLskills internals.
Well, I attended a full week of SQL internals from Paul Randal [Blog | Twitter] and Kimberley L. Tripp [Blog | Twitter]...
2011-03-06
507 reads
SQL Server Hardware Selection Presentation from Rocky Mountain Tech Trifecta
I just wanted to post a link to my presentation on Hardware 201: Selecting and Sizing Database Hardware for OLTP...
2011-03-05
515 reads
Leading Wildcards Aren’t A Good Default
SQL Server has LIKE, which lets us do various pattern matches, but most commonly we use the percent side as...
2011-03-05
1,188 reads
Women in Technology PPT Template
Well hey-howdy-hey (as we don’t say in Texas), it’s Women’s History Month! And by all accounts, it’s going to be a...
2011-03-04
1,036 reads
Oh Yes It’s Ladies Ni…errr…Month
Making WIT awesome since 1993
It’s March and this month sees a lot of celebration, amongst the parties are Mardi Gras...
2011-03-04
446 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes. There was a lot of good feedback from that....
2011-03-04
14 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes....
2011-03-04
521 reads
Back from the MVP Summit
Back home after three days in Seattle at the 2011 MVP Summit. As I wrote in an editorial this week,...
2011-03-04
445 reads
March PASSMN Meeting Announced
Come one, come all to the March PASSMN meeting – that’s the Minnesota SQL Server User Group. This month we’re going...
2011-03-04
662 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