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

Tools: Apex SQL Log, Apex SQL Log API, Sample Corrupted Databases

by Brian Kelley

Databases – Infrastructure – Security

Apex SQL has announced a new version of Apex SQL Log as well as an API for it.
Release Notes...

2007-11-07

790 reads

SQL Server: Showing permissions for a given database user

by Brian Kelley

Databases – Infrastructure – Security

Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...

2007-11-06

611 reads

Becoming a DBA, Part II

by Brian Kelley

Databases – Infrastructure – Security

This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...

2007-11-05

918 reads

The Impact of Architecture/Design Choices

by Brian Kelley

Databases – Infrastructure – Security

I try my best to get things right the first time. So often, correcting a mistake or bad choice is...

2007-11-05

686 reads

Online Resource: Safari Tech Books Online

by Brian Kelley

Databases – Infrastructure – Security

I've used Safari (the O'Reilly version) for a number of years now and it is a resource I often recommend...

2007-11-02

863 reads

Why SQL Server 2005 Doesn't Permit Non-ANSI Style OUTER JOINs

by Brian Kelley

Databases – Infrastructure – Security

As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes...

2007-11-01

2,184 reads

Tool: KeePass Password Safe password manager/vault

by Brian Kelley

Databases – Infrastructure – Security

Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open...

2007-10-31

2,608 reads

SQL Server: Listing all the database roles for a given database user

by Brian Kelley

Databases – Infrastructure – Security

SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion,...

2007-10-30

2,569 reads

Becoming a DBA, Part I

by Brian Kelley

Databases – Infrastructure – Security

A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...

2007-10-29

1,676 reads

Structuring the Blog Better

by Brian Kelley

Databases – Infrastructure – Security

For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....

2007-10-28

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

ALAMAT BCA KCP Burangrang Telp:08218154393

WA:08218154393 Jl. Burangrang No.44, Burangrang, Kec. Lengkong, Kota Bandung, Jawa Barat 40262

ALAMAT KONTAK BCA KCP Bantul Telp:08218154393

WA:08218154393 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

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

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