Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell

If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance Solution. If you haven’t please start here https://ola.hallengren.com/ You can also watch his presentation at SQLBits at this link http://sqlbits.com/Sessions/Event9/Inside_Ola_Hallengrens_Maintenance_Solution where he talks about and demonstrates the solution. It is possible to just run his… Read More Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell

Parsing XML Child Nodes and Converting to DateTime with PowerShell

As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to get some schedule information to input into a database. I had read Steve Jones blog posts on Downloading SQL Saturday Data and followed the steps there to download the data from the SQL Saturday website for our… Read More Parsing XML Child Nodes and Converting to DateTime with PowerShell

Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month

Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm GMT 12pm EDT and also at the Cardiff SQL User Group on Tuesday 31st March I will be giving my Making Powershell Useful for your Team presentation You have heard about PowerShell and may be… Read More Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month