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

Two Sessions Up for Vote at SQLRally!

by Brian Kelley

Databases – Infrastructure – Security

I received great news last week that one of my sessions, Windows Operating System Internals for DB Pros, was accepted,...

2012-02-21

856 reads

USB/Flash Drive Security

by Brian Kelley

Databases – Infrastructure – Security

Gone are the days when remote drives were easy to detect because there was some size to them. Nowadays USB...

2012-02-15 (first published: 2012-02-13)

2,211 reads

See You at SQL Saturday!

by Brian Kelley

Databases – Infrastructure – Security

I've been asked this question a few times, and Columbia, SC isn't hosting a SQL Saturday this year. Bobby Dimmick...

2012-02-13

1,175 reads

Discuss

Slides and Scripts from Idera February webcast

by Brian Kelley

Databases – Infrastructure – Security

For those who've asked, here are the slides and scripts from my SQL Server auditing webinar with Idera:

Presentation (.PDF)Scripts (.ZIP)
If...

2012-02-10

1,038 reads

Discuss

Webcast: Successfully Meeting Your Audits for SQL Server

by Brian Kelley

Databases – Infrastructure – Security

Tomorrow at 3 PM Eastern I'll be giving a webcast in conjection with Idera and MSSQLTips.com:

Registration for Successfully Meeting Your...

2012-02-07

1,014 reads

About those backups...

by Brian Kelley

Databases – Infrastructure – Security

So I went to present at Charleston PASS on Thursday night and of course I had my standard contact information...

2012-01-30 (first published: 2012-01-25)

2,003 reads

Discuss

New article: Identifying What Runs at Startup on SQL Server

by Brian Kelley

Databases – Infrastructure – Security

Another article has published over at MSSQLTips.com. This one covers how to identify what stored procedures are set to run when...

2012-01-30

936 reads

Discuss

You require WHAT for a license?

by Brian Kelley

Databases – Infrastructure – Security

I was trying to acquire a license for a product I was trying to look at using a free program....

2012-01-26

1,028 reads

Discuss

Clicking on Links in Email

by Brian Kelley

Databases – Infrastructure – Security

Every security awareness presentation makes the warning about opening attachments or clicking on links in emails when you don't know...

2012-01-24

1,250 reads

Discuss

New Article: How to audit sysadmin members on multiple servers using PowerShell

by Brian Kelley

Databases – Infrastructure – Security

My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit...

2012-01-23

1,940 reads

Discuss

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