Cargando…
SQL server 2012 with PowerShell V3 cookbook /
SQL Server 2012 with PowerShell V3 Cookbook"" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2012.
|
| Colección: | Quick answers to common problems.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- SQL Server 2012 with PowerShell V3 Cookbook; SQL Server 2012 with PowerShell V3 Cookbook; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Getting Started with SQL Server and PowerShell; Introduction; Notable PowerShell V3 features.
- Before you start: Working with SQL Server and PowerShellWorking with the sample code; How to do it ... ; See also; Exploring the SQL Server PowerShell hierarchy; Getting ready; How to do it ... ; How it works ... ; Installing SMO; Getting ready; How to do it ... ; There's more ... ; Loading SMO assemblies; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Discovering SQL-related cmdlets and modules; Getting ready; How to do it ... ; How it works ... ; There's more ... ; More information on running PowerShell scripts; More information on mixed assembly error.
- Creating a SQL Server instance objectGetting ready; How to do it ... ; How it works ... ; See also; Exploring SMO server objects; Getting ready; How to do it ... ; How it works ... ; See also; 2. SQL Server and PowerShell Basic Tasks; Introduction; Development environment; Administrator; PowerShell ISE; Running scripts; Listing SQL Server instances; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Discovering SQL Server services; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Starting/stopping SQL Server services; Getting ready; How to do it ...
- How it works ... There's more ... ; See also; Listing SQL Server configuration settings; How to do it ... ; How it works ... ; See also; Changing SQL Server instance configurations; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Searching for database objects; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Creating a database; Getting ready; How to do it ... ; How it works ... ; Altering database properties; Getting ready; How to do it ... ; How it works ... ; See also; Dropping a database; Getting ready; How to do it ... ; How it works ...
- Changing a database ownerGetting ready; How to do it ... ; How it works ... ; See also; Creating a table; Getting ready; How to do it ... ; How it works ... ; See also; Creating a view; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating a stored procedure; Getting ready; How to do it ... ; How it works ... ; Creating a trigger; Getting ready; How to do it ... ; How it works ... ; Creating an index; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Executing a query / SQL script; Getting ready; How to do it ... ; How it works ...