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

Upcoming Online Training for the Week of February 18, 2013

by Brian Kelley

Databases – Infrastructure – Security

I used to compile a list of online training for the following week and posting it on Fridays. I stopped...

2013-02-14

1,009 reads

Avoid This Time Scheduling Mistake

by Brian Kelley

Databases – Infrastructure – Security

I was recently asked by a project manager to lay out when DBAs would accomplish certain tasks for a particular...

2013-02-07

1,412 reads

Consider All the Possibilities When Troubleshooting

by Brian Kelley

Databases – Infrastructure – Security

When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...

2013-01-28

1,670 reads

Cash Over Credit

by Brian Kelley

Databases – Infrastructure – Security

What does cash over credit have to deal with security? An awful lot, as it turns out.
Personal Story: Mere days...

2013-01-17

1,211 reads

Observe Carefully When Things Are Running Fine

by Brian Kelley

Databases – Infrastructure – Security

Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...

2013-01-14 (first published: 2013-01-10)

2,152 reads

Rename the SQL Server Management Studio shortcut

by Brian Kelley

Databases – Infrastructure – Security

Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...

2013-01-11

7,787 reads

Speaking at Midlands PASS in February

by Brian Kelley

Databases – Infrastructure – Security

On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...

2013-01-10

962 reads

Re-Awarded as a Microsoft MVP

by Brian Kelley

Databases – Infrastructure – Security

Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....

2013-01-02

1,188 reads

Looking Forward to the New Year - Professional Goals

by Brian Kelley

Databases – Infrastructure – Security

Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....

2013-01-01

1,307 reads

Are You a Chessplayer?

by Brian Kelley

Databases – Infrastructure – Security

I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...

2012-12-17

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