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

Biography/History:

Santos Donabel: Donabel Santos is a self-confessed data geek. She loves working with data, writing queries, and developing reports on her SQL Server databases, and exploring and visualizing data with Tableau. She is the principal and senior business intelligence architect at QueryWorks Solutions, a Tableau Learning and Alliance partner in Vancouver, BC, Canada, providing consulting and training services. She has spent years in consulting and has developed a variety of solutions for clients in different verticalsfinance, manufacturing, healthcare, legal, higher education, and local government. Donabel is a multi-year Microsoft Data Platform MVP (previously known as SQL Server MVP) and has extensive experience in the SQL server in different areas, such as development, administration, data warehouse, reporting (SSRS), tuning, troubleshooting, XML, CLR, and integration with ERPs and CRMs using PowerShell, C#, SSIS, and Power BI. One of Donabel's passions is teaching and sharing her love for data. She is a Tableau Certified Professional and a Tableau accredited trainer, delivering Tableau public and on-site client training. She is also the lead instructor for a number of courses at British Columbia Institute of Technology (BCIT), including Applied Database Administration and Design (ADAD) and Applied Data Analytics (ADA) programs. She teaches SQL server administration, development, integration (SSIS), data warehouse foundations, and visual analytics with Tableau. Donabel has also authored three other books with Packt Publishing: SQL Server 2012 with PowerShell V3 Cookbook, PowerShell for SQL Server Essentials, and SQL Server 2014 with PowerShell V5 Cookbook. She also contributed a chapter to Manning Publications' PowerShell Deep Dives.

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