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

Don’t Fear the Technology

by Brian Kelley

Databases – Infrastructure – Security

The concern that a particular technology is going to destroy the world seems to be an ever present fear. The technology changes but the fear and the marketing around...

2026-10-05 (first published: 2026-09-22)

392 reads

New article – migrating from a named instance

by Brian Kelley

Databases – Infrastructure – Security

Do you have a case where you have a named instance you'd like to migrate to a default instance? Is there pushback on doing so? Are there concerns that...

2026-09-07 (first published: 2026-08-26)

349 reads

Learning Tool – Deepstash

by Brian Kelley

Databases – Infrastructure – Security

A few months ago I started using Deepstash. Deepstash breaks books into the key ideas, usually 10-12 per book. If I am thinking about reading a book, I check...

2026-08-27

97 reads

Take Time to Gain Perspective

by Brian Kelley

Databases – Infrastructure – Security

Probably the best piece of advice I ever received is to take time to gain perspective.

2026-08-24 (first published: 2026-08-14)

426 reads

Stanford Emerging Technology Review 2026 Report is out

by Brian Kelley

Databases – Infrastructure – Security

Artificial Intelligence and quantum computing are two areas of emerging technology that receive most of the tech news. However, the Stanford Emerging Technology Review tries to include any relevant...

2026-08-19 (first published: 2026-08-04)

406 reads

Methodology for dealing with bad data in production

by Brian Kelley

Databases – Infrastructure – Security

Pinal Dave wrote up his methodology for what to do when you discover bad data in production. If you’ve never been in this situation, having a plan beforehand is...

2026-08-17 (first published: 2026-07-30)

451 reads

Claude finds two cryptographic weaknesses (but the sky isn’t falling)

by Brian Kelley

Databases – Infrastructure – Security

If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview) to find cryptographic weaknesses in two algorithms. However, this doesn't impact anything anyone has in...

2026-08-12 (first published: 2026-07-29)

467 reads

My Social Media Rules

by Brian Kelley

Databases – Infrastructure – Security

I developed these rules a while back, before COVID. I had a period of self-reflection when I realized I was spending time wastefully arguing with folks on the various...

2026-08-12

182 reads

Excellent article on securing msdb

by Brian Kelley

Databases – Infrastructure – Security

Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's why you should read it if you're a DBA or security professional.

2026-08-11

315 reads

Accept the no and move on

by Brian Kelley

Databases – Infrastructure – Security

Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin. When we are rejected, whatever the situation, many of us want to know why. We...

2026-08-10

306 reads

All authors

Brian Kelley

Don’t Fear the Technology

New article – migrating from a named instance

Learning Tool – Deepstash

Take Time to Gain Perspective

Stanford Emerging Technology Review 2026 Report is out

Methodology for dealing with bad data in production

Claude finds two cryptographic weaknesses (but the sky isn’t falling)

My Social Media Rules

Excellent article on securing msdb

Accept the no and move on

Blogs

T-SQL Tuesday #203: Risk and Reward

dataMinds Connect 2026 – Slides & Scripts

How to Clear the SSMS Cache (SSMS 21 and Later)

Forums

Alamat BCA KCP Tanah Abang Blok B Telp:0821°8200°233

Alamat BCA KCP Juanda III Telp:0821°8200°203

Alamat BCA KCP Jembatan Lima Telp:0821°7555°651

Question of the Day

PostgreSQL psql Meta Commands: Databases