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

Bad Admins: Stealing the SQL Server Service Account

by Brian Kelley

Databases – Infrastructure – Security

This is part of a series of tips on how bad/rogue admins can get access to the data in your...

2011-07-22

1,368 reads

Bad Admins: Pocketing Backups

by Brian Kelley

Databases – Infrastructure – Security

This is part of a series of tips on how bad/rogue admins can get access to the data in your...

2011-07-21

728 reads

Gaining Speaker Experience Credentials, Part II

by Brian Kelley

Databases – Infrastructure – Security

In a previous post I gave suggestions on how to get speaking credentials for consideration at a larger event, such...

2011-07-21

939 reads

Bad Admins: Stealing An Account

by Brian Kelley

Databases – Infrastructure – Security

Yesterday I posted about manipulating group membership to get access to a SQL Server. Today comes attack vector #2: stealing an...

2011-07-14

1,188 reads

Bad Admins: Attacking via Group Membership

by Brian Kelley

Databases – Infrastructure – Security

This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...

2011-07-13

1,869 reads

Gaining Speaker Experience Credentials

by Brian Kelley

Databases – Infrastructure – Security

One of the things I saw on Twitter yesterday was several folks saying their abstract submissions had been turned down...

2011-06-16

1,884 reads

Speaking at the 2011 PASS Summit

by Brian Kelley

Databases – Infrastructure – Security

The emails came in today and 2 out of 4 of my sessions were selected. Both are the ones I...

2011-06-15

889 reads

Planning Your Upgrade Well

by Brian Kelley

Databases – Infrastructure – Security

Yesterday I talked about the importance of having a tested business recovery plan. If you didn't read yesterday's post, the...

2011-06-07

965 reads

The Importance of a Business Recovery Plan

by Brian Kelley

Databases – Infrastructure – Security

Recently I was in one of those chain restaurants (the middle-priced, sit-down types) and shortly after we got there, we...

2011-06-06

1,890 reads

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

731 reads

Blogs

A Small LLM Fail

Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By Peter Skoglund

Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

I hosted this month, late as it turns out, but we still had a...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?)

By Eric M Russell

We have an issue where SSIS packages are failing with a status of "ended...

SQL Newbie HELP: The query references an object that is not supported in distr..

Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers