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

Cain does LSA Secrets dump on Vista and higher now

by Brian Kelley

Databases – Infrastructure – Security

Since going back to being a senior DBA, I've not stayed on top of the latest tools like I did...

2011-04-19

2,077 reads

"What's the point?"

by Brian Kelley

Databases – Infrastructure – Security

This is a crucial question with regards to what needs to be done. It really hit home after listening to...

2011-04-18

808 reads

It's not about whether you're a consultant or full-time staff...

by Brian Kelley

Databases – Infrastructure – Security

There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...

2011-04-12

1,334 reads

An Appeal to Those Writing Training Documentation and Labs

by Brian Kelley

Databases – Infrastructure – Security

I'm coming to the end of a week of training in a Microsoft Official Curriculum (MOC) Course. I should expect...

2011-04-08

919 reads

On Leadership - Lead by Example

by Brian Kelley

Databases – Infrastructure – Security

This is the second part of a leadership series I started with On Leadership - Lead from the Front. To recap...

2011-04-07

1,603 reads

SQL Injection: It's not just about your data

by Brian Kelley

Databases – Infrastructure – Security

On the topic of my SQL Connections SQL Server presentation, one of the things I pointed out about recent SQL...

2011-04-06

1,105 reads

SQL PASS ERC: How to Score the Interview?

by Brian Kelley

Databases – Infrastructure – Security

One of the topics the Election Review Committee has discussed is how best to score the interview portion. Because of...

2011-04-06

1,353 reads

Epsilon Data Breach and Staying Safe

by Brian Kelley

Databases – Infrastructure – Security

By now, you may have received an email from one of the larger businesses you've given your email address to...

2011-04-05

757 reads

A SQL Story in Eleven Words or Less

by Brian Kelley

Databases – Infrastructure – Security

Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...

2011-04-04

698 reads

Isolating SQL Server from other systems

by Brian Kelley

Databases – Infrastructure – Security

In a recent explanation about the RSA breach, Rick Wanner wrote on the Internet Storm Center (ISC) Diary:
The traditional paradigm...

2011-04-04

2,147 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