Versions (Master Data Services) - Where to use
Multiple versions of the master data within a model can be created in Master Data Services(MDS).When you create a model...
2015-08-21
702 reads
Designing a Data Warehouse from the Ground Up Webinar Recording with Q & A
Thank you to everyone that registered and attended my webinar Designing your Data Warehouse from the Ground Up webinar this...
2015-08-21
753 reads
Your Devs' Questions Answered With sys.dm_server_services
It starts with "I'm a developer...
"... with no RDP access, how can I tell if the SQL Server Agent service...
2015-08-20
831 reads
ISNULL around the predicate and SARGability
You may have heard of the word, SARGable. In brief, it’s a term derived from the phrase, Search ARGument able,...
2015-08-20
3,836 reads
Importing Power Pivot & Power View into Power BI
The Power BI August update just rolled out today (8/20/2015) and in the latest update there’s a lot of cool,...
2015-08-20
2,492 reads
Changing Cell Phones Again
Slightly off topic, but since I use a cell phone so much for data transfer and work, it’s important that...
2015-08-20
844 reads
Reblog: How I prepared myself for the MCSE certification
SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL...
2015-08-20
1,075 reads
Remember Nepal - Lead by Example
Below is the original article in its entirety, that was published on the Americas MVP Community Facebook page, on July...
2015-08-20
1,444 reads
Creating an SQL Databases – New Portal
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-08-19
1,024 reads
Tables, Columns and Defaults Oh My!
The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script...
2015-08-19
7 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