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

Join the Community - AKA, "Where did he go, George?"

by Brian Kelley

Databases – Infrastructure – Security

In recent days I've kind of dropped off the map with respect to SQL Server, including with the Security and...

2010-05-11

761 reads

Why I Don't Look for a Telecommuting Job

by Brian Kelley

Databases – Infrastructure – Security

I just got done reading Brent Ozar's post about why folks don't get the telecommuting job they want. It's a...

2010-05-07

3,108 reads

SQL University Post Coming Tomorrow

by Brian Kelley

Databases – Infrastructure – Security

This is a short note to say that the SQL University post will arrive tomorrow. Today we're dealing with the...

2010-04-28

1,437 reads

SQL Saturday - Columbia, SC - October 2, 2010

by Brian Kelley

Databases – Infrastructure – Security

This is the official announcement that we are officially scheduled for holding a SQL Saturday in Columbia, SC, on October...

2010-04-27

883 reads

SQL University: Auditing SQL Server, Part I

by Brian Kelley

Databases – Infrastructure – Security

Welcome to the Security and Auditing Week for SQL University. Last semester we looked at the basics of SQL Server...

2010-04-26

2,786 reads

2010 Scripting Games

by Brian Kelley

Databases – Infrastructure – Security

Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...

2010-04-21

763 reads

Thoughts on the SQL Server 2008 R2 Press Conference

by Brian Kelley

Databases – Infrastructure – Security

If you weren't aware, Microsoft held a BI telelconference today which announced the release to manufacturing (RTM) of SQL Server...

2010-04-21

1,181 reads

PowerShell 2.0 on Windows XP SP3 - Can It Be Upgraded?

by Brian Kelley

Databases – Infrastructure – Security

In my last blog post I indicated that I would be adding learning PowerShell to my list of goals. I...

2010-04-15

5,025 reads

Why I Have Had a Hard Time Adopting PowerShell

by Brian Kelley

Databases – Infrastructure – Security

PowerShell has been out for a while. When it first came out, I went and grabbed a copy and tinkered...

2010-04-14

4,280 reads

Hosting a User Group Meeting - Day of "Bare Bones" Checklist

by Brian Kelley

Databases – Infrastructure – Security

This actually came as a response to a tweet from Mike Walsh (Twitter | Blog). But here is the barebones checklist I...

2010-04-13

588 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