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

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

Using the new SQLServer Powershell module to get SQL Agent Job Information 03 Jul 2016
So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here As I mentioned in my previous post the name of the module has changed to sqlserver This means that if you have a PowerShell script doing Import-Module SQLPS, it will need to be changed ...

PowerShell CMDLets added for SQL2016 Always Encrypted 30 Jun 2016
The post on the SQLServer blog at TechNet by the SQL Server Tools Team today made me jump out of my seat. The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of thanks for this effort to the great collaboration with our community. We ...

Some Pester Tests for SQL Defaults 24 May 2016
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the slides and code here) I found out about Irwin Strachans Active Directory Operations Test which got me thinking. I decided to do the same for my usual SQL Set-up. Treating all of ...