Currently we have have the COVID-19 pandemic sweeping the world. Here in New Zealand we are currently in lockdown – what this means is that we Kiwis are required...
2020-03-31
95 reads
Hi, I’m Hamish Watson and I am running for the PASS Board of Directors: https://www.pass.org/Governance/Elections.aspx This blog post is why I decided to run for the board, why I...
2019-11-06
21 reads
So I started blogging in 2016: So why blog….now? It is very interesting going back and reading that first blog post. It was mostly thanks to my late great...
2019-10-21
27 reads
This blog post is how to get git going after upgrading to Catalina (10.15). I use git as a method of storing all my presentations and work files. It...
2019-10-19
1,769 reads
This blog post is about the situation where after upgrading to the latest macOS version 10.15 – also known as Catalina – you may not be able to share...
2019-10-18
54 reads
This blog post is around the changing landscape of both SQL Server and the people who are our trusted guardians of it – DBAs. If you have been involved...
2019-07-22
284 reads
This blog post is about a situation that initially perplexed me – I was installing SQL Server 2017 onto a new DEMO machine – running Windows Server 2019. This...
2019-07-19
28,206 reads
So in January I wrote a blog post on some goals I had this year: Some of my goals for 2019 It’s now July – how are things going?...
2019-07-19
14 reads
This blog post explains how to get into SQL Server if you have lost your sa password or you have...
2019-03-11 (first published: 2019-02-23)
4,541 reads
This blog post is not going to be a technical one…. but it’s about technology – well more accurately about bringing...
2019-03-07
290 reads
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Comments posted to this topic are about the item Where Your Value Separates You...
Comments posted to this topic are about the item Fixing the Error
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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