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...

Superpowers Revealed

Like many of you out there, I’m constantly looking for new things to learn. A new skill, a new hobby,...

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...

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...

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...

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...

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...

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...

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...

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...