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

Re-Focusing the Blog a Bit

by Brian Kelley

Databases – Infrastructure – Security

In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...

2011-06-01

736 reads

Project Management: Dedicated vs. Shared Resources

by Brian Kelley

Databases – Infrastructure – Security

As an infrastructure type person, I typically represent a "shared" resource. What that means is I'm not dedicated to just...

2011-05-13

18,850 reads

You Are Responsible for You

by Brian Kelley

Databases – Infrastructure – Security

Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...

2011-05-12

735 reads

Dealing with Frustration in the Workplace

by Brian Kelley

Databases – Infrastructure – Security

Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...

2011-05-11

3,031 reads

Vote for My PASS Summit Sessions

by Brian Kelley

Databases – Infrastructure – Security

Yes, this is absolutely a shameless post for self-promotion. However, since potential attendees get to offer input into what sessions...

2011-05-11

956 reads

Know Your Limits

by Brian Kelley

Databases – Infrastructure – Security

A little over a week ago I roughed up my back moving sound equipment after a ministry event. I have...

2011-05-10

1,711 reads

I Won't Be at SQL Rally

by Brian Kelley

Databases – Infrastructure – Security

I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...

2011-05-05

863 reads

My PASS Summit Submissions

by Brian Kelley

Databases – Infrastructure – Security

Following Andy Leonard's (blog | twitter) footsteps, here are my PASS Summit submissions. I decided to go a little different this...

2011-05-05

788 reads

Outlook Productivity Tricks

by Brian Kelley

Databases – Infrastructure – Security

I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...

2011-05-05

2,103 reads

Writing Better Emails

by Brian Kelley

Databases – Infrastructure – Security

In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...

2011-05-04

2,929 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

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

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

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