SQL server 2012 with PowerShell V3 cookbook. (2012)

• Record Type: Book
• 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; 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 ...
• 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.