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

Blogs

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

By

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

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

By

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

More fun with Git: git restore

By

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

By krypto69

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

Catalog max connection pool size: 100

By Pete Bishop

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