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

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

38 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

68 reads

T-SQL Tuesday #170 – Learning from Failure

by Brian Kelley

Databases – Infrastructure – Security

So what did I learn? I think a better question is, "What did I re-learn?"

2024-01-26 (first published: 2024-01-09)

253 reads

Is that the right question to ask?

by Brian Kelley

Databases – Infrastructure – Security

This is not a “clickbait” title, but an important consideration when it comes to developing technical solutions. Let me give you an example between two questions for SQL Server...

2023-11-29 (first published: 2023-11-17)

266 reads

Giving a Security Webinar this Wednesday

by Brian Kelley

Databases – Infrastructure – Security

If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern Standard Time, I’m presenting a webinar on how to harden SQL Server. Link to Register...

2023-11-27

26 reads

Webinar: How to Harden SQL Server

by Brian Kelley

Databases – Infrastructure – Security

On November 29, 2023, at 11 AM Eastern Standard Time, I'm presenting a webinar on how to harden SQL Server.

2023-11-15

200 reads

Product Review: DataVeil

by Brian Kelley

Databases – Infrastructure – Security

If you’re looking at data masking tools, I recently was able to review the DataVeil solution. Quite simply, getting production data out of non-production environments is still a big...

2023-09-19

70 reads

Restarting What’s Important

by Brian Kelley

Databases – Infrastructure – Security

I’m currently in Enterprise Architecture in my organization and as a result, I blogged earlier about putting up study notes with regards to preparing for the two TOGAF (The...

2023-09-13

41 reads

Appalachian State Cyber Summit – September 8, 2023

by Brian Kelley

Databases – Infrastructure – Security

Looking to attend a security summit in cooler weather that will benefit students? Applachian State holds an annual cybersecurity summit and this year it is scheduled for September 8,...

2023-08-17

46 reads

TOGAF 9 Certified Exam Breakdown

by Brian Kelley

Databases – Infrastructure – Security

In the last post I hadn’t found the breakdown of questions for the exam. The Open Group does publish the TOGAF 9 Certified Study Guide (link goes to the...

2023-03-06

68 reads

All authors

Brian Kelley

Videos from MITRE ATT&CKcon 4.0

SQL Server documentation refresh: Logical and physical showplan operator reference

T-SQL Tuesday #170 – Learning from Failure

Is that the right question to ask?

Giving a Security Webinar this Wednesday

Webinar: How to Harden SQL Server

Product Review: DataVeil

Restarting What’s Important

Appalachian State Cyber Summit – September 8, 2023

TOGAF 9 Certified Exam Breakdown

Blogs

Fighting Procrastination?

A Fun Prize at the PASS Data Community Summit

How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents

Forums

Alamat BCA KCP Pluit Samudra Telp 0821 6277 387

Alamat BCA KCP Pluit Raya Telp +62 821-6277-387

Alamat BCA KCP Dayeuhkolot Telp +62 821 6277 387

Question of the Day

SQL Server Vector Support I