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

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

SQL Server 2005 SP2 and Maintenance Plans - Still not fixed yet

by Brian Kelley

Databases – Infrastructure – Security

SQL Server MVP Aaron Bertrand has posted that there is still a bug with maintenance plans for SQL Server 2005...

2007-03-15

1,449 reads

New Version of ApexSQL Doc (2005.11.0203)

by Brian Kelley

Databases – Infrastructure – Security

ApexSQL announced that a new version of ApexSQL doc is available.

News Announcement

The latest version is 2005.11.0203 and there are...

2007-03-14

1,519 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers