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

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

WinFS rolled into next version of SQL Server

by Brian Kelley

Databases – Infrastructure – Security

A blog posting from the WinFS team
caught me a bit by surprise today. Apparently I wasn't the only one,
judging by...

2006-06-27

1,533 reads

Top 100 Network Security Tools

by Brian Kelley

Databases – Infrastructure – Security

This is a bit dated (it came out last week), but here is the list of
the top 100 network security...

2006-06-26

1,445 reads

Professional Association of SQL Server (PASS) Local Chapter in Columbia, SC

by Brian Kelley

Databases – Infrastructure – Security

We are starting up efforts again to try and get a local PASS
chapter based in the Columbia, SC area. If...

2006-06-23

1,374 reads

Blogs

A New Word: Flichtish

flichtish – adj. nervously aware how much of your self-image is based on untested...

Automating Container Image Builds with Docker Build Cloud and Github Actions

By Andrew Pruski

In a previous post we went through how to use Docker Build Cloud to...

The Ireland and UK DevOps Roadshow

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

Read the latest Blogs

Forums

Linked Server Product Name?

By Brandie Tarvin

Just came across something weird. Was wondering if anyone else has ever seen this....

Can index fragmentation cause the database to enter suspect mode?

By IT researcher

My database was in suspect mode, and when I checked using DBCC CHECKDB, it...

Creating Statistics on XML

By Steve Jones - SSC Editor

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

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