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

Setting Realistic Goals & Learning to Adjust

by Brian Kelley

Databases – Infrastructure – Security

There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I...

2009-08-31

2,028 reads

Quick 2005/2008 Script to Export Permissions

by Brian Kelley

Databases – Infrastructure – Security

I had a need to export permissions to be run against the database once an older version was restored (but which didn't...

2009-08-28

13,579 reads

PASS Board of Directors Call for Nominations

by Brian Kelley

Databases – Infrastructure – Security

This is just a reminder that the call for nominations for the PASS Boards of Directors is open. The final...

2009-08-24

916 reads

The Need for a College Degree

by Brian Kelley

Databases – Infrastructure – Security

I'm reading through Brad McGehee'sHow to Be an Exceptional DBAand in chapter 4 he talks about having the right skill...

2009-08-24

2,426 reads

Keeping SQL Server Client Tools Up-to-Date

by Brian Kelley

Databases – Infrastructure – Security

In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...

2009-08-21

1,412 reads

Half-Way Through My Year as a Microsoft MVP

by Brian Kelley

Databases – Infrastructure – Security

I meant to write this earlier, like in July, but I suppose it's better late than never. I'm halfway through...

2009-08-18

1,313 reads

SQL Quiz #5

by Brian Kelley

Databases – Infrastructure – Security

Another SQL Quiz started by His Evilness, Chris Shaw. Okay, Chris isn't evil; I just wanted to say "evilness" and these quizzes...

2009-08-17

2,546 reads

"Just smile and wave, boys. Smile and wave."

by Brian Kelley

Databases – Infrastructure – Security

If you're not familiar with the reference, it comes from the movie Madagascar and the subsequent sequel and TV series...

2009-08-13

13,767 reads

Getting Security Vulnerability Information

by Brian Kelley

Databases – Infrastructure – Security

Staying abreast of security vulnerability alerts can be a daunting task because there are so many each day. One source...

2009-08-12

1,161 reads

Security is a Zero-Sum Game...

by Brian Kelley

Databases – Infrastructure – Security

but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...

2009-08-11

708 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