Opinionated SQL
Search

Month: January 2020

NotASQLServerProblem

SQL Server Self-Signed Certificate “Vulnerabilities”– FFS Get Off My Lawn

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 […]

Read article: SQL Server Self-Signed Certificate “Vulnerabilities”– FFS Get Off My Lawn
NotASQLServerProblem

Error 8474 state 11, 17836 state 20, 9642 state 3, and your company’s need to incessantly scan for vulnerable ports

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 […]

Read article: Error 8474 state 11, 17836 state 20, 9642 state 3, and your company’s need to incessantly scan for vulnerable ports