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

PowerShell, Pester and Ola Hallengrens Maintenance Solution 24 Sep 2016
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and click the link and look at the easiest way to ensure that all of your essential database maintenance is performed. You can also watch a video from Ola at SQL Bits Recently I was thinking ...

The SQL Server Community Collaborative GitHub Organisation is born 14 Sep 2016
My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called dbatools and dbareports If you are working with SQL Server I highly recommend that you take a look at the vast number of commands available to you at dbatools which will help ...

Converting SQL Agent Job Duration to TimeSpan using PowerShell 12 Sep 2016
When you look in msdb for the SQL Agent Job duration you will find that it is an int. This is also the same when you look at Get-SQLAgentJobHistory from the sqlserver module. (You can get this by downloading the latest SSMS release from here) This means that when you look at the various duration ...

Making Start-Demo work with multi-line commands without a backtick 29 Aug 2016
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the PowerShell Conference in Hanover I started to make use of it in my presentations. Start-Demo was written in 2007 by a fella who knows PowerShell pretty well :-)  ...

Remove-SQLDatabaseSafely My First Contribution to DBATools 20 Jul 2016
What is DBA Tools? A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now grown into a collection of various commands that help automate DBA tasks and encourage best practices. You can read more about here and it is freely available for ...