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

DR planning article up at MSSQLTips!

by Brian Kelley

Databases – Infrastructure – Security

My latest article is up at MSSQLTips.com:

Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right

For more of...

2013-05-23

838 reads

Giving an SSIS security webinar with Andy Leonard

by Brian Kelley

Databases – Infrastructure – Security

Andy Leonard (blog | twitter) and I are teaming up to do a security presentation on SSIS. It's scheduled for Wednesday, May...

2013-05-23

1,035 reads

Do you check to see if an SSIS package has been modified?

by Brian Kelley

Databases – Infrastructure – Security

Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...

2013-05-22

2,698 reads

I'm thinking of hosting a series of webinars on SQL Server security

by Brian Kelley

Databases – Infrastructure – Security

With the PASS Summit sessions announced, I took a quick look to see how many were what I'd consider security-centric....

2013-05-22

2,824 reads

Speaking in Columbia and Charlotte Next Week

by Brian Kelley

Databases – Infrastructure – Security

I'm speaking at two user groups next week.

Tuesday - Midlands PASS - May 14
I'll be giving a presentation on PowerShell to help...

2013-05-10

1,034 reads

I'm Giving a SQL Server Security Webinar on May 9, 2013

by Brian Kelley

Databases – Infrastructure – Security

On May 9, 2013, at 3 PM EDT I will be presenting on 5 Steps Every DBA Should Take to...

2013-05-07

1,194 reads

2013 Carolina Code Camp Presentations

by Brian Kelley

Databases – Infrastructure – Security

As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...

2013-05-06

1,012 reads

Speaking at the 2013 Carolina Code Camp

by Brian Kelley

Databases – Infrastructure – Security

On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...

2013-04-23

880 reads

T-SQL Tuesday #41: How I Got My Start in Presenting

by Brian Kelley

Databases – Infrastructure – Security

For this month's T-SQL Tuesday, Bob challenges us to discuss how we came to love presenting. Here's my story.
I developed a...

2013-04-19 (first published: 2013-04-09)

1,957 reads

Don't Alienate Your Customer

by Brian Kelley

Databases – Infrastructure – Security

This should go without saying, because most of us have been on the receiving end of poor customer support. However,...

2013-04-05

1,028 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

SQL Server 2019 - Agent job PowerShell step issue

I have a couple of SQL Agent job steps which run PowerShell commands of...

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

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