Intro to Data Factory–Training on the T’s Follow Up Post
This is a follow up blog post based on the Intro to Data Factory session I gave on the Training...
2015-01-13
985 reads
T-SQL Tuesday #62 – Healthy SQL
The invitation for T-SQL Tuesday this month comes from Robert Pearl. It’s called HealthySQL and it’s a topic I like....
2015-01-13
808 reads
Identify Primary Keys That Are Not Identity Columns
Reading Time: 3 minutesPrimary Keys help keep your database in balance
Continuing the thoughts of knowing what is going on in...
2015-01-13
1,164 reads
Dev Tools: The File Searcher/Launcher to rule them all
Why does this not have more recognition? In the experimentation of various file management and launching apps, I've tried several...
2015-01-13
826 reads
TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?
I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this...
2015-01-15 (first published: 2015-01-13)
6,308 reads
Putting Your head in the Cloud– A Beginner’s Guide to SQL Azure
David Postlethwaite will be speaking at this years SQL Saturday Vienna. The event will be held in Vienna on Saturday...
2015-01-13
507 reads
Author of the Year at MSSQLTips.com
I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at...
2015-01-13
521 reads
T-SQL Tuesday #62 - Achieving Healthy SQL with MDW
Today:
Tuesday, January 13, 2015 is the 62nd entry and first T-SQL Tuesday
of the year 2015, and I am honored to...
2015-01-16 (first published: 2015-01-13)
8,773 reads
T-SQL – How to find Next Business day from a given date
There are many methods to find next business day. One common way is to use of calendar table. This post is to...
2015-01-19 (first published: 2015-01-12)
8,226 reads
She Taught Me to Code–A Tribute to Sheila, My Wife
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals...
2015-01-12
756 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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