Data Driven Security

Set a security standard across environments that developers can see and run, but not change.

New SQL Server 2014 Permissions: CONNECT ANY DATABASE

CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and why would we ever want this?

The Case Of the Downward Pointing Arrow

Reading, Writing, and Riskmetic

Cloud Storage Security: Are You Doing Your Part?

If the level cloud storage encryption are so high, then why is the cloud security industry experiencing such distrust?

I Gotta See the Code

Access Granted or Not?

Get the all user and their server role

The script give you the list of all users and their respective Server roles

SQL Server Security Checklist

SQL Server security related tasks can be divided into four main categories: physical security, operating system level security, SQL Server configuration and user management. Here is your SQL Server security checklist.

I No Longer Have Access to My DB and I'm a DBCreator!