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

All authors

Webcast: How to Secure SQL Server – End to End Security

by Brian Kelley

Databases – Infrastructure – Security

On April 16, 2024, I will be giving another webcast; this one will be on SQL Server security. Sign up link As always, the registration is free. Here’s the...

2024-03-29

98 reads

Tomorrow – Webcast on SQL Server Administration

by Brian Kelley

Databases – Infrastructure – Security

I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...

2024-03-25

17 reads

Webcast on SQL Server Administration

by Brian Kelley

Databases – Infrastructure – Security

I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...

2024-03-15 (first published: 2024-03-08)

308 reads

Humble Bundle of Java Books

by Brian Kelley

Databases – Infrastructure – Security

I try to keep an eye on the Humble Bundle bundles for books. The bundles serve two great purposes: I was able to grab the Cybersecurity bundle, but by...

2024-02-26

125 reads

Security Justifications for Infrastructure as Code (IaC)

by Brian Kelley

Databases – Infrastructure – Security

Last week, the Cybersecurity & Infrastructure Security Agency (CISA) put out an emergency directive which ordered federal agencies to pull Ivanti Connect Secure and Ivanti Policy Secure installations from...

2024-02-23 (first published: 2024-02-05)

191 reads

David Kahn, legendary author, has passed away

by Brian Kelley

Databases – Infrastructure – Security

I first saw this at Schneier on Security. David Kahn, author of The Codebreakers, has passed away at 93. The Codebreakers was considered the best book on the history...

2024-02-05

41 reads

ISACA Journal Article on AI

by Brian Kelley

Databases – Infrastructure – Security

The first issue of 2024 for the ISACA Journal has been published and the articles are available both in written and on-line format. I have a regular column on...

2024-02-02

24 reads

BI Training with Eugene Meidinger

by Brian Kelley

Databases – Infrastructure – Security

I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...

2024-01-31

59 reads

Videos from MITRE ATT&CKcon 4.0

by Brian Kelley

Databases – Infrastructure – Security

If you aren’t familiar with the ATT&CK framework and knowledge base, it’s a tool to help classify and understand cyberattacks. Recently (Oct 2023), ATT&CKcon 4.0 was held and MITRE...

2024-01-29

11 reads

SQL Server documentation refresh: Logical and physical showplan operator reference

by Brian Kelley

Databases – Infrastructure – Security

Understanding query plans is key to successful query tuning in Microsoft SQL Server. Randolph West of the Microsoft docs team posted on Thursday that the logical and physical showplan...

2024-01-26

42 reads

All authors

Brian Kelley

Webcast: How to Secure SQL Server – End to End Security

Tomorrow – Webcast on SQL Server Administration

Webcast on SQL Server Administration

Humble Bundle of Java Books

Security Justifications for Infrastructure as Code (IaC)

David Kahn, legendary author, has passed away

ISACA Journal Article on AI

BI Training with Eugene Meidinger

Videos from MITRE ATT&CKcon 4.0

SQL Server documentation refresh: Logical and physical showplan operator reference

Blogs

SQL Server 2025 RegEx and AI

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

Why Databases Still Fascinate Me

Forums

Columnstore index question

Transactional Replication

Member was not found in the cube when the string

Question of the Day

Identify a Slipstream Installation