SQL University: SQL Agent Jobs That Run at SQL Agent Start
Welcome to Security week at SQL University. I apologize for the late start. However, if you want to do some...
2011-10-27
2,953 reads
Databases – Infrastructure – Security
Understanding Kerberos, Part II
The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...
2011-10-18
4,053 reads
Understanding Kerberos, Part I
A get a lot of questions where I work about Kerberos and how it works for SQL Server, whether we're...
2011-10-17
4,306 reads
Speaking at the 2011 Carolina Technology Conference
On Tuesday, October 18, 2011, I will be speaking at the Carolina Technology Conference in Columbia, SC. I'm scheduled for...
2011-10-14
1,407 reads
Cloud? Chotto Matte Kudasai.
If you're not familiar with Chotto matte kudasai, it means "A moment, please," in Japanese. The cloud is big news....
2011-10-14
1,208 reads
A Disturbing Trend: Government Sponsored Malware
It is understandable that nations may undertake operations against other nations. This is believed to be the origin of StuxNet...
2011-10-13
939 reads
Piiiiiiiigs, er DBAs, in Space!
If you don't get the reference, it was a set of skits on the old Muppet Show and it starred...
2011-10-13
994 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,298 reads
PASS Summit Attendees: Remember to Network and Maintain
Previously, when I had attended conferences, I had used them to attend as many seminars or talks as I could...
2011-10-10
1,412 reads
Advanced Persistent Threats and Us
In a blog post from last year, Richard Bejtlich (blog | twitter) talked about a concept called an Advanced Persistent Threat...
2011-10-07
1,320 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