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

All authors

When It’s No Longer Viable

by Brian Kelley

Databases – Infrastructure – Security

Sometimes a solution is no longer viable because there isn’t a path forward and sometimes a solution isn’t viable because there are better options out there from the organization’s...

2024-10-09

When It’s Still Viable

by Brian Kelley

Databases – Infrastructure – Security

If a technology is still viable, don’t overlook it. Don’t get caught up chasing the “shiny” or the “perfect” solution just because you can.

2024-10-08

A word on misogyny/sexism in cybersecurity/IT

by Brian Kelley

Databases – Infrastructure – Security

Recently, on a post celebrating a female professional earning a significant achievement within the cybersecurity field, another individual (male) commented wondering if this was due to DEI. The one...

2024-09-24

Reducing Meetings and Making Them More Productive

by Brian Kelley

Databases – Infrastructure – Security

I’m sick of meetings and I know many other folks are, too. Every time a knowledge worker (such as IT or cybersecurity but also business) has to go to...

2024-08-09

A word about IT/cybersecurity and mental health

by Brian Kelley

Databases – Infrastructure – Security

Just as it's important to take care of our physical health (and I'm guilty of neglecting that), it is important to take care of our mental health, too. Also,...

2024-05-20

T-SQL Tuesday #174: Job Interview Questions

by Brian Kelley

Databases – Infrastructure – Security

Once upon a time, I used to think of difficult technical questions to ask candidates for a DBA position. However, over time I came to understand that in most...

2024-05-14

Friday Basics: RPO and RTO

by Brian Kelley

Databases – Infrastructure – Security

I did a post last month titled RTO and RPO are myths unless you've tested recovery, but I only briefly covered what RPO and RTO are. This post goes...

2024-05-10

Non-Functional Requirements

by Brian Kelley

Databases – Infrastructure – Security

I have found that non-functional requirements (NFRs) can be hard to define for a given solution. I’ve seen teams struggle with NFRs. However, to ensure I’m speaking the same...

2024-05-08

Attacking the Weakest Link

by Brian Kelley

Databases – Infrastructure – Security

When I look at a system and think about its security model, the first thing I start poking around at is where I think security is weakest. For instance,...

2024-05-06

Friday Basics: Authentication vs. Authorization

by Brian Kelley

Databases – Infrastructure – Security

Another security fundamentals topic is authentication versus authorization. For those who have a clear understanding of the difference between the two, like with Recovery Point Objective (RPO) vs. Recovery...

2024-05-03

All authors

Brian Kelley

When It’s No Longer Viable

When It’s Still Viable

A word on misogyny/sexism in cybersecurity/IT

Reducing Meetings and Making Them More Productive

A word about IT/cybersecurity and mental health

T-SQL Tuesday #174: Job Interview Questions

Friday Basics: RPO and RTO

Non-Functional Requirements

Attacking the Weakest Link

Friday Basics: Authentication vs. Authorization

Blogs

What do client diagnostics in Cosmos DB mean?

Adding Row Numbers to a Query: #SQLNewBlogger

Adding Row Numbers to a Query: #SQLNewBlogger

Forums

7 sept, scheduled book

7 sept, schedlued article

6 sept, published book

Question of the Day

Azure Data Lake Storage Gen 2