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

Getting to know helpful cmdlets


Before we start covering any SQL Server-specific snippets, it's good to identify cmdlets that are frequently used when you are monitoring and logging any activities. The cmdlets described in this section are the ones you will (most likely) frequently use. Remember to use Get-Help to get the full documentation on syntax, parameter sets, and examples.

The Send-MailMessage cmdlet

Simply stated, the Send-MailMessage cmdlet allows you to e-mail something from PowerShell, which is a pretty useful action when you are monitoring something and want to get some alerts or reports via e-mail. This is the syntax of Send-MailMessage from TechNet:

Send-MailMessage [-To] <String[]> [-Subject] <String> [[-Body] <String> ] [[-SmtpServer] <String> ] -From <String> [-Attachments <String[]> ] [-Bcc <String[]> ] [-BodyAsHtml] [-Cc <String[]> ] [-Credential <PSCredential> ] [-DeliveryNotificationOption <DeliveryNotificationOptions...