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

Geek Sync on Wednesday: Taking Control of Your Organization’s SQL Server Sprawl

by Brian Kelley

Databases – Infrastructure – Security

This Wednesday, July 26th, at 12 PM EDT, I’ll be giving a presentation through Idera’s Geek Sync series. You will...

2017-07-24

299 reads

Security Basics: The Principle of Least Privilege

by Brian Kelley

Databases – Infrastructure – Security

Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...

2017-07-17 (first published: 2017-06-30)

2,963 reads

The Three A’s: Auditing

by Brian Kelley

Databases – Infrastructure – Security

Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at...

2017-07-13 (first published: 2017-06-28)

1,631 reads

The Three A’s: Authorization

by Brian Kelley

Databases – Infrastructure – Security

Having covered authentication yesterday, let’s move on the second A, authorization. Authentication was about proving identity. Now that we know...

2017-07-10 (first published: 2017-06-27)

1,675 reads

The Three A’s: Authentication

by Brian Kelley

Databases – Infrastructure – Security

When I start talking with folks about security, one of the areas of confusion I often find has to do...

2017-07-05 (first published: 2017-06-26)

1,834 reads

Recording of PASS Security VC Webinar

by Brian Kelley

Databases – Infrastructure – Security

If you were unable to attend this month’s PASS Security Virtual Chapter webinar, The Dirty Business of Auditing, it has...

2017-06-29

571 reads

#SQLChat on Performance Issues

by Brian Kelley

Databases – Infrastructure – Security

Twitter can often be a great source of information for the SQL Community, especially with the #SQLHelp hashtag. Another resource...

2017-06-23

381 reads

PASS Security VC Presentation – The Dirty Business of Auditing

by Brian Kelley

Databases – Infrastructure – Security

On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.
Registration...

2017-06-19

378 reads

Speaking at Charleston PASS on May 18, 2017

by Brian Kelley

Databases – Infrastructure – Security

During the day of the 18th I’ll be at the Syntax Code and Craft Conference in Charleston, SC. That evening...

2017-05-12

326 reads

Slides from 24 Hours of PASS – Data Security

by Brian Kelley

Databases – Infrastructure – Security

As promised, here are my slides from the 24 Hours of PASS on Data Security:
S1 – Brian Kelley_WhatYouAbsolutelyMustKnowAboutSQLServerSecurity (.pptx – 733 KB)
S7 – Brian...

2017-05-09

393 reads

All authors

Brian Kelley

Geek Sync on Wednesday: Taking Control of Your Organization’s SQL Server Sprawl

Security Basics: The Principle of Least Privilege

The Three A’s: Auditing

The Three A’s: Authorization

The Three A’s: Authentication

Recording of PASS Security VC Webinar

#SQLChat on Performance Issues

PASS Security VC Presentation – The Dirty Business of Auditing

Speaking at Charleston PASS on May 18, 2017

Slides from 24 Hours of PASS – Data Security

Blogs

Goodbye, Microsoft

The SUM of Nothing: #SQLNewBlogger

How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections

Forums

Buy driver’s license to legally drive in any EU country.

review about registered documents.

Review about how people can get documents online without any stress

Question of the Day

RegEx Functions IV