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

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,734 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

862 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

731 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,378 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,916 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

889 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,669 reads

SQL University: Diving into Authorization

by Brian Kelley

Databases – Infrastructure – Security

It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on...

2009-10-27

6,139 reads

SQL University: Authentication and Authorization

by Brian Kelley

Databases – Infrastructure – Security

Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...

2009-10-25

10,867 reads

Another Year, Another Missed PASS Summit

by Brian Kelley

Databases – Infrastructure – Security

This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...

2009-10-23

1,666 reads

Blogs

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...

Advice I Like: Art

Superheroes and saints never make art. Only imperfect beings can make art because art...

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