The HUGE announcement at Microsoft Build yesterday was Microsoft Fabric (see Introducing Microsoft Fabric: Data analytics for the era of AI), now available in public preview. I have been...
2023-06-12 (first published: 2023-05-24)
533 reads
In SQL Server you can also compress your encrypted backups. Unlike TDE this has been possible with Backup Encryption since the feature was first made available, and there have...
2023-06-12 (first published: 2023-05-24)
355 reads
There is a scenario I have seen again and again. A company has developed a nice piece of software which many clients are running with happily. Then along comes...
2023-06-12
17 reads
Hello Dear Reader! Let's address the missing week. Last week I was really behind due to the move. We did not have a Monday video and despite my best...
2023-06-12
17 reads
slipfast adj. longing to disappear completely; to melt into a crowd and become invisible, so you can take in the world without having to take part in it –...
2023-06-09
83 reads
For those that attended my talk at Denver Dev Days, here are the slides: BloggingFortheTechPro.pptx A couple interesting questions that I need to add to the deck. What do...
2023-06-09
11 reads
As a part of my AI experiments, I decided to ask CoPilot to write some unit tests. Here is what happened. The Prompt To get started, you enter a...
2023-06-09
57 reads
I ran across an interesting post from Rita Fainshtein that looked at the different types of graphs for a set of data. I thought that was interesting, so I...
2023-06-09 (first published: 2023-05-22)
450 reads
I have been living with ALS for the past two years. I was diagnosed in September 2022 but had my first symptoms and started researching what was going on...
2023-06-09 (first published: 2023-05-25)
124 reads
I am proud to announce the launch of a new book, centered around the importance of SQL, authored by six consultants from 3Cloud. Our new book is called “SQL...
2023-06-07
20 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