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

Observe Carefully When Things Are Running Fine

by Brian Kelley

Databases – Infrastructure – Security

Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...

2013-01-14 (first published: 2013-01-10)

2,162 reads

Rename the SQL Server Management Studio shortcut

by Brian Kelley

Databases – Infrastructure – Security

Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...

2013-01-11

7,793 reads

Speaking at Midlands PASS in February

by Brian Kelley

Databases – Infrastructure – Security

On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...

2013-01-10

964 reads

Re-Awarded as a Microsoft MVP

by Brian Kelley

Databases – Infrastructure – Security

Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....

2013-01-02

1,199 reads

Looking Forward to the New Year - Professional Goals

by Brian Kelley

Databases – Infrastructure – Security

Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....

2013-01-01

1,311 reads

Are You a Chessplayer?

by Brian Kelley

Databases – Infrastructure – Security

I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...

2012-12-17

1,037 reads

Are Your Protecting Your DB Backups?

by Brian Kelley

Databases – Infrastructure – Security

Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...

2012-11-27

3,168 reads

Server Level Security

by Brian Kelley

Databases – Infrastructure – Security

We'll discuss surface area later in the week. Today let's talk about if you're able to connect to SQL Server....

2012-11-09 (first published: 2012-11-06)

3,426 reads

SQL Server Security: The Sum of Its Parts

by Brian Kelley

Databases – Infrastructure – Security

When it comes to attacking SQL Server, whether we're talking about the security of an installation or as a piece...

2012-11-05

1,468 reads

Preparing for Certification

by Brian Kelley

Databases – Infrastructure – Security

One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...

2012-10-22

1,358 reads

Blogs

Day of Data Baton Rouge Slides and Code

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

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

Read the latest Blogs

Forums

ALAMAT BANK BCA KCU TARAKAN TLP/WA 08218200203

Hub Cs:08218200203 Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan,...

Alamat Bank BCA KCU BALIKPAPAN Telp 08218200203

Hub.Via,WhatsApp:08218200203 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...

Alamat Bank BCA KCU PALANGKARAYA Telp 08218200203

By layanan_Bca88

Hub.Via,WhatsApp:08218200203 Jl. Jend. A. Yani No.47, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan Tengah...

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