The PowerShell Virtual Chapter is geared towards those wanting to learn more about PowerShell and to share best practices.

PowerShell for SQL Server Database Administrators

As a DBA, PowerShell can help simplify tasks that you do every day, as well as tasks that you do every once in a while. The goal of the SQL PASS PowerShell Virtual User Group is to get you as excited about PowerShell as we are, if you aren't already. If you're already pumped up about PowerShell and SQL Server, consider presenting for us!
Next Meeting

Wed, Jun 01 2016 12:00 Eastern Daylight Time


Painting with PowerShell: SQL Server Administration

RSVP: https://attendee.gotowebinar.com/register/4145195493943894785

Painting with PowerShell: SQL Server Administration

The SQL Server canvas gives us limitless opportunity for scripting and automation, and PowerShell is the perfect brush to paint with. Configuring our database servers, deploying database code changes, performing backups and restores are just a few examples of a day in the life of a DBA. Automation and scripting bring consistency, simplicity and scalability to many of these sometimes daunting tasks. Join SQL Server DBA and PowerShell Nut Chris Sommer to learn how to paint your own SQL Server canvas with PowerShell.


Chris started in computing and I.T. in the mid to late 1990’s. After the dust had settled from Y2K, he found himself a bit more focused and working with database servers on the Unix platform. His first exposure to SQL Server was in 2007 and he has been working on that platform ever since. Chris is currently a Senior SQL DBA with a focus on reliability, stability and performance. He truly enjoys the building tools with PowerShell to help his fellow DBA's manage their ever growing environment.

Previous Webcasts

Below are a few of our previous sessions. Check out our meeting archive for a full list of webcasts. Or just head
straight to our YouTube channel If you have a request for a specific SQL related PowerShell topic, let us know!

High Class PowerShell: Objects and Classes in PowerShell

In this session SQL Server MVP Robert Cain focuses on the ability to create custom objects in PowerShell, covering PowerShell versions 3 to 5. Then, he looks at the new Class and Enum types included with PowerShell 5, and how to incorporate classes into your own modules.

This session is for people already familiar with PowerShell and are wanting to take their skills to the advanced level by learning how to create their own objects and classes.



SQL Server’s sqlcmd on Linux using Windows Authentication

You've heard that SQL Server will soon be available on Linux, but did you know that the client tools have already been ported *and* they support Integrated Authentication? Watch as PowerShell MVP and SUSE Certified Linux Administrator Chrissy LeMaire shows SQL Server MVP Aaron Nelson how to install Linux, join an Active Directory domain, login as a domain user, and execute a SQL query against SQL Server using sqlcmd.



Documenting SQL Server with PowerShell

In this webcast, Sander Stad will show you show how easy it is to use PowerShell to retrieve information from your servers. He'll detail what can be used to document your servers, how to retrieve the information and what should be documented. In the end you no longer have an excuse not to document your servers.



PowerShell Unbound - Tips & Tricks

PowerShell MVP Jeff Wouters presents a session all about tips 'n tricks you can use in PowerShell. Mostly practical, some improve performance of scripts and others are just plain fun.