André KammanOld School Expertise, Future Ready Solutions
Managing Ola Hallengrens scripts with Powershell

Managing Ola Hallengrens scripts with Powershell

I presented for the PASS Powershell Virtual Chapter on June 15th, 2016
It was an online session and it was recorded, the youtube video of it is here

I figured out what was wrong with the two little demo fails.
I was pressing F8 to only execute my selection but because of a CLS I didn’t see the error message.
That function that I use to load a script from a relative path doesn’t work when you press F8, only when you run the whole script with F5
Apparently F8 gives you a different execution context.

And the reason why the Excel demo didn’t produce 2 paths is because I specified the -SHOW option in the first one, the second export option failed because the excel file was in use by Excel itself

The slides and scripts can be downloaded here

Share:FacebookX
Written by
André Kamman
Join the discussion

This site uses Akismet to reduce spam. Learn how your comment data is processed.

André Kamman

About Me

André Kamman

André is a Data Engineer and architect mostly in Azure. He has done a lot of DBA work on 1000’s of SQL Servers where he discovered his love for Powershell, architecting data solutions, building and tuning ETL processes (with BIML), and even implementing PDW. Having to wrangle a lot of data he's using Python, SparkSQL in Azure Databricks, Data Factory, dbt and Power BI as well these days. André is a Data Platform MPV since 2009, Dutch Microsoft Data Platform Meetup lead, organiser of Data Saturday Holland and Data & BI track volunteer for Techorama Holland

Article Topics

You can find me here

  • Data Community Austria Day 24/01/2025 An Introduction to dbt
  • SQL Konferenz - Hanau, Germany 24/02/2025 – 26/02/2025 An introduction to dbt   &  My top tips for continuous learning without spending every minute of your free time on it