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

One Week from SQLRally!

by Brian Kelley

Databases – Infrastructure – Security

SQLRally is a week away (pre-cons start on Tuesday, conference starts on Thursday). I have the privilege of two sessions to...

2012-05-02

850 reads

Updated Thoughts on Antivirus on SQL Servers

by Brian Kelley

Databases – Infrastructure – Security

I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...

2012-04-30 (first published: 2012-04-24)

5,844 reads

Professional Productivity Books

by Brian Kelley

Databases – Infrastructure – Security

Just as with the "soft skills" books, in my professional development presentation, I list the professional productivity books that I have found most helpful in my...

2012-04-18

917 reads

Tribal knowledge is no knowledge

by Brian Kelley

Databases – Infrastructure – Security

I've run across several incidents in the last couple of months regarding something that is typically called "tribal knowledge." This is...

2012-04-18 (first published: 2012-04-12)

1,309 reads

"Soft Skills" books

by Brian Kelley

Databases – Infrastructure – Security

In my professional development presentation, I list the "soft skills" books that I have found most helpful in my career to date. You can find...

2012-04-16

1,593 reads

Re-thinking security for customer service

by Brian Kelley

Databases – Infrastructure – Security

This morning my son woke up to find his eBook reader frozen. It wouldn't unlock. It was fully charged (the...

2012-04-12

1,277 reads

Why an employer should never ask about accessing your Facebook page

by Brian Kelley

Databases – Infrastructure – Security

There's a brilliant piece of work posted as a fictitious resignation letter that gives some scenarios as to why an employer could...

2012-04-03

1,360 reads

Why you can't provide your Facebook credentials

by Brian Kelley

Databases – Infrastructure – Security

I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...

2012-04-02

2,402 reads

T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It

by Brian Kelley

Databases – Infrastructure – Security

If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?

Being a specialist means you're...

2012-03-13

1,468 reads

SQL Saturday #110 - Tampa - The Dirty Business of Auditing Presentation Materials

by Brian Kelley

Databases – Infrastructure – Security

For those who might want the materials for my presentation at SQL Saturday #110, I've posted them to the site.

SQL...

2012-03-10

1,055 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

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

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

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

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