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

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,912 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,453 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,612 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,395 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,713 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,397 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,540 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,541 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,448 reads

Blogs

Advice I Like: Failure

If it fails where you thought it would fail that is not a failure....

Data Conferences – Worth Every Dollar

Some of the best career enhancers you can buy. Why I Go to...

SQL Server 2025 RegEx and AI

One of the language changes in SQL Server 2025 that I’ve seen a lot...

Read the latest Blogs

Forums

SQL 2022 stuck on xp_delete_file

SQL 2022 hangs on xp_delete_file, it works for a while when sever is rebooted...

Select @ for different fields

I have a need where I need to pass a field name to a...

Getting the Object Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Object Code

Visit the forum

Question of the Day

Getting the Object Code

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; 
GO

See possible answers