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…
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…
The Dude I get asked if I know anything about <newest SQL vulnerability as reported by random website>, quite often.…
You’ve Asked, It’s Now Here! The largest complaint, by far, for Availability Groups (AG) has been that system databases could…