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

First Heroes Happen Here (HHH) Comic

by Brian Kelley

Databases – Infrastructure – Security

Microsoft and Seagate have partnered togethered to put together an IT Heroes comic (daily even). The first one is here:
...

2008-01-29

1,561 reads

Ken Henderson has passed away

by Brian Kelley

Databases – Infrastructure – Security

I know I'm not the first in the SQL Server community to post this, but Ken Henderson has passed away...

2008-01-29

1,908 reads

Part II of Troubleshooting Memory Issues

by Brian Kelley

Databases – Infrastructure – Security

The Windows Server Performance Team has published part 2 of troubleshooting memory issues.
This one covers excessive paging and memory...

2008-01-29

1,668 reads

Citrix Presentation Server Becomes XenApp

by Brian Kelley

Databases – Infrastructure – Security

Citrix is changing the name of its flagship product from Citrix Presentation Server (CPS) to XenApp. More from the blogosphere:
Citrix...

2008-01-28

1,989 reads

Metasploit 3.1 is out

by Brian Kelley

Databases – Infrastructure – Security

The new version of Metasploit is out. Included is a GUI interface. It's a complete re-write in Ruby (note to...

2008-01-28

1,512 reads

Microsoft .NET Framework 3.5 Deployment Guides available

by Brian Kelley

Databases – Infrastructure – Security

Saw this first on Aaron Stebner's blog:
.NET Framework 3.5 deployment guides have been published on MSDN
Guidance information for both...

2008-01-28

1,557 reads

Microsoft Security Webcast

by Brian Kelley

Databases – Infrastructure – Security

This one is geared towards IT management:
IT Manager Webcast: Dynamic IT and Security (Part 4 of 5): Identity and Access...

2008-01-28

1,650 reads

Vendor Neutral Database Certification

by Brian Kelley

Databases – Infrastructure – Security

First saw this off of Planet MySQL:
New Vendor Neutral Database Certification (Dave's Stuff)
Following the link to the CIW site, there...

2008-01-28

2,865 reads

Inexpensive Video Training from Internals Expert, Kalen Delaney

by Brian Kelley

Databases – Infrastructure – Security

I saw this in my blog reader today:
You can pre-order the Kalen Delaney SQL Server Internals Course - Lesson 1 DVD...

2008-01-25

1,071 reads

New Technique to Steal From Baggage

by Brian Kelley

Databases – Infrastructure – Security

I first saw this on funsec security discussion list:
Dwarves zipped in
suitcases steal from Swedes

The gist of the story...

2008-01-25

782 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