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

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

892 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,795 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

769 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,197 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,055 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,291 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

599 reads

Cloud Computing - Will Data Breaches Cost More?

by Brian Kelley

Databases – Infrastructure – Security

That's the main point from the following article:
Video: Data breaches to cost more in the cloud
The cost was calculated per...

2010-04-09

1,045 reads

A Good Expansion on the Topic of Plagiarism

by Brian Kelley

Databases – Infrastructure – Security

In a previous post I gave some links which help explain what plagiarism is and how to generally avoid it....

2010-04-08

674 reads

Blogs

SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library

By MarlonRibunal

I built a free library of runnable SQL Server demos. Each reproduces a real...

Experimenting with CHOOSE: #SQLNewBlogger

I was looking over the CHOOSE() function while editing an article at SQL Server...

Fighting Procrastination?

By Brian Kelley

Here is another short video (~ 15 minutes). This is by the author of...

Read the latest Blogs

Forums

MERGE in a nested TRY/CATCH won't roll back

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

SQL Server 2025 Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Server-level Roles

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers