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

Why I ended up getting a Zune

by Brian Kelley

Databases – Infrastructure – Security

I've been looking at getting an MP3 player for a while now because I want to make better use of...

2007-01-27

1,541 reads

Midlands PASS February Meeting

by Brian Kelley

Databases – Infrastructure – Security

Our next meeting
will be on Thursday, February 1, 2007, at
6:30 PM. It'll be at the Training Concepts facility once...

2007-01-26

1,407 reads

New Review: NGS Software's Typhon III

by Brian Kelley

Databases – Infrastructure – Security

I recently had the opportunity to review NGS Software's updated Typhon III general vulnerability scanner. I had previously reviewed it...

2007-01-25

1,732 reads

Adding value to our organizations

by Brian Kelley

Databases – Infrastructure – Security

Sean McCown writes in the latest Database Underground about how DBAs should try and make things better for users of...

2007-01-09

1,539 reads

Most humorous line I've read in a while

by Brian Kelley

Databases – Infrastructure – Security

This is from Michael Kaplan's blog over at MDSN. He was writing about the power outage that affected the Northwest...

2007-01-07

1,360 reads

Shared Items on Google Reader

by Brian Kelley

Databases – Infrastructure – Security

I read through a lot of blogs each day in a variety of technology categories. I've always fashioned myself as...

2007-01-06

1,357 reads

Midlands PASS January 2007 Meeting Minutes

by Brian Kelley

Databases – Infrastructure – Security

January 4,
2007 Meeting Minutes: Members in
Attendance: 15Next Meeting
Date: February 1, 2007 Job
Board: I had a consulting
firm contact me...

2007-01-05

1,695 reads

Midlands PASS Chapter Meeting for January

by Brian Kelley

Databases – Infrastructure – Security

Our next meeting will be
on Thursday, January 4, 2007, at 6:30 PM. It'll be at the Training Concepts
facility...

2006-12-29

1,499 reads

Setting Goals for the New Year and Beyond

by Brian Kelley

Databases – Infrastructure – Security

I've never been a big fan of "New Year's Resolutions" for the same reason most other folks are against them:...

2006-12-29

1,592 reads

How to handle an invalid default database

by Brian Kelley

Databases – Infrastructure – Security

My general recommendation for SQL Server service accounts and accounts that have sysadmin fixed server role membership is to default...

2006-12-11

1,898 reads

Blogs

T-SQL Tuesday #193 – Notes to past and future me

By Mala Mahadevan

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

A Note and a Message: T-SQL Tuesday #193

This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...

More fun with Git: git restore

By Randolph West

The setup My day job involves babysitting a lot of Git repositories hosted on...

Read the latest Blogs

Forums

This doesn't make sense to me - making me crazy - er

Hi So I have the below select query that won't return results if I...

Catalog max connection pool size: 100

Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...

CAST datetimeoffset(7) as a datetime in UK format

By tylerschuler75

I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...

Visit the forum

Question of the Day

Putting the Player with the Number

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

See possible answers