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

DBA Database scripts are on Github 16 May 2016
It started with a tweet from Dusty The second session I presented at the fantastic PowerShell Conference Europe was about using the DBA Database to automatically install DBA scripts like sp_Blitz, sp_AskBrent, sp_Blitzindex from Brent Ozar , Ola Hallengrens Maintenance Solution , Adam Mechanics ...

A Day In The Life of a SQLBits Volunteer 10 May 2016
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over 4 days in Liverpool last week. 2 days of full day sessions and 2 days of shorter sessions, a pub quiz, a party (literally) out of this world. It is organised and run by ...

Using PowerShell to set Extended Events Sessions to AutoStart 28 Mar 2016
When you look after more than a few SQL Servers you will need to perform the same actions against a number of  them and that is where PowerShell will be of great benefit. Recently I needed to ensure that all SQL Servers had a certain Extended Event Session set to auto-start and that it was … ...