THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

PASS PowerShell/SQL Server PreCon

PowerShell is an amazing tool to help you automate your administrative processes. There are a lot of books and online sources to help you learn PowerShell, but how do you learn how to use it with SQL Server? Simple, just sign up for my PASS PreCon session. Here's the outline:

Use PowerShell to Get the Most out of SQL Server

  • Module 1: Introduction to PowerShell
    • Cmdlets
    • Aliases
    • The Pipeline
    • Variables
    • Objects
    • Control Flow
    • Functions
    • Modules
    • Error Handling
    • Command-line Arguments
  • Module 2: Introduction to SMO
    • Introduction to the SMO Library
    • SQLPS.exe - The SQL Server Mini-Shell
    • The SMO Object Model
  • Module 3: Backup and Recovery
    • Backup
    • Restore
  • Module 4: Automating & Maintaining Databases
    • Automating Index Maintenance
    • Automating DBCC
  • Module 5: Importing, Exporting and Transforming Data
    • ADO.NET
    • Invoke-SQLCMD
    • Importing and Exporting using CSV Files
    • Importing and Exporting using XML Files
  • Module 6: Manipulating Database Objects
    • Creating and Deleting Schemas
    • Creating, Modifying and Deleting Tables
    • Creating, Modifying and Deleting Triggers
    • Creating, Modifying and Deleting Indexes
    • Creating, Modifying and Deleting Views
  • Module 7: Managing the Enterprise
    • Registering Servers
    • Creating a Central Management Server
    • Connecting to a Central Management Server
    • Running Scripts Against Multiple Servers
    • Defining Policies for Policy-Based Management
    • Evaluating Policies for Policy-Based Management
  • Module 8: Profiling and Monitoring SQL Server
    • Gathering WMI Information
    • Gathering Performance Counters
    • Setting up a Server Side Trace
    • Monitor Log Growth
  • Module 9: Configuring and Tuning SQL Server
    • Setting Configuration Options
    • Setting Windows Mode or Mixed Mode

As you can see, we're going to spend the first part of the day learning the basics of PowerShell, but the focus is on how you can manage your own environment using this powerful language, so you can spend your time solving problems instead of the constant point-and-click drudgery of typical DBA tasks.

The all-day session is reasonably priced, and you'll come away with scripts to help you put this tool into use right away. Check out the session details at Use PowerShell to Get the Most out of SQL Server.

See you there!


Published Thursday, August 19, 2010 4:17 PM by AllenMWhite



Shawn Melton said:

You know I was not to terribly dissappointed that I could not go to PASS Summit this year, even though I have never been before anyway. Hearing about last year I had been thinking about how I could get out there to see it, but...

Well now reading this post...I'm down right depressed!

Are the pre-con sessions available on DVD or something (like they do TechEd)?

August 19, 2010 4:34 PM

Jim Puder said:


I attended your session at PASS 24 Hours of SQL on gathering perf data using Powershell.  You mentioned that your script might be available when the recording of the post went up, but I am unable to find it.  Would it be possible for you to post it somewhere it could be downloaded?

October 1, 2010 4:32 PM

AllenMWhite said:

Jim, the script is available in the attachment to this blog post:

Thanks for attending.

October 4, 2010 8:19 AM

Helen Siegert said:

Hi Allen,

I just attended your pre-conference seminar at SQLPass, and need to know where to download the scripts you used in class.  Do you mind providing those?


helen siegert

November 10, 2010 6:31 PM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement