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

Thu, Aug 18 2016 12:00 Eastern Daylight Time


PowerShell, SQL and Power BI - Reducing your Context Switching

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

PowerShell, SQL and Power BI - Reducing your Context Switching

"Could you just tell me……….?" This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties. In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy. I will also show you how you can use this to enable consistency across your estate. This session will be of benefit to the "Accidental DBAs" as well as DBAs looking after large estates The majority of the session will concentrate on the way I use PowerShell to gather the information and store it. I will also show you how to enable self-service with natural language query using Power BI. You will leave the session with all of the tools you need to return to work and convince your boss this is a worthwhile use of your time and to implement this solution to provide a modern way of providing accurate information about your estate.


Rob is a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). He has volunteered and spoken at SQL community events through the UK and Europe and is a member of the committee that organises SQL Saturday Exeter. He is a proud supporter of the SQL and Powershell communities. He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter. He has a fabulous beard.

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!

The State of PowerShell, SQL Server, and SQLPS

The July update of SSMS 2016 brought more needed PowerShell enhancements to the new SqlServer PowerShell module. We discuss the 25 new cmdlets that made the cut and show you some practical ways to use them! There are also 3 great update to existing functionality that we will walk through.
SQL Server MVP Aaron Nelson, PowerShell MVP Chrissy LeMaire, and SQL DBA and PowerShell Enthusiast Rob Sewell discuss the past, present and future of SQL Server, PowerShell and SQLPS. Bring your questions and be ready to take these demos for a spin!

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.



Deploy & Manage Ola Hallengren's Scripts in SQL Server with PowerShell

SQL Server MVP Andre Kamman. Are you enjoying Ola Hallengren's Maintenance Solution scripts as much as I am? I've written PowerShell scripts to deploy and manage them across multiple servers.



Painting with PowerShell: SQL Server Administration

SQL DBA & PowerShell Enthusiast Chris Sommer presents 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.



Automating Your SQL Server Best Practices Word Document

PowerShell MVP Laerte Junior presents a session about how to create a Word document for your client with the best practices on SQL Server



Advanced PowerShell Development

Bryan Cafferky presents a session for you to learn how to: maximize reuse with advanced functions using cmdletbinding, increase extensibility with script modules, add support for user interaction, efficiently access SQL Server, add support for application configuration and add support for pipeline processing.



Applying SQL Server Best Practices via PowerShell

Amit banerjee ( twitter ) from the SQL Server Tiger Team presents a session on how some best practice checks can be automated for SQL Server instances running on your on-premise data centers and on Azure Virtual Machines. In this session you will learn how you can leverage the POWER of PowerShell to automate health checks, keep your systems healthy and run SQL Server efficiently!