Rob Sewell

Rob is a SQL Server DBA with a passion for Powershell and automation currently supporting several hundred databases ranging from SQL 2000 to SQL 2012 and including Ingres and Oracle. Rob has volunteered and spoken at community events through the UK and is an organiser for SQL Saturday Exeter

Blog posts RSS

Setting Up and Using Azure VM SQL Automated Backup (and Restore) 24 Jul 2015
This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots. I have always used my Powershell scripts described here to create my test systems and with a new job taking up a lot of my time had missed the announcement about Azure SQL Automated Backup ...

Installing and upgrading default scripts automation – part one – Introduction 08 Jun 2015
First I must say thank you to all of the wonderful people who have put time and effort into providing free tools and scripts to enable not only myself but all SQL DBAs to ease their work. For this series I especially thank Brent Ozar – w|t Ola Hallengren – w Adam Mechanic – ...

Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell 06 May 2015
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 You can also watch his presentation at SQLBits at this link ...

Spinach and Database Development- SQLSatExeter Keynote 30 Apr 2015
Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we were delighted to have a world exclusive keynote video by Phil Factor about Spinach and Database Development. With many thanks to those that made it possible and particularly to Phil Factor I ...

Instances and Ports with PowerShell 22 Apr 2015
Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them When you know a server name but not the name of the instances or the ports that they are using this function will be of use