My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2018-02-26
670 reads
Blog Posts
Off to SQL in the City 2018
I’m off today on a plane, flying to the UK for this Wednesday’s SQL in the City broadcast. This is...
2018-02-26
335 reads
SQL Server Tune Your Transaction Log
Whenever a transaction log file grows the space it is allocated is divided up into virtual log files (VLFs). Depending...
2018-02-26
112 reads
Synonyms, how and why.
Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even...
2018-02-26 (first published: 2018-02-15)
3,356 reads
The Data Platform has expanded – so too should our approach in using it….
In recent years we as data professionals have moved from dealing with SQL Server databases with SQL Server Reporting Server...
2018-02-26
505 reads
Stop Worrying About Index Fragmentation and Manage Your Statistics
I see a lot of posts online about rebuilding indexes in a scheduled maintenance task, this is a pretty intensive...
2018-02-25
94 reads
Guide for Set Up of Telegraf for Monitoring SQL Server xPlat
Problem
We need a way to collect performance metrics for all our SQL Servers (Windows and Linux) into one system and...
2018-02-24
4,905 reads
If your Surface Book loses it’s keyboard and trackpad – try removing KB4074588 update
My Surface Book (gen 1) recently did updates and then a day or so later the keyboard and trackpad mysteriously...
2018-02-24
459 reads
Hobbies, stress relief, and meeting management: T-SQL Tuesday #99
It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that...
2018-02-23 (first published: 2018-02-13)
2,015 reads
How I Used Pragmatic Works Training to Pass the Power BI 70-778 Certification
Recently I took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft...
2018-02-23 (first published: 2018-02-12)
2,363 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