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

SQL Saturday #354 – Charleston, SC is almost here!

by Brian Kelley

Databases – Infrastructure – Security

If you are relatively near to Charleston, SC, there’s a SQL Saturday there this weekend, December 13th!
SQL Saturday #354 – Charleston,...

2014-12-09

462 reads

FUD Makes Security Harder

by Brian Kelley

Databases – Infrastructure – Security

The US government’s illogical screeds against better personal encryption for data and communications is well documented. Then comes this reported...

2014-11-20

683 reads

More on that Cyberwar

by Brian Kelley

Databases – Infrastructure – Security

As a follow-up to my post on being at war, cyberwar:
State Department Hacked
If the experts are correct, this trend is...

2014-11-18

578 reads

Generalists vs. Specialists

by Brian Kelley

Databases – Infrastructure – Security

I’ve stated quite often that being a generalist has generally been beneficial for my IT career (pun intended). That’s why...

2014-11-13 (first published: 2014-11-06)

7,237 reads

We’re at War – Cyberwar

by Brian Kelley

Databases – Infrastructure – Security

In case you’ve not been following the news with regards to *government* breaches:
White House computers hacked – Russia suspectedUS Postal Service...

2014-11-13

752 reads

Speaking at SQL Saturday #354 – Charleston, SC

by Brian Kelley

Databases – Infrastructure – Security

If you’re looking to warm up for the winter, come on down to Charleston, SC, on December 13, 2014. Charleston...

2014-11-12

647 reads

Consolidating Email Accounts

by Brian Kelley

Databases – Infrastructure – Security

I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either...

2014-10-21

528 reads

SQL Server Security Benchmarks

by Brian Kelley

Databases – Infrastructure – Security

If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...

2014-10-20

868 reads

#TSQL2sday #59 – My Heroes

by Brian Kelley

Databases – Infrastructure – Security

Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....

2014-10-14

542 reads

Slides and Code for SSIG Talk

by Brian Kelley

Databases – Infrastructure – Security

Thank you for those who made it out to the SQL Server Innovators Guild last night in Greenville, SC. I...

2014-10-08

601 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