SQL Server 2012 with PowerShell V3 Cookbook -- Table of Contents -- 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 PowerShell -- Working 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 object -- Getting 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 owner -- Getting 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... -- Performing bulk export using Invoke-Sqlcmd -- Getting ready -- How to do it... -- How it works... -- See also -- Performing bulk export using bcp -- Getting ready -- How to do it... -- How it works... -- See also -- Performing bulk import using BULK INSERT -- Getting ready -- How to do it... -- How it works... -- See also -- Performing bulk import using bcp -- Getting ready -- How to do it... -- How it works... -- See also -- 3. Basic Administration -- Introduction -- Creating a SQL Server instance inventory.

How to do it... -- How it works... -- There's more... -- See also -- Creating a SQL Server database inventory -- Getting ready -- How to do it... -- How it works... -- See also -- Listing installed hotfixes and service packs -- How to do it... -- How it works... -- There's more... -- See also -- Listing running/blocking processes -- Getting ready -- How to do it... -- How it works... -- See also -- Killing a blocking process -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Checking disk space usage -- How to do it... -- How it works... -- See also -- Setting up WMI Server event alerts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Detaching a database -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Attaching a database -- Getting ready -- How to do it... -- How it works... -- See also -- Copying a database -- Getting ready -- How to do it... -- How it works... -- See also -- Executing a SQL query to multiple servers -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a filegroup -- Getting ready -- How to do it... -- How it works... -- See also -- Adding secondary data files to a filegroup -- Getting ready -- How to do it... -- How it works... -- See also -- Moving an index to a different filegroup -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Checking index fragmentation -- Getting ready -- How to do it... -- How it works... -- See also -- Reorganizing/rebuilding an index -- Getting ready -- How to do it... -- How it works... -- See also -- Running DBCC commands -- How to do it... -- How it works... -- Setting up Database Mail -- Getting ready -- How to do it... -- How it works... -- There's more... -- Listing SQL Server jobs -- Getting ready -- How to do it...

How it works... -- See also -- Adding a SQL Server operator -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a SQL Server job -- Getting ready -- How to do it... -- How it works... -- See also -- Adding a SQL Server event alert -- How to do it... -- How it works... -- There's more... -- See also -- Running a SQL Server job -- Getting ready -- How to do it... -- How it works... -- See also -- Scheduling a SQL Server job -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 4. Security -- Introduction -- Listing SQL Server service accounts -- How to do it... -- How it works... -- See also -- Changing SQL Server service account -- Getting ready -- How to do it... -- How it works... -- See also -- Listing authentication modes -- Getting ready -- How to do it... -- How it works... -- See also -- Changing authentication mode -- Getting ready -- How to do it... -- How it works... -- There's more... -- More on legacy LoginMode values -- See also -- Listing SQL Server log errors -- Getting ready -- How to do it... -- How it works... -- See also -- Listing failed login attempts -- How to do it... -- How it works... -- See also -- Listing logins, users, and database mappings -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Listing login/user roles and permissions -- How to do it... -- How it works... -- See also -- Creating a login -- Getting ready -- How to do it... -- How it works... -- See also -- Assigning permissions and roles to a login -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a database user -- Getting ready -- How to do it... -- How it works... -- See also -- Assigning permissions to a database user -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a database role -- Getting ready.

How to do it... -- How it works... -- See also -- Fixing orphaned users -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a credential -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a proxy -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 5. Advanced Administration -- Introduction -- Listing facets and facet properties -- How to do it... -- How it works... -- See also -- Listing policies -- Getting ready -- How to do it... -- How it works... -- See also -- Exporting a policy -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Importing a policy -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a condition -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a policy -- Getting ready -- How to do it... -- How it works... -- See also -- Evaluating a policy -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Enabling/disabling change tracking -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Running and saving a profiler trace event -- Getting ready -- How to do it... -- How it works... -- See also -- Extracting the contents of a trace file -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a database master key -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a certificate -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating symmetric and asymmetric keys -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Setting up Transparent Data Encryption (TDE) -- Getting ready -- How to do it... -- How it works...

There's more...