T-SQL Documentation Generator
This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-01-08
10 reads
T-SQL Documentation Generator
This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-01-08
21 reads
Msg 8909, Level 16, State 1, Line 1 Table error: Object ID index ID partition ID
Being a DBA , you will see database...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-01-08
16 reads
Msg 8909, Level 16, State 1, Line 1 Table error: Object ID index ID partition ID
Advertisements
Being a DBA , you will see database corruptions in your environments. I got four or five and not affected much...
2019-01-08
27,592 reads
Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment
Pre-conference Workshop at SQLSaturday Chicago – 825
I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Chicago on March 23rd 2018! This...
2019-01-08
9 reads
Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment
Pre-conference Workshop at SQLSaturday Chicago – 825
I’m proud to announce that I will be be presenting an all day pre-conference workshop...
2019-01-08
233 reads
The Top 4 Data Technology Trends Every DBA Should Know About in 2019
Join Sentry One, Kevin Kline, and me in an exciting (and laugh-filled) panel session this Wednesday, January 9th, at 2pm...
2019-01-07
46 reads
Azure SQL DB VS SQL Server For the DBA
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
324 reads
PowerShell to Simulate Load
Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still...
2019-01-17 (first published: 2019-01-07)
2,345 reads
Query plan hash
This is post 3 in the series about query fingerprints. Here’s the previous posts in this series:
Query HashSQL Handle
What is...
2019-01-07
944 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