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

Day of Data Baton Rouge Slides and Code

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

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By Anthony Nocentino

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

We are product focused at Redgate Software. Here is another of our values that...

Read the latest Blogs

Forums

ALAMAT BCA KCU PONTIANAK Telp:083178278662

WA,CS:083178278662 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...

ALAMAT BCA KCU Karawang Telp:083178278662

By Layanan_BCA_24jam

WA,CS:083178278662 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang, Jawa Barat...

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server 2016 Plan

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)

What is returned?

See possible answers