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

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,…

PowerShelling SQL Saturday Sessions to the Guidebook app 07 Apr 2015
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to get information from the SQL Saturday web site I thought that this information and script may be useful for others performing the same task. Edit – This post was written prior to ...

Parsing XML Child Nodes and Converting to DateTime with PowerShell 21 Mar 2015
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 ...

Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month 17 Mar 2015
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 ...