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

Update Your Audit Queries for SQL Server

by Brian Kelley

Databases – Infrastructure – Security

I was working with an auditor today who is working through a system with an external audit agency. The external...

2013-06-13

2,136 reads

Personally Identifiable Information (PII) and Data Encryption

by Brian Kelley

Databases – Infrastructure – Security

Hitting close to home, SC Governor Nikki Haley noted that after the SC Department of Revenue breach was reported, that the IRS didn't...

2013-06-07

5,089 reads

Why Anti-Virus Offers Limited Protection

by Brian Kelley

Databases – Infrastructure – Security

Sitting in the first Keynote for the 2013 Techno Security and Forensics Investigation Conference, I was not surprised to hear Kevin...

2013-06-06

1,498 reads

From the 2013 Techno Security Conference - Cloud Computing and Digital Forensics

by Brian Kelley

Databases – Infrastructure – Security

I'm processing through my notes for the 2013 Techno Security Conference, which is finishing up today with post-cons. Of all...

2013-06-05

1,164 reads

Notes from 2013 Techno Security Conference Tuesday Keynote

by Brian Kelley

Databases – Infrastructure – Security

There's enough from this morning's 2013 Techno Security and Forensics Investigation Conference to split into multiple blog posts. I'll focus this...

2013-06-04

1,161 reads

SQL Server security webinar series is coming soon!

by Brian Kelley

Databases – Infrastructure – Security

I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All...

2013-06-04 (first published: 2013-05-30)

2,542 reads

Notes from the First Day of the 2013 Techno Security Conference

by Brian Kelley

Databases – Infrastructure – Security

The Techno Security & Forensics Security Conference is held in conjunction with the Mobile Forensic Conference each year in Myrtle Beach,...

2013-06-03

1,189 reads

SQL Saturday Charleston!

by Brian Kelley

Databases – Infrastructure – Security

Finally.... SQL Saturday has come back to... South Carolina! (with apologies to The Rock)

After the last SQL Saturday in Columbia,...

2013-05-30

1,910 reads

Security and SSIS webinar recording available

by Brian Kelley

Databases – Infrastructure – Security

If you missed the webinar Andy Leonard (blog | twitter) and I presented today or you had technical difficulties, here's the...

2013-05-29

949 reads

SSIS Security Presentation today, May 29th

by Brian Kelley

Databases – Infrastructure – Security

Andy Leonard (blog | twitter) and I are teaming up to do a security presentation today on SSIS. It's scheduled for 11 AM...

2013-05-29

842 reads

Blogs

A New Word: Dorgone

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

Hyperscale Replicas II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas II

Practical Reporting Queries with CROSS APPLY (Part 3)

Comments posted to this topic are about the item Practical Reporting Queries with CROSS...

Your Favorite Quotes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Your Favorite Quotes

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers