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

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,517 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,917 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,456 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,618 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,398 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,716 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,399 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,359 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,546 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,545 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers