Identify orphaned Database Users and differentiate them from "Loginless" Database Users.  Read more...

There is a lot of data out there that is specific to an individual, none more important perhaps than biometric data. Steve Jones writes a bit about the security implications involved in working with this data. (This editorial was originally published on Nov 10, 2008. It is being re-run as Steve is at SQL Bits.)  Read more...

If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...  Read more...

Script to find username and corresponding loginname for all user database in SQL Server  Read more...

Changes DB owner to sa for Online DB's where owner is not sa  Read more...

Microsoft might be changing their patching process for applications. This has Steve Jones worried they may move towards an Apple/iOS like model, which would not be good for server systems.   Read more...

There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...  Read more...

This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...  Read more...

This Friday Steve Jones talks about xp_cmdshell and the security regarding its use. Do you have any holes that might exist if administrators are allowed to use this tool on their instances?  Read more...

Evernote recently had a security incident and forced all users to reset their passwords. Many people thought this was a good response to a security incident. Would your company act in a similar manner?  Read more...

This week Steve Jones talks encryption and why you shouldn't be implementing anything you've invented.  Read more...

I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get rid of...  Read more...

A short look at the vulnerabilities your data may be susceptible to outside of the database tables.   Read more...

There's potentially an exploit that can download lots of data to a machine. This shouldn't be a concern for servers, but you never know.  Read more...

I will describe a simple method anyone can use to obtain lost password information for a SQL Server login.  Read more...

This script gives a server level snapshot of recent security changes  Read more...

Read more...

Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.  Read more...

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a...  Read more...

The password issue has Steve Jones concerned. So many of us that use computing devices don't do a good job of securing our information.  Read more...