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

Security Architecture: Knowing the Adversary

by Brian Kelley

Databases – Infrastructure – Security

When I present or teach on a security topic, I take the time to cover the mindset of the adversary....

2017-12-13 (first published: 2017-12-04)

1,740 reads

Register for Red Gate’s SQL in the City

by Brian Kelley

Databases – Infrastructure – Security

Aunt Kathi. Grant Fritchey. Steve Jones. They’re part of five hours of training on SQL Server performance and DevOps with...

2017-12-08

477 reads

Kalen Delaney’s Weekly Webinars

by Brian Kelley

Databases – Infrastructure – Security

Anyone who has been working with SQL Server for any length of time should be aware of the name Kalen...

2017-12-07

340 reads

Webinar: Understanding SQL Injection and Its Consequences

by Brian Kelley

Databases – Infrastructure – Security

On Thursday, December 14, at 3 PM Eastern, I will be giving a presentation on SQL injection. Registration is required...

2017-12-06

472 reads

Geek Sync Recording: Taking Control of Your SQL Server Sprawl

by Brian Kelley

Databases – Infrastructure – Security

Back in July, I gave a webcast for Idera’s Geek Sync. They’ve published the recording. You can find it here:
Take...

2017-11-17

446 reads

Learning to Give Presentations Well (Part 1)

by Brian Kelley

Databases – Infrastructure – Security

I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...

2017-11-17 (first published: 2017-11-06)

1,509 reads

Learning to Give Presentations Well (Part 2)

by Brian Kelley

Databases – Infrastructure – Security

Presentation Zen cover
In Part 1, I gave some advice from Toastmasters. We’ll return to the Toastmasters advice in Part 3....

2017-11-15

529 reads

Don’t “Test” Against Production

by Brian Kelley

Databases – Infrastructure – Security

A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the...

2017-10-30 (first published: 2017-10-18)

2,062 reads

If You’re Stuck at Home for the PASS Summit

by Brian Kelley

Databases – Infrastructure – Security

Conferences are a great place to network, to see new technologies or to see existing technologies being used in new...

2017-10-30

674 reads

Automating Everything with PowerShell – Getting Started #tsql2sday

by Brian Kelley

Databases – Infrastructure – Security

I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other...

2017-10-17

907 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