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

SANS Stay Sharp Course - SEC351: Computer and Network Security Awareness

by Brian Kelley

Databases – Infrastructure – Security

A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...

2006-06-21

2,153 reads

Whitepaper: SQL Server 2005 Physical Database Storage Design

by Brian Kelley

Databases – Infrastructure – Security

Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...

2006-06-15

2,061 reads

Distributing Database Connection Strings Using Active Directory Group Policy

by Brian Kelley

Databases – Infrastructure – Security

I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...

2006-06-13

2,333 reads

TechEd - DATTLC01 : Troubleshooting Performance Problems in SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...

2006-06-12

1,583 reads

In Boston for TechEd

by Brian Kelley

Databases – Infrastructure – Security

This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...

2006-06-11

1,494 reads

Two things I wish they'd change about endpoints in SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...

2006-05-27

2,148 reads

When It Takes Time...

by Brian Kelley

Databases – Infrastructure – Security

Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:

Project Managing Latency or: How to...

2006-05-25

1,452 reads

Disaster Recovery and SQL Server, Part II

by Brian Kelley

Databases – Infrastructure – Security

In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...

2006-05-24

1,503 reads

SQL Prompt

by Brian Kelley

Databases – Infrastructure – Security

I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...

2006-05-23

1,623 reads

Disaster Recovery and SQL Server, Part I

by Brian Kelley

Databases – Infrastructure – Security

The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...

2006-05-20

1,655 reads

Blogs

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...

SQL Server Security Hardening Guide Using the DoD STIG Checklist

By MarlonRibunal

Security on your SQL Server is important. That doesn’t need any explaining. But where...

EightKB 2026: Registration is Open!

By Anthony Nocentino

It’s that time of year again! EightKB is back on August 20th at 13:00...

Read the latest Blogs

Forums

Backing Up a DMK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing Up a DMK

The Quiet Part

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Quiet Part

BIT_COUNT in SQL Server

Comments posted to this topic are about the item BIT_COUNT in SQL Server

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