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

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

Analysis Services Performance Optimization Tips

Over the last few weeks I have focused most of my blog energy into writing a couple articles.  So I...

Running a Small User Group - Getting Help

When we first started Midlands PASS, we tried to do it the way PASS suggested. We tried to get folks...