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

Re-Focusing the Blog a Bit

by Brian Kelley

Databases – Infrastructure – Security

In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...

2011-06-01

752 reads

Project Management: Dedicated vs. Shared Resources

by Brian Kelley

Databases – Infrastructure – Security

As an infrastructure type person, I typically represent a "shared" resource. What that means is I'm not dedicated to just...

2011-05-13

18,955 reads

You Are Responsible for You

by Brian Kelley

Databases – Infrastructure – Security

Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...

2011-05-12

749 reads

Dealing with Frustration in the Workplace

by Brian Kelley

Databases – Infrastructure – Security

Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...

2011-05-11

3,041 reads

Vote for My PASS Summit Sessions

by Brian Kelley

Databases – Infrastructure – Security

Yes, this is absolutely a shameless post for self-promotion. However, since potential attendees get to offer input into what sessions...

2011-05-11

967 reads

Know Your Limits

by Brian Kelley

Databases – Infrastructure – Security

A little over a week ago I roughed up my back moving sound equipment after a ministry event. I have...

2011-05-10

1,724 reads

I Won't Be at SQL Rally

by Brian Kelley

Databases – Infrastructure – Security

I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...

2011-05-05

875 reads

My PASS Summit Submissions

by Brian Kelley

Databases – Infrastructure – Security

Following Andy Leonard's (blog | twitter) footsteps, here are my PASS Summit submissions. I decided to go a little different this...

2011-05-05

802 reads

Outlook Productivity Tricks

by Brian Kelley

Databases – Infrastructure – Security

I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...

2011-05-05

2,113 reads

Writing Better Emails

by Brian Kelley

Databases – Infrastructure – Security

In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...

2011-05-04

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