Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-10-02
2,012 reads
Kendal Van Dyke
Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-09-29
1,849 reads
SSMS "Connect to Database Engine" Prompt Behavior When Dragging And Dropping Files
A minor annoyance of mine for a long time has been how SSMS will sometimes prompt you to connect to...
2009-09-17
378 reads
Networking While On Vacation
There's been a lot of attention given to professional networking (e.g. Andy Warren's blog posts) recently and if you recall...
2009-09-15
600 reads
How To Get Table Row Counts Quickly And Painlessley
Just a quick note to call out that I've had an article posted on SQLServerCentral that shows how to retrieve...
2009-09-02
444 reads
Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?
Code Outlining has been part of Visual Studio since VS.NET 2002. If you're not familiar with it, code outlining is...
2009-08-04
465 reads
Things You Need To Know If You Use DFS Replication
In addition to being a SQL DBA I'm also a network administrator, or at least I pretend to be. This...
2009-07-31
2,786 reads
SQL Logins For Windows Domain Accounts Limited To Pre-Windows 2000 Format
You may have noticed that when you create a login on a SQL server that's mapped to a Windows domain...
2009-07-28
652 reads
Interested In *Free* SQL Training? Attend A SQL Saturday Near You!
Can't make the PASS summit? Or maybe you're going but looking for something whet your appetite between now and November....
2009-07-27
754 reads
So You Want To Meet People At PASS…But What Do You Say?
Going to the PASS Summit this November? Let's fast forward and pretend it's November 2. You've made it to Seattle...
2009-07-23
514 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