Book description
Manage and monitor SQL Server administration and application deployment with PowerShell
In Detail
PowerShell for SQL Server Essentials helps us to manage and monitor server administration and application deployment. Use PowerShell along with SQL Server to perform common DBA tasks.
Starting with a basic introduction to PowerShell, the initial chapters will provide the SQL Server professional PowerShell fundamentals, covering topics such as PowerShell notations and syntax, cmdlets, pipeline, and getting help. Succeeding chapters build upon these fundamentals, and illustrate how to administer and automate SQL Server. Tasks covered throughout include profiling the SQL Server instance, performing backup and restores, invoking T-SQL scripts using PowerShell, and monitoring jobs, security, and permissions.
Packed with practical examples and numerous ready-to-use snippets, this book gets you to an intermediate level in using PowerShell for SQL Server.
What You Will Learn
- Create scripts using PowerShell to manage and monitor server administration and application deployment
- Automate the creation of SQL Database objects through PowerShell with the help of the SQL Server module (SQLPS) and SQL Server snap-ins
- Use PowerShell to work with SQL Server specific providers and cmdlets
- Identify and manage SQL Server services, instances, settings, and confi gurations
- Profile your SQL Server instances and export current configurations to a file
- Monitor SQL Server jobs and alerts
- Manage logins, database users, and instance security and permissions
- Invoke T-SQL queries from PowerShell and export results
- Accomplish tasks from your DBA daily/weekly/monthly/yearly checklists with PowerShell
Table of contents
-
PowerShell for SQL Server Essentials
- Table of Contents
- PowerShell for SQL Server Essentials
- Credits
- About the Author
- Acknowledgments
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Getting Started with PowerShell
- 2. Using PowerShell with SQL Server
- 3. Profiling and Configuring SQL Server
- 4. Basic SQL Server Administration
- 5. Querying SQL Server with PowerShell
- 6. Monitoring and Automating SQL Server
- A. Implementing Reusability with Functions and Modules
- Index
Product information
- Title: PowerShell for SQL Server Essentials
- Author(s):
- Release date: February 2015
- Publisher(s): Packt Publishing
- ISBN: 9781784391492
You might also like
video
PowerShell Core for SQL Server: Automating Your Transact-SQL Scripts
Get up and running with accessing SQL Server from PowerShell Core. By the end of this …
book
Learn PowerShell Core 6.0
Enhance your skills in expert module development, deployment, security, DevOps, and cloud Key Features A step-by-step …
book
PowerShell Deep Dives
Here's your chance to learn from the best in the business. PowerShell Deep Dives is a …
book
Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services
Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration …