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

Professional Goals for 2009

by Brian Kelley

Databases – Infrastructure – Security

Every time management / professional development book out there tells one to not only develop goals but actually write them down. That's...

2009-02-06

1,227 reads

Speaking / Teaching Engagements

by Brian Kelley

Databases – Infrastructure – Security

I should have put this out earlier, before going to the SQL Server Innovators Guild, but I got too busy....

2009-02-06

692 reads

SQL Server security bulletin due on Tuesday

by Brian Kelley

Databases – Infrastructure – Security

As part of its advance notification, Microsoft has released the list of security bulletins that should be coming our way...

2009-02-05

829 reads

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,052 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,100 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

686 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

909 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

918 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

748 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

815 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers