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

Functionality and User Experience are important, too

by Brian Kelley

Databases – Infrastructure – Security

There are a few posts and articles around the security-scape lately concluding Windows 7 is more secure than OS X,...

2011-08-09

820 reads

Security Is Your Responsibility

by Brian Kelley

Databases – Infrastructure – Security

My primary responsibility at my organization is no longer to be the security architect and incident response team lead. I...

2011-08-08

963 reads

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,046 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,235 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,679 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,187 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,377 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

735 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

951 reads

Blogs

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By Mala Mahadevan

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By Brian Kelley

A few months ago I started using Deepstash. Deepstash breaks books into the key...

New article – migrating from a named instance

By Brian Kelley

Do you have a case where you have a named instance you'd like to...

Read the latest Blogs

Forums

Understanding Temp Tables and Table Variables in SQL Server

Comments posted to this topic are about the item Understanding Temp Tables and Table...

The Data API Builder MCP Server Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Data API Builder MCP...

Collecting Data Is Hard

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Collecting Data Is Hard

Visit the forum

Question of the Day

The Data API Builder MCP Server Tools

The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?

See possible answers