SQL server 2012 with PowerShell V3 cookbook / Donabel Santos.

Format:

Book

Author/Creator:

Santos, Donabel.

Series:

Quick answers to common problems.

Language:

English

Subjects (All):

SQL server.

Database management.

Windows PowerShell (Computer program language).

Physical Description:

1 online resource (634 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, [Eng.] : Packt Publishing, 2012.

Language Note:

English

Summary:

SQL Server 2012 with Power Shell V3 Cookbook"" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using Power Shell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away,This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants

Contents:

Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with SQL Server and PowerShell; Introduction; Before you start: Working with SQL Server and PowerShell; Working with the sample code; Exploring the SQL Server PowerShell hierarchy; Installing SMO; Loading SMO assemblies; Discovering SQL-related cmdlets and modules; Creating a SQL Server instance object; Exploring SMO server objects; Chapter 2: SQL Server and PowerShell Basic Tasks; Introduction; Listing SQL Server instances

Discovering SQL Server services Starting/stopping SQL Server services; Listing SQL Server configuration settings; Changing SQL Server instance configurations; Searching for database objects; Creating a database; Altering database properties; Dropping a database; Changing a database owner; Creating a table; Creating a view; Creating a stored procedure; Creating a trigger; Creating an index; Executing a query / SQL script; Performing bulk export using Invoke-Sqlcmd; Performing bulk export using bcp; Performing bulk import using BULK INSERT; Performing bulk import using bcp

Chapter 3: Basic Administration Introduction; Creating a SQL Server instance inventory; Creating a SQL Server database inventory; Listing installed hotfixes and service packs; Listing running/blocking processes; Killing a blocking process; Checking disk space usage; Setting up WMI Server event alerts; Detaching a database; Attaching a database; Copying a database; Executing a SQL query to multiple servers; Creating a file group; Adding secondary data files to a file group; Moving an index to a different file group; Checking index fragmentation; Reorganizing/rebuilding an index

Running DBCC commands Setting up Database Mail; Listing SQL Server jobs; Adding a SQL Server operator; Creating a SQL Server job; Adding a SQL Server event alert; Running a SQL Server job; Scheduling a SQL Server job; Chapter 4: Security; Introduction; Listing SQL Server service accounts; Changing SQL Server service account; Listing authentication modes; Changing authentication mode; Listing SQL Server log errors; Listing failed login attempts; Listing logins, users, and database mappings; Listing login/user roles and permissions; Creating a login; Assigning permissions and roles to a login

Creating a database user Assigning permissions to a database user; Creating a database role; Fixing orphaned users; Creating a credential; Creating a proxy; Chapter 5: Advanced Administration; Introduction; Listing facets and facet properties; Listing policies; Exporting a policy; Importing a policy; Creating a condition; Creating a policy; Evaluating a policy; Enabling/disabling change tracking; Running and saving a profiler trace event; Extracting the contents of a trace file; Creating a database master key; Creating a certificate; Creating symmetric and asymmetric keys

Setting up Transparent Data Encryption (TDE)

Notes:

Includes index.

ISBN:

9781283739085

1283739089

9781849686471

1849686475

OCLC:

818818960