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

ISACA Class: Auditing SQL Server in Every Way Possible

by Brian Kelley

Databases – Infrastructure – Security

At this year’s TechnoSecurity and Digital Forensics Conference I gave a 1 hour presentation on auditing SQL Server. There were...

2018-08-09

262 reads

New at Simple-Talk: Principles of Data Protection

by Brian Kelley

Databases – Infrastructure – Security

My latest article, Principles of Data Protection, has been published at Simple-Talk! I address the basic problem and how we...

2018-07-02

364 reads

I’m published at Simple-Talk!

by Brian Kelley

Databases – Infrastructure – Security

My first article has gone live at Simple-Talk! Thanks to Aunt Kathi for the opportunity!
Detecting Data Breaches
I’m also still writing...

2018-06-12

337 reads

New Article: Return SQL Server Connections Information Using sys.dm_exec_connections

by Brian Kelley

Databases – Infrastructure – Security

I’ve started a new series at MSSQLTips.com walking through the various Dynamic Management Objects we have available to us in SQL...

2018-05-18

409 reads

Speaking at Idera’s Live Virtual Conference

by Brian Kelley

Databases – Infrastructure – Security

Have you heard about Idera’s Live Virtual Conference? It is being held on May 16, from 9 AM to 3...

2018-05-01

270 reads

Webinar: Auditing with Extended Events

by Brian Kelley

Databases – Infrastructure – Security

I’m giving a webinar today, April 5th, at 3 PM Eastern, on using Extended Events to audit your SQL Servers....

2018-04-05

336 reads

Webinar: Identify and Eliminate SQL Server Performance Issues

by Brian Kelley

Databases – Infrastructure – Security

I’m giving a webinar tomorrow, March 22, 2018, at 3 PM Eastern.
Free Registration Link
Here’s what I’ll be covering:
Are you struggling...

2018-03-21

364 reads

Speaking at the 2018 Techno Security and Digital Forensics Conference

by Brian Kelley

Databases – Infrastructure – Security

One of my favorite conferences is held in Myrtle Beach, SC, in June. It’s a security and digital forensics conference which...

2018-03-01

314 reads

Settings Goals Professionally

by Brian Kelley

Databases – Infrastructure – Security

I was reminded of this topic after yesterday’s #SQLChat. Have you set professional goals for yourself? If so, have you...

2018-02-16 (first published: 2018-02-08)

2,071 reads

Tinker as You Learn

by Brian Kelley

Databases – Infrastructure – Security

In recent weeks I’ve seen my brother from another mother, Andy Leonard (twitter | blog), write or post about his learning...

2018-02-09 (first published: 2018-01-24)

1,937 reads

Blogs

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

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

What Does It Mean to Make Data AI-Ready?

Making Data AI-Ready, Part 1 (This is the first article in a three-part series...

Using the Data API Builder–VS Live San Diego Resources

Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...

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