Your Quick Introduction to Extended Events in Analysis Services
XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and...
2021-01-01
12 reads
Your Quick Introduction to Extended Events in Analysis Services
XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and...
2021-01-01
10 reads
Your Quick Introduction to Extended Events in Analysis Services
XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and...
2021-01-01
15 reads
Your Quick Introduction to Extended Events in Analysis Services
XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and...
2021-01-01
32 reads
Your Quick Introduction to Extended Events in Analysis Services
XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and...
2021-01-01
19 reads
Your Quick Introduction to Extended Events in Analysis Services
XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and...
2021-01-01
670 reads
Logging the history of my past SQL Saturday presentations
(2020-Dec-31) PASS (formerly known as the Professional Association for SQL Server) is the global community for data professionals who use the Microsoft data platform. On December 17, 2020 PASS announced...
2020-12-31
146 reads
Storage savings with Table Compression
In one of my recent assignments, my client asked me for a solution, to reduce the disk space requirement, of the staging database of an ETL workload. It made...
2021-01-06 (first published: 2020-12-31)
494 reads
Daily Coping 31 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-31
72 reads
Hope!
2020 was a rough year. We’ve had friends and family leave us. Jobs lost. Health scares a plenty and that’s ... Continue reading
2020-12-31
70 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