Welcome to the CoderBoard Community!

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to exclusive download links, post topics, communicate privately with other members (conversations), respond to polls, share content and access many other special features.
Registration is fast, simple and absolutely FREE so please, join our community today!

Click Here to Sign Up Now!

MULTI SQL Server 2014 with PowerShell v5 Cookbook

Discussion in 'Database Development Books & Tutorials' started by beastie, Dec 17, 2015.

  1. beastie

    beastie Well-Known Member

    Joined:
    Dec 1, 2015
    Messages:
    495
    Likes Received:
    6,922
    [​IMG]
    SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos
    English | 4 Dec. 2015 | ISBN: 1785283324 | 760 Pages | MOBI/PDF (conv) | 42.28 MB

    Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity.

    About This Book

    This book helps you build a strong foundation to get you comfortable using PowerShell with SQL Server, empowering you to create more complex scripts for your day-to-day job
    The book provides numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes, or other components
    It offers easy-to-follow, practical recipes to help you get the most out of SQL Server and PowerShell

    Who This Book Is For

    If you are a SQL Server database professional (DBA, developer, or BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks, this books is for you. Prior knowledge of scripting would be helpful, but it is not necessary.

    What You Will Learn

    Explore database objects and execute queries on multiple servers
    Manage and monitor the running of SQL Server services and accounts
    Back up and restore databases
    Create an inventory of database properties and server configuration settings
    Maintain permissions and security for users
    Work with CLR assemblies, XML, and BLOB objects in SQL
    Manage and deploy SSIS packages and SSRS reports

    In Detail

    PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities are robust and flexible, allowing you to simplify automation and integration across different Microsoft applications and components.

    The book starts with an introduction to the new features in SQL Server 2014 and PowerShell v5 and the installation of SQL Server. You will learn about basic SQL Server administration tasks and then get to know about some security-related topics such as the authentication mode and assigning permissions. Moving on, you will explore different methods to back up and restore your databases and perform advanced administration tasks such as working with Policies, Filetables, and SQL audits. The next part of the book covers more advanced HADR tasks such as log shipping and data mirroring, and then shows you how to develop your server to work with BLOB, XML, and JSON.

    Following on from that, you will learn about SQL Server's BI stack, which includes SSRS reports, the SSIS package, and the SSAS cmdlet and database. Snippets not specific to SQL Server will help you perform tasks quickly on SQL servers. Towards the end of the book, you will find some useful information, which includes a PowerShell tutorial for novice users, some commonly-used PowerShell and SQL Server syntax, and a few online resources. Finally, you will create your own SQL Server Sandbox VMs. All these concepts will help you to efficiently manage your administration tasks.

    Style and approach

    SQL Server 2014 with PowerShell v5 Cookbook is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. 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.

    Hidden Content:
    You must reply before you can see the hidden data contained here.
     
    #1
    Max Rodrigues likes this.
  2. iCEVooDoo

    iCEVooDoo New Member

    Joined:
    Mar 25, 2016
    Messages:
    17
    Likes Received:
    0
  3. owliber

    owliber New Member

    Joined:
    Apr 14, 2016
    Messages:
    5
    Likes Received:
    0
    thank you
     
    #3
  4. iCEVooDoo

    iCEVooDoo New Member

    Joined:
    Mar 25, 2016
    Messages:
    17
    Likes Received:
    0
  5. Dustin Marzolf

    Dustin Marzolf New Member

    Joined:
    Aug 19, 2016
    Messages:
    11
    Likes Received:
    1
  6. Mightymemnon

    Mightymemnon New Member

    Joined:
    Sep 6, 2016
    Messages:
    4
    Likes Received:
    0
    Thanks!
     
    #6
  7. tgeeee

    tgeeee New Member

    Joined:
    Sep 22, 2016
    Messages:
    4
    Likes Received:
    0
    thanks for it
     
    #7
  8. WONDER

    WONDER New Member

    Joined:
    Sep 30, 2016
    Messages:
    11
    Likes Received:
    0
  9. fluidi

    fluidi New Member

    Joined:
    Oct 27, 2016
    Messages:
    8
    Likes Received:
    1
     
    #9
  10. shasha12

    shasha12 New Member

    Joined:
    Nov 3, 2016
    Messages:
    3
    Likes Received:
    0
    gracias amigo!
     
    #10
  11. kwellens

    kwellens New Member

    Joined:
    Nov 5, 2016
    Messages:
    5
    Likes Received:
    0
    Thanks
     
    #11
  12. Max Rodrigues

    Max Rodrigues New Member

    Joined:
    Nov 11, 2016
    Messages:
    24
    Likes Received:
    0

Share This Page