Three in a Row – MVP Renewed

I woke up this morning, late, after a great New Year’s Eve with friends. Too tired to get out of...

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

My Biggest Weakness

I took some time off in December and I'm finally getting around to catching up on RSS feeds. Turns out...

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

Saying Goodbye To 2009

I'll close out 2009 with an update on the goals I set at the beginning of this year and things...

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

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

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