In Boston for TechEd
This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...
2006-06-11
1,491 reads
Databases – Infrastructure – Security
Two things I wish they'd change about endpoints in SQL Server 2005
I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...
2006-05-27
2,144 reads
When It Takes Time...
Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:
Project Managing Latency or: How to...
2006-05-25
1,450 reads
Disaster Recovery and SQL Server, Part II
In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...
2006-05-24
1,495 reads
SQL Prompt
I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...
2006-05-23
1,622 reads
Disaster Recovery and SQL Server, Part I
The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...
2006-05-20
1,649 reads
Backing up virtual machines on VMware ESX Server
I know VMware and Virtual Server
technology is becoming more and more prevalent in organizations as both
packages can greatly reduce hardware...
2006-05-17
1,614 reads
Nice Article on Security Myths in May/June 2006 Issue of TechNet Magazine
The May/Jone 2006 issue of TechNet Magazine has a feature on security. One of the articles is titled Deconstructing Common...
2006-05-12
1,531 reads
Review of SQL Server 2005 Integration Services, Part 1 of 4
Back in First Impressions of Professional SQL Server 2005 Integration Services,
I indicated I felt the book was worth the buy...
2006-05-10
1,457 reads
Excellent article on cracking SQL Server passwords
The SQLServerAdvisor mailing from SearchSQLServer.com had a link to a
very good article on cracking SQL Server passwords. The article, by
Kevin...
2006-05-09
1,595 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