VSLive 2018 Austin, TX
VSLive events are nice conferences to get a wide range of topics from .Net to mobile development to the data...
2018-02-01
485 reads
Blog Posts
Why I cannot download .pbix files from powerbi.com
If like me you thought “Hey, it’s a new feature, I can finally create reports in powerbi.com service and then...
2018-02-01
973 reads
Can You Hear It Now?
Here is a quick blog to show you something I discovered that I didn’t know existed.
I was on a Skype...
2018-01-31
392 reads
Database Fundamentals #16: Removing Data With T-SQL
Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.
How it Works
In the same way...
2018-01-31 (first published: 2018-01-22)
2,255 reads
DAX IF & Switch Statement Performance – Does Order Matter?
Intro
I’ve written a couple of article about IF & SWITCH in DAX over the past few years. Recently I noticed that...
2018-01-31
151 reads
Farewell, Tom Roush
My friend Tom died yesterday. I just heard the news a few hours ago and while it will take some...
2018-01-31
793 reads
I’m a Speaking Mentor!
I am so excited to announce that I have been accepted as a speaking mentor on SpeakingMentors.com!
I struggled for so...
2018-01-31
496 reads
Speaking at SQLSaturday 725 in Victoria
Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It...
2018-01-31
529 reads
SSMS Activity Monitor (Day 31)
SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance....
2018-01-31
800 reads
Surround Code with Comments in SQL Prompt
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2018-01-31
1,578 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