Today we’re going to hit my top 5 – well, top 6 – boots-on-the-ground security tips for SQL server: schemas, db_owner, dynamic SQL, DENY, crossover groups, and secondary servers.
SQL Server Security on the Ground Read More »
Quite a lot of data folks are reasonably concerned with the possible security holes that xp_cmdshell could introduce. Unfortunately, all the wrong things get all the attention. In this article, we cover what you really need to understand and secure xp_cmdshell, with a nice summary at the end.
There are daily reports of data leaks and ransomware attacks that maim companies in the public eye. What is it you’re supposed to do? Live in audit mode!
Dear Leadership: your SQL security stinks Read More »
You’ve heard xp_cmdshell is a security hole, right? It is NOT. The true danger to any SQL Server shop is unchecked SQL administrator rights!
xp_cmdshell is not the problem Read More »
Ransomware is becoming a huge problem in the corporate world as more and more companies fall prey to this heinous act of terrorism. One of the biggest disasters that could befall you as a company – or even specifically as a DBA – is to come in one day and discover your shop has been
Protect yourself from Ransomware with Minion Enterprise Read More »