SQL server 2012 with PowerShell V3 cookbook. (2012)
- Record Type:
- Book
- Title:
- SQL server 2012 with PowerShell V3 cookbook. (2012)
- Main Title:
- SQL server 2012 with PowerShell V3 cookbook
- Further Information:
- Note: Donabel Santos.
- Other Names:
- Santos, Donabel
- Contents:
- 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;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 ... … (more)
- Publisher Details:
- Birmingham : Packt Pub
- Publication Date:
- 2012
- Extent:
- 1 online resource
- Subjects:
- 005.7585
COMPUTERS -- System Administration -- Windows Administration
Database management
Windows PowerShell (Computer program language)
Computer
Database management
Windows PowerShell (Computer program language)
COMPUTERS -- Data Processing
Database management
Windows PowerShell (Computer program language)
COMPUTERS -- System Administration -- General
Electronic books - Languages:
- English
- ISBNs:
- 9781849686471
1849686475
9781849686464
1849686467 - Notes:
- Note: Print version record.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.91352
- Ingest File:
- 01_034.xml