2015-12-15
7 reads
Comparing data in two identical tables
Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for...
2015-12-14
893 reads
Supporting Khan Academy
Khan Academy is doing a fund raiser and I just donated $10 to help out – my kids have easily gotten...
2015-12-15 (first published: 2015-12-14)
1,741 reads
The Writeable Warm Standby
I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log...
2015-12-23 (first published: 2015-12-14)
1,760 reads
Monday Morning SQL Break – December 14, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-14
420 reads
One More PASS Board Update for 2015
Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?
Never mind.*
Instead, it seems I’ll be...
2015-12-18 (first published: 2015-12-14)
1,259 reads
Can we get a license for DDL Triggers?
There are several types of triggers.
Logon triggers – Fired when someone tries to connect to the instance.DML triggers – Fired after...
2015-12-17 (first published: 2015-12-14)
1,697 reads
Picking a Clustered Index
A Clustered Index is not another term for Primary Key, and more thought should be put into the key columns...
2015-12-16 (first published: 2015-12-14)
2,592 reads
Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?
So two new exciting capabilities were announced recently in Power BI. One involved Excel and the other SSRS, but they...
2015-12-17 (first published: 2015-12-14)
1,867 reads
SQL Server – Check the status of active Trace Flags
Hi friends, few days back I was exploring data masking features introduced in SQL Server 2016. I got stuck in...
2015-12-14
558 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