Daily Coping 2 Sep 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-09-02
29 reads
Group By 2020 Fall Edition – Call For Speakers
The Call for Speakers for the 2020 Fall edition of GroupBy is open, but it closes in just 3 days! We’re currently using Sessionize to help us organize this...
2020-09-02
61 reads
Skip Validation of SSIS Packages
There’s been an update of the SSIS extension for Visual Studio 2019. There are some bug fixes and deployments are blocked to Azure-SSIS if the target server version is...
2020-09-10 (first published: 2020-09-02)
599 reads
Failing SQL Agent Jobs – Part 1
SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log...
2020-09-09 (first published: 2020-09-01)
657 reads
Daily Coping 1 Sep 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-09-01
32 reads
SQL Homework – September 2020 – More DML Triggers
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading
2020-09-01
118 reads
Daily Coping 31 Aug 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-08-31
28 reads
Information Measurement with SQL Server, Part 6.1: Information Gain and Tree Structures
By Steve Bolton …………Like many of my other series of amateur mistutorials, the section of my blog devoted to the broad topic of Information Measurement is ultimately meant to...
2020-09-07 (first published: 2020-08-30)
591 reads
Creating Your First Azure Data Factory
Azure Data Factory has grown in both popularity and utility in the past several years. It has evolved beyond its significant limitations in its initial version, and is quickly...
2020-09-08 (first published: 2020-08-28)
517 reads
Podcast recording – Mixed Extents 01 – Cloud vs. On-Prem
I’m thrilled to have been part of the second EightKB Mixed Extents podcast recording where Joey D’Antoni, Melody Zacharias, Andrew Pruski, Mark Wilkinson, Anthony Nocentino, and I talked about...
2020-09-09 (first published: 2020-08-28)
222 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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