Windows 7 to be released next month - SQL Server related info...
I wanted disseminate some news to our DBA audience regarding the long anticipated release of Microsoft's new operating system, Windows...
2009-09-14
1,002 reads
Robert Pearl
September 11 - Never Forget - My story of the tragic day..........
I was sitting going through some of my materials, scripts, emails and news feeds to find a worthy topic for...
2009-09-10
1,327 reads
Labor Day Comes and Goes as Unemployment Grows......
Labor Day, which marks the unoffical end of Summer in the U.S., is particularly poignant in light of the news...
2009-09-08
849 reads
Job Market Update and some Job Search Advice…..
Job Market Update and some Job Search Advice…..
Not too long ago, I posted a blog on the possible thawing of...
2009-09-04
1,411 reads
Decompressing on Compression in SQL Server 2008....
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
2009-09-02
2,756 reads
Decompressing on Compression in SQL Server 2008....
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
2009-08-31
9,515 reads
Looking for a Laptop......
Now that the kids have interest in computers, I sometimes find myself competing with them. I recently purchased a business class...
2009-08-29
1,359 reads
Database Mirroring Across Domains, Using Certificates.....
Database Mirroring w/o a Domain, Can be a Pain - but it can be done......
Have you ever had to setup mirroring...
2009-08-25
6,523 reads
SOX in the City - Preparations for Audit
As I was going through some of my documentation at past clients, I found my summary of the general SOX...
2009-08-23
2,460 reads
I/O I/O - It's why my server's slow.....Examing I\O Statistics
I/O I/O - It's why my server's slow.....
Often I've been curious about ways to measure the performance of SQL Server, and...
2009-08-20
4,229 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