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

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,881 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,492 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

832 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

626 reads

More on SQL Server Built-In Cryptography Options

by Brian Kelley

Databases – Infrastructure – Security

I wrote a series of articles at MSSQLTips.com to cover the cryptographic algorithms that are available with Microsoft SQL Server....

2013-08-02

861 reads

Thank you, Mr. Solomon

by Brian Kelley

Databases – Infrastructure – Security

On one of the newsgroups I follow, I received a message that David Solomon will no longer be teaching seminars...

2013-07-30

1,411 reads

Audio and slides are up for my webinar on SQL Server encryption

by Brian Kelley

Databases – Infrastructure – Security

The webinar audio and slides/demo scripts are up for the presentation I did for the PASS Security virtual chapter.

PASS Security...

2013-07-19

758 reads

Presenting for the new PASS Security Virtual Chapter on July 18

by Brian Kelley

Databases – Infrastructure – Security

The PASS Security virtual chapter is up and running thanks to the hard work of Argenis Fernandez (blog | twitter) and...

2013-07-17

1,269 reads

Dealing with Auditors: Password Settings

by Brian Kelley

Databases – Infrastructure – Security

Yet again I've seen an audit request where the auditor wants the DBA to show what SQL Server's settings are...

2013-06-19

8,233 reads

Blogs

Audit – Security Compliance Frameworks (Part 1)

By Vinay Thakur

This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...

Restore SQL Server Database to an OrbStack Container

By MarlonRibunal

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...

Day of Data Baton Rouge Slides and Code

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Read the latest Blogs

Forums

Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened

By Pablo Echeverria

Comments posted to this topic are about the item Can You Really Downgrade from...

What is CPU Usage?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is CPU Usage?

Limiting Checkpoints

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limiting Checkpoints

Visit the forum

Question of the Day

Limiting Checkpoints

If I use the -k parameter with a number after it, what does this change in SQL Server?

See possible answers