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

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,599 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,904 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,872 reads

Log Buffer #22: A Carnival of the Vanities for DBAs

by Brian Kelley

Databases – Infrastructure – Security

Welcome to the 22nd edition of Log Buffer, a
weekly compendium of postings and news from database-related blogs across the...

2006-12-08

1,600 reads

Extreme Work

by Brian Kelley

Databases – Infrastructure – Security

"The Productivity Pro" Laura Stack posted in her blog today about jobs where long hours are the norm:

'Extreme' jobs...

2006-12-05

1,485 reads

Guidance on Microsoft Certified Architect Submissions

by Brian Kelley

Databases – Infrastructure – Security

For those considering the Microsoft Certified Architect program, some guidance on what to submit as documentation has been posted to...

2006-12-05

1,460 reads

Excellent post on encryption

by Brian Kelley

Databases – Infrastructure – Security

Laurentiu Cristofor has an excellent blog post, Who needs encryption?, which presents some point blank facts about encryption and the...

2006-12-01

1,653 reads

Blogs

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By Anthony Nocentino

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

We are product focused at Redgate Software. Here is another of our values that...

KDA: Echoes of Deception - Case 7

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Read the latest Blogs

Forums

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server 2016 Plan

whats that ssis analyzer product that documents lineage

hi, a few years ago was at a very large company that bought a...

Implicit Conversions Cripple SQL Server

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)

What is returned?

See possible answers