Granting or denying permissions to all of the tables within a database
When granting or denying permissions to the tables within a database you have two options. You can either add the...
2014-05-20 (first published: 2014-05-15)
4,950 reads
Quick Tips–SQL Prompt Formatting
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-20 (first published: 2014-05-14)
3,449 reads
Drop Me? No, I Don’t Think So–Question of the Day
Drop Me? No, I Don’t Think So is my latest question of the day and has to do with dropping...
2014-05-14
402 reads
2014-05-14
771 reads
Building the SQLSaturday Orlando Marketing Plan-Part 7
Just spent some time re-reading my notes far and my ideas from before – glad I wrote them down, lots and...
2014-05-14
541 reads
Smart As A Bear?
I got this at Hobby Lobby for $7 on sale, it’s about the width of a license plate and a...
2014-05-14
315 reads
Warrant Canaries & Transparency
I recently ran across the warrant canary FAQ from the Electronic Frontier Foundation (EFF). The concept is simple – put up...
2014-05-14
554 reads
Speaking at ITPROceed
I’m delighted to announce I will be giving a session at ITPROceed, a new event in Belgium for the IT...
2014-05-14
533 reads
T-SQL Tuesday #54 – Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog|twitter) and his chosen topic is “Interviews and Hiring” – specifically interviewing and hiring of SQL Server Professionals. This is a...
2014-05-14
9 reads
T-SQL Tuesday #54 – Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog|twitter) and his chosen topic is “Interviews and Hiring” – specifically interviewing and hiring...
2014-05-16 (first published: 2014-05-14)
1,763 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
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