Remembering Robert Davis, aka @SQLSoldier
I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...
2018-04-03
57 reads
Blog Posts
2018-04-03
264 reads
TDE – Regenerating the Database Encryption Key
As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...
2018-04-03
1,153 reads
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...
2018-04-03
580 reads
Why Projects Fail...Free Session, Free Beer and Free Food
Why Projects Fail...Free Session, Free Beer and Free Food
Mark Williams and myself will delivering a seminar called #Not the GDPR news in...
2018-04-03
324 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Many people think daylight savings time was created to help align the hours that the sun is up with our...
2018-04-02 (first published: 2018-03-27)
5,202 reads
Buggy Whips 2.0
I recently found myself rereading a very old blog post of mine, from the very beginning of this blog, discussing...
2018-04-02
282 reads
Free Webinar – DBAs vs. SysAdmins in Cloud Availability April 19
SIOS and I are proud to host a joint free webinar entitled “DBAs vs. SysAdmins in Cloud Availability” on Thursday,...
2018-04-02
289 reads
How SQL Compilation Can Prove the Server CPU
It is relatively easy to spot CPU-bound system. But, the source of CPU pressure is not always easy to pinpoint....
2018-04-02
1,266 reads
Imposter syndrome
Last week I posted the following “joke” on twitter: –
I’ve called it a “joke” but I wasn’t really joking. This...
2018-04-02
307 reads
Blogs
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