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

Update Your Audit Queries for SQL Server

by Brian Kelley

Databases – Infrastructure – Security

I was working with an auditor today who is working through a system with an external audit agency. The external...

2013-06-13

2,130 reads

Personally Identifiable Information (PII) and Data Encryption

by Brian Kelley

Databases – Infrastructure – Security

Hitting close to home, SC Governor Nikki Haley noted that after the SC Department of Revenue breach was reported, that the IRS didn't...

2013-06-07

5,084 reads

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,493 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,159 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,157 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,541 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,186 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

948 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

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