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,516 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,915 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,454 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,616 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,396 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,714 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,398 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,357 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,543 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,543 reads

Blogs

The Benefits of Teaching

By Brian Kelley

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By DataOnWheels

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

The Book of Redgate: What Our Staff Says

This image is from 2010, and it goes along with my last post of...

Read the latest Blogs

Forums

Deny Connect problem

By Brandie Tarvin

I have a login I need to deny connect to on a server, but...

Website Stability 2025/12/05

By Steve Jones - SSC Editor

All week we've had issues with the site being up and down. There's been...

403 Forbidden

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers