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

Raising a Technology Savvy Daughter

by Brian Kelley

Databases – Infrastructure – Security

I was introduced to electronics at a very young age. I think I was three when I first started doing...

2009-11-23

711 reads

Should DBAs have local administrator rights?

by Brian Kelley

Databases – Infrastructure – Security

This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...

2009-11-20

14,009 reads

Why We Recommend Against xp_cmdshell

by Brian Kelley

Databases – Infrastructure – Security

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...

2009-11-13

21,109 reads

SQL Server Wish: Last Logon Information

by Brian Kelley

Databases – Infrastructure – Security

The other day my wife and I were driving around and noticed that a Little Caesar's location had shown up...

2009-11-10

8,739 reads

Always Striving to Improve

by Brian Kelley

Databases – Infrastructure – Security

I'm enjoying a relaxing Saturday morning and I'm doing a bit of reading on ESPN. I see the article about...

2009-11-07

863 reads

OFF-TOPIC: Surviving, Missing Folks, Glad I'm Home

by Brian Kelley

Databases – Infrastructure – Security

I certainly wish circumstances were different and I would have been able to attend the PASS Summit this week. I...

2009-11-06

732 reads

Not Attending/Presenting at SQL Connections

by Brian Kelley

Databases – Infrastructure – Security

Given everything that has happened in the last couple of weeks, this is not surprising to those who have kept...

2009-10-31

1,379 reads

OFF-TOPIC: God is Still Good, Even as We Mourn

by Brian Kelley

Databases – Infrastructure – Security

Kimberly and I went to the high risk doctor's office this morning for the ultrasound. Unfortunately, they realized very quickly...

2009-10-30

1,919 reads

OFF-TOPIC: More about the pregnancy

by Brian Kelley

Databases – Infrastructure – Security

Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private....

2009-10-29

891 reads

SQL University: Multiple Paths and Ownership Chaining

by Brian Kelley

Databases – Infrastructure – Security

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...

2009-10-29

2,671 reads

Blogs

How to Find Expensive Queries in Amazon Redshift

By Eduardo Pivaral

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

If you've been here before, you know this blog is usually about SQL Server,...

Designing a Storage Load Test for SQL Server

By Anthony Nocentino

I’ve been doing storage load tests for SQL Server for a long time, both...

Read the latest Blogs

Forums

How Long is a Long I/O?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Long is a Long...

T-SQL Trigonometric Functions in SQL Server

Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...

Half of All Engineers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Half of All Engineers

Visit the forum

Question of the Day

How Long is a Long I/O?

In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?

See possible answers