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

More on SQL Server Built-In Cryptography Options

by Brian Kelley

Databases – Infrastructure – Security

I wrote a series of articles at MSSQLTips.com to cover the cryptographic algorithms that are available with Microsoft SQL Server....

2013-08-02

854 reads

Thank you, Mr. Solomon

by Brian Kelley

Databases – Infrastructure – Security

On one of the newsgroups I follow, I received a message that David Solomon will no longer be teaching seminars...

2013-07-30

1,402 reads

Audio and slides are up for my webinar on SQL Server encryption

by Brian Kelley

Databases – Infrastructure – Security

The webinar audio and slides/demo scripts are up for the presentation I did for the PASS Security virtual chapter.

PASS Security...

2013-07-19

751 reads

Presenting for the new PASS Security Virtual Chapter on July 18

by Brian Kelley

Databases – Infrastructure – Security

The PASS Security virtual chapter is up and running thanks to the hard work of Argenis Fernandez (blog | twitter) and...

2013-07-17

1,268 reads

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,206 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,129 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

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers