The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

PowerShell for the DBA, Part 2 - Objects and Tools – sponsored by Hewlett Packard Enterprise

Wed, Mar 08 2017 19:00 UTC

PowerShell for the DBA, Part 2 - Objects and Tools

In part 1, we explored the basics of PowerShell, and just scratched the surface of applying PowerShell to DBA tasks. In this second session we'll use PowerShell to explore the SQL Management Objects (SMO) and walk through example scripts to work with SQL Server to perform common SQL functions. We will also explore freely available PowerShell modules & scripts from both Microsoft and the SQL community that leverage SMO into powerful tools to make the DBA's life easier. Note: David presented the first part of this talk in September, 2016. You may want to review the recording which is available at on the meeting archives page.

David Cobb

David Cobb is a Systems Architect for CheckAlt Payment Solutions, providers of automated and electronic check transaction processing since 2005. He is a Microsoft Certified Trainer, with MCSE Data Platform certification for SQL 2012, training people on SQL Server since 2002. David is also the principal consultant for Cobb Information Technologies, Inc, founded in 1996, providing technology consulting with a focus on SQL Server.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Group holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.


Follow us on Twitter: @PASS_DBA_VC

Back to Top