2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as...
2019-01-01
1,005 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
9 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
8 reads
Why Can't I Shrink TempDB?
I know, I know....#OMGShrinkingIsBadDontEverDoThatOrElseEtcEtcEtc
We all know that there are simply times you have to shrink some files. There are risks...
2019-01-14 (first published: 2019-01-01)
559 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...
2019-01-01
37 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...
2019-01-01
443 reads
Happy 2019!
As I’m writing this it’s actually still 2018, so this is both my last blog post of the year and the first blog post of the new year ??...
2019-01-01
12 reads
The most-read posts in 2018
Good morning #sqlfamily folks! The very first post in the new year 2019. Tell me: when this time passed??? The...
2019-01-01
205 reads
An error occurred while writing an audit trace. SQL Server is shutting down
There was this incident at one of the clients in recent past. It was a nice morning. I was enjoying the tea of the day. I just started my...
2019-01-01
49 reads
Using Microsoft Learn
I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...
2018-12-31
437 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