An In-Depth Examination of Red Gate SQL Monitor
A review of SQL Monitor, the new DBA utility from Red Gate Software that can help you keep an eye on what your SQL Server instances are doing.
2011-02-14
3,747 reads
Adam Machanic
- Interests: RDB theory, VLDB, query optimization
2005-08-08
1,254 reads
A Guide to SQL Server 2000 Transactional and Snapshot Replication
Two MVPs at one shot in this one. SQL Server MVP Hilary Cotter has written a book on replication, one of the very few there are on this topic. And it's presented as a review by MVP Adam Mechanic, a regular visitor to SQLServerCentral.com. If you're looking for replication help, check out this book.
2005-04-13
7,221 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
Bali trip
A bali trip is a dream vacation for travelers who want to experience beautiful...
Bali trip
A bali trip is a dream vacation for travelers who want to experience beautiful...
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
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