SQL and PowerShell, an Introduction

Tags: sql-server powershell beginner smo

Presentation on PowerShell and SQL for South Florida CodeCamp 2016 by David Cobb

By adding PowerShell to our toolset when working with data, DBAs and developers can go beyond Management Studio and T-SQL, applying a powerful scripting language that leverages .Net objects and Windows server capabilities, enabling us to simplify management of servers and databases, automate recurring processes, and access and manipulate data. We’ll discuss PowerShell basics and concepts useful for DBAs and Developers, as well as PowerShell community resources that can help you take your work with data to the next level.

Files

PowerShell Scripts

• _A Introduction.ps1
• 00 Setup and Basics.ps1
• 01 Starting with SQL.ps1
• 02 Tasks using SMO.ps1
• 03 Scripting Database Tables.ps1
• 04 Reading SQL Server Error Logs.ps1
• 05 Working with Queries and Data.ps1
• 08 SQLPowerDoc.ps1
• 09 Integrating Data with Outside Resources.ps1