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 17 2013 12:00 Eastern Daylight Time


Creating HTML reports with PowerShell

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

Creating HTML reports with PowerShell

Creating HTML reports on one hand is almost brain-dead easy in PowerShell. But using it with style takes a little more work. Wouldn't you like to add a little pizzazz to your HTML reports that you create in PowerShell. In this session I'll offer some tips and tricks for creating great looking, or at least better looking, HTML reports including stylized alternate rows and embedded graphics.


Jeffery Hicks is a Microsoft MVP in Windows PowerShell, Microsoft Certified Trainer and an IT veteran with over 20 years of experience, much of it spent as an IT consultant specializing in Microsoft server technologies with an emphasis in automation and efficiency. He works today as an independent author, trainer and consultant. Jeff writes the popular Prof. PowerShell column for MPCMag.com, is a regular contributor to the Petri IT Knowledgebase, 4SysOps and the Altaro Hyper-V blog, as well as frequent speaker at technology conferences and user groups. If he isn't writing, Jeff is most likely recording training videos for companies like TrainSignal or hanging out in the forums at PowerShell.org. Jeff's latest books are Learn PowerShell 3 in a Month of Lunches, Learn PowerShell Toolmaking in a Month of Lunches and PowerShell in Depth: An Administrators Guide. You can keep up with Jeff at his blog http://jdhitsolutions.com/blog , on Twitter at twitter.com/jeffhicks and on Google Plus (http:/gplus.to/JeffHicks)

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.