Home Forums Programming Powershell Project ideas for DBA to advance in powershell RE: Project ideas for DBA to advance in powershell

  • Lowell (3/3/2016)


    i did a big Powershell documentation initiative.

    this script from awhile ago started it:

    Powershell script to script out jobs, databases, users, linked servers, logins, roles, alerts, etc from a list of servers

    using that as a baseline, i added the scripting all database objects(tables/views/etc);

    after that i added scripts to extract all SSRS Reports and objects from the ReportServer database;

    then I've got a pair that extract SSIS packages from either the SSIS catalog, or the SSISDB if it was a 2012+ server.

    I've got a couple still on my to-do list: extracting master keys, credentials and SSRS encryption keys via powershell;

    things i also already do in TSQL, that i could do in powershell would be scripting out traces,extended events, database mail settings, and linked servers(in the way i like it, not the way the above link does it).

    That sounds like an awesome usage of PowerShell. Any chance of you posting yours?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)