Do You Use Projects/Solutions in SSMS?
When SQL Server 2005 was released Microsoft made a major change to the client tools provided with SQL Server, moving...
2009-12-10
1,773 reads
Jack Corbett
- Interests: Sports, books, Bible
OPASS December Meeting Recap
This was the first meeting where I really lead most of the meeting. Andy Warren (@sqlandy) did the networking at...
2009-12-09
363 reads
T-SQL Tuesday #001 – Dates and Times
T-SQL Tuesday was started by Adam Machanic (@AdamMachanic) on his blog to encourage SQL Bloggers to share their tips and...
2009-12-08
462 reads
Good Programmer = Lazy & Dumb?
Alternative title for programmers using C-derivatives and Java:
Good Programmer == Lazy & Dumb?
I read this blog post, Why Good Programmers Are...
2009-12-07
662 reads
Book Review: Apress Pro SQL Server 2008 Administration
Several months ago I received a copy of the Apress book, Pro SQL Server 2008 Administration (Amazon)by Ken Simmons (@kensimmons),...
2009-12-04
975 reads
Maintaining Security and Performance Using Stored Procedures Part II – Signing
Well, it has been a couple of weeks since my last blog post and over a month since Maintaining Security...
2009-11-30
1,647 reads
PASS Summit 2009 – Wrap-up – What’s the Value?
I’ve already written four posts (1, 2, 3, 4) that discussed what I did at the Summit, including what I...
2009-11-09
415 reads
PASS Summit Day 3 – Brain on Overload
After the first 2 official days of the Summit the brain is already on overload and then the second part...
2009-11-07
542 reads
Let the Learning Begin
Finally time for the sessions to begin after a day and a half in Seattle being overwhelmed by the people...
2009-11-05
730 reads
PASS Summit Day 2 – What More Can I Learn
I actually slept in on Wednesday until 6am. This was a change from being wide awake at 4am. I made...
2009-11-05
534 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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