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, Sep 18 2013 12:00 Eastern Daylight Time


SSIS - Integrating PowerShell in a ScriptTask comp

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

SSIS - Integrating PowerShell in a ScriptTask component

This session will demostrate how you can reuse a PowerShell script in SSIS "Script Task" component as part on a ETL flow. I'll be showing some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Session Level: Intermediate


Born in Puerto Rico, has been working with computers since 1979, and is the only PowerShell MVP in Florida. Throughout many years, have worked with various types of databases such as: Dbase, OS/400-DB2, MySQL and MSSQL.  And, as a Senior IT/Developer has provided support for Windows Servers 2003/2008, Windows 7, SQL Servers Applications, Microsoft Virtualization Technologies, and building Visual Studio solutions. Microsoft PowerShell MVP awarded since 2008. Also, in 2010 got his SAPIEN Technologies MVP Award.

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.