I don’t often find many people using FileStream in their databases (which isn’t a bad or good thing, in my…
I would say I’m surprised but… ahem… I’m not. My own snarkyness aside, I’m not sure what updates have or…
Issue Introduction I was sent a quite an interesting email stating that SQL Server would not shut down. Attempting to…
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,…
Issue Introduction I was asked if I knew any reason why SQL Agent would be using “a bunch” of memory…
When SQL Server 2019 came out, there was a new service installed along with SQL Server called, “AzureAttestService”, however there…
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…
Let me start off by saying that DBATools is a great tool that is immensely helpful to the community, if…