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

Whitepaper on Malware to Attack Databases

by Brian Kelley

Databases – Infrastructure – Security

Cesar Cerrudo of Argeniss Information Security has put out a new whitepaper (.pdf format), Data0: Next generation malware for stealing...

2007-11-23

1,989 reads

Physical Fitness

by Brian Kelley

Databases – Infrastructure – Security

Real life events continue to interfere with my regular posting. However, I would rather deal with them and neglect posting...

2007-11-19

1,580 reads

Veterans' Day

by Brian Kelley

Databases – Infrastructure – Security

I'll post Part III of Becoming a DBA tomorrow (meaning there will be two posts). Veterans' Day is typically celebrated...

2007-11-12

627 reads

Resources: SQL Server 2005 Security

by Brian Kelley

Databases – Infrastructure – Security

Work responsibilities took up my time on Thursday and Friday, so I never got around to posting. Here's the resources...

2007-11-11

632 reads

Tools: Apex SQL Log, Apex SQL Log API, Sample Corrupted Databases

by Brian Kelley

Databases – Infrastructure – Security

Apex SQL has announced a new version of Apex SQL Log as well as an API for it.
Release Notes...

2007-11-07

798 reads

SQL Server: Showing permissions for a given database user

by Brian Kelley

Databases – Infrastructure – Security

Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...

2007-11-06

621 reads

Becoming a DBA, Part II

by Brian Kelley

Databases – Infrastructure – Security

This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...

2007-11-05

928 reads

The Impact of Architecture/Design Choices

by Brian Kelley

Databases – Infrastructure – Security

I try my best to get things right the first time. So often, correcting a mistake or bad choice is...

2007-11-05

694 reads

Online Resource: Safari Tech Books Online

by Brian Kelley

Databases – Infrastructure – Security

I've used Safari (the O'Reilly version) for a number of years now and it is a resource I often recommend...

2007-11-02

872 reads

Why SQL Server 2005 Doesn't Permit Non-ANSI Style OUTER JOINs

by Brian Kelley

Databases – Infrastructure – Security

As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes...

2007-11-01

2,208 reads

Blogs

Experimenting with CHOOSE: #SQLNewBlogger

I was looking over the CHOOSE() function while editing an article at SQL Server...

Fighting Procrastination?

By Brian Kelley

Here is another short video (~ 15 minutes). This is by the author of...

A Fun Prize at the PASS Data Community Summit

I had a briefing for the 2026 PASS Data Community Summit, which is just...

Read the latest Blogs

Forums

SQL Server 2025 Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Server-level Roles

Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions

By Bill Pearson

Comments posted to this topic are about the item Stairway to DAX and Power...

AI Is Improving Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Is Improving Security

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers