Restoring a SQL Server Database in Docker
Last month I blogged about using Docker to run SQL Server as a quick and easy way to get SQL Server up and running. While it continues to be...
2020-06-19
9 reads
John
- Website: https://sqlrus.com
Quickly Blocking Inbound Connections to SQL Server
Sometimes the brilliance of a solution is lost in its simplicity. Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has given me permission to blog about...
2020-06-04 (first published: 2020-05-22)
538 reads
Quickly Blocking Inbound Connections to SQL Server
Sometimes the brilliance of a solution is lost in its simplicity. Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has given me permission to blog about...
2020-05-22
4 reads
Running SQL Server on my Mac with Docker
My day to day work machine is a Windows 10 HP laptop. It remains docked at my desk where it happily helps me to go about my daily business. ...
2020-05-14 (first published: 2020-05-01)
402 reads
Working from Home Effectively
Some of us have been lucky enough to have already been working from home (WFH) prior to the world events. This has allowed most of us the ability to...
2020-05-06 (first published: 2020-04-24)
603 reads
Running SQL Server on my Mac with Docker
My day to day work machine is a Windows 10 HP laptop. It remains docked at my desk where it happily helps me to go about my daily business. ...
2020-05-01
8 reads
Working from Home Effectively
Some of us have been lucky enough to have already been working from home (WFH) prior to the world events. This has allowed most of us the ability to...
2020-04-24
131 reads
Azure SQL Database: Great Choice for Modern Cloud Applications
Microsoft offers several options for moving your SQL Server workloads to Azure. If you’re looking to host modern cloud applications, your best option is Azure SQL Database Service. For...
2020-03-27
179 reads
Changing How I Write Abstracts
Sometimes a swift kick in the rear is needed to become motivated. Recently, I was the recipient of the business end of a boot and it drove me to...
2020-03-06
3 reads
Happy New Year!
Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this...
2020-01-03
7 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