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

All authors

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,677 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,151 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,879 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,668 reads

Habits and Activities for De-Stressing

by Brian Kelley

Databases – Infrastructure – Security

I was chatting on FaceBook today with a guy from my church who is learning to be a network engineer. He's...

2009-10-22

929 reads

Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

by Brian Kelley

SQLServerCentral.com

SQL Server Express has the same code base as the rest of the versions of SQL Server, but there are some differences in how to set it up and configure various tasks. MVP Brian Kelley shows us how to enable the Dedicated Administrator Connection.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(13)

You rated this post out of 5. Change rating

2009-10-21

6,014 reads

Discuss

Review: ASUS Eee PC 1005HA Netbook

by Brian Kelley

Databases – Infrastructure – Security

Our home desktop was several years old and due for replacement. I still have my Dell laptop, and it's still more than...

2009-10-19

2,254 reads

Vetting the PASS Board of Directors candidates

by Brian Kelley

Databases – Infrastructure – Security

I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...

2009-10-16

1,362 reads

Are you sticking to your goals? Do you know what they are?

by Brian Kelley

Databases – Infrastructure – Security

I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back...

2009-10-15

1,195 reads

Weak Passwords Discovered in the 10,000 Disclosed Hotmail/Live.com/MSN leaked accounts

by Brian Kelley

SQLServerCentral.com

Blogs

By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-10-13

3,534 reads

All authors

Brian Kelley

SQL University: Multiple Paths and Ownership Chaining

SQL University: Diving into Authorization

SQL University: Authentication and Authorization

Another Year, Another Missed PASS Summit

Habits and Activities for De-Stressing

Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

Review: ASUS Eee PC 1005HA Netbook

Vetting the PASS Board of Directors candidates

Are you sticking to your goals? Do you know what they are?

Weak Passwords Discovered in the 10,000 Disclosed Hotmail/Live.com/MSN leaked accounts

Blogs

What Does It Mean to Make Data AI-Ready?

Using the Data API Builder–VS Live San Diego Resources

Running a Local LLM On Your Laptop Resources

Forums

Hyperscale Replicas II

Practical Reporting Queries with CROSS APPLY (Part 3)

Your Favorite Quotes

Question of the Day

Hyperscale Replicas II