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…
Primer If you haven’t already read up on cooperative and preemptive scheduling or aren’t sure what those are, please read…
I am often asked about all kinds of various errors, of course with absolutely no context. I also get asked…
The Dude I get asked if I know anything about <newest SQL vulnerability as reported by random website>, quite often.…