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

Read-Only Access to SQL Server Jobs

by Brian Kelley

Databases – Infrastructure – Security

This question comes up a lot: how do I give read-only access to job status to a group of people?...

2009-01-22

4,075 reads

What Do You Want Auditors to Know About Auditing SQL Server?

by Brian Kelley

Databases – Infrastructure – Security

Right now it looks like I'll be putting a training session on for my local ISACA chapter on SQL Server...

2009-01-22

1,105 reads

Video: xp_cmdshell execution in SQL Server 2005/2008

by Brian Kelley

Databases – Infrastructure – Security

The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...

2009-01-21

690 reads

Conficker / Downadup Worm One More Time

by Brian Kelley

Databases – Infrastructure – Security

Hopefully by now everyone has seen this, but if not, here's a reminder to continue to spread the details. Denis Gobo...

2009-01-20

922 reads

Fake LinkedIn profiles with links to malware

by Brian Kelley

Databases – Infrastructure – Security

This is a little old (five days based on the last update), but TrendMicro put on their blog about fake...

2009-01-20

932 reads

Have you disabled autoplay yet?

by Brian Kelley

Databases – Infrastructure – Security

If not, you should. Because autoplay being on means any time a removable data device, such as a USB stick,...

2009-01-15

756 reads

Microsoft Solution Accelerators on TechNet

by Brian Kelley

Databases – Infrastructure – Security

I was browsing through the new titles that are on Safari and saw some planning guides around Windows Server 2008...

2009-01-15

828 reads

More About Twitter

by Brian Kelley

Databases – Infrastructure – Security

I've mentioned before that I was on Twitter and I know that for some the question is still out on...

2009-01-12

928 reads

MySQL GUI Tools

by Brian Kelley

Databases – Infrastructure – Security

This came up on Twitter today. I have a search set for "SQL Server" and it pulled up someone who...

2009-01-09

952 reads

Windows Server 2008 R2 Core supports SQL Server

by Brian Kelley

Databases – Infrastructure – Security

First saw this because Jason Massietwittered about it. But apparently there are enough bits of the .NET Framework in R2...

2009-01-09

1,272 reads

Blogs

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By Mala Mahadevan

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

Read the latest Blogs

Forums

Training the next generation

Comments posted to this topic are about the item Training the next generation

Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)

Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...

PostgreSQL psql Meta Commands: Databases

By Grant Fritchey

Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Databases

Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?

See possible answers