Upcoming conferences
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...
2016-04-26
876 reads
Interview with Warwick Rudd
Part of traveling to various events and being a part of the SQL Community means one can meet some pretty...
2016-05-09 (first published: 2016-04-26)
1,017 reads
Strengthsfinder Results
I recently took the Strengthsfinder evaluation and thought I’d save the results here.
2016-04-26
619 reads
How to Recover Data From Corrupted Log File In SQL Server ?
Introduction
SQL Server is a database platform designed for providing large-scale transactions, e-commerce applications, data mining, etc. It is widely used...
2016-04-26
4,653 reads
PASS – A Business Case for Attendance
[read this post on Mr. Fox SQL blog] For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say that’s a huge number!) the PASS Summit provides...
2016-04-25
10 reads
PASS – A Business Case for Attendance
[read this post on Mr. Fox SQL blog]
For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say...
2016-05-06 (first published: 2016-04-25)
2,467 reads
Cumulative Updates Every 2 Months
The SQL Server team is implementing an Incremental Servicing Model (ISM) to deliver updates for SQL Server. This is basically a...
2016-04-25
605 reads
Explicitly using tempdb with ##tables
I had someone ask me last night if this statement would create a permanent table in tempdb with a strange...
2016-04-25
1,702 reads
Monday Morning SQL Break – April 25, 2016
It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s...
2016-04-25
519 reads
Upcoming Florida IT Pro Camps
Two IT Pro Camps coming up, register soon!
IT Pro Camp – Jacksonville FL – June 11 at Keiser UniversityIT Pro Camp – Tampa...
2016-05-05 (first published: 2016-04-25)
1,034 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