Password Insecurities
Tony Davis argues that the Standards and best practices exist to avoid being hacked, but implementing them requires time and investment and often there simply doesn't seem to be the will to do it.
2012-11-26
114 reads
Editorial
Review Your Indexing
Today Steve Jones reminds us that we should analyze and re-evalute our indexing strategy on a regular basis.
2012-11-26
306 reads
The SQL Server Pro Awards
Phil Factor is pleasantly surprised by the SQL Server Pro awards, and talks about the thinking behind Down Tools Week.
2012-11-23
168 reads
2012-11-22
153 reads
The Small Print
In today's guest editorial, Phil Factor issues a stark warning against cunning salesmen and hidden costs in cloud computing.
2012-11-21
124 reads
A Tool for the Job
Phil Factor is puzzled by reading how difficult a relatrional database is to use for certain tasks.
2012-11-20
201 reads
SSD Lifetimes
This week Steve Jones looks at the expected lifetimes of SSDs and finds one that might be a nice upgrade for your system.
2012-11-19
255 reads
The Cost of Storage
As DBAs we constantly need more storage, but do we know what the impact or cost of this storage is to our employers? Answer this week's poll.
2012-11-16
136 reads
Failure Lessons
Steve Jones would like to see more disclosure about what works and doesn't work when deploying new systems and software.
2012-11-15
124 reads
The Future of DBAs
What's the future for DBAs with cloud services and computing? Steve Jones talks about what might be coming soon.
2012-11-14
345 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