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,045 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,234 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,678 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,186 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,063 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,376 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

734 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

950 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,198 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,875 reads

Blogs

T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?

The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...

Monday Monitor Tips: Configuring Access to the MCP Server

I have been experimenting with MCP servers in a few ways, including the Redgate...

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

Read the latest Blogs

Forums

Admin Rights for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Admin Rights for Everyone

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

By Arvind Toorpu

Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...

RegEx Functions I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions I

Visit the forum

Question of the Day

RegEx Functions I

Which of these RegEx functions need compatibility level 170 in SQL Server 2025?

See possible answers