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

Presenting at Columbia, SC DotNet User Group

by Brian Kelley

Databases – Infrastructure – Security

I'll be presenting at the DotNet Columbia SC User Group on August 8th.
My presentation is tentatively titled, "Something old, something...

2006-07-20

1,631 reads

The Plumbing Behind MSDN 2

by Brian Kelley

Databases – Infrastructure – Security

There is a very interesting article about how MSDN 2 utilizes SQL
Server 2005 technologies, specifically Service Broker and CLR
integration. The...

2006-07-20

1,513 reads

Free Data Models

by Brian Kelley

Databases – Infrastructure – Security

I saw this on a Channel 9 forum thread:

Library of Free Data Models

There are quite a few starter data models...

2006-07-19

1,909 reads

Get a Better Understanding of How Queries Execute

by Brian Kelley

Databases – Infrastructure – Security

I was catching up on my blog reading (unfortunately, in some cases I'm
a month behind) and came across a link...

2006-07-14

1,450 reads

New KB Article on SQL Server 2005 File Growth Bug

by Brian Kelley

Databases – Infrastructure – Security

There is are two new KB articles on how the file growth value can become abnormally large. You can find...

2006-07-13

1,604 reads

A Chronology of Data Breaches Reported Since the ChoicePoint Incident

by Brian Kelley

Databases – Infrastructure – Security

Found this link on one of the security mailing lists I peruse. You can find an archive of the original...

2006-07-11

1,389 reads

New KB Article on Remote Mirroring Support Requirements

by Brian Kelley

Databases – Infrastructure – Security

Microsoft has published a new Knowledge Base article on the
requirements to receive support for what is known as remote mirroring.

Requirements...

2006-07-07

1,709 reads

New Article on SQL Server 2005 Logins

by Brian Kelley

Databases – Infrastructure – Security

I wrote a new article for SQL Server Central on SQL Server 2005 Logins. It covers the basics. This is...

2006-07-05

1,393 reads

Microsoft Office 2007 Delayed

by Brian Kelley

Databases – Infrastructure – Security

It looks like Microsoft Office 2007 will be delayed due to performance
issues. It was supposed to release in conjunction with...

2006-06-29

1,349 reads

Idera SQL Check updated for SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

Idera's SQL Check
has been updated to support SQL Server 2005. SQL Check is a free
performance monitoring tool, not anywhere near...

2006-06-28

1,530 reads

Blogs

The Ireland and UK DevOps Roadshow

We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...

SQL Aggregate Functions: Your Essential Guide & Cheat Sheet

By Tracy McKibben

SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....

T-SQL Tuesday #174 – My Favorite Interview Question

This month is a great topic to me. I think growing and improving your...

Read the latest Blogs

Forums

Creating Statistics on XML

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Statistics on XML

Managing SQL Agent in Azure Data Studio

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managing SQL Agent in Azure...

Database design help and tips for a small app used to coach tennis players.

Hi, I hope this isn't too long of a question- I tried to make...

Visit the forum

Question of the Day

Creating Statistics on XML

I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?

See possible answers