T-SQL Tuesday #47: My Best SQL Server SWAG
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-10-08
1,214 reads
Kendal Van Dyke
T-SQL Tuesday #47: Your Best SQL Server SWAG
The Stuff We All Get!
Fall has arrived which means it's conference season: Connections is happening this week, the PASS Summit...
2013-10-07 (first published: 2013-10-03)
1,664 reads
A Tainted PASS Elections
Another PASS Board of Directors election cycle has come and gone, and with the results now announced I'd like to...
2013-10-02
844 reads
Practical PowerShell: Merge SQLSaturday Speaker SpeedPASSes Into One PDF
To make things easier on speakers prior to a SQLSaturday organizers are encouraged to print & cut their SpeedPASSes ahead of...
2013-09-19
1,399 reads
24 Hours Of PASS: 2013 Summit Preview Starts In Less Than 24 Hours!
If you like free SQL Server training you're in luck – starting at 12:00 PM GMT/8:00 AM EDT, July 31 (that's...
2013-07-30
1,343 reads
Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break
We all know that we should document our SQL Servers, right? RIGHT?
So let's say you had some time on...
2013-04-24 (first published: 2013-04-11)
3,803 reads
SQL Power Doc Update - Version 1.0.1.0
A quick note to let you know that SQL Power Doc version 1.0.1.0 is now live. This release fixes issues...
2013-04-24
1,019 reads
T-SQL Tuesday #41 - Presenting Opens Doors
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-04-09
956 reads
T-SQL Tuesday #39 - Use PowerShell To Copy A Database To Another Instance
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-02-12
2,011 reads
Transactional Replication Toolbox Scripts: Show Articles And Columns For All Publications
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have...
2013-02-05 (first published: 2013-01-29)
2,753 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