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

Looking to interact with those proficient in Japanese

by Brian Kelley

Databases – Infrastructure – Security

In the 1970s my mother and her younger sister married U.S. Marines. Both came to the States when their husbands...

2011-09-12

787 reads

Don't Wait to Start Blogging

by Brian Kelley

Databases – Infrastructure – Security

I was reading a post by Jonathan Fields (blog | twitter) about making bad guitars. Okay, so what does that have to...

2011-08-15

2,252 reads

Have the Time? Get in the Game.

by Brian Kelley

Databases – Infrastructure – Security

This year there's a two step process for electing members to the Professional Association for SQL Server (PASS) Board of Directors...

2011-08-11

883 reads

T-SQL Tuesday/Wednesday #21: A Crappy Workaround

by Brian Kelley

Databases – Infrastructure – Security

A long time ago (in IT terms) in a galaxy far, far away I was helping an organization with a...

2011-08-10

2,065 reads

Functionality and User Experience are important, too

by Brian Kelley

Databases – Infrastructure – Security

There are a few posts and articles around the security-scape lately concluding Windows 7 is more secure than OS X,...

2011-08-09

811 reads

Security Is Your Responsibility

by Brian Kelley

Databases – Infrastructure – Security

My primary responsibility at my organization is no longer to be the security architect and incident response team lead. I...

2011-08-08

950 reads

MSSQLTips.com Kindle Contest

by Brian Kelley

Databases – Infrastructure – Security

I'm always wary of contests to win free stuff, but the folks running MSSQLTips.com are legitimate (I write there as...

2011-08-04

1,043 reads

Rant: Security Isn't Sexy and It's a Shame

by Brian Kelley

Databases – Infrastructure – Security

I grew up immersed in security. My father was a US Marine and going on and off base meant... security....

2011-08-03

1,232 reads

Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings

by Brian Kelley

Databases – Infrastructure – Security

We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...

2011-08-02

15,668 reads

Bad Admins: Non-Production Servers

by Brian Kelley

Databases – Infrastructure – Security

This is part of a series of tips on how bad/rogue admins can get access to the data in your...

2011-07-28

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