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

Should DBAs have local administrator rights?

by Brian Kelley

Databases – Infrastructure – Security

This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...

2009-11-20

14,026 reads

Why We Recommend Against xp_cmdshell

by Brian Kelley

Databases – Infrastructure – Security

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...

2009-11-13

21,115 reads

SQL Server Wish: Last Logon Information

by Brian Kelley

Databases – Infrastructure – Security

The other day my wife and I were driving around and noticed that a Little Caesar's location had shown up...

2009-11-10

8,741 reads

Always Striving to Improve

by Brian Kelley

Databases – Infrastructure – Security

I'm enjoying a relaxing Saturday morning and I'm doing a bit of reading on ESPN. I see the article about...

2009-11-07

865 reads

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

735 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,386 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,920 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

891 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,676 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,149 reads

Blogs

T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?

The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...

Monday Monitor Tips: Configuring Access to the MCP Server

I have been experimenting with MCP servers in a few ways, including the Redgate...

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

Read the latest Blogs

Forums

Admin Rights for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Admin Rights for Everyone

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

By Arvind Toorpu

Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...

RegEx Functions I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions I

Visit the forum

Question of the Day

RegEx Functions I

Which of these RegEx functions need compatibility level 170 in SQL Server 2025?

See possible answers