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

How often do you check email?

by Brian Kelley

Databases – Infrastructure – Security

If you read the experts, most folks check their emails too many times during the day. Today, while giving a...

2011-05-03

796 reads

Love What You Do

by Brian Kelley

Databases – Infrastructure – Security

I've been dealing with illness the last few weeks, probably due to the rather heavy pollen season here in South...

2011-04-29

1,551 reads

SQL University: Who has access to my SQL Server?

by Brian Kelley

Databases – Infrastructure – Security

Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...

2011-04-26

2,799 reads

If a web page asks you to update Adobe Flash Player

by Brian Kelley

Databases – Infrastructure – Security

You don't want to do so from that web page. Instead you want to go to the Adobe web site...

2011-04-22

1,139 reads

Why having two accounts is a good thing

by Brian Kelley

Databases – Infrastructure – Security

Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...

2011-04-22

708 reads

Evaluating my SQL Connection Scores

by Brian Kelley

Databases – Infrastructure – Security

This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...

2011-04-20

1,490 reads

Cain does LSA Secrets dump on Vista and higher now

by Brian Kelley

Databases – Infrastructure – Security

Since going back to being a senior DBA, I've not stayed on top of the latest tools like I did...

2011-04-19

2,085 reads

"What's the point?"

by Brian Kelley

Databases – Infrastructure – Security

This is a crucial question with regards to what needs to be done. It really hit home after listening to...

2011-04-18

810 reads

It's not about whether you're a consultant or full-time staff...

by Brian Kelley

Databases – Infrastructure – Security

There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...

2011-04-12

1,343 reads

An Appeal to Those Writing Training Documentation and Labs

by Brian Kelley

Databases – Infrastructure – Security

I'm coming to the end of a week of training in a Microsoft Official Curriculum (MOC) Course. I should expect...

2011-04-08

939 reads

Blogs

SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library

By MarlonRibunal

I built a free library of runnable SQL Server demos. Each reproduces a real...

Experimenting with CHOOSE: #SQLNewBlogger

I was looking over the CHOOSE() function while editing an article at SQL Server...

Fighting Procrastination?

By Brian Kelley

Here is another short video (~ 15 minutes). This is by the author of...

Read the latest Blogs

Forums

MERGE in a nested TRY/CATCH won't roll back

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

SQL Server 2025 Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Server-level Roles

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers