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

My Biggest Weakness

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

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