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

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,377 reads

SANS Stay Sharp Course - SEC351: Computer and Network Security Awareness

by Brian Kelley

Databases – Infrastructure – Security

A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...

2006-06-21

2,139 reads

Whitepaper: SQL Server 2005 Physical Database Storage Design

by Brian Kelley

Databases – Infrastructure – Security

Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...

2006-06-15

2,049 reads

Distributing Database Connection Strings Using Active Directory Group Policy

by Brian Kelley

Databases – Infrastructure – Security

I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...

2006-06-13

2,326 reads

TechEd - DATTLC01 : Troubleshooting Performance Problems in SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...

2006-06-12

1,578 reads

In Boston for TechEd

by Brian Kelley

Databases – Infrastructure – Security

This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...

2006-06-11

1,489 reads

Two things I wish they'd change about endpoints in SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...

2006-05-27

2,139 reads

When It Takes Time...

by Brian Kelley

Databases – Infrastructure – Security

Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:

Project Managing Latency or: How to...

2006-05-25

1,447 reads

Disaster Recovery and SQL Server, Part II

by Brian Kelley

Databases – Infrastructure – Security

In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...

2006-05-24

1,492 reads

SQL Prompt

by Brian Kelley

Databases – Infrastructure – Security

I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...

2006-05-23

1,620 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

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

T-SQL in SQL Server 2025: Concatenating Strings

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

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