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

Good Advice on "Certification"

by Brian Kelley

Databases – Infrastructure – Security

Buck Woody (blog | twitter) is often seen as one of the wise men of the SQL Server community and with...

2013-09-13 (first published: 2013-09-10)

2,636 reads

Database DoS Whitepaper from Securosis

by Brian Kelley

Databases – Infrastructure – Security

Securosis has released a whitepaper on their research with regards to database denial-of-service attacks. This whitepaper is platform agnostic. It...

2013-09-11

2,028 reads

Sometimes I don't understand Microsoft's vulnerability classifications

by Brian Kelley

Databases – Infrastructure – Security

Here's a great example:

MS13-079 - Vulnerability in Active Directory Could Allow Denial of Service (2853587)

Basically, this patches a vulnerability where an...

2013-09-10

1,878 reads

Good Intro Podcast on Hadoop

by Brian Kelley

Databases – Infrastructure – Security

Have you heard about Hadoop but don't know much about it? What about "big data?" Would you like an intro...

2013-09-09 (first published: 2013-09-03)

2,099 reads

Is Microsoft's Certification Program Value Microsoft's Fault?

by Brian Kelley

Databases – Infrastructure – Security

I'd be interested if anyone says, "No," to that question. Gail Shaw raised a few points in this post about...

2013-09-04

1,989 reads

Before Asking for Help...

by Brian Kelley

Databases – Infrastructure – Security

I have a standard rule that I use before going and bugging a co-worker or posting via social media/message forum about...

2013-08-29

1,872 reads

Specify the Parameter Names for Stored Procedures

by Brian Kelley

Databases – Infrastructure – Security

I just ran across a case where a script was failing. Here's the part that's failing:

EXEC sp_addrolemember 'MyDomain\MyGroup', 'SomeRole';
GO
Do...

2013-08-27 (first published: 2013-08-23)

4,483 reads

Schneier's Thoughts on the Future of IT Security and the Impact of the Internet on Power

by Brian Kelley

Databases – Infrastructure – Security

If you've got an hour to spare, you might want to check out this presentation by Bruce Schneier where he...

2013-08-23 (first published: 2013-08-15)

1,666 reads

Boorish Behavior? No, Worse. Death Threats Against Developers/Designers.

by Brian Kelley

Databases – Infrastructure – Security

I know DBAs and developers have a rocky relationship. However, I don't believe we go as far as some of...

2013-08-16

831 reads

Windows Phone Security Advisory - Weakness in Security Protocol

by Brian Kelley

Databases – Infrastructure – Security

If you're using a Windows phone, versions 7.8 or 8, there is a new security advisory out with respect to...

2013-08-06

615 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