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

Consolidating Email Accounts

by Brian Kelley

Databases – Infrastructure – Security

I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either...

2014-10-21

527 reads

SQL Server Security Benchmarks

by Brian Kelley

Databases – Infrastructure – Security

If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...

2014-10-20

867 reads

#TSQL2sday #59 – My Heroes

by Brian Kelley

Databases – Infrastructure – Security

Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....

2014-10-14

541 reads

Slides and Code for SSIG Talk

by Brian Kelley

Databases – Infrastructure – Security

Thank you for those who made it out to the SQL Server Innovators Guild last night in Greenville, SC. I...

2014-10-08

601 reads

The Fallacy of Internal Access Only

by Brian Kelley

Databases – Infrastructure – Security

In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only...

2014-10-07 (first published: 2014-09-30)

7,116 reads

Carolina Technology Conference: Presentation Materials

by Brian Kelley

Databases – Infrastructure – Security

For those able to attend my session at this year’s Carolina Technology Conference, thank you! As promised, here are the...

2014-10-06

794 reads

Four Things PASS gets Right

by Brian Kelley

Databases – Infrastructure – Security

PASS has taken a lot of heat recently. A few folks have pointed out that you only seem to hear...

2014-09-29 (first published: 2014-09-24)

6,777 reads

[Off-Topic] Beating Childhood Cancer

by Brian Kelley

Databases – Infrastructure – Security

Note: I feel this post is important enough to post across all my blogs.
September is Childhood Cancer Awareness Month here...

2014-09-09

550 reads

4 Attitudes I Wish I Had Earlier as a DBA

by Brian Kelley

Databases – Infrastructure – Security

I was tagged by Mike Walsh (blog | twitter) in his post 4 Attitudes I Wish I Had Earlier As a...

2014-09-05 (first published: 2014-08-28)

8,123 reads

Audit Webinar Tomorrow (4 September 2014)

by Brian Kelley

Databases – Infrastructure – Security

I will be given a webinar on how to audit SQL Server through MSSQLTips.com.
Webinar Registration Link
The abstract:
Don’t become a statistic....

2014-09-03

505 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