Liveblog for #SQLBits X Day 1 Keynote
Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your...
2012-03-30
1,612 reads
John Sansom
SQL Server Crossword #4
To mark my 31st Birthday today(gifts are of course most welcome) here’s a SQL Server Crossword for you to enjoy. You...
2012-03-21
977 reads
What SQL2012 Feature Are You Excited About the Most?
Last week the internet went crazy with the news of super cool new stuff for techies to play with.
If you’re...
2012-03-13
881 reads
What Does a Database Administrator Actually Do?
Most people in your organisation, never mind everyone else, have no real clue as to what it is you do.
It’s...
2012-03-05
1,649 reads
Script SQL Server Agent Jobs Using PowerShell
It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is...
2012-02-29
4,742 reads
How To Write an Interview Winning CV
Writing a CV that rocks is not an art. It just requires some planning and an understanding of what you...
2012-02-24 (first published: 2012-02-21)
3,605 reads
Your Road to Becoming a DBA: Getting Organised
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-02-17 (first published: 2012-02-13)
2,324 reads
Why Every DBA is a Clown
It’s late, really late and you’ve got a mountain of work to get through to meet the deadline. To add...
2012-02-06
978 reads
Your Road to Becoming a DBA: Acquiring Experience is Key
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-02-01
1,066 reads
Your Road to Becoming a DBA: Laying a Strong Foundation
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-01-31
2,137 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