What Would You Like to See in a New Book on Indexing?
I am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice...
2010-01-20
417 reads
I am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice...
2010-01-20
417 reads
My new eBook, Brad’ Sure Guide to SQL Server Maintenance Plans is now available as a free, 269 page PDF...
2010-01-14
1,776 reads
Not every DBA has the time to sit down and spend a couple of hours learning about some new topic...
2010-01-14
437 reads
When you create a SQL Server Maintenance Plan using the Maintenance Plan Wizard or the Maintenance Plan Designer, the SQL...
2010-01-13
1,589 reads
The PASS SQL Server Standard has published a new article called “Busting 6 SQL Server Failover Clustering Myths”, by Kathi...
2010-01-13
378 reads
Reprinted from my editorial in Database Weekly.
In the course of my job, I get to give a lot of presentations,...
2010-01-11
365 reads
The SSMS maintenance plan wizard is shunned by many DBAs, but Brad McGehee has come to view it as a perfectly valid and viable tool, especially for part-time or accidental DBAs, or those just finding their feet in the role.
2010-01-11
247 reads
This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008.
I think most of us are...
2010-01-05
1,908 reads
Since I wrote the first part of this blog series, SQLServerCentral.com (SSC) SQL Servers have been upgraded, and performance is...
2010-01-03
892 reads
I have always liked information presented to me in lists. Lists are simple, straight-forward, and to the point. If you...
2009-12-23
626 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