Data We Don't Want

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.

How to Recover a SQL Server Login Password

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

Script to clean up “Windows” logins no longer in AD

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...

Alter User

Stored Procedures and SQL Injection

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.

Security Change Snapshot

This script gives a server level snapshot of recent security changes

Granting Permission to Grant Permissions

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

Serious Security

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.

Statistical Protection

Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.

The $50,000 Laptop

The average value of a lost laptop has been found to be much more than you might expect. Steve Jones talks about a recent study.