Book Image

PowerShell for SQL Server Essentials

By : Donabel Santos
Book Image

PowerShell for SQL Server Essentials

By: Donabel Santos

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
PowerShell for SQL Server Essentials
Donabel Santos
Feb, 2015 | 186 pages
No titles found
Table of Contents (15 chapters)
PowerShell for SQL Server Essentials
PowerShell for SQL Server Essentials
Credits
Credits
About the Author
About the Author
Acknowledgments
Acknowledgments
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Getting Started with PowerShell
Getting Started with PowerShell
A brief history of PowerShell
The PowerShell environment
PowerShell versions
PowerShell cmdlets
PowerShell providers
Snap-ins and modules
PowerShell Pipeline
Scripting basics
Running PowerShell scripts
Getting help
Summary
2
Using PowerShell with SQL Server
Using PowerShell with SQL Server
SQL Server via PowerShell
SQL Server-specific cmdlets
SQL Server Management Objects
Summary
3
Profiling and Configuring SQL Server
Profiling and Configuring SQL Server
Current server resources
Hotfixes and service packs
Current SQL Server instances
Services and service accounts
SQL Server error logs
Current instance configuration
Changing configurations
Summary
4
Basic SQL Server Administration
Basic SQL Server Administration
Listing databases and tables
Adding files and filegroups
Checking enabled features
Scripting database objects
Attaching and detaching databases
Backing up and restoring databases
Reorganizing or rebuilding indexes
Managing logins, users, and permissions
Policies
Managing jobs
Summary
5
Querying SQL Server with PowerShell
Querying SQL Server with PowerShell
To PowerShell or not to PowerShell
Sending queries to SQL Server
Fixing orphaned users
Getting fragmentation data
Backing up and restoring databases
Exporting data using bcp
Summary
6
Monitoring and Automating SQL Server
Monitoring and Automating SQL Server
Getting to know helpful cmdlets
Scheduling PowerShell scripts
Checking logs
Monitoring failed jobs
Alerting on disk space usage
Logging blocked processes
Getting performance metrics
Summary
Implementing Reusability with Functions and Modules
Implementing Reusability with Functions and Modules
Functions
Modules
Summary
Index
Index

Chapter 6. Monitoring and Automating SQL Server

This chapter covers how SQL Server usage and performance monitoring, logging, alerting, and error checking can be done with PowerShell. The topics covered in this chapter include the following:

  • Getting to know helpful cmdlets

  • Scheduling PowerShell scripts

  • Checking logs

  • Monitoring failed jobs

  • Alerting on disk space usage

  • Logging blocked processes

  • Getting performance metrics

Previous Section
End of Section 1
Next Section