SQLSaturday Finally Listed in PASS Connector
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,397 reads
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,397 reads
I've been following Steve's exploits trying to learn the podcasting business and we usually talk about it once a week...
2007-10-25
1,459 reads
Views are one of the more basic constructs in SQL Server, but often it seems that developers are not sure when to use them. SQL Server expert DBA and trainer Andy Warren brings us a look at views as an abstraction layer in your database.
2007-10-25
5,093 reads
This went up today and there is one great comment about possibly using snapshot isolation as an alternative to the...
2007-10-25
1,353 reads
If you do any coding in .Net using aspx pages you'll recognize this one. Each page has a title attribute...
2007-10-24
1,471 reads
Had a friend call me recently to ask about how to do this, had an nvarchar(2000) column that needed to...
2007-10-22
1,449 reads
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-21
1,834 reads
We're at 215 registered with 3 weeks to the big day! This week I'll be having the last planning meeting...
2007-10-21
1,459 reads
The most recent ACM Queue Magazine (Vol 5 #6, Sep/Oct 2007) had two really interesting articles. The first was about...
2007-10-21
1,500 reads
PASS is the global users group for SQL Server DBAs, but there are a number of people who have never heard of it. Longtime author Andy Warren has a few suggestions for PASS and encourages you to submit your own.
2007-10-18
2,034 reads
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Comments posted to this topic are about the item Where Your Value Separates You...
Comments posted to this topic are about the item Fixing the Error
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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