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

Slides and Scripts from Idera Auditing SQL Server presentation

by Brian Kelley

Databases – Infrastructure – Security

I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...

2012-10-10

1,563 reads

Kathi Kellenberger speaking at Midlands PASS

by Brian Kelley

Databases – Infrastructure – Security

On October 17th, Midlands PASS will welcome Kathi Kellenberger to speak on T-SQL 2012. Here's what her talk will be...

2012-10-05

1,086 reads

Webcast on SQL Server Auditing on October 9th

by Brian Kelley

Databases – Infrastructure – Security

Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...

2012-10-04

1,058 reads

Participate in the PASS Election Process

by Brian Kelley

Databases – Infrastructure – Security

Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...

2012-09-26

1,063 reads

The Reason I Won't Be at the PASS Summit This Year

by Brian Kelley

Databases – Infrastructure – Security

We welcomed daughter #3 and child #5 into this world on Saturday at 9:43 AM. She came a bit earlier...

2012-09-24

1,478 reads

PASS ProfDev VC presentation recording available

by Brian Kelley

Databases – Infrastructure – Security

Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...

2012-09-10

1,130 reads

An important query to remember

by Brian Kelley

Databases – Infrastructure – Security

This is based on a post with respect to where our focus and efforts should be that I wrote at...

2012-08-30

1,861 reads

Resources for Those Dealing with Security Patches

by Brian Kelley

Databases – Infrastructure – Security

It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...

2012-08-24 (first published: 2012-08-21)

2,575 reads

Don't Disconnect Your Common Sense

by Brian Kelley

Databases – Infrastructure – Security

This falls in line with a previous post about common sense in IT.
I was having lunch with a co-worker,...

2012-08-23

1,746 reads

Rant: Applying Common Sense in IT

by Brian Kelley

Databases – Infrastructure – Security

I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...

2012-08-23 (first published: 2012-08-17)

4,600 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