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,375 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,502 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,419 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,493 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,876 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,564 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,352 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,366 reads

Blogs

Day of Data Baton Rouge Slides and Code

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By Anthony Nocentino

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

We are product focused at Redgate Software. Here is another of our values that...

Read the latest Blogs

Forums

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server 2016 Plan

whats that ssis analyzer product that documents lineage

hi, a few years ago was at a very large company that bought a...

Implicit Conversions Cripple SQL Server

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)

What is returned?

See possible answers