Stored Procedures to Store and Get Database Users with All Permissions

Introduction

Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...

[OT] Happy New Year

Well, it's been an interesting year. I got to teach four different brand new SQL Server courses, and teach classes...

Final Recap – 2009 Goals

Well, I set 7 professional goals for 2009 and I did okay in meeting them, but I was not successful...

Goals for 2010

Last year I wrote about my goals for 2009. Yesterday I looked over them and evaluated my performance. I think...

Running a Small User Group - Remember, It's Not Exclusively Yours

I'm going to conclude this series on running a small user group with a topic that came up for discussion earlier...

Script Individual User Rights in a Database with PowerShell

Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...

Wrapping Up Blogging for 2009

I think I’ve met my goal of blogging every day. I’m at almost 800 posts now over the past 2.5...

A Small Collection of I/O Specific DMV Queries

It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many...

Practice Your Restores

Steven Jones posted an excellent editorial today all about how your backups are only good if you know that you...

Running a Small User Group - The Tools

Because running a small user group is a labor of love, we look for time savings wherever we can to...