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

SQL Server MVP Andy Leonard on .NET Rocks!

by Brian Kelley

Databases – Infrastructure – Security

SQL Server MVP Andy Leonard is on the latest edition of .NET Rocks! If you're not familiar with .NET Rocks!,...

2008-02-01

749 reads

The Importance of Verifying Database Backups Regularly

by Brian Kelley

Databases – Infrastructure – Security

Yesterday, as I was pulling into my driveway, my front left tire gave. Thankfully, I was going really slow and...

2008-01-31

1,665 reads

A Long Overdue Database Security Rant

by Brian Kelley

Databases – Infrastructure – Security

I've been dealing with a security product from a security company in recent days that breaks best practices with respect...

2008-01-30

2,302 reads

First Heroes Happen Here (HHH) Comic

by Brian Kelley

Databases – Infrastructure – Security

Microsoft and Seagate have partnered togethered to put together an IT Heroes comic (daily even). The first one is here:
...

2008-01-29

1,562 reads

Ken Henderson has passed away

by Brian Kelley

Databases – Infrastructure – Security

I know I'm not the first in the SQL Server community to post this, but Ken Henderson has passed away...

2008-01-29

1,909 reads

Part II of Troubleshooting Memory Issues

by Brian Kelley

Databases – Infrastructure – Security

The Windows Server Performance Team has published part 2 of troubleshooting memory issues.
This one covers excessive paging and memory...

2008-01-29

1,669 reads

Citrix Presentation Server Becomes XenApp

by Brian Kelley

Databases – Infrastructure – Security

Citrix is changing the name of its flagship product from Citrix Presentation Server (CPS) to XenApp. More from the blogosphere:
Citrix...

2008-01-28

1,990 reads

Metasploit 3.1 is out

by Brian Kelley

Databases – Infrastructure – Security

The new version of Metasploit is out. Included is a GUI interface. It's a complete re-write in Ruby (note to...

2008-01-28

1,513 reads

Microsoft .NET Framework 3.5 Deployment Guides available

by Brian Kelley

Databases – Infrastructure – Security

Saw this first on Aaron Stebner's blog:
.NET Framework 3.5 deployment guides have been published on MSDN
Guidance information for both...

2008-01-28

1,559 reads

Microsoft Security Webcast

by Brian Kelley

Databases – Infrastructure – Security

This one is geared towards IT management:
IT Manager Webcast: Dynamic IT and Security (Part 4 of 5): Identity and Access...

2008-01-28

1,651 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers