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

PASS Chapter Starting Up in Charleston, SC

by Brian Kelley

Databases – Infrastructure – Security

Woo hoo! Charleston, SC is starting up a Professional Association for SQL Server official chapter. It is being started up...

2009-09-14

1,092 reads

Remember the Milk: Smart Adds

by Brian Kelley

Databases – Infrastructure – Security

A while ago, Brent Ozar pointed me to Remember the Milk to help with task tracking. It's a web-based task...

2009-09-08

987 reads

Setting Realistic Goals & Learning to Adjust

by Brian Kelley

Databases – Infrastructure – Security

There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I...

2009-08-31

2,027 reads

Quick 2005/2008 Script to Export Permissions

by Brian Kelley

Databases – Infrastructure – Security

I had a need to export permissions to be run against the database once an older version was restored (but which didn't...

2009-08-28

13,578 reads

PASS Board of Directors Call for Nominations

by Brian Kelley

Databases – Infrastructure – Security

This is just a reminder that the call for nominations for the PASS Boards of Directors is open. The final...

2009-08-24

913 reads

The Need for a College Degree

by Brian Kelley

Databases – Infrastructure – Security

I'm reading through Brad McGehee'sHow to Be an Exceptional DBAand in chapter 4 he talks about having the right skill...

2009-08-24

2,425 reads

Keeping SQL Server Client Tools Up-to-Date

by Brian Kelley

Databases – Infrastructure – Security

In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...

2009-08-21

1,412 reads

Half-Way Through My Year as a Microsoft MVP

by Brian Kelley

Databases – Infrastructure – Security

I meant to write this earlier, like in July, but I suppose it's better late than never. I'm halfway through...

2009-08-18

1,312 reads

SQL Quiz #5

by Brian Kelley

Databases – Infrastructure – Security

Another SQL Quiz started by His Evilness, Chris Shaw. Okay, Chris isn't evil; I just wanted to say "evilness" and these quizzes...

2009-08-17

2,545 reads

"Just smile and wave, boys. Smile and wave."

by Brian Kelley

Databases – Infrastructure – Security

If you're not familiar with the reference, it comes from the movie Madagascar and the subsequent sequel and TV series...

2009-08-13

13,712 reads

Blogs

Data Céilí 2026 Call for Speakers!

By Andrew Pruski

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

Streamlining Azure VM Moves Into Availability Zones

One of the more frustrating aspects about creating an Azure virtual machine is that...

Monday Monitor Tips: Native Replication Monitoring

Redgate Monitor has been able to monitor replication for a long term, but it...

Read the latest Blogs

Forums

Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

Comments posted to this topic are about the item Think LSNs Are Unique? Think...

A Big PK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Big PK

The AI Bubble and the Weak Foundation Beam

Comments posted to this topic are about the item The AI Bubble and the...

Visit the forum

Question of the Day

A Big PK

In SQL Server 2025, how many columns can be included in a Primary Key constraint?

See possible answers