Read Scale Availability Groups can be pretty useful in the right places and for the right things and were a…
I’ve been playing around with some different NVMe drives lately, looking at different performance characteristics and when I saw the…
I don’t often find many people using FileStream in their databases (which isn’t a bad or good thing, in my…
There was a question that came up on the MCM mailing list about what are these files: model_msdbdata.mdf, model_msdblog.ldf, model_replicatedmaster.mdf,…
Setup If you’re using availability groups with read-scale or linux (cluster type = None/External), you might want to watch the…
I was recently asked a question, while fixing a cluster connectivity issue, about how the cluster resource dll knows on…
I see many questions, and have been on the receiving end of many myself, about out of support items and…
You’ve Asked, It’s Now Here! The largest complaint, by far, for Availability Groups (AG) has been that system databases could…
Initially I thought to myself, “this is the most misunderstood wait type that exists in the HA space for SQL…
One of the most common issues I look at from day to day is some variation of the question. “Why…