Presenting at SQLSaturday #89–Atlanta

I’m very excited to be going to Atlanta on September 17th and presenting at the SQL Saturday event being held there. I was lucky enough to get two submissions accepted.

Centralized auditing of permissions with SQL Server

As a DBA it can be a challenge to know who has permissions to what SQL instances and what objects. The more instances you have the more complex that task. In this presentation I'll share a method using PowerShell and TSQL that can be used to capture permissions from all of your SQL instances and load them into a centralized location. We'll even take it a step further by auditing those permissions so that we can quickly and easily identify any that might have changed.

PowerShell: Are you checking out my profile?

PowerShell is a very powerful management tool and you can spend hours writing magical scripts to provide automation for frequently run tasks. Often forgotten is the PowerShell profile, a place you can add your own functions which can provide you lightning fast access to information. In this session we'll talk about the power a profile puts at your fingertips. I will also demo (and share) several PowerShell functions that I use frequently for common tasks like checking database backups and disk space. I'll show you my PowerShell profile if you show me yours.

There are a grand total of 17 MVP’s presenting that day. I’m frankly stunned I have to opportunity to be in rarified company and be able to speak myself (in fact my first session I’m up at the same time as 7 MVP’s so I’m expecting a quiet room). It should be a blast though, be sure to say hi if you’re there. I might even sneak in a preview of my PASS Summit Lightning talk.

Such fun.

Presenting At SQLSaturday #67

This upcoming weekend (3/26/11) I will be speaking SQLSaturday #67 in Chicago. My 10:45AM session is titled “PowerShell: Are you checking out my profile?”

I think the title sums it up pretty well, but in case you need more details: Powershell is a very powerful management tool and you can spend hours writing magical scripts to do all the things you want. Frequently forgotten is the Powershell profile, a place you can add your own functions which can provide you lightening fast access to information. We'll talk about the power a profile puts at your fingertips. I will also demo (and share) a bunch of short functions that I use frequently for common tasks. I'll show you my Powershell profile if you show me yours.

If you decide to attend my session don’t expect much in the way of pretty slides, extended powerpoint information and the like. This is going to be heavy on the demo side of things and interactive, so bring your questions, thoughts and ideas.