MPG.eBooks - Description: PowerShell for SQL Server essentials

Cover Image

Read Now

PowerShell for SQL Server essentials manage and monitor SQL Server administration and application deployment with PowerShell

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

Bibliographic Details
Main Author:	Santos, Donabel
Format:	eBook
Language:	English
Published:	Birmingham, UK Packt Publishing 2015
Series:	Professional expertise distilled
Subjects:	Windows Powershell (computer Program Language) / Fast Bases De Données / Gestion Windows Powershell (computer Program Language) / Http://id.loc.gov/authorities/subjects/sh2008003638 Sql Server / Fast Database Design / Fast Sql (langage De Programmation) Sql Server / Http://id.loc.gov/authorities/names/n90684343 Database Design / Http://id.loc.gov/authorities/subjects/sh88004472 Database Management / Http://id.loc.gov/authorities/subjects/sh85035848 Bases De Données / Conception Windows Powershell (langage De Programmation) Database Management / Fast Sql (computer Program Language) / Fast Sql (computer Program Language) / Http://id.loc.gov/authorities/subjects/sh86006628
Online Access:	https://learning.oreilly.com/library/view/~/978178...
Collection:	O'Reilly - Collection details see MPG.ReNa

Description
Summary:	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 Chapter 5: Querying SQL Server with PowerShell; To PowerShell or not to PowerShell; Sending queries to SQL Server; SQL Server Management Objects; The Invoke-Sqlcmd cmdlet; ADO.NET; The Invoke-Expression cmdlet; Sending simple queries to SQL Server - different variations; Fixing orphaned users; Getting fragmentation data; Backing up and restoring databases; Exporting data using bcp; Summary; Chapter 6: Monitoring and Automating the SQL Server; Getting to know helpful cmdlets; The Send-MailMessage cmdlet; The ConvertTo-Html cmdlet; The Export-Csv cmdlet; The Write-EventLog cmdlet Chapter 2: Using PowerShell with SQL Server; SQL Server via PowerShell; Mini-shell (or the sqlps utility); The SQLPS module; SQL Server snap-ins; SQL Server assemblies; SQL Server-specific cmdlets; SQL Server Management Objects; Creating SMO objects; Summary; Chapter 3: Profiling and Configuring SQL Server; Current server resources; Getting processor (CPU) information; Checking server memory; Checking disk space; Checking network settings; Hotfixes and service packs; Current SQL Server instances; Services and service accounts; SQL Server error logs; Current instance configuration
Item Description:	Includes index
Physical Description:	1 volume illustrations
ISBN:	1784397105 9781784397104 1784391492