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

[OFF-TOPIC] Make a difference

by Brian Kelley

Databases – Infrastructure – Security

I follow the blog of Johnny Long (twitter) from time-to-time, especially as he chronicled his work in Uganda. I know...

2011-03-09

804 reads

Selecting Speakers for SQL Saturday #70

by Brian Kelley

Databases – Infrastructure – Security

The Call for Speakers for SQL Saturday #70 - Columbia, SC, ended on February 17, 2011. We wanted to put the...

2011-02-25

1,650 reads

Configuring Antivirus for SQL Servers

by Brian Kelley

Databases – Infrastructure – Security

I've been on both sides of the debate with respect to whether or not to install antivirus software on a...

2011-02-24

3,387 reads

PASS in Five Years: It's about the Members

by Brian Kelley

Databases – Infrastructure – Security

Andy Warren (blog | twitter) recently blogged about wanting input on What Should PASS Be? and I think it's a reasonable...

2011-02-24

1,491 reads

PASS Election Review Committee: NomCom Process

by Brian Kelley

Databases – Infrastructure – Security

Over on the ERC forums, Bill Graziano (blog | twitter) has posted the proposed NomCom selection process. We would really like...

2011-02-23

601 reads

Shameless Self-Promotion - Introduction to SQL Server [Book]

by Brian Kelley

Databases – Infrastructure – Security

My introductory text to SQL Server, appropriately titled Introduction to SQL Server, is now in print and available for sale. The...

2011-02-22

950 reads

Use Patterns and Prior Code and Don't Reinvent the Wheel

by Brian Kelley

Databases – Infrastructure – Security

In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...

2011-02-21

1,974 reads

SQL Saturday #70 - Columbia, SC 2011 Session Schedule Is Up!

by Brian Kelley

Databases – Infrastructure – Security

As announced, we have posted our session schedule for SQL Saturday #70 - Columbia, SC. The event will be March 19, 2011...

2011-02-19

1,271 reads

I'm in at SQL Connections!

by Brian Kelley

Databases – Infrastructure – Security

At the end of March I'll be journeying down with the family to Orlando, Florida. We plan on stopping in...

2011-02-18

946 reads

SQL University: Home-Grown, with Real Options!

by Brian Kelley

Databases – Infrastructure – Security

There's the light, as this is the last class for Security week at SQL University. From the scenarios we specified...

2011-02-11

1,609 reads

Blogs

2025 Wrapped for Steve

I’ve often done some analysis of my year in different ways. Last year I...

The Book of Redgate: Spread across the world

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Merry Christmas

Today is Christmas and while I do not expect anybody to actual be reading...

Read the latest Blogs

Forums

Database security permissions save script

By Srinivas Merugu

Comments posted to this topic are about the item Database security permissions save script

Database backup job steps

I have a SQL Agent job for backing up a set of Analysis Services...

SQL Server 2025 Backup Compression Algorithm

By Johan Bijnens

Comments posted to this topic are about the item SQL Server 2025 Backup Compression...

Visit the forum

Question of the Day

The Large Encoded Value

I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?

See possible answers