2015 in review
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2016-01-04
337 reads
Monday Morning SQL Break – January 4, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-04
443 reads
Query the Buffer Pool
SQL Server's buffer pool is a majority of your memory, but most DBAs can't tell you what's in it.
2016-01-04
25 reads
Query the Buffer Pool
DBAs are known for asking for more memory, but often can’t say what’s in memory. While I agree that many...
2016-01-07 (first published: 2016-01-04)
2,749 reads
2015 a year in review
It’s a new year, so time to look back at the previous year, and forward to the next. I’ll tell...
2016-01-04
445 reads
Technical Dogma
Humans are creatures of habit, and I suspect that engineering/technical types are even more so. We find something that works...
2016-01-04
453 reads
Hidden GUI Gems
I have a few gems that are available to you in the GUI. These gems should help solidify your understanding of the tools available through the GUI to help...
2016-01-02
7 reads
Hidden GUI Gems
The GUI for Extended Events offers some power to help you get started with trying to work with Extended Events....
2016-01-02
1,485 reads
Happy New Year Friends
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.
2016-01-01
18 reads
Happy New Year Friends
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and...
2016-01-01
478 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