Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-12-02 (first published: 2020-11-20)
388 reads
Book Review: Making Work Visible
I was recommended Making Work Visible by a developer at Redgate Software. The book caught my eye as it seeks to ensure you can work more efficiently by watching...
2020-12-04 (first published: 2020-11-20)
325 reads
The Silliness of a Group
Recently we had a quick online tutorial for Mural, a way of collaborating online with a group. It’s often used for design, but it can be used for brainstorming...
2020-11-20
28 reads
Daily Coping 20 Nov 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-11-20
28 reads
Sharding Mongodb
Sharding is a method for distributing data across multiple machines. MongoDB uses sharding to support deployments with very large data sets and high throughput operations.(more...)
2020-11-20
28 reads
Power BI Monthly Digest – November 2020
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-12-01 (first published: 2020-11-20)
343 reads
Announcing EightKB 2021
The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1,000 attendees!
We were honestly blown away by how successful the first...
2020-11-19
21 reads
Announcing EightKB 2021
The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1,000 attendees! We were honestly blown away by how successful the...
2020-11-19
67 reads
Speaking at DPS 2020
I was lucky enough to attend the Data Platform Summit a few years ago. One of my favorite speaking photos was from the event.Me on a massive stage, massive...
2020-12-03 (first published: 2020-11-19)
130 reads
Daily Coping 19 Nov 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-11-19
23 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