2009 PASS Summit Presentation Results
I opened my inbox Wednesday morning to find the evaluation results for my presentation on Transactional Replication at the 2009...
2010-01-07
414 reads
Kendal Van Dyke
10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
2010-01-06
706 reads
My Biggest Weakness
I took some time off in December and I'm finally getting around to catching up on RSS feeds. Turns out...
2009-12-31
1,514 reads
Saying Goodbye To 2009
I'll close out 2009 with an update on the goals I set at the beginning of this year and things...
2009-12-31
1,394 reads
Fix The Problem, Don't Just Band-Aid It
Let's face it, when it comes to computers there's a 100% certainty that something is going to break eventually. Maybe...
2009-12-03
582 reads
What It Means To Be A Production DBA
Remember that scene from Office Space where the Bobs ask, "What would you say you do here?" I've been a...
2009-12-02
537 reads
Replication Scripts: Show All Transactional Publications & Subscribers At Distributor
Anybody who has talked with me about replication or heard me present about it knows that I recommend using a...
2009-11-23
635 reads
PASS Summit 2009 Final Thoughts…or What I've Learned From The 2009 Summit
Last week I wrote a day by day recount of my PASS Summit experience (Monday, Tuesday, Wednesday, Thursday, Friday). Since...
2009-11-20
713 reads
Looking Back – PASS Summit 2009 Day 5
Since this was my time visiting Seattle I opted to stay an extra day and take in the sights and...
2009-11-13
591 reads
Looking Back – PASS Summit 2009 Day 4
Thursday started off with a meeting of the SQL Saturday minds over breakfast at Top Pot Donuts a few blocks...
2009-11-12
877 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