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

Jason Haley recently began posting his interesting finds again

by Brian Kelley

Databases – Infrastructure – Security

Jason Haley used to post his Interesting Finds about every day, if not multiple times a day. The interesting finds...

2006-12-09

1,375 reads

SysInternals Tools Updated

by Brian Kelley

Databases – Infrastructure – Security

Several SysInternals Tools have been updated. One of the big updates was to the PSTools Suite - now you can pass...

2006-12-09

1,432 reads

Windows 2000 Resource Kit Tools Available

by Brian Kelley

Databases – Infrastructure – Security

If you're like me and rely a lot on the resource kit tools, you may have found that it's relatively...

2006-12-09

1,858 reads

Log Buffer #22: A Carnival of the Vanities for DBAs

by Brian Kelley

Databases – Infrastructure – Security

Welcome to the 22nd edition of Log Buffer, a
weekly compendium of postings and news from database-related blogs across the...

2006-12-08

1,590 reads

Extreme Work

by Brian Kelley

Databases – Infrastructure – Security

"The Productivity Pro" Laura Stack posted in her blog today about jobs where long hours are the norm:

'Extreme' jobs...

2006-12-05

1,484 reads

Guidance on Microsoft Certified Architect Submissions

by Brian Kelley

Databases – Infrastructure – Security

For those considering the Microsoft Certified Architect program, some guidance on what to submit as documentation has been posted to...

2006-12-05

1,453 reads

Excellent post on encryption

by Brian Kelley

Databases – Infrastructure – Security

Laurentiu Cristofor has an excellent blog post, Who needs encryption?, which presents some point blank facts about encryption and the...

2006-12-01

1,645 reads

Professional Association of SQL Server - Midlands Chapter First Meeting

by Brian Kelley

Databases – Infrastructure – Security

If you are in South Carolina or a nearby location (Charlotte, Augusta, etc.) and are interested in participating in an...

2006-12-01

1,577 reads

TechEd 2007 tracks announced

by Brian Kelley

Databases – Infrastructure – Security

The Microsoft TechEd tracks have been released early here:

Sneak Peak at the 2007 Tracks

For those who are interested in attending...

2006-12-01

1,484 reads

ApexSQL SQL Server VIP/MVP Offer

by Brian Kelley

Databases – Infrastructure – Security

ApexSQL has an offer to anyone who is a SQL Server MVP or VIP for a gratuity of their ApexSQL...

2006-11-29

1,741 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