Tool: KeePass Password Safe password manager/vault

Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open source and free. It's a nice password manager and some of the features I like are:

Strong encryption of the password database
The ability to use a password, key…

1 comments, 586 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 31 October 2007

SQL Server: Listing all the database roles for a given database user

SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion, we'd have to resort to a temporary table or a like type of structure. Therefore, if we have hierarchical lookups, CTEs are a great construct to use to navigate…

3 comments, 602 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 October 2007

Becoming a DBA, Part I

A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a RunAs Radio podcast with SQL Server MVP Brad McGehee on Being a Better DBA and that raises the question, "What does it take to become a DBA?"

I came at…

4 comments, 474 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 October 2007

Structuring the Blog Better

For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like. That doesn't just include the blog, but also writing articles. It's been a long while since I've written an article for SSC. I want to get back to writing…

0 comments, 393 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 October 2007

Alpha Version of SQLPing3 Command Line Available

Noted SQL Server security expert, Chip Andrews, has released an alpha version of a command-line version of SQLPing3. You can find it at his free tools location on SQLSecurity.com:

SQLSecurity.com Free Tools

If you aren't familiar with the SQLPing series, these tools are used to detect SQL Servers in…

0 comments, 761 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 October 2007

My Book is Out!

How to Cheat at Securing SQL Server 2005

I recently had the opportunity to contribute a couple of chapters to this new SQL Server security book from Syngress. The concept of the book is to provide a fundamental understanding for harried IT workers on how to use SQL Server 2005's…

3 comments, 104 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 4 October 2007