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

One Week from SQLRally!

by Brian Kelley

Databases – Infrastructure – Security

SQLRally is a week away (pre-cons start on Tuesday, conference starts on Thursday). I have the privilege of two sessions to...

2012-05-02

847 reads

Updated Thoughts on Antivirus on SQL Servers

by Brian Kelley

Databases – Infrastructure – Security

I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...

2012-04-30 (first published: 2012-04-24)

5,828 reads

Tribal knowledge is no knowledge

by Brian Kelley

Databases – Infrastructure – Security

I've run across several incidents in the last couple of months regarding something that is typically called "tribal knowledge." This is...

2012-04-19 (first published: 2012-04-12)

1,302 reads

Professional Productivity Books

by Brian Kelley

Databases – Infrastructure – Security

Just as with the "soft skills" books, in my professional development presentation, I list the professional productivity books that I have found most helpful in my...

2012-04-18

912 reads

"Soft Skills" books

by Brian Kelley

Databases – Infrastructure – Security

In my professional development presentation, I list the "soft skills" books that I have found most helpful in my career to date. You can find...

2012-04-16

1,581 reads

Re-thinking security for customer service

by Brian Kelley

Databases – Infrastructure – Security

This morning my son woke up to find his eBook reader frozen. It wouldn't unlock. It was fully charged (the...

2012-04-12

1,262 reads

Why an employer should never ask about accessing your Facebook page

by Brian Kelley

Databases – Infrastructure – Security

There's a brilliant piece of work posted as a fictitious resignation letter that gives some scenarios as to why an employer could...

2012-04-03

1,349 reads

Why you can't provide your Facebook credentials

by Brian Kelley

Databases – Infrastructure – Security

I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...

2012-04-02

2,389 reads

T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It

by Brian Kelley

Databases – Infrastructure – Security

If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?

Being a specialist means you're...

2012-03-13

1,458 reads

SQL Saturday #110 - Tampa - The Dirty Business of Auditing Presentation Materials

by Brian Kelley

Databases – Infrastructure – Security

For those who might want the materials for my presentation at SQL Saturday #110, I've posted them to the site.

SQL...

2012-03-10

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