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

Most humorous line I've read in a while

by Brian Kelley

Databases – Infrastructure – Security

This is from Michael Kaplan's blog over at MDSN. He was writing about the power outage that affected the Northwest...

2007-01-07

1,363 reads

Shared Items on Google Reader

by Brian Kelley

Databases – Infrastructure – Security

I read through a lot of blogs each day in a variety of technology categories. I've always fashioned myself as...

2007-01-06

1,368 reads

Midlands PASS January 2007 Meeting Minutes

by Brian Kelley

Databases – Infrastructure – Security

January 4,
2007 Meeting Minutes: Members in
Attendance: 15Next Meeting
Date: February 1, 2007 Job
Board: I had a consulting
firm contact me...

2007-01-05

1,698 reads

Midlands PASS Chapter Meeting for January

by Brian Kelley

Databases – Infrastructure – Security

Our next meeting will be
on Thursday, January 4, 2007, at 6:30 PM. It'll be at the Training Concepts
facility...

2006-12-29

1,510 reads

Setting Goals for the New Year and Beyond

by Brian Kelley

Databases – Infrastructure – Security

I've never been a big fan of "New Year's Resolutions" for the same reason most other folks are against them:...

2006-12-29

1,601 reads

How to handle an invalid default database

by Brian Kelley

Databases – Infrastructure – Security

My general recommendation for SQL Server service accounts and accounts that have sysadmin fixed server role membership is to default...

2006-12-11

1,906 reads

Midlands PASS Chapter is official

by Brian Kelley

Databases – Infrastructure – Security

A group of us met on Thursday, December 7th, 2006, and voted to approve the bylaws and a motion to...

2006-12-11

1,457 reads

Jason Haley recently began posting his interesting finds again

by Brian Kelley

Databases – Infrastructure – Security

Jason Haley used to post his Interesting Finds about every day, if not multiple times a day. The interesting finds...

2006-12-09

1,377 reads

SysInternals Tools Updated

by Brian Kelley

Databases – Infrastructure – Security

Several SysInternals Tools have been updated. One of the big updates was to the PSTools Suite - now you can pass...

2006-12-09

1,434 reads

Windows 2000 Resource Kit Tools Available

by Brian Kelley

Databases – Infrastructure – Security

If you're like me and rely a lot on the resource kit tools, you may have found that it's relatively...

2006-12-09

1,873 reads

Blogs

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

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

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