This project has moved and is read-only. For the latest updates, please go here.

Previous SQL Server Proxy Accounts SQL Server Memory Management Next

DBA Password Store

The DBA Team will need to keep a record of a large number of passwords as part of their normal work. They should make sure they have a secure place to store these passwords.

There are a number of free and commercial products that can provide a secure password store, and the DBA Team should use whatever method is recommended at their site.

One of the simplest methods is to use the built-in encryption features in Microsoft Word. For all versions from Microsft Word 2003 onwards, putting a Read Password on to a document also encrypts it. In more recent versions of Word, this is specifically marked as Encrypt Document.

After the document is encrypted, the password for the document can be shared across all of the DBA Team. If someone leaves the DBA Team, it is a simple process to re-encrypt the password document with a new password.

Copyright © 2012 - 2013 Edward Vassie. License and Acknowledgements
Previous SQL Server Proxy Accounts Top SQL Server Memory Management Next

Last edited May 23, 2013 at 4:13 PM by EdVassie, version 4