SQL Express Migration Auto Close Setting
With over 700 databases to look after at MyWork automation is high on my list of priorities. I have two PowerShell scripts which run regularly checking SQL E...
Rob Sewell
Rob was a SQL Server DBA.
Now he just helps people with PowerShell, Azure, Automation, and Data.
He is a Cloud and Data Center MVP and a Data Platform MVP, co-leader of Data South West UK user group and PSConfEU organiser. One of the Admins for Data Saturdays https://datasaturdays.com
He is a proud supporter of the Data and PowerShell communities.
He has a fabulous beard
Recent Posts
Checking for SQL Server logins with PowerShell
As some of you may know, I love PowerShell!
sp_BlitzIndex™ ouput to Excel with Powershell
I am impressed with the output from sp_BlitzIndex™ and today I tried to save it to an excel file so that I could pass it on to the developer of the service. ...
Powershell can read email & insert excel file attachment into a SQL Database
So at our SQL SouthWest User Group session last week we had sessions from Jonathan @fatherjack and Annette @Mrsfatherjack on SSRS and SSIS respectively. Dur...
Checking SQL Error Logs, Event Logs and Stopping Services with Powershell
It was patching time this week at MyWork so I thought I would share some Powershell scripts I use to speed up the process.