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

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

Checking SQL Server User Role Membership with PowerShell 14 Apr 2015
Originally posted on SQL DBA with A Beard:As you know, I love PowerShell! I use it all the time in my daily job as a SQL DBA and at home whilst learning as well. Not only do I use PowerShell for automating tasks such as Daily Backup Checks, Drive Space Checks, Service Running Checks,…