Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.

Archives: October 2007

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…

Read more

1 comments, 1,604 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…

Read more

3 comments, 1,431 reads

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

Becoming a DBA, Part I

A recent thread on 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…

Read more

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…

Read more

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 Free Tools

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

Read more

0 comments, 1,556 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…

Read more

Midlands PASS October Meeting

Taya Blanchard to speak on A Practical Guide to Making Sense of Your SQL Server Application Performance

Midlands PASS Chapter - October 4, 2007 Meeting

Sponsored by Quest Software

The Midlands PASS Chapter is pleased to announce Taya Blanchard as our speaker for our October meeting. She will be speaking… Read more