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

809 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,338 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

933 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,608 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,116 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,359 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

767 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

702 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,161 reads

Blogs

T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?

The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...

Monday Monitor Tips: Configuring Access to the MCP Server

I have been experimenting with MCP servers in a few ways, including the Redgate...

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

Read the latest Blogs

Forums

Admin Rights for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Admin Rights for Everyone

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

By Arvind Toorpu

Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...

RegEx Functions I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions I

Visit the forum

Question of the Day

RegEx Functions I

Which of these RegEx functions need compatibility level 170 in SQL Server 2025?

See possible answers