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, Jul 06 2016 12:00 Eastern Daylight Time


The State of PowerShell, SQL Server, and SQLPS

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

The State of PowerShell, SQL Server, and SQLPS

It sounds like the [end-of] June release of SSMS 2016 will be bringing more needed PowerShell enhancements to the SQLPS. We will discuss the new cmdlets that made the cut and show you some practical ways to use them!


Aaron Nelson is a senior SQL Server architect with over 15 years of experience in architecture, business intelligence, development, and performance tuning of SQL Server. He has experience managing enterprise-wide data needs in both transactional and data warehouse environments. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, and Database Developer. Aaron leads the PowerShell Virtual Chapter of PASS ( SQLPS.com ) and is a volunteer at his local PASS chapter, AtlantaMDF.

The State of PowerShell, SQL Server, and SQLPS

It sounds like the [end-of] June release of SSMS 2016 will be bringing more needed PowerShell enhancements to the SQLPS. We will discuss the new cmdlets that made the cut and show you some practical ways to use them!


Chrissy is a Windows PowerShell MVP who has worked in IT for nearly 20 years. She currently serves as the SQL Server DBA for NATO Special Ops in Belgium, and the SQL PASS PowerShell Virtual Chapter Co-lead. She's also an avid scripter, and has used PowerShell since it was introduced in 2005 at Microsoft's Professional Developers Conference in Los Angeles. Chrissy is the author of the dbatools module, which helps simplify SQL Server migrations. Chrissy is currently pursuing an MS in Systems Engineering at Regis University. In her spare time, she explores Trappist breweries in Belgium with her wife and maintains RealCajunRecipes.com with her mom and best friend. You can follow her on Twitter at @cl.

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.