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

Looking back at 2009 Goals

I set goals at the start of 2009 for the year. They were:
Continue with 400 posts a month Blog Daily...

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