Brian Kelley

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.

Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology

More information about SQL Server 2005 and SP2

by Brian Kelley

Databases – Infrastructure – Security

SQL Server MVP Aaron Bertrand has posted an update (April 6, 2007) on the version numbers of post SP2 hotfixes....

2007-04-09

1,374 reads

How to pick a combination lock in 30 seconds

by Brian Kelley

Databases – Infrastructure – Security

This is just frightening. A piece of a beer can, a pair of pliers, and the combo lock pops open.

...

2007-04-07

1,501 reads

SQL Server Samples on CodePlex

by Brian Kelley

Databases – Infrastructure – Security

Like many other SQL Server focus area, SQL Server Samples has its own blog. A recent post there indicates that...

2007-04-06

1,417 reads

Thoughts from The Cuckoo's Egg

by Brian Kelley

Databases – Infrastructure – Security

The Cuckoo's Egg by Clifford Stoll has been around for a while, having been published in 1989. It details how...

2007-04-06

1,655 reads

Updated Website

by Brian Kelley

Databases – Infrastructure – Security

I've taken some time to update my website. In particular I have updated:
ArticlesReading ListChess Reading List
Nothing fancy or special, but...

2007-03-20

1,343 reads

Whitepaper on ESX Server 3.0 and SAN-attached Storage

by Brian Kelley

Databases – Infrastructure – Security

First saw this at Blade Watch. VMWare has released a white paper on using SANs with VMWare ESX Server 3.0....

2007-03-20

1,491 reads

SQL Server 2005 Security Best Practices Whitepaper Released

by Brian Kelley

Databases – Infrastructure – Security

Saw this first here: SQL Server 2005 Security Best Practices. It's on the blog for Microsoft UK's SQL Server Premier...

2007-03-19

1,872 reads

Windows PowerShell and Windows Server 2003 SP2

by Brian Kelley

Databases – Infrastructure – Security

Saw this on the Windows PowerShell blog:

Since W2K3 SP2 is an update to W2K3 SP1, if you install Powershell on...

2007-03-19

2,550 reads

"Wet" Pet Food Recall

by Brian Kelley

Databases – Infrastructure – Security

Animals are near and dear to my heart, to the point where I have a cat even though I am...

2007-03-17

1,344 reads

Windows Mobile Security

by Brian Kelley

Databases – Infrastructure – Security

I'm working on a new article for SQL Server Central talking about physical security and SQL Server and I was...

2007-03-17

1,359 reads

Blogs

In-Person CISA Training – April 13-16, 2026

By Brian Kelley

I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...

EightKB 2026

By Andrew Pruski

EightKB is back again for 2026! The biggest online SQL Server internals conference is...

The FinOps Lifecycle: From Budgeting to Reporting

Working in DevOps long enough teaches you two universal truths: That’s exactly why I...

Read the latest Blogs

Forums

query to track time spent on individual tasks in SSIS

Hi everyone I am looking at building a query to determine how much time...

SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database

Comments posted to this topic are about the item SQL Server Transactional Replication from...

Hidden Heroes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hidden Heroes

Visit the forum

Question of the Day

Identities and Sequences I

When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?

See possible answers