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

Security: People Are the Weakest Link

by Brian Kelley

Databases – Infrastructure – Security

There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...

2013-04-05 (first published: 2013-03-28)

3,327 reads

Free SQL Server Training for the Week of April 1, 2013

by Brian Kelley

Databases – Infrastructure – Security

Here are some training events you might be interested in for the coming week:

Tuesday, April 2
11:00-12:00 EDT, Introduction to SQL...

2013-03-29

1,598 reads

What to Do When You Can't Wipe an Infected System

by Brian Kelley

Databases – Infrastructure – Security

When it comes to workstations within most organizations, the solution when one gets infected is to wipe it and re-image...

2013-03-27

2,662 reads

Get Data Warehouse Training and Help a Neat School

by Brian Kelley

Databases – Infrastructure – Security

If you're located relatively near the Atlanta, Georgia area, I wanted to bring your attention to data warehousing training on...

2013-02-18

1,104 reads

Upcoming Online Training for the Week of February 18, 2013

by Brian Kelley

Databases – Infrastructure – Security

I used to compile a list of online training for the following week and posting it on Fridays. I stopped...

2013-02-14

1,008 reads

Avoid This Time Scheduling Mistake

by Brian Kelley

Databases – Infrastructure – Security

I was recently asked by a project manager to lay out when DBAs would accomplish certain tasks for a particular...

2013-02-07

1,412 reads

Consider All the Possibilities When Troubleshooting

by Brian Kelley

Databases – Infrastructure – Security

When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...

2013-01-28

1,668 reads

Cash Over Credit

by Brian Kelley

Databases – Infrastructure – Security

What does cash over credit have to deal with security? An awful lot, as it turns out.
Personal Story: Mere days...

2013-01-17

1,210 reads

Observe Carefully When Things Are Running Fine

by Brian Kelley

Databases – Infrastructure – Security

Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...

2013-01-14 (first published: 2013-01-10)

2,150 reads

Rename the SQL Server Management Studio shortcut

by Brian Kelley

Databases – Infrastructure – Security

Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...

2013-01-11

7,786 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