Automated Permissions Auditing With Powershell and T-SQL: Part 4
Previously, on REAL-SQL-Guy…
We were introduced to two SQL queries to obtain database login permissions, one for SQL Server 2000, one...
2013-11-18
1,063 reads
RealSQLGuy - Helping You To Become A SQL Hero
Superpowers Revealed
Like many of you out there, I’m constantly looking for new things to learn. A new skill, a new hobby,...
2013-11-16
422 reads
Friday Followup For November 15, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-15
487 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 3
In this episode, I’m going to start introducing some of the Powershell elements that tie this audit process together.
DISCLAIMER: I...
2013-11-14
3,540 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 2
In Part 1 of this series, I presented a T-SQL query that will return a summary of login permissions within...
2013-11-13
579 reads
The Cloud Is Scary – #TSQL2sDay #49
It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic...
2013-11-12
645 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 1
A big part of my job is controlling security to multiple production databases, and reporting on that security for quarterly...
2013-11-11
1,048 reads
SYS.PARTITIONS: Better Than X-Ray Vision
Originally posted 2011-09-09 21:27:00. Republished by Blog Post Promoter
Over the past few months, I’ve been doing a lot of work...
2013-11-19 (first published: 2013-11-09)
2,011 reads
Friday Followup for November 8th, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-08
447 reads
Transparent Data Encryption’s Dirty Little Secret
Remember when you were eight years old, how exciting it was to order some of those amazing products that were...
2013-11-07
939 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