What do you think?
Rate this book
PowerShell for SQL Server Essentials
Manage and monitor SQL Server administration and application deployment with PowerShellAbout This BookCreate scripts using PowerShell to manage and monitor server administration and application deploymentAutomate creation of SQL Database objects through PowerShell with the help of SQL Server module (SQLPS) and SQL Server snapinsA fast paced guide, packed with hands-on examples on profiling and configuring SQL ServerWho This Book Is ForThis 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 LearnCreate scripts using PowerShell to manage and monitor server administration and application deploymentAutomate the creation of SQL Database objects through PowerShell with the help of the SQL Server module (SQLPS) and SQL Server snap-insUse PowerShell to work with SQL Server specific providers and cmdletsIdentify and manage SQL Server services, instances, settings, and confi gurationsProfile your SQL Server instances and export current configurations to a fileMonitor SQL Server jobs and alertsManage logins, database users, and instance security and permissionsInvoke T-SQL queries from PowerShell and export resultsAccomplish tasks from your DBA daily/weekly/monthly/yearly checklists with PowerShellIn DetailPowerShell 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 LearnCreate scripts using PowerShell to manage and monitor server administration and application deploymentAutomate the creation of SQL Database objects through PowerShell with the help of the SQL Server module (SQLPS) and SQL Server snap-insUse PowerShell to work with SQL Server specific providers and cmdletsIdentify and manage SQL Server services, instances, settings, and confi gurationsProfile your SQL Server instances and export current configurations to a fileMonitor SQL Server jobs and alertsManage logins, database users, and instance security and permissionsInvoke T-SQL queries from PowerShell and export resultsAccomplish tasks from your DBA daily/weekly/monthly/yearly checklists with PowerShellIn DetailPowerShell 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.
188 pages, Kindle Edition
First published February 25, 2015
6 people are currently reading
7 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.