Platinum Sponsor

Rob Sewell

Rob is a SQL Server DBA currently supporting several hundred databases ranging from SQL 2000 to SQL 2012 and including Ingres and Oracle for a government organisation. Rob has a fabulous beard and loves to use Powershell to make his life easier
http://sqldbawithabeard.com http://sqldbawithabeard.com/feed/

Blog posts RSS

Refreshing A SQL Mirrored Database Using Powershell 25 Aug 2014
  SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and although the feature is deprecated it is still widely utilised. You can read more about it on MSDN here and Jes Borland wrote a useful post answering many questions here ...

Enable CLR with Powershell 05 May 2014
I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter He was getting an error whilst trying to set CLR Enabled during an automatic install and asked if I had any ideas. The error he had was related to Invoke-SQLcmd and the method he was ...

Listing the SQL Server SysAdmins With PowerShell 14 Apr 2014
A very short blog today just to pass on this little script. I was required to list all of the SysAdmins across a large estate. Obviously I turned to PowerShell :-) I iterated through my server list collection and then created a server SMO object and used the EnumServerRoleMembers method to display ...

How I Check Hundreds of SQL Agent Jobs in 60 Seconds with Powershell 31 Mar 2014
Checking that your Agent Jobs have completed successfully is a vital part of any DBA’s responsibility. It is essential to ensure that all of the hard work you have put into setting up the jobs can be quickly and easily checked. In a large estate this can be very time consuming and if done ...

Rationalisation of Database with Powershell and T-SQL part two 03 Mar 2014
In the previous post I showed the script to create an Excel Workbook, colour coded showing the last used date for all of the databases on servers in my sqlservers.txt file. After gathering that information over several months, there is then a requirement for someone to make a decision as to which ...