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

Catching Up On SQLOrlando

Somehow two years have elapsed since my last update; hopefully it won’t be that...

Advice I Like: Pyramid Schemes

If someone is trying to convince you it’s not a pyramid scheme, it’s a...

Using Prompt AI for a Travel Data Analysis

I was looking back at my year and decided to see if SQL Prompt...

Read the latest Blogs

Forums

Switch partition: NULL boundary id

I have table: t1 in schema1 with 19 billion records. I have another table...

Minimally Viable Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Minimally Viable Security

Encoding NULL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encoding NULL

Visit the forum

Question of the Day

Encoding NULL

What is returned from this code in SQL Server 2025?

SELECT BASE64_ENCODE(NULL)

See possible answers