Rant: Security Isn't Sexy and It's a Shame
I grew up immersed in security. My father was a US Marine and going on and off base meant... security....
2011-08-03
1,231 reads
Databases – Infrastructure – Security
Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings
We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...
2011-08-02
15,667 reads
Bad Admins: Non-Production Servers
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-28
2,174 reads
Bad Admins: Taking Advantage of Maintenance Periods
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-25
1,059 reads
Bad Admins: Stealing the SQL Server Service Account
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-22
1,369 reads
Gaining Speaker Experience Credentials, Part II
In a previous post I gave suggestions on how to get speaking credentials for consideration at a larger event, such...
2011-07-21
940 reads
Bad Admins: Pocketing Backups
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-21
728 reads
Bad Admins: Stealing An Account
Yesterday I posted about manipulating group membership to get access to a SQL Server. Today comes attack vector #2: stealing an...
2011-07-14
1,190 reads
Bad Admins: Attacking via Group Membership
This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...
2011-07-13
1,873 reads
Gaining Speaker Experience Credentials
One of the things I saw on Twitter yesterday was several folks saying their abstract submissions had been turned down...
2011-06-16
1,887 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