You would like to grant all access on...

You suspect that a hacker is trying to...

To execute sp_change_users_login procedure with all the three...

Bill's company recently purchased another company and he...

Yukon Passwords

Some good info on password changes in Yukon (SQL 2005). Based on the beta, but worth taking a look at.

On your production SQL Server 2000, you have...

How to Make Sure You Have Good Passwords

As Robin points out there is no built in way to make sure users have strong passwords when using SQL authentication. There are a couple changes you can make (with appropriate warnings!) that will allow you to do this. Read on to find out why and how.

Tonya needs to manage what user accounts can...

SQL Injection - Part 1

Randy says that the biggest reason we have so many injection vulnerabilities is that all the asp books use inline sql for their examples! We STILL encounter developers who don't understand injection. Read and pass on to your dev team.

SQL Server 2000 Best Practices Analyzer Beta

Microsoft has released a new tool to analyzer your SQL Servers and see how they conform to their list of common best practices. Give it a try and let us know what you think.