4th - 7th May 2016

Liverpool

Rob_Sewell.jpg

Rob Sewell

Rob is a SQL Server DBA with a passion for Powershell and automation. Rob has volunteered and spoken at community events through the UK and Europe and is an organiser for SQL Saturday Exeter
http://sqldbawithabeard.com http://sqldbawithabeard.com/feed/

Blog posts RSS

Using PowerShell to set Extended Events Sessions to AutoStart 28 Mar 2016
When you look after more than a few SQL Servers you will need to perform the same actions against a number of  them and that is where PowerShell will be of great benefit. Recently I needed to ensure that all SQL Servers had a certain Extended Event Session set to auto-start and that it was… ...

Backing up to URL container name – case is important 03 Mar 2016
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name case is important So will work but will give an (400) Bad Request Error which may not be easy to diagnose If you are using Ola Hallengrens jobs to perform your backup then your ...

PowerShell Pester Testing for Parameter Validation 31 Jan 2016
This error caught me out. I am putting this post here firstly to remind me if I do it again adn also to help others who may hit the same issue. Today I am rewriting a function to create a Hyper-V VM so that I can properly script the creation of my labs for demos… Read More PowerShell Pester ...

PowerShell Pester – "The script failed due to call depth overflow." 31 Jan 2016
This error caught me out. I am putting this post here firstly to remind me if I do it again and also to help others who may hit the same issue. I also have been looking at Pester which is a framework for running unit tests within PowerShell You will find some good blog posts… Read More ...

Power Bi, PowerShell and SQL Agent Jobs 28 Sep 2015
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs – The SQL Agent Job report. You can get the scripts and reports here This gives a quick overview of the status of the Agent Jobs… Read More ...