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

SQL Server 2005 SP2 CTP Available for Download

by Brian Kelley

Databases – Infrastructure – Security

The Community Technology Preview (CTP) version SQL Server 2005 SP2 has been released by Microsoft. You can find the download...

2006-11-08

1,974 reads

Chess

by Brian Kelley

Databases – Infrastructure – Security

Recently I started getting back into the game of chess as I began coaching my boys. Chess is a great...

2006-11-02

1,686 reads

Picking back up on blogging

by Brian Kelley

Databases – Infrastructure – Security

It has been a trying month to month and a half with the implementation of Microsoft's CRM 3.0 product. By...

2006-10-30

1,371 reads

Diversions

by Brian Kelley

Databases – Infrastructure – Security

I've been rather quiet for a while and there's a reason. I've been
helping some friends get a general gaming site...

2006-09-22

1,503 reads

SQL Server 2005 Scripts on TechNet

by Brian Kelley

Databases – Infrastructure – Security

I've not been posting over the last week because I'm in the midst of a
two week vacation, the first I've...

2006-09-01

1,457 reads

Removing SQL Server Express from VS Team System for Database Professionals CTP 5

by Brian Kelley

Databases – Infrastructure – Security

As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out,
if you don't already...

2006-08-24

1,385 reads

Visual Studio Team System for Database Professionals CTP 5 Out

by Brian Kelley

Databases – Infrastructure – Security

If you aren't aware, the Visual Studio Team System for Database
Professionals CTP 5 is available for download. It's a significantly
larger...

2006-08-23

1,428 reads

The Importance of Database Coding Standards

by Brian Kelley

Databases – Infrastructure – Security

I was working with a developer the other day and the question came up
of how to return status from a...

2006-08-17

1,824 reads

Presentation slides and sql scripts up

by Brian Kelley

Databases – Infrastructure – Security

I have posted the slides for the presentation I gave to the DotNet Columbia User Group.
The talk was called, "Something...

2006-08-09

714 reads

Visual Studio Team System - Database Professionals: Database Connection Error

by Brian Kelley

Databases – Infrastructure – Security

If you're like me, you don't have SQL Server 2005 sitting on the
default instance because SQL Server 2000 is sitting...

2006-08-06

659 reads

Blogs

Catching Up On SQLOrlando

Somehow two years have elapsed since my last update; hopefully it won’t be that...

Advice I Like: Pyramid Schemes

If someone is trying to convince you it’s not a pyramid scheme, it’s a...

Using Prompt AI for a Travel Data Analysis

I was looking back at my year and decided to see if SQL Prompt...

Read the latest Blogs

Forums

Switch partition: NULL boundary id

I have table: t1 in schema1 with 19 billion records. I have another table...

Minimally Viable Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Minimally Viable Security

Encoding NULL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encoding NULL

Visit the forum

Question of the Day

Encoding NULL

What is returned from this code in SQL Server 2025?

SELECT BASE64_ENCODE(NULL)

See possible answers