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

MSSQLTips.com Kindle Contest

by Brian Kelley

Databases – Infrastructure – Security

I'm always wary of contests to win free stuff, but the folks running MSSQLTips.com are legitimate (I write there as...

2011-08-04

1,043 reads

Rant: Security Isn't Sexy and It's a Shame

by Brian Kelley

Databases – Infrastructure – Security

I grew up immersed in security. My father was a US Marine and going on and off base meant... security....

2011-08-03

1,231 reads

Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings

by Brian Kelley

Databases – Infrastructure – Security

We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...

2011-08-02

15,667 reads

Bad Admins: Non-Production Servers

by Brian Kelley

Databases – Infrastructure – Security

This is part of a series of tips on how bad/rogue admins can get access to the data in your...

2011-07-28

2,174 reads

Bad Admins: Taking Advantage of Maintenance Periods

by Brian Kelley

Databases – Infrastructure – Security

This is part of a series of tips on how bad/rogue admins can get access to the data in your...

2011-07-25

1,059 reads

Bad Admins: Stealing the SQL Server Service Account

by Brian Kelley

Databases – Infrastructure – Security

This is part of a series of tips on how bad/rogue admins can get access to the data in your...

2011-07-22

1,369 reads

Bad Admins: Pocketing Backups

by Brian Kelley

Databases – Infrastructure – Security

This is part of a series of tips on how bad/rogue admins can get access to the data in your...

2011-07-21

728 reads

Gaining Speaker Experience Credentials, Part II

by Brian Kelley

Databases – Infrastructure – Security

In a previous post I gave suggestions on how to get speaking credentials for consideration at a larger event, such...

2011-07-21

940 reads

Bad Admins: Stealing An Account

by Brian Kelley

Databases – Infrastructure – Security

Yesterday I posted about manipulating group membership to get access to a SQL Server. Today comes attack vector #2: stealing an...

2011-07-14

1,190 reads

Bad Admins: Attacking via Group Membership

by Brian Kelley

Databases – Infrastructure – Security

This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...

2011-07-13

1,873 reads

Blogs

2025 Wrapped for Steve

I’ve often done some analysis of my year in different ways. Last year I...

The Book of Redgate: Spread across the world

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Merry Christmas

Today is Christmas and while I do not expect anybody to actual be reading...

Read the latest Blogs

Forums

Database security permissions save script

By Srinivas Merugu

Comments posted to this topic are about the item Database security permissions save script

Database backup job steps

I have a SQL Agent job for backing up a set of Analysis Services...

SQL Server 2025 Backup Compression Algorithm

By Johan Bijnens

Comments posted to this topic are about the item SQL Server 2025 Backup Compression...

Visit the forum

Question of the Day

The Large Encoded Value

I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?

See possible answers