2017-08-19 - SQL and PowerShell Tools

PowerShell for SQL Server Part 2

Tags: sql-server powershell tools modules

Outline

Intro

My Environment

SSMS 2016 - Feb 2017 - build 13.0.16106.4
SQL Server 2014 Developer Edition
PowerShell 5.1

The old SQL module: SQLPS

Thru SQL 2014

The new module: SQLServer

Included with SSMS 2016 (free), backward compatible

SQL Provider

SQL Objects, Methods, Properties

DB
Table
Jobs

Useful Scripts

Restore from Folder
Restore Logs

Community Resources

PowerShell Gallery
DBATOOLS.IO
- Reset SQL Password
- Restore from Ola Hallengren Backup
SQLPX
PowerShell for SQL Books
Blogs

Takeaways

Pick a problem to solve
Start with public scripts and adapt
Use public modules

Files

PowerShell Scripts