Manage and monitor SQL Server administration and application deployment with PowerShell
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
Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.