Post Description

Provides over a hundred practical recipes that utilize PowerShell to automate, integrate and simplify SQL Server tasks
    Offers easy to follow, step-by-step guide to getting the most out of SQL Server and PowerShell
    Covers numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes or other components
    Builds a strong foundation that gets you comfortable using PowerShell with SQL Server--empowering you to create more complex scripts that you need in your day-to-day job


What you will learn from this book

    Create an inventory of database properties and server configuration settings
    Backup and restore databases
    Execute queries to multiple servers
    Maintain permissions and security for users
    Import and export XML into SQL Server
    Extract CLR assemblies and BLOB objects from the database
    Explore database objects
    Manage and deploy SSIS packages and SSRS reports
    Manage and monitor running SQL Server services and accounts
    Parse and display the contents of trace files
    Create SQL Server jobs, alerts and operators
    Find blocking processes that are hampering your database performance

 Language : English
Paperback : 634 pages [ 235mm x 191mm ]
Release Date : October 2012
ISBN : 1849686467
ISBN 13 : 9781849686464
Author(s) : Donabel Santos
gepost door : Rockhound57