tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
298 reads
Blog Posts
tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
244 reads
Forensic Analysis of Log files in SQL Server
The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we...
2018-02-05
3,464 reads
Giving back – Speaking Mentors
I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who...
2018-02-05
338 reads
How to write a PowerShell function to use Confirm, Verbose and WhatIf
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the...
2018-02-05 (first published: 2018-01-25)
1,609 reads
Learning Goals–January Review
In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks...
2018-02-05
398 reads
PASS Summit 2017 Wrap-Up - The People!
I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...
2018-02-05
10 reads
SQL Homework – February 2018 – Work with security
This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts
Create a SQL login and a Windows authenticated login....
2018-02-05
310 reads
Will GDPR cause a “Database Run”?
What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set...
2018-02-05 (first published: 2018-01-23)
2,415 reads
Power BI with Azure Data Lake - where the water doesn't run dry
(2018-Feb-04) I've had a case working with very large data files as a source for my heat map visualizations in...
2018-02-04
730 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