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

Before You Begin Auditing...

by Brian Kelley

Databases – Infrastructure – Security

There is a fine line between auditing and attacking. The line actually is one built based on authorization. Same tools,...

2010-07-06

949 reads

Why I Use Social Media

by Brian Kelley

Databases – Infrastructure – Security

Yesterday was a scary time for the Kelley family. Our youngest, our five year-old daughter, suddenly had a rash everywhere....

2010-07-01

589 reads

SQL Saturday #48 - Columbia, SC - Registration and Call for Speakers is On-line

by Brian Kelley

Databases – Infrastructure – Security

The website is up for SQL Saturday #48 - Columbia. We're holding it on October 2, 2010, in West Columbia, SC,...

2010-06-30

1,436 reads

First Performance Virtual Chapter Webcast

by Brian Kelley

Databases – Infrastructure – Security

Thanks to the outstanding efforts of Tim Edwards (twitter | blog), our fearless leader, and the rest of the crew, the PASS...

2010-06-28

893 reads

So I Won't Be Going to the Summit This Year

by Brian Kelley

Databases – Infrastructure – Security

As the deadline for abstracts to be submitted to the PASS Summit came due, I made the hard decision not...

2010-06-16

643 reads

A Greek Tragedy

by Brian Kelley

Databases – Infrastructure – Security

This is just tragic. Thanks to Brent Ozar (twitter | blog) for posting it.
Idera web site hit by SQL injection attack
The...

2010-06-11

573 reads

Overcoming Your Limits

by Brian Kelley

Databases – Infrastructure – Security

As I age in years, I realize more and more how blessed I was to attend The Citadel, the Military...

2010-06-08

1,263 reads

Slides from SQL Server Auditing Class

by Brian Kelley

Databases – Infrastructure – Security

Here are the slides from the SQL Server Auditing Class held on June 2, 2010.
Hour 1 - Attacking SQL Server
Hour 2...

2010-06-03

1,017 reads

Providing Quality to the Community

by Brian Kelley

Databases – Infrastructure – Security

This has been on my mind since last week after a conversation with a friend of mine, Bobby Dimmick (twitter)....

2010-05-19

1,188 reads

Microsoft Certified Architect - Infrastructure and Solutions Are No More

by Brian Kelley

Databases – Infrastructure – Security

A friend of mine had been out to the Microsoft Certified Architect site recently and noted that the Infrastructure and...

2010-05-14

1,961 reads

Blogs

Performance tuning KubeVirt for SQL Server

By Andrew Pruski

Following on from my last post about Getting Started With KubeVirt & SQL Server,...

T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future

I haven’t posted in a while (well, not here at least since I’ve been...

Keeping MS Docs Up to Date

One of the things that I like about the SQL Server docs (MS Learn...

Read the latest Blogs

Forums

Change Tracking – Troubleshooting

I have change tracking configured in several databases, in QA and production environments, and...

is there a no code way to limit an ssis extract from excel to the 1st 21 rows?

is there a no code way to limit an ssis extract from excel to...

Pivot but preserve all rows on Aggregate column

Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return?

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers