There were a few emails about login times so I figured it warranted a blog post. Strap in, this one goes sideways fast. Some people noted that the amount of time to log in with a SQL Login in SQL Server 2025 all of a sudden took longer. This is clearly stated in the Docs, […]
It feels like only yesterday I was complaining about Sentinel One trying to take the crown for shittiest security software. Afraid they may be dethroned, CrowdStrike hit back and hit back hard! It started off with a report that Erik loves some big memory grants and cannot lie. One of the worst monitoring tools for […]
I have a long history shitting on CrowdStrike – and well, with their past it’s pretty warranted – but antivirus software is general does bother the hell out of me. You’re essentially installing something that interrogates everything on your system and injects itself everywhere hoping it stops a known issue but generally ends up causing […]
Quite the interesting problem was brought to me by a friend, in that they had a database level audit setup and were having `select` queries trigger audits that the object had updates run on them. The question became, how is this possible as a select query doesn’t update anything. Let’s start with a quick setup […]
Security must be making the rounds again as I’ve recently had quite a few inquiries about a “vulnerability” in SQL Server connections. I am in the camp of, if it isn’t easy to exploit or is completely theoretical and the exploit is barely an inconvenience such as, “could allow a local admin user to rearrange […]
Contained Availability Groups are the most recent update to the Availability Groups feature, and a great update at that! They are completely new in SQL Server 2022, and like any new feature (or even mature ones) there will be some bugs. Enter in some Access Violations (AVs) that may occur when creating a new contained […]
When SQL Server 2019 came out, there was a new service installed along with SQL Server called, “AzureAttestService”, however there was no documentation and the service continues to be installed with SQL Server 2022. To this day there still isn’t any. To be fair, the question only comes up a handful of times and each […]
I was recently asked a question, while fixing a cluster connectivity issue, about how the cluster resource dll knows on which port to connect to SQL Server. It’s not a very exciting answer, which is, “It doesn’t.”. After some days passed I was thinking about the question and answer as though the response I had […]
Let me start off by saying that DBATools is a great tool that is immensely helpful to the community, if you haven’t heard about it or tried it, please give it a shot! I personally believe that the SQL Server community is truly the best out there, with so many people helping each other and […]
The Dude I get asked if I know anything about <newest SQL vulnerability as reported by random website>, quite often. Generally, my answer is that I don’t for two main reasons… the first being that none of them are actual vulnerabilities, and the second being that none of them are particularly new but merely items […]
