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

Do You Need A Log Recovery Tool?

A couple of weeks ago I wrote a post dispelling the myth that the simple recovery model disables the transaction...

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

sp_BackupDatabases v1.2

I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent...

What’s In My Utility Belt? Issue #1

Welcome to the first issue of what I hope will become a monthly series called “What’s In My Utility Belt?”....

SQL Query Formatting – Putting Lipstick On A Pig

“Psssst….”
“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this...