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,620 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,108 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

928 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

535 reads

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

PASS Summit East is in one week. I was on the road last week...

I don’t have SQL Server installed on my laptop. In an effort to keep...

Comments posted to this topic are about the item Increase Deadlock Detection

Comments posted to this topic are about the item A Tool is Better than...

Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?