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

OFF-TOPIC: Surviving, Missing Folks, Glad I'm Home

by Brian Kelley

Databases – Infrastructure – Security

I certainly wish circumstances were different and I would have been able to attend the PASS Summit this week. I...

2009-11-06

739 reads

Not Attending/Presenting at SQL Connections

by Brian Kelley

Databases – Infrastructure – Security

Given everything that has happened in the last couple of weeks, this is not surprising to those who have kept...

2009-10-31

1,388 reads

OFF-TOPIC: God is Still Good, Even as We Mourn

by Brian Kelley

Databases – Infrastructure – Security

Kimberly and I went to the high risk doctor's office this morning for the ultrasound. Unfortunately, they realized very quickly...

2009-10-30

1,925 reads

OFF-TOPIC: More about the pregnancy

by Brian Kelley

Databases – Infrastructure – Security

Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private....

2009-10-29

894 reads

SQL University: Multiple Paths and Ownership Chaining

by Brian Kelley

Databases – Infrastructure – Security

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...

2009-10-29

2,681 reads

SQL University: Diving into Authorization

by Brian Kelley

Databases – Infrastructure – Security

It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on...

2009-10-27

6,152 reads

SQL University: Authentication and Authorization

by Brian Kelley

Databases – Infrastructure – Security

Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...

2009-10-25

10,887 reads

Another Year, Another Missed PASS Summit

by Brian Kelley

Databases – Infrastructure – Security

This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...

2009-10-23

1,673 reads

Habits and Activities for De-Stressing

by Brian Kelley

Databases – Infrastructure – Security

I was chatting on FaceBook today with a guy from my church who is learning to be a network engineer. He's...

2009-10-22

933 reads

Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

by Brian Kelley

SQLServerCentral.com

SQL Server Express has the same code base as the rest of the versions of SQL Server, but there are some differences in how to set it up and configure various tasks. MVP Brian Kelley shows us how to enable the Dedicated Administrator Connection.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(13)

You rated this post out of 5. Change rating

2009-10-21

6,045 reads

Discuss

All authors

Brian Kelley

OFF-TOPIC: Surviving, Missing Folks, Glad I'm Home

Not Attending/Presenting at SQL Connections

OFF-TOPIC: God is Still Good, Even as We Mourn

OFF-TOPIC: More about the pregnancy

SQL University: Multiple Paths and Ownership Chaining

SQL University: Diving into Authorization

SQL University: Authentication and Authorization

Another Year, Another Missed PASS Summit

Habits and Activities for De-Stressing

Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

Blogs

Experimenting with CHOOSE: #SQLNewBlogger

Fighting Procrastination?

A Fun Prize at the PASS Data Community Summit

Forums

MERGE in a nested TRY/CATCH won't roll back

Perfermance result aftet purge operatio

SQL Server 2025 Server-level Roles

Question of the Day

SQL Server 2025 Server-level Roles