SQL Server 2014 with PowerShell v5 Cookbook / Donabel Santos

Von:

Santos, Donabel [aut]

Resource type: Ressourcentyp: Buch (Online)Buch (Online)Sprache: Englisch Verlag: Birmingham, UNKNOWN : Packt Publishing, 2015Verlag: Birmingham, UNKNOWN : Packt PublishingAuflage: 1Beschreibung: 1 online resource (760)ISBN:

9781785283611
1785283618

Schlagwörter:

Andere physische Formen: 1785283618. | 9781785283611. DDC-Klassifikation:

005.282

LOC-Klassifikation:

QA76.9.C55

Online-Ressourcen:

Zugang im Netz des KIT

Zusammenfassung: Cover -- Copyright -- Credits -- About the Author -- Acknowledgments -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Getting Started with SQL Server and PowerShell -- Introduction -- Working with the sample code -- Installing SQL Server using PowerShell -- Installing SQL Server Management Objects -- Loading SMO assemblies -- Exploring the SQL Server PowerShell hierarchy -- 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 -- Scripting SQL Server Stored Procedures -- Creating a database -- Altering database properties -- Dropping a database -- Changing 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 the bcp command-line utility -- Performing bulk import using BULK INSERT -- Performing bulk import using the bcp command-line utility -- Connecting to an Azure SQL database -- Creating a table in an Azure SQL database -- 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 SQL query to multiple servers.PPN: PPN: 860191915Package identifier: Produktsigel: ZDB-26-MYL | ZDB-30-PQE | ZDB-38-EBR

Exemplare ( 0 )

Dieser Titel hat keine Exemplare