Win at IT Contracting: The recruitment Agent Business Model
WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships
Welcome to WIN at IT contracting: A...
2018-03-08
521 reads
Gethyn Ellis
What do recruitment agents do for contractors?
WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships
Are you...
2018-03-01
375 reads
Azure SQL Elastic Pools
In this video tutorial David talks you through the benefits of Azure SQL Elastic pools. Elastic pools allow you to...
2018-02-21
725 reads
Renaming a local windows login after SQL Server Computer Name Change
I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server...
2018-01-25 (first published: 2018-01-15)
7,121 reads
SCOM: SQL Instance and Databases exclusion
This post is by Chris Gibson
I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM...
2018-01-10
1,364 reads
Patching your SQL Servers - Meltdown and Spectre
The latest security issue with the name "Meltdown and Spectre" affecting Intel processors was made public last week. This security...
2018-01-08
612 reads
What is the oldest version of SQL Server you are running?
I have a twitter poll running asking "What is the oldest version of SQL Server you are running?", to use...
2018-01-03
422 reads
New Year: 2017 Year in Review
Welcome to gethynellis.com and our final post of the year.
SQL Server 2017 - In Review
It’s the end of what has been...
2017-12-30
580 reads
An Introduction to Azure SQL Databases
This David's SQL Server Saturday talk titled an introduction to Azure SQL Databases
It does pretty much what is says on...
2017-12-08 (first published: 2017-11-28)
2,245 reads
Monitoring and Alerts with Azure SQl Database
Continuing with the Azure SQL Database theme, in this short video David demonstrates how to setup alerts for an Azure SQL...
2017-12-04 (first published: 2017-11-22)
1,171 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