Powershell for SQL Server Essentials

Santos, Donabel

ISBN 10: 1784391492 / ISBN 13: 9781784391492

Edité par Packt Publishing, 2015

This item is in overall acceptable condition. Covers and dust jackets are intact but may have heavy wear including creases, bends, edge wear, curled corners or minor tears as well as stickers or sticker-residue. Pages are intact but may have minor curls, bends or moderate to considerable highlighting/ writing. Binding is intact; however, spine may have heavy wear. Digital codes may not be included and have not been tested to be redeemable and/or active. A well-read copy overall. Please note that all items are donated goods and are in used condition. Orders shipped Monday through Friday! Your purchase helps put people to work and learn life skills to reach their full potential. Orders shipped Monday through Friday. Your purchase helps put people to work and learn life skills to reach their full potential. Thank you! N° de réf. du vendeur 466U1D000R7Q

Synopsis :

This book is written for SQL Server administrators and developers who want to leverage PowerShell to work with SQL Server. Some background with scripting will be helpful but not necessary.

Présentation de l'éditeur:

Manage and monitor SQL Server administration and application deployment with PowerShell

About This Book

• Create scripts using PowerShell to manage and monitor server administration and application deployment
• Automate creation of SQL Database objects through PowerShell with the help of SQL Server module (SQLPS) and SQL Server snapins
• A fast paced guide, packed with hands-on examples on profiling and configuring SQL Server

Who This Book Is For

This book is written for SQL Server administrators and developers who want to leverage PowerShell to work with SQL Server. Some background with scripting will be helpful but not necessary.

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

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.

Détails bibliographiques

Titre : Powershell for SQL Server Essentials
Éditeur : Packt Publishing
Date d'édition : 2015
Reliure : Couverture souple
Etat : Acceptable