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

SC Midlands Chapter of ISACA - SQL Server Auditing Course Materials

by Brian Kelley

Databases – Infrastructure – Security

If you attended my SQL Server Auditing course held for the SC Midlands Chapter of ISACA, I finally was able...

2012-03-09

1,330 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-06

1,225 reads

Speaking at oPASS on March 8th

by Brian Kelley

Databases – Infrastructure – Security

I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...

2012-03-01

1,028 reads

New Article: Exploiting SQL Server via CONTROL SERVER permissions

by Brian Kelley

Databases – Infrastructure – Security

I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...

2012-02-27

1,734 reads

Presenting Two Sessions at SQLRally

by Brian Kelley

Databases – Infrastructure – Security

I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....

2012-02-27

978 reads

A Plea: Have your guidance documentation reviewed

by Brian Kelley

Databases – Infrastructure – Security

Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...

2012-02-23

1,229 reads

Two Sessions Up for Vote at SQLRally!

by Brian Kelley

Databases – Infrastructure – Security

I received great news last week that one of my sessions, Windows Operating System Internals for DB Pros, was accepted,...

2012-02-21

855 reads

USB/Flash Drive Security

by Brian Kelley

Databases – Infrastructure – Security

Gone are the days when remote drives were easy to detect because there was some size to them. Nowadays USB...

2012-02-15 (first published: 2012-02-13)

2,210 reads

See You at SQL Saturday!

by Brian Kelley

Databases – Infrastructure – Security

I've been asked this question a few times, and Columbia, SC isn't hosting a SQL Saturday this year. Bobby Dimmick...

2012-02-13

1,174 reads

Discuss

Slides and Scripts from Idera February webcast

by Brian Kelley

Databases – Infrastructure – Security

For those who've asked, here are the slides and scripts from my SQL Server auditing webinar with Idera:

Presentation (.PDF)Scripts (.ZIP)
If...

2012-02-10

1,037 reads

Discuss

Blogs

The Benefits of Teaching

By Brian Kelley

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By DataOnWheels

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

The Book of Redgate: What Our Staff Says

This image is from 2010, and it goes along with my last post of...

Read the latest Blogs

Forums

Deny Connect problem

By Brandie Tarvin

I have a login I need to deny connect to on a server, but...

Website Stability 2025/12/05

By Steve Jones - SSC Editor

All week we've had issues with the site being up and down. There's been...

403 Forbidden

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers