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,616 reads

Refreshing A SQL Mirrored Database Using Powershell

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

2014-08-25

1,104 reads

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

2014-05-05

917 reads

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

2014-04-14

530 reads

One of the language changes in SQL Server 2025 that I’ve seen a lot...

I hosted this month, but I decided to put my own entry in as...

I get asked a lot about why or how I began working with databases...

Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...

Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...

Hey, I've not done a cube for many years but I find myself supporting...

I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?