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

Love What You Do

by Brian Kelley

Databases – Infrastructure – Security

I've been dealing with illness the last few weeks, probably due to the rather heavy pollen season here in South...

2011-04-29

1,539 reads

SQL University: Who has access to my SQL Server?

by Brian Kelley

Databases – Infrastructure – Security

Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...

2011-04-26

2,783 reads

If a web page asks you to update Adobe Flash Player

by Brian Kelley

Databases – Infrastructure – Security

You don't want to do so from that web page. Instead you want to go to the Adobe web site...

2011-04-22

1,117 reads

Why having two accounts is a good thing

by Brian Kelley

Databases – Infrastructure – Security

Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...

2011-04-22

698 reads

Evaluating my SQL Connection Scores

by Brian Kelley

Databases – Infrastructure – Security

This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...

2011-04-20

1,473 reads

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

807 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,331 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

918 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,601 reads

Blogs

A Small LLM Fail

Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By Peter Skoglund

Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

I hosted this month, late as it turns out, but we still had a...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?)

By Eric M Russell

We have an issue where SSIS packages are failing with a status of "ended...

SQL Newbie HELP: The query references an object that is not supported in distr..

Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers