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

SQLRally 2012 - Dallas Registration Is Open!

by Brian Kelley

Databases – Infrastructure – Security

Want 2 days of Microsoft SQL Server training where you can hand-pick what you're learning about for the low price...

2011-11-30

2,032 reads

No SQL Saturday - Columbia, SC in 2012

by Brian Kelley

Databases – Infrastructure – Security

Last week my partner in crime, Bobby Dimmick (blog | twitter) and I sat down for lunch and caught up and...

2011-11-14

1,665 reads

SQL Server security webinar now available on-demand

by Brian Kelley

Databases – Infrastructure – Security

Last week I was able to give a SQL Server security webinar with Quest Software and SQL Server MVP Kevin...

2011-11-08

1,166 reads

Meme Monday: #SQLFamily

by Brian Kelley

Databases – Infrastructure – Security

Tom asks what #SQLFamily means to me. This is a hard one, not because of what #SQLFamily does for me,...

2011-11-07

1,723 reads

Presenting Tomorrow (Thursday) via Webinar - SQL Server Security

by Brian Kelley

Databases – Infrastructure – Security

I have the privilege of being able to give a webinar tomorrow, November 3, at 11 AM EDT. It will...

2011-11-02

1,087 reads

Understanding Kerberos, Part III

by Brian Kelley

Databases – Infrastructure – Security

Welcome back to both our Kerberos coverage and to another topic for SQL University's Security and Auditing Week. In today's...

2011-10-28

16,135 reads

Webinar on SQL Server Security on November 3, 2011

by Brian Kelley

Databases – Infrastructure – Security

I have the privilege of being able to give a webinar next Thursday, November 3, at 11 AM EDT. It...

2011-10-28

1,007 reads

SQL University: SQL Agent Jobs That Run at SQL Agent Start

by Brian Kelley

Databases – Infrastructure – Security

Welcome to Security week at SQL University. I apologize for the late start. However, if you want to do some...

2011-10-27

2,954 reads

Understanding Kerberos, Part II

by Brian Kelley

Databases – Infrastructure – Security

The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...

2011-10-18

4,057 reads

Understanding Kerberos, Part I

by Brian Kelley

Databases – Infrastructure – Security

A get a lot of questions where I work about Kerberos and how it works for SQL Server, whether we're...

2011-10-17

4,320 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

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

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

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