Powershell is a powerful scripting and automation tool available for the DBA. In this session, we will look at the building blocks of powershell and how it can make day to day DBA tasks easier. Building upon the basics, we will look at an automated script to help deploy code changes to multiple environments. The powershell code will read through all scripts in a directory, execute against the appropriate instance, and provide auditing and logging functionality to simplify this common task.
Speaker: Mendl Borensztejn
Mendl is a Database Administrator for RDX (Remote DBA Experts) in Pittsburgh, PA. He works with clients on general database administration needs. Mendl also enjoys reading and studying philosophy and logic as well as petting small furry animals.