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

Why Anti-Virus Offers Limited Protection

by Brian Kelley

Databases – Infrastructure – Security

Sitting in the first Keynote for the 2013 Techno Security and Forensics Investigation Conference, I was not surprised to hear Kevin...

2013-06-06

1,497 reads

From the 2013 Techno Security Conference - Cloud Computing and Digital Forensics

by Brian Kelley

Databases – Infrastructure – Security

I'm processing through my notes for the 2013 Techno Security Conference, which is finishing up today with post-cons. Of all...

2013-06-05

1,163 reads

Notes from 2013 Techno Security Conference Tuesday Keynote

by Brian Kelley

Databases – Infrastructure – Security

There's enough from this morning's 2013 Techno Security and Forensics Investigation Conference to split into multiple blog posts. I'll focus this...

2013-06-04

1,160 reads

SQL Server security webinar series is coming soon!

by Brian Kelley

Databases – Infrastructure – Security

I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All...

2013-06-04 (first published: 2013-05-30)

2,542 reads

Notes from the First Day of the 2013 Techno Security Conference

by Brian Kelley

Databases – Infrastructure – Security

The Techno Security & Forensics Security Conference is held in conjunction with the Mobile Forensic Conference each year in Myrtle Beach,...

2013-06-03

1,188 reads

SQL Saturday Charleston!

by Brian Kelley

Databases – Infrastructure – Security

Finally.... SQL Saturday has come back to... South Carolina! (with apologies to The Rock)

After the last SQL Saturday in Columbia,...

2013-05-30

1,910 reads

Security and SSIS webinar recording available

by Brian Kelley

Databases – Infrastructure – Security

If you missed the webinar Andy Leonard (blog | twitter) and I presented today or you had technical difficulties, here's the...

2013-05-29

949 reads

SSIS Security Presentation today, May 29th

by Brian Kelley

Databases – Infrastructure – Security

Andy Leonard (blog | twitter) and I are teaming up to do a security presentation today on SSIS. It's scheduled for 11 AM...

2013-05-29

841 reads

You Must Cross Teams for Sound Security

by Brian Kelley

Databases – Infrastructure – Security

I've given a couple of security presentations recently where I talked about how you must keep track of how security...

2013-05-29

1,076 reads

DR planning article up at MSSQLTips!

by Brian Kelley

Databases – Infrastructure – Security

My latest article is up at MSSQLTips.com:

Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right

For more of...

2013-05-23

847 reads

Blogs

T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?

The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...

Monday Monitor Tips: Configuring Access to the MCP Server

I have been experimenting with MCP servers in a few ways, including the Redgate...

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

Read the latest Blogs

Forums

Admin Rights for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Admin Rights for Everyone

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

By Arvind Toorpu

Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...

RegEx Functions I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions I

Visit the forum

Question of the Day

RegEx Functions I

Which of these RegEx functions need compatibility level 170 in SQL Server 2025?

See possible answers