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 by Obscurity?

by Brian Kelley

Databases – Infrastructure – Security

Andy Warren points to a TechNet article about Security by Obscurity and wanted me to post some notes. Let's start...

2008-06-04

959 reads

Now on Twitter

by Brian Kelley

Databases – Infrastructure – Security

A few colleagues of mine, Andy Leonard, Jason Massie, and Chuck Boyce, are all on Twitter. As a matter of fact,...

2008-05-30

1,525 reads

Security Issue with SQL Server Reporting Services 2008

by Brian Kelley

Databases – Infrastructure – Security

I have a CTP of SSRS 2008 deployed to one of my servers. Today I built a couple of reports...

2008-05-30

2,540 reads

Pictures from Midlands PASS Chapter Meeting

by Brian Kelley

Databases – Infrastructure – Security

Last night the Midlands PASS Chapter had the pleasure of hosting SQL Server MVP Brian Knight. I was able to...

2008-05-28

1,550 reads

Reminder: Midlands PASS Chapter Meeting with Brian Knight

by Brian Kelley

Databases – Infrastructure – Security

Tuesday, May 27, 2008
Speaker: SQL Server MVP Brian Knight
The Midlands PASS chapter will hold a special meeting on...

2008-05-23

1,730 reads

SQL Saturday in Orlando

by Brian Kelley

Databases – Infrastructure – Security

The dates for Microsoft's TechEd 2008 are fast approaching here in North America. Sandwiched between the two weeks of this year's...

2008-05-23

1,953 reads

Review of How to Cheat at Securing SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

SQL Server MVP Frank Kalis has posted a short review on How to Cheat at Securing SQL Server 2005, a...

2008-05-20

1,902 reads

Technical Podcasts I Listen To

by Brian Kelley

Databases – Infrastructure – Security

There are a few podcasts I tend to listen to as I have time. Since I work with a wide...

2008-05-19

4,044 reads

Giving a Presentation?

by Brian Kelley

Databases – Infrastructure – Security

As a president of a local PASS chapter, one of the things I've struggled with is getting "locals" to give...

2008-05-17

676 reads

Setting Static Ports when dealing with Named Instances and Kerberos

by Brian Kelley

Databases – Infrastructure – Security

I ran across this a week or so ago. There were a couple of SQL Servers running named instances that...

2008-05-17

10,626 reads

Blogs

From Planning to Practice: Setting Up Your FinOps Framework

As someone who works in DevOps, I’m always focused on creating systems that are...

“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....

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