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

FUD Makes Security Harder

by Brian Kelley

Databases – Infrastructure – Security

The US government’s illogical screeds against better personal encryption for data and communications is well documented. Then comes this reported...

2014-11-20

687 reads

More on that Cyberwar

by Brian Kelley

Databases – Infrastructure – Security

As a follow-up to my post on being at war, cyberwar:
State Department Hacked
If the experts are correct, this trend is...

2014-11-18

585 reads

Generalists vs. Specialists

by Brian Kelley

Databases – Infrastructure – Security

I’ve stated quite often that being a generalist has generally been beneficial for my IT career (pun intended). That’s why...

2014-11-13 (first published: 2014-11-06)

7,238 reads

We’re at War – Cyberwar

by Brian Kelley

Databases – Infrastructure – Security

In case you’ve not been following the news with regards to *government* breaches:
White House computers hacked – Russia suspectedUS Postal Service...

2014-11-13

759 reads

Speaking at SQL Saturday #354 – Charleston, SC

by Brian Kelley

Databases – Infrastructure – Security

If you’re looking to warm up for the winter, come on down to Charleston, SC, on December 13, 2014. Charleston...

2014-11-12

656 reads

Consolidating Email Accounts

by Brian Kelley

Databases – Infrastructure – Security

I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either...

2014-10-21

538 reads

SQL Server Security Benchmarks

by Brian Kelley

Databases – Infrastructure – Security

If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...

2014-10-20

874 reads

#TSQL2sday #59 – My Heroes

by Brian Kelley

Databases – Infrastructure – Security

Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....

2014-10-14

550 reads

Slides and Code for SSIG Talk

by Brian Kelley

Databases – Infrastructure – Security

Thank you for those who made it out to the SQL Server Innovators Guild last night in Greenville, SC. I...

2014-10-08

608 reads

The Fallacy of Internal Access Only

by Brian Kelley

Databases – Infrastructure – Security

In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only...

2014-10-07 (first published: 2014-09-30)

7,118 reads

Blogs

Narrow Task Decomposition in AI Pipeline Agents

By Eduardo Pivaral

A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...

Car Update: August 2026

It’s been some time since I provided a car update, so I decided to...

Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To

An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...

Read the latest Blogs

Forums

Alamat BCA KCU Pantai Indah Kapuk Tlp:0817825533

By layanan_Bca88

Hub Via Wa:62817825533 Alamat: Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal...

Alamat Kantor BCA KCU Taman Duta Mas Tlp:0817825533

Hub Via Wa:62817825533 Alamat: ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, RT.14/RW.11,...

Alamat Kantor BCA KCU Tanjung Priok Tlp:0817825533

Hub Via Wa:62817825533 Alamat: Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt...

Visit the forum

Question of the Day

Backing Up a DMK

In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?

See possible answers