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

Some Pester Tests for SQL Defaults 24 May 2016
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the slides and code here) I found out about Irwin Strachans Active Directory Operations Test which got me thinking. I decided to do the same for my usual SQL Set-up. Treating all of ...

DBA Database scripts are on Github 16 May 2016
It started with a tweet from Dusty The second session I presented at the fantastic PowerShell Conference Europe was about using the DBA Database to automatically install DBA scripts like sp_Blitz, sp_AskBrent, sp_Blitzindex from Brent Ozar , Ola Hallengrens Maintenance Solution , Adam Mechanics ...

A Day In The Life of a SQLBits Volunteer 10 May 2016
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over 4 days in Liverpool last week. 2 days of full day sessions and 2 days of shorter sessions, a pub quiz, a party (literally) out of this world. It is organised and run by ...

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 ...