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

SysInternals now on Microsoft TechNet

by Brian Kelley

Databases – Infrastructure – Security

It wasn't too long ago that Mark Russinovich announced he was becoming a Microsoft employee (new link as his old...

2006-11-27

1,692 reads

NGSSoftware compares Oracle and SQL Server security

by Brian Kelley

Databases – Infrastructure – Security

I first saw this at SQL Server MVP Jasper Smith's blog post Which database is more secure? Oracle vs. Microsoft:

NGSSoftware...

2006-11-25

1,705 reads

Teaching Children to Program

by Brian Kelley

Databases – Infrastructure – Security

One of the blogs I follow is Andrew Coates' blog over at MSDN. He has posted about starting to help...

2006-11-21

1,458 reads

Mixed Feelings about the SQL Server Central Sale to Red Gate

by Brian Kelley

Databases – Infrastructure – Security

I've read numerous posts and several blogs discussing the SQL Server Central sale to Red Gate and at the end...

2006-11-20

1,636 reads

SQL Server 2005 SP2 CTP Available for Download

by Brian Kelley

Databases – Infrastructure – Security

The Community Technology Preview (CTP) version SQL Server 2005 SP2 has been released by Microsoft. You can find the download...

2006-11-08

1,978 reads

Chess

by Brian Kelley

Databases – Infrastructure – Security

Recently I started getting back into the game of chess as I began coaching my boys. Chess is a great...

2006-11-02

1,687 reads

Picking back up on blogging

by Brian Kelley

Databases – Infrastructure – Security

It has been a trying month to month and a half with the implementation of Microsoft's CRM 3.0 product. By...

2006-10-30

1,383 reads

Diversions

by Brian Kelley

Databases – Infrastructure – Security

I've been rather quiet for a while and there's a reason. I've been
helping some friends get a general gaming site...

2006-09-22

1,513 reads

SQL Server 2005 Scripts on TechNet

by Brian Kelley

Databases – Infrastructure – Security

I've not been posting over the last week because I'm in the midst of a
two week vacation, the first I've...

2006-09-01

1,459 reads

Removing SQL Server Express from VS Team System for Database Professionals CTP 5

by Brian Kelley

Databases – Infrastructure – Security

As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out,
if you don't already...

2006-08-24

1,386 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