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

Troubleshooting SQL Server Error 15517

by Brian Kelley

Databases – Infrastructure – Security

Last week I had the following error message repeating over and over again in the SQL Server log of one of...

2018-03-21 (first published: 2013-04-22)

59,914 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

356 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

311 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,063 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,925 reads

WIT: A Quick Thought

by Brian Kelley

Databases – Infrastructure – Security

I recently had the opportunity to be a Dungeon Master (DM) at a gaming convention. It was my first time....

2018-02-02 (first published: 2018-01-22)

1,565 reads

DevOps Does Not Make Admins Obsolete

by Brian Kelley

Databases – Infrastructure – Security

As a follow up to my tweet, I stand by my belief that DevOps does not make administrators obsolete. I...

2018-01-11 (first published: 2018-01-03)

1,051 reads

BK’s Professional Learning Plans for 2018 #tsql2sday

by Brian Kelley

Databases – Infrastructure – Security

With 2018 coming, I’ve thought about the question, “What do I want to be when I grow up?” I ask...

2018-01-01 (first published: 2017-12-12)

1,414 reads

Learning to Give Presentations Well (Part 3)

by Brian Kelley

Databases – Infrastructure – Security

See Part 1 and Part 2.
Perfect Practice Makes Perfect
I can remember my Air Force ROTC class on communications skills where...

2017-12-29 (first published: 2017-12-11)

1,425 reads

More Beginner / Fundamentals Content

by Brian Kelley

Databases – Infrastructure – Security

Not surprisingly, there are folks who want beginner / fundamentals presentations and blog posts.

I put up the poll based on a...

2017-12-22 (first published: 2017-12-05)

1,895 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers