SQL Server 2012 with PowerShell V3 Cookbook
| Author | : | |
| Rating | : | 4.85 (602 Votes) |
| Asin | : | 1849686467 |
| Format Type | : | paperback |
| Number of Pages | : | 634 Pages |
| Publish Date | : | 2017-03-17 |
| Language | : | English |
DESCRIPTION:
Not awful, but leaves out some important features Denis M. Mcdowell I bought this book as a reference for some SQL Server 2012 automation I am working on. While this book covers many of the day to day functions of a DBA, it leaves out virtually all of the new SQL 2012 features and how to manage them in PowerShell. Not a word about AlwaysOn Availability Groups, Contained DB, or other important features. I was disappointed that these items were left out. It is almost as if they simply changed "SQL Server . "Good foundation on PowerShell with SQL Server" according to Mary Jane Zhang. I wanted to learn how to use PowerShell with SQL Server. This book delivers easy to read chapters and easy to follow exercises. I liked the clear and to-the-point examples and explanations. While not exhaustive of all SQL Server 2012 features, this book provides a very good foundation to anyone who wants to start using PowerShell with SQL Server. It starts off with the basics, so even if you are not very familiar with PowerShell this bo. Great reference and though pattern Donabel did an amazing job with this book. I liked the way she started out with a base and then quickly added to the foundation. She starts off with simple powershell commands, tips and tools and then slowly starts to add more knowledge. It is a must read.
She holds MCITP certifications for SQL Server 2005/2008, and an MCTS for SharePoint. She is a Microsoft Certified Trainer (MCT), and is also the lead instructor for SQL Server Administration, Development, and SSIS courses at British Columbia Institute of Technology (BCIT).Donabel is a proud member of PASS (Professional Association of SQL Server), and a proud BCIT alumna (CST diploma and d
She holds MCITP certifications for SQL Server 2005/2008, and an MCTS for SharePoint. She has worked with SQL Server since version 2000 in numerous development, tuning, reporting, and integration projects with ERPs, CRMs, SharePoint, and other custom applications. She is a Microsoft Certified Trainer (MCT), and is also the lead instructor for SQL Server Administration, Development, and SSIS courses at British Columbia Institute of Technology (BCIT).Donabel is a proud member of PASS (Professional Association of SQL Server), and a proud BCIT alumna (CST diploma and degree). About the AuthorDonabel SantosDonabel Santos is a SQL Server MVP and is the senior SQL Server Developer/DBA/Trainer at QueryWorks Solutions, a consulting and training company in Vancouver, BC. She blogs (sqlmusings), tweets (@sqlbelle), speaks and presents (SQLSaturday, VANPASS, Vancouver TechFest, and so on), trains (BCIT, QueryWorks Solutions), and writes (Packt, Idera, SSWUG, and so
Packed with more than 100 practical, ready-to-use scripts, "SQL Server 2012 with PowerShell V3 Cookbook" will be your go-to reference in automating and managing SQL Server.What you will learn from this bookCreate an inventory of database properties and server configuration settingsBackup and restore databasesExecute queries to multiple serversMaintain permissions and security for usersImport and export XML into SQL ServerExtract CLR assemblies and BLOB objects from the databaseExplore database objects Manage and deploy SSIS packages and SSRS reportsManage and monitor running SQL Server services and accountsParse and display the contents of trace filesCreate SQL Server jobs, alerts and operatorsFind blocking processes that are hampering your database performance. Database professionals can leverage PowerShell by utilizing its numerous built-in cmdlets, or using any of the readily available .NET classes, to automate database tasks, simplify integration, or just discover new ways to accomplish the