NOTE THE CHANGE OF VENUE

SQLLunch

12:30 sharp start , upstairs bar at the The Old Doctor Butler's Head, EC2V 5BT

Agenda :

12:30 - 12:31 Welcome and hello

12:31 - 13:30 Remote Presentation : Andre Kamman

How to outsource yourself with a Powershell script 

Well, kidding of course. Someone needs to maintain those scripts :-) But there is a lot of repetitive work that can easily be scripted. And powershell is so versatile that it can be used to make scripts that "think" the way a DBA thinks. It will solve problems or complete a task for you that includes reacting to various (un)expected circumstances. I will show you how to use some cool new features of Powershell 3, like workflows and web access, and I'll use some of my own scripts to demonstrate how this all comes together.

Speaker bio

I’m a SQL Server consultant based in the Netherlands, an MVP and I'm part of the team that runs the Dutch PASS Chapter & SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100's of servers. Currently the better part of my day is spent with SSIS. In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that ;-)