Update 5/24/2022: I’ve updated the DMV to reflect the various node and witness dynamic settings with a new column at the end of the DMV called number_of_current_votes. This is only in 2022 and will not be backported. Background I’ve now run across a few different instances where the monitoring for quorum was done via this […]
Refresher It may be news (or not) to you that SQL Server can utilize the latest transport security standards when talking to clients and servers. Normally you’d need to create your own certificate for use with said standard protocols, but SQL Server is super nice and will create one for you, self-signed, and use that […]
The road to Hell is paved with good intentions. I get it, your security team is the best ever. You work at a company where the industry (or public sector) requires that servers be “compliant” by constantly and incessantly scanning them for vulnerabilities, in production of course. I know for some it checks a required […]
I had initially wrote this post with a great deal of information, but it came across as snarky and condescending which was not my original intention. Thus I’ve rewritten it in the hopes that it’s succinct and distilled down the the minimal amount of information needed to make an informed decision. This post is specifically […]
There has, for whatever reason, been a recent craze to figure out if a certain replica does or does not have the availability group create database permission. This is the permission that allows for automatic seeding to take place on the replica that is part of the availability group. I don’t quite understand the need. […]
Migrations from Windows Server 2008/R2 must be in full swing as there seems to be quite the buzz that SQL Server uses the sIDHistory attribute in Active Directory and they can migrate away with naught another thought. To set the background for this, Active Directory administrators have had an attribute that some applications have been […]
Note (4/30/2021): DPA/SolarWinds still executes queries to turn this TF on, even though they’ve been told multiple times by myself and others that it no longer exists. You might want to get a better monitoring product if you’re still using this.Note (7/4/2021): I’m a random person on the internet, but I also work with SQL […]
