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

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

903 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,421 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,407 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,309 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,538 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,692 reads

Getting Security Vulnerability Information

by Brian Kelley

Databases – Infrastructure – Security

Staying abreast of security vulnerability alerts can be a daunting task because there are so many each day. One source...

2009-08-12

1,157 reads

Security is a Zero-Sum Game...

by Brian Kelley

Databases – Infrastructure – Security

but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...

2009-08-11

704 reads

Why Use Named Pipes?

by Brian Kelley

Databases – Infrastructure – Security

The other day a colleague and I were shadowing a vendor who was installing their 3rd party application on a...

2009-08-10

24,222 reads

Blogs

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

Come See Me at the PASS Data Community Summit

By Brian Kelley

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

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

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

Are topic notifications working?

By Edward Casbon

This is a topic to test whether reply notifications are working or not.

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers