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 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,098 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,988 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,871 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,665 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

830 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

614 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

852 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,402 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

750 reads

Blogs

Flyway Tips: AI Deployment Script Descriptions

With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...

A New Word: Fawtle

fawtle – n. a weird little flaw built into your partner that somehow only...

Post-quantum key exchange – Insurance policy for your packets

By anup.varier@gmail.com

AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...

Read the latest Blogs

Forums

Where Your Value Separates You from Others

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Where Your Value Separates You...

Fixing the Error

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fixing the Error

T-SQL in SQL Server 2025: Encoding Functions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Fixing the Error

On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:

SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';

I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error?

See possible answers