A PowerShell Cookbook for DBAs

Track: Enterprise Database Administration and Deployment
Level: 100 (Novice)
Abstract: This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of “recipes,” stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, 2008/2008 R2. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.
Goals:
  • Show the value of PowerShell to DBAs through practical applications of the tool, rather than teaching the language itself
  • Help new PowerShell users to get started by walking through installation and running one’s first scripts
  • Provide a dozen scripts that can be used immediately in the attendee’s daily work to save them time

This presentation has been/will be delivered at the following event(s):

Version Date Event
1.1 2010-06-05 SQLSaturday #22
1.2 2010-06-16 June user group meeting
1.3 2010-08-14 SQLSaturday #28
1.4 2010-10-09 Houston TechFest 2010
1.5 2010-10-27 October virtual chapter meeting
1.6 2011-01-29 SQLSaturday #57
1.7 2011-06-04 CodeStock 2011

The following Zip files contain the downloadable presentation materials (slides, code, and handout(s)):

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s