PowerShell for SQL Server Administration

Introduction

• Manage SQL servers with PowerShell
• What you should know
• Download tools

1. PowerShell in SQL Server

• PowerShell won't solve all problems
• When PowerShell is useful
• Differences between the two modules
• Open-source solutions

2. Connecting to SQL Server from PowerShell

• Declaring objects
• Connecting to SQL Server
• Parameters in PowerShell
• Closing connections
• Disposing connections
• Object reuse

3. Creating Objects in PowerShell

• Creating databases
• Creating tables
• Creating views
• Creating procedures

4. Querying Data in PowerShell

• Inserting data into tables
• Returning data from SQL Server
• Running stored procedures in PowerShell

5. Looping Through Servers in PowerShell

• Loops in PowerShell
• Storing servers for PowerShell
• Concepts of threading
• PowerShell threading commandlets
• Authentication and threading
• Piping between objects
• Exporting CSV files
• Importing CSV files
• Exporting XML data
• Importing XML data

6. PowerShell Remoting

• What is remoting?
• Removing over HTTP ports
• Enabling remoting via PowerShell
• Enabling remoting via GPO
• Starting a remote session
• Ending a remote session
• Using alternate credentials for remoting
• Invoking a remote command

Conclusion

• Next steps