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

The Reason I Won't Be at the PASS Summit This Year

by Brian Kelley

Databases – Infrastructure – Security

We welcomed daughter #3 and child #5 into this world on Saturday at 9:43 AM. She came a bit earlier...

2012-09-24

1,478 reads

PASS ProfDev VC presentation recording available

by Brian Kelley

Databases – Infrastructure – Security

Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...

2012-09-10

1,131 reads

An important query to remember

by Brian Kelley

Databases – Infrastructure – Security

This is based on a post with respect to where our focus and efforts should be that I wrote at...

2012-08-30

1,863 reads

Resources for Those Dealing with Security Patches

by Brian Kelley

Databases – Infrastructure – Security

It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...

2012-08-24 (first published: 2012-08-21)

2,576 reads

Don't Disconnect Your Common Sense

by Brian Kelley

Databases – Infrastructure – Security

This falls in line with a previous post about common sense in IT.
I was having lunch with a co-worker,...

2012-08-23

1,746 reads

Rant: Applying Common Sense in IT

by Brian Kelley

Databases – Infrastructure – Security

I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...

2012-08-23 (first published: 2012-08-17)

4,602 reads

Delaying AV Definitions?

by Brian Kelley

Databases – Infrastructure – Security

Auto-deploying AV definitions has become common place throughout the industry. However, this post from the SANS Internet Storm Center raises the...

2012-08-21

1,276 reads

PowerShell Saturday in Charlotte, NC

by Brian Kelley

Databases – Infrastructure – Security

If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September...

2012-08-15

1,352 reads

Speaking Tomorrow for Professional Development VC

by Brian Kelley

Databases – Infrastructure – Security

As I blogged about previously, tomorrow (Wednesday) I will be speaking for the PASS Professional Development virtual chapter. My talk will...

2012-08-14

1,134 reads

Audit Yourself Regularly

by Brian Kelley

Databases – Infrastructure – Security

Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried...

2012-08-13

1,706 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