|
|
|
|
LEADER |
05021nmm a2200553 u 4500 |
001 |
EB001939559 |
003 |
EBX01000000000000001102461 |
005 |
00000000000000.0 |
007 |
cr||||||||||||||||||||| |
008 |
210123 ||| eng |
020 |
|
|
|a 1784397105
|
020 |
|
|
|a 9781784397104
|
020 |
|
|
|a 1784391492
|
050 |
|
4 |
|a QA76.9.D3
|
100 |
1 |
|
|a Santos, Donabel
|
245 |
0 |
0 |
|a PowerShell for SQL Server essentials
|b manage and monitor SQL Server administration and application deployment with PowerShell
|c Donabel Santos
|
246 |
3 |
1 |
|a PowerShell for Structured Query Language Server essentials
|
246 |
3 |
1 |
|a Manage and monitor SQL Server administration and application deployment with PowerShell
|
260 |
|
|
|a Birmingham, UK
|b Packt Publishing
|c 2015
|
300 |
|
|
|a 1 volume
|b illustrations
|
505 |
0 |
|
|a Additional cmdletsScheduling PowerShell scripts; Checking logs; Monitoring failed jobs; Alerting on disk space usage; Logging blocked processes; Getting performance metrics; Summary; Appendix: Implementing Reusability with Functions and Modules; Functions; Simple functions; Advanced functions; Best practices; Modules; Script modules; Summary; Index
|
505 |
0 |
|
|a Changing configurationsStart or stop services; Changing a service account; Change instance settings; Summary; Chapter 4: Basic SQL Server Administration; Listing databases and tables; Listing database files and filegroups; Adding files and filegroups; Listing the processes; Checking enabled features; Scripting database objects; Attaching and detaching databases; Detaching databases; Backing up and restoring databases; Backing up; Restoring; Reorganizing or rebuilding indexes; Managing logins, users, and permissions; Permissions; Adding a login; Adding database users; Policies; Managing jobs
|
505 |
0 |
|
|a Cover; Copyright; Credits; About the Author; Acknowledgments; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with PowerShell; A brief history of PowerShell; The PowerShell environment; The PowerShell console; The PowerShell ISE; Running PowerShell as an administrator; Execution policy; PowerShell versions; PowerShell cmdlets; Cmdlet naming convention; Cmdlet parameters; Cmdlet aliases; PowerShell providers; Snap-ins and modules; PowerShell Pipeline; Scripting basics; Running PowerShell scripts; Getting help; Getting help from other cmdlets
|
653 |
|
|
|a Windows PowerShell (Computer program language) / fast
|
653 |
|
|
|a Bases de données / Gestion
|
653 |
|
|
|a Windows PowerShell (Computer program language) / http://id.loc.gov/authorities/subjects/sh2008003638
|
653 |
|
|
|a SQL server / fast
|
653 |
|
|
|a Database design / fast
|
653 |
|
|
|a SQL (Langage de programmation)
|
653 |
|
|
|a SQL server / http://id.loc.gov/authorities/names/n90684343
|
653 |
|
|
|a Database design / http://id.loc.gov/authorities/subjects/sh88004472
|
653 |
|
|
|a Database management / http://id.loc.gov/authorities/subjects/sh85035848
|
653 |
|
|
|a Bases de données / Conception
|
653 |
|
|
|a Windows PowerShell (Langage de programmation)
|
653 |
|
|
|a Database management / fast
|
653 |
|
|
|a SQL (Computer program language) / fast
|
653 |
|
|
|a SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh86006628
|
041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
989 |
|
|
|b OREILLY
|a O'Reilly
|
490 |
0 |
|
|a Professional expertise distilled
|
500 |
|
|
|a Includes index
|
776 |
|
|
|z 9781784391492
|
856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781784391492/?ar
|x Verlag
|3 Volltext
|
082 |
0 |
|
|a 658
|
082 |
0 |
|
|a 005.432
|
082 |
0 |
|
|a 745.4
|
520 |
|
|
|a 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
|
520 |
|
|
|a 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
|
520 |
|
|
|a 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
|