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

Are Your Protecting Your DB Backups?

by Brian Kelley

Databases – Infrastructure – Security

Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...

2012-11-27

3,161 reads

Server Level Security

by Brian Kelley

Databases – Infrastructure – Security

We'll discuss surface area later in the week. Today let's talk about if you're able to connect to SQL Server....

2012-11-09 (first published: 2012-11-06)

3,426 reads

SQL Server Security: The Sum of Its Parts

by Brian Kelley

Databases – Infrastructure – Security

When it comes to attacking SQL Server, whether we're talking about the security of an installation or as a piece...

2012-11-05

1,464 reads

Preparing for Certification

by Brian Kelley

Databases – Infrastructure – Security

One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...

2012-10-22

1,348 reads

Microsoft Security Bulletin MS12-070 for SSRS

by Brian Kelley

Databases – Infrastructure – Security

Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...

2012-10-15 (first published: 2012-10-09)

4,293 reads

MS12-070 - Should I patch more than Reporting Services?

by Brian Kelley

Databases – Infrastructure – Security

If you're dealing with a version of SQL Server greater than SQL Server 2000, at this point I'm going to...

2012-10-11

1,980 reads

Slides and Scripts from Idera Auditing SQL Server presentation

by Brian Kelley

Databases – Infrastructure – Security

I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...

2012-10-10

1,564 reads

Kathi Kellenberger speaking at Midlands PASS

by Brian Kelley

Databases – Infrastructure – Security

On October 17th, Midlands PASS will welcome Kathi Kellenberger to speak on T-SQL 2012. Here's what her talk will be...

2012-10-05

1,087 reads

Webcast on SQL Server Auditing on October 9th

by Brian Kelley

Databases – Infrastructure – Security

Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...

2012-10-04

1,059 reads

Participate in the PASS Election Process

by Brian Kelley

Databases – Infrastructure – Security

Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...

2012-09-26

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