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

792 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

617 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

923 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

690 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

866 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,198 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,622 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,575 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,681 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,468 reads

Blogs

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

What Does It Mean to Make Data AI-Ready?

Making Data AI-Ready, Part 1 (This is the first article in a three-part series...

Using the Data API Builder–VS Live San Diego Resources

Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...

Read the latest Blogs

Forums

Hyperscale Replicas II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas II

Practical Reporting Queries with CROSS APPLY (Part 3)

Comments posted to this topic are about the item Practical Reporting Queries with CROSS...

Your Favorite Quotes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Your Favorite Quotes

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers