Custom cover image
Custom cover image

SQL Server 2014 with PowerShell v5 Cookbook / Donabel Santos

By: Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Publisher: Birmingham, UNKNOWN : Packt Publishing, 2015Publisher: Birmingham, UNKNOWN : Packt PublishingEdition: 1Description: 1 online resource (760)ISBN:
  • 9781785283611
  • 1785283618
Subject(s): Additional physical formats: 1785283618. | 9781785283611. DDC classification:
  • 005.282
LOC classification:
  • QA76.9.C55
Online resources: Summary: 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
No physical items for this record
KIT – The University in the Helmholtz Association                         Home | Impressum | Datenschutz | Barrierefreiheit | KIT