SQL Server Security on the Ground
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.
Data Security
UNDERSTANDING SQL SERVER SECURITY: Secure xp_cmdshell with the Microsoft Master’s guide (in 4 not-so-easy steps)
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.
Dear Leadership: your SQL security stinks
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!
xp_cmdshell is not the problem
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!
Protect yourself from Ransomware with Minion Enterprise
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 »