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

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

Building The Redneck Treadmill Desk

Don’t tell Brent Ozar, but here’s another DBA writing another helpful article about shrinkage. Before he gets bent out of...

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