It’s Great When No One Asks Questions You’re taking the best steps to track what goes on in your instance – that’s awesome, even in heavily regulated industries which require these things, no one ever looks at them. Having been part of audits for years (and thankfully not involved for almost the last decade) I […]
Overall Introduction I’ve had some feedback that people would like to know some of the stuff I see and how I ended up finding the issue and troubleshooting the problem. I present to you a new heading/series called “olved steries”. If you’re wondering, “What is this name and do you not know how to spell?” […]
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 […]
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 […]
