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

Dealing with Auditors: Password Settings

by Brian Kelley

Databases – Infrastructure – Security

Yet again I've seen an audit request where the auditor wants the DBA to show what SQL Server's settings are...

2013-06-19

8,059 reads

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,117 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,073 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,483 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,144 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,153 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,539 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,179 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,908 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

942 reads

Blogs

How to Run Databases on Kubernetes: An 8-Step Guide

By Ige Adetokunbo Temitayo

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Episode 11 of Simple Talks: Oracle

The 11th episode is now live, recorded a few weeks ago at the PASS...

A New Word: Mornden

mornden – n. the self-container pajama universe shared by two people on a long...

Read the latest Blogs

Forums

What is the best index strategy for a table that gets truncated?

Hi everyone My SSIS package does a bulk insert of csv files into a...

Blob Storage automated downloads

By Brandie Tarvin

Dipping my toes into the waters of Azure and of course before I get...

Announcing SQL Server 2025

By Press Release

Comments posted to this topic are about the item Announcing SQL Server 2025

Visit the forum

Question of the Day

Running Steve's Code

Can you run this code in any of your SQL Server 2019 databases without error?

CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
    
        SELECT Consumer_ID ,
               Trend_Category ,
               Bit_Trace
        FROM    NewWorldDB.dbo.MarketTrend;
    
GO

See possible answers