Are you ready to take your SQL skills from theoretical to tactical? If you've been yearning for a risk-free environment to test, experiment, and refine your SQL queries against...
2024-07-17 (first published: 2024-07-06)
362 reads
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a career game-changer. Companies crave professionals who can wrangle data, uncover insights, and drive decision-making. If...
2024-06-16
81 reads
Dreaming of a data analyst career but feeling a little lost? Already playing with data at work and craving the bigger picture? Or simply looking for a solid read...
2024-06-08
126 reads
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with LearnSQL's special offer. For the entire month of June 2024, they are giving away their...
2024-06-04
53 reads
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge. Dive into a real-world gym database and help Christine, the gym's manager, wrangle her data....
2024-06-01
59 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers to questions that can drive your business forward. To unlock this potential, you need the...
2024-05-27 (first published: 2024-05-07)
375 reads
If you're a data analyst, you already know that SQL isn't just a nice-to-have skill – it's the bedrock of your work. But let's face it, SQL isn't a...
2024-05-25 (first published: 2024-05-24)
56 reads
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative data career or just want a new skill under your belt, learning SQL is a...
2024-05-21
90 reads
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights. They condense multiple rows into single, meaningful values, making it easier to grasp the big...
2024-05-15
332 reads
The world of databases keeps growing, and the pressure to extract meaningful insights from that data increases just as fast. If you work with data, you know that SQL...
2024-05-15 (first published: 2024-05-01)
1,195 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