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

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,067 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

839 reads

Giving an SSIS security webinar with Andy Leonard

by Brian Kelley

Databases – Infrastructure – Security

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

2013-05-23

1,036 reads

Do you check to see if an SSIS package has been modified?

by Brian Kelley

Databases – Infrastructure – Security

Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...

2013-05-22

2,709 reads

I'm thinking of hosting a series of webinars on SQL Server security

by Brian Kelley

Databases – Infrastructure – Security

With the PASS Summit sessions announced, I took a quick look to see how many were what I'd consider security-centric....

2013-05-22

2,828 reads

Speaking in Columbia and Charlotte Next Week

by Brian Kelley

Databases – Infrastructure – Security

I'm speaking at two user groups next week.

Tuesday - Midlands PASS - May 14
I'll be giving a presentation on PowerShell to help...

2013-05-10

1,034 reads

I'm Giving a SQL Server Security Webinar on May 9, 2013

by Brian Kelley

Databases – Infrastructure – Security

On May 9, 2013, at 3 PM EDT I will be presenting on 5 Steps Every DBA Should Take to...

2013-05-07

1,194 reads

2013 Carolina Code Camp Presentations

by Brian Kelley

Databases – Infrastructure – Security

As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...

2013-05-06

1,012 reads

Speaking at the 2013 Carolina Code Camp

by Brian Kelley

Databases – Infrastructure – Security

On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...

2013-04-23

881 reads

T-SQL Tuesday #41: How I Got My Start in Presenting

by Brian Kelley

Databases – Infrastructure – Security

For this month's T-SQL Tuesday, Bob challenges us to discuss how we came to love presenting. Here's my story.
I developed a...

2013-04-19 (first published: 2013-04-09)

1,959 reads

Blogs

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

If you've been here before, you know this blog is usually about SQL Server,...

Designing a Storage Load Test for SQL Server

By Anthony Nocentino

I’ve been doing storage load tests for SQL Server for a long time, both...

Questions and Answers from Running a Local LLM

I had a few random questions from my Running a Local LLM on Your...

Read the latest Blogs

Forums

A question about how to store the address in the database

I have an app that has an address field on the customer and the...

SSIS package failing intermittently on last Excel Component

Good Afternoon, I have a Job which "fires" off an SSIS package (that is...

T-SQL in SQL Server 2025: JSON_ARRAYAGG

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Multiple Sequence Values

How do I easily get the next 12 sequence values from a sequence object?

See possible answers