Book Image

PowerShell for SQL Server Essentials

By : Donabel Santos
Book Image

PowerShell for SQL Server Essentials

By: Donabel Santos

Overview of this book

Table of Contents (15 chapters)
PowerShell for SQL Server Essentials
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Implementing Reusability with Functions and Modules
Index

Summary


In this chapter, we looked at different ways of sending queries and commands to SQL Server using PowerShell. We saw that, in addition to using the cmdlets Invoke-Sqlcmd and Invoke-Expression, we can also utilize ADO.NET and SMO. We also learned to that although in most cases we can use PowerShell to query SQL Server, we have to consider if there are better tools to assist us in accomplishing our task.

In the next chapter, we will look at tasks that help monitor and automate SQL Server, and see how these are accomplished using PowerShell.