3/12 – Webinar : Beginning Automation with Powershell

Anything I can do to reduce the time I have to spend dealing with otherwise time-sucking tasks gives me a happy. Currently, where I am, I have reduced our daily deployment process to a single Powershell cmdlet with a log file review. All the steps that normally went into each deployment (applying SQL scripts, data updates, updating the TFS task, sending an email that the deployment is done) are handled by Powershell, and the process accepts multiple deployments at the same time. As long as there are no errors in the log file for a deployment, there is nothing more to do. There’s an error? Run the same cmdlet with the rollback option.

I am still working on improving this process, from trying to get the error handling to work the way I want it to, to incorporating the automation of check-in to source control of the changes that were just applied. It is a work-in-progress that will continue to reduce the amount of time spent on what would otherwise be manual tasks.

This work led me to the idea for a session on Powershell and automation of processes. Join me and Pragmatic Works on Thursday, March 12th from the comfort of your own desk at 11am EST/10am CST for Beginning Automation with Powershell. This demo-heavy session will go over some different Powershell cmdlets and automation concepts that you can take and build upon in your own environment. Powershell is a tool that no DBA should work without. A development background is helpful but not necessary – what DBA would not want to spend a few hours writing code for a process that will save them from having to do a repetitive manual task over and over again? Automation frees up time for us to do other projects that we want to spend time on and grow our skill sets.

Have questions about this? Leave a comment below. See y’all there. 🙂

9 Responses to 3/12 – Webinar : Beginning Automation with Powershell

  1. Hey Amy, thanks for the article. How does the Rollback option work? Were the rollback scripts previously created or do you use a database snapshot and comparison tool to perform this function? Thanks!

    • Hi Patrick,

      The rollback option currently uses the scripts that have been provided by the developer. I have a separate Powershell process that generates both deployment and rollback scripts (my preference) using the command line version of RedGate SQL Compare but we are not using that right now since I am not getting the piece from them that I need to make that happen (XML) and I don’t have the time to basically troll all the code and create that on my own.

      Also, FWIW – this will not be a part of this webinar since I would have to use things from my employer and I am not sure they would like that. And I like having a job. I will be going over some automation techniques and concepts that you can use as a stepping stone to doing similar things where you are.

  2. Amy, you indicated during the webinar that the scripts for the PowerShell presentation would be made available via your website. Can you point me in the right direction please?
    Paul (Powershell Newb)

    • Hi Paul,

      I will be getting that into a new post this weekend and it will be on my twitter feed once it is available. Thanks for watching yesterday – hope you got a lot out if it! 🙂

  3. Hi Amy,

    Are the scripts available for download?


    • Hi Jimmy,

      Thanks for watching yesterday – I will have the scripts up this weekend. Let me know if you have any questions about them or Powershell in general. 🙂

  4. Can you email me a copy of your presentation and scripts from the Beginning Automation with Powershell on Thur march 12, 2015.
    I’m not on twitter either.

  5. Can we get the scripts you used in this talk and demo?

  6. Where do I get the password to download the scripts?


Leave a Reply

Your email address will not be published. Required fields are marked *