PowerShell for SQL Server Essentials

PowerShell for SQL Server Essentials

AUTHOR: Donabel Santos

PUBLISHER: Packt

PAGES: 183

ISBN-10: 1784391492; ISBN-13: 978-1784391492

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.

About the Author
Donabel Santos (SQL Server MVP) is a business intelligence architect, trainer/instructor, consultant, author, and principal at QueryWorks Solutions, based in Vancouver, Canada. She works primarily with SQL Server for database/data warehouse, reporting, and ETL solutions. She scripts and automates tasks with PowerShell and creates dashboards and visualizations with Tableau and Power BI. She is a Microsoft Certified Trainer (MCT). She provides consulting and corporate training to clients. She is also the lead instructor for SQL Server and Tableau (Visual Analytics) courses at British Columbia Institute of Technology (BCIT). Donabel is an MCITP DBA and a developer for SQL Server and MCTS for SharePoint. She is also a Tableau Desktop 7 Core Certified and a Tableau Desktop 8 Certified Professional. She is currently working on her SQL Server 2012 (and upcoming 2014) certifications. She is a self-confessed data geek. She loves working with data and thinks SQL Server is a lot of fun and Tableau is just amazing at delivering insights. She authored SQL Server 2012 with PowerShell V3 Cookbook, Packt Publishing, and contributed to PowerShell Deep Dives, Manning Publications. She blogs at www.sqlbelle.com and tweets at @sqlbelle.

Book Category

Android Developer / Asp.Net / Asp.Net MVC / Blockchain / C# / C++ / Computer Science / Database / Game Developer / Java / JavaScript / jQuery / Linux / Maven / MS Sql / MySQL / Networking / Oracle / PHP / Python / Spring / VB.Net / Visual Studio / Web Developer

Disclaimer

Programming books display here are property of respective owners. All information about the book published in this website is in good faith and for general information purpose only.

Please support author by buying hardcopy to the nearest book store in your place or order books in publisher websites.

HRMS & Payroll Web Application

BIR Alphalist .Dat File Format to Convert ITR Form 2316

Easy way to convert your annual BIR .dat file output to BIR Form 2316 in a single file pdf format using this web based application tools and also easiest way of printing because it contain a one file only. read more »

Inventory Management Web Application

Inventory Management Web Application is a software that can track inventory of products, orders, suppliers, customers, sales and deliveries in any device with internet browser. Widely used in a variety of business industries, from manufacturing to utilities, healthcare, education, schools, government, and more. read more »

Data Entry of Taxable and Non-Taxable with Previous Employer

Generating annual report of BIR Alphalist contains a history of employee with previous tax deduction to consolidate it for yearly tax computation. Pinoy Web Application have a tools to input employee newly hired with previous employer within the year that covered of annual tax report that system automatic get the additional information during the processing of a year end alphalist tax schedule 7.1, 7.2, 7.3, 7.4 & 7.5. read more »

Alphalist Excel File Template to Convert BIR .Dat File Format

Free tools of BIR Alphalist excel report type schedule 7.1, 7.2, 7.3, 7.4, 7.5 that convert to BIR DAT File format generated by BIR Alphalist Data Entry Application version 6.0. Easy to use... try this web application tools for alphalist .dat file conversion. read more »

How to get SSS Number online in the Philippines

Today, it’s already possible to apply SS number online in the Philippines. SSS government agency evolve their technology to help filipino people accommodate in a fastest way using online registration in get temporary SS number before going to the nearest SSS Branch to get permanent SS Number. read more »