What the ???? T-SQL Tuesday #120
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and all. Wayne Sheffield (blog|twitter) is our ... Continue reading
2019-11-21 (first published: 2019-11-12)
455 reads
First Time Speaking at PASS Summit
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive the experience.
2019-11-12
26 reads
First Time Speaking at PASS Summit
Watch this week's video on YouTube
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive...
2019-11-12
10 reads
First Time Speaking at PASS Summit
Watch this week's video on YouTube
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive...
2019-11-12
10 reads
Azure SQL Best Practices?
A way to enforce good practice and standards is by Azure Policy. As stated by Microsoft “Azure Policy is a service in Azure that you use to create, assign,...
2019-11-12
63 reads
Azure Data Studeo- Nov 2019 Release
SQL Server Management studio is now can be installed separately not part of SQL Server package. with this enhancement SSMS has several features and version is getting updated and...
2019-11-12
63 reads
Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you […]
The post Build a...
2019-11-11
28 reads
Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-11
36 reads
Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-18 (first published: 2019-11-11)
589 reads
Azure Synapse Analytics new features
Almost lost in all the announcements from Ignite was a bunch of amazing new features that were added to the Provisioned Resources/SQL Pool section (read SQLDW functionalities) side of...
2019-11-19 (first published: 2019-11-11)
534 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