SQL DBA With A Beard

Emailing Disk Space Alerting With Powershell

• by Rob Sewell

• SQL DBA With A Beard

 
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening...

2014-11-04

4,675 reads

Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell

• by Rob Sewell

• SQL DBA With A Beard

So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...

2014-10-06

686 reads

PowerShell Snippets A Great Learning Tool

• by Rob Sewell

• SQL DBA With A Beard

When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good...

2014-09-09

681 reads

Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information

• by Rob Sewell

• SQL DBA With A Beard

 
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...

2014-09-07

505 reads

Refreshing Availability Group Database with PowerShell

• by Rob Sewell

• SQL DBA With A Beard

Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh...

2014-09-04

1,335 reads

Refreshing A SQL Mirrored Database Using Powershell

• by Rob Sewell

• SQL DBA With A Beard

 
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...

2014-08-25

948 reads

Enable CLR with Powershell

• by Rob Sewell

• SQL DBA With A Beard

I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
He...

2014-05-05

778 reads

Listing the SQL Server SysAdmins With PowerShell

• by Rob Sewell

• SQL DBA With A Beard

A very short blog today just to pass on this little script.
I was required to list all of the SysAdmins...

2014-04-14

491 reads