T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
27 reads
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
16 reads
Daily Coping 8 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-08
37 reads
T-SQL Tuesday #133–What I Learned From Presenting
This month Lisa Griffin Bohm is the host and thanks to her from hosting. She was one of the last people I pressured lightly to host. She came up...
2020-12-08
24 reads
Using Aws Sdk With Go for Ec2 Ami Metrics
Source
The source code for this repo is located here:
What This Is
This is a quick overview of some AWS SDK Go work, but not a detailed tutorial.
I’d love feedback from...
2020-12-17 (first published: 2020-12-07)
151 reads
Data Architecture Blog Post: CI CD in Azure Synapse Analytics Part 1
Hello Dear Reader! It's been a while. I've got a new blog post over on the Microsoft Data Architecture Blog on using Azure Synapse Analytics titled, CI...
2020-12-07
20 reads
Data Architecture Blog Post: CI CD in Azure Synapse Analytics Part 1
Hello Dear Reader! It's been a while. I've got a new blog post over on the Microsoft Data Architecture Blog on using Azure Synapse Analytics titled, CI...
2020-12-07
88 reads
AutoCorrect in Git
I can’t believe autocorrect is available, or that I didn’t know it existed. I should have looked, after all, git is smart enough to guess my intentions. I learned...
2020-12-18 (first published: 2020-12-07)
221 reads
Migrating from SQL Server to Amazon AWS Aurora
Is Microsoft’s licensing scheme getting you down? It’s 2020 and there are now plenty of data platforms that are good for running your enterprise data workloads. Amazon’s Aurora PaaS...
2020-12-16 (first published: 2020-12-07)
669 reads
Daily Coping 7 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-07
37 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