Category: PASS

Not Presenting At PASS Summit 2011

Sadly neither of the two sessions that I submitted for the PASS Summit 2011 were chosen and so I won’t be presenting. I’m not going to claim that I am not disappointed because I am. I felt that I had a really good chance of being chosen, but when there are 649 abstract submitted and only 111 slots available someone is going to miss out. This year I was one of the majority that didn’t make it.

I’m not disheartened, I’ll continue speaking at other events this year and next and already plan on submitting sessions for next years Summit.

I will, however, be at the Summit this year. I paid for my submission early in the year and got a significant discount on the price…which reminds me, go register now and save $600 on the full admission price.

There are going to be some fantastic speakers and sessions, including half-day sessions for that deeper dive (don’t take my seat in Bob Wards session if you know what’s good for you). Don’t forget there are 2-days of precons this year. I know my buddy Aaron Nelson (blog|twitter) would love to spend a day talking your ear off about PowerShell.

Hope to see you there, and to enjoy watching you entertain everyone at SQL Karaoke!

Central Auditing Of SQL Permissions Scripts

Yesterday I gave a presentation for the PASS PowerShell Virtual Chapter on central auditing of SQL permissions with PowerShell and TSQL. For those that attended feel free to download the scripts I used in my presentation. For those that didn’t…well you can still download them but this picture may not apply to you…

Image from http://whosawesome.com/

Presenting For The PASS PowerShell Virtual Chapter

A quick note, on Wednesday at 1PM EST I’ll be giving an online presentation on one of the two topics I submitted for the PASS Summit this year.

 The presentation will be heavy on the demo side of things and I’ll cover the basics of querying SQL Server using PowerShell, running scripts against multiple machines quickly and easily as well as bulk loading data into SQL.

Please check out http://www.powershell.sqlpass.org/ for a link to the livemeeting.

 

Central auditing of SQL permissions with PowerShell & TSQL

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

 

Rock The PASS Summit Vote

The PASS Summit 2011 is fast approaching. It’s being held in October this year and the call for speaker sessions has already closed. In a great turn of events PASS is asking you to take a part in helping to decide on the sessions to be presented. Up until May 20th you can vote on the sessions that you want to see.

I’ve already voted for multiple sessions over at the Session Preferencing page, please ensure that you do so as well. In doing so I hope that you consider voting for two sessions I submitted.

 

PowerShell: Are you checking out my profile? [100 level]
Session Category: Regular Session (75 minutes) 
Session Track: Enterprise Database Administration and Deployment 

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.

 

I’ve given this presentation at a couple of SQLSaturday events and it’s proven very popular both times. I have a couple of new items in my profile which extends this topic further.

 

Centralized auditing of permissions with SQL Server and PowerShell [100 level]
Session Category: Regular Session (75 minutes) 
Session Track: Enterprise Database Administration and Deployment 

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.

I will actually be presenting a shortened version of this on May 18th at 1pm EST for the PASS PowerShell Virtual Chapter. I hope you can attend that and get an idea of how the longer session could help you in auditing your SQL servers.