Rob_Sewell.jpg

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
http://sqldbawithabeard.com http://sqldbawithabeard.com/feed/

Blog posts RSS

Populating My DBA Database for Power Bi with PowerShell – Server Info 31 Aug 2015
Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database. They are the secondary part to my DBADatabase which I also use to automate the installation and upgrade of all of my DBA scripts as… ...

Using Power Bi with my DBA Database 16 Aug 2015
Every good DBA should have a DBA database. A place to store information about all of their instances and databases. I have an InstanceList table which looks like this   I use this as the basis for all of my information gathering. By adding Server name, Instance Name , Port, Environment and ...

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

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 https://ola.hallengren.com/ You can also watch his presentation at SQLBits at this link ...