gdpr - panic part 4
In the first part of this series, we looked at where to find out more information about GDPR in the...
2018-02-08
104 reads
Blog Posts
gdpr - panic part 4
In the first part of this series, we looked at where to find out more information about GDPR in the...
2018-02-08
120 reads
Layman’s Guide to Performance Tuning
Performance tuning is one of those things that is hard to get right when you do not have an established...
2018-02-08 (first published: 2018-01-30)
3,532 reads
Managing SQL Prompt Code Analysis Rules
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2018-02-08 (first published: 2018-01-29)
1,612 reads
sp_AGReconfigure 1.1 is now available
sp_AGReconfigure 1.1 is now available HERE and on GitHub
V1.1 includes a new Parameter and some minor bug fixes:
@Readable
NULL – DEFAULT: ...
2018-02-08
390 reads
Speaking at PASS.org Summit
For the last 7 years, I have been speaking at the PASS Summit. This event is usually in Seattle, but one year it was in Denver (did not speak...
2018-02-08
11 reads
Speaking at PASS.org Summit
For the last 7 years, I have been speaking at the PASSSummit. This event is usually in Seattle, but one...
2018-02-08
330 reads
“Data Security for the Cloud”: A New Pre-Con at SQLSaturday Chicago
More and more companies are considering a move to the cloud, but one aspect of such a migration that may...
2018-02-07
339 reads
Azure SQL Database sa Connections?
I was using a query on one of my local SQL Servers where I wanted to know what logins were...
2018-02-07
1,100 reads
Deleting Azure SQL Database VNETs
This is quite a new feature (currently in preview) but an important one where we now have the ability to...
2018-02-07 (first published: 2018-01-29)
1,038 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