Webinar: Is the traditional data warehouse dead?
As a follow-up to my blog Is the traditional data warehouse dead?, I did a webinar on that very topic for...
2018-03-28
414 reads
Blog Posts
Webinar: Is the traditional data warehouse dead?
As a follow-up to my blog Is the traditional data warehouse dead?, I did a webinar on that very topic for...
2018-03-28
103 reads
What’s the difference between Files and Filegroups?
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct...
2018-03-28
786 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Watch this week's video on YouTube
Many people think daylight savings time was created to help align the hours that the sun is up with our waking hours so farmers...
2018-03-27
22 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Watch this week's video on YouTube
Many people think daylight savings time was created to help align the hours that the sun is up with our waking hours so farmers...
2018-03-27
33 reads
DB_NAME() vs ORIGINAL_DB_NAME()
I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular...
2018-03-27 (first published: 2018-03-15)
2,906 reads
How To Steal Data Using Second Order SQL Injection Attacks
One misconception some people have about SQL injection is that it can only happen when concatenating a user input parameter...
2018-03-27 (first published: 2018-03-20)
5,069 reads
Template Explorer Gold Mine
Sometimes as a newbie to SQL Server using SQL Server Management Studio (SSMS) you don’t know about the little gold...
2018-03-27
510 reads
Women in Technology - All are welcome!
I was at SQL Saturday 723 in Rochester, NY last weekend. I was selected to deliver 2 sessions, and I...
2018-03-27
221 reads
Azure SQL Database and Cost Threshold for Parallelism
We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated...
2018-03-26 (first published: 2018-03-16)
2,341 reads
Blogs
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