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

Advanced Persistent Threats and Us

by Brian Kelley

Databases – Infrastructure – Security

In a blog post from last year, Richard Bejtlich (blog | twitter) talked about a concept called an Advanced Persistent Threat...

2011-10-07

1,320 reads

Detecting Security Updates on Vista/Windows 7/2008/2008R2

by Brian Kelley

Databases – Infrastructure – Security

When trying to detect whether updates have been installed or not, there were several places we investigated:
HKLM\Software\Microsoft\Windows\CurrentVersion\UninstallHKLM\Software\Microsoft\WindowsNT\CurrentVersion\HotFixHKLM\Software\Microsoft\UpdatesSome updates still write to...

2011-10-06

2,701 reads

Two Great Talks on the State of Internet Security

by Brian Kelley

Databases – Infrastructure – Security

Recently I've started following the public work of Mikko Hypponen (blog | twitter), the Chief Research Officer of F-Secure. I've known...

2011-10-05

1,040 reads

Have end users who need an introduction to SQL Server book?

by Brian Kelley

Databases – Infrastructure – Security

At the beginning of this year, my introductory text to SQL Server, appropriately titled Introduction to SQL Server, became available for sale....

2011-09-19

1,323 reads

Looking to interact with those proficient in Japanese

by Brian Kelley

Databases – Infrastructure – Security

In the 1970s my mother and her younger sister married U.S. Marines. Both came to the States when their husbands...

2011-09-12

786 reads

Don't Wait to Start Blogging

by Brian Kelley

Databases – Infrastructure – Security

I was reading a post by Jonathan Fields (blog | twitter) about making bad guitars. Okay, so what does that have to...

2011-08-15

2,251 reads

Have the Time? Get in the Game.

by Brian Kelley

Databases – Infrastructure – Security

This year there's a two step process for electing members to the Professional Association for SQL Server (PASS) Board of Directors...

2011-08-11

882 reads

T-SQL Tuesday/Wednesday #21: A Crappy Workaround

by Brian Kelley

Databases – Infrastructure – Security

A long time ago (in IT terms) in a galaxy far, far away I was helping an organization with a...

2011-08-10

2,065 reads

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

810 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

948 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