Resolution to “Connection Timeout Expired. [Pre-Login] initialization =18090; handshake=14281” error
This blog post is about a SQL Server connection issue that presents itself:
We were building an Availability Group (AG) at...
2017-04-20
428 reads
HeyMo0sh
Can I tune the tempDB of an Azure based SQL Server database…
Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...
2017-04-02
385 reads
How to grow the exposure of a Data Platform based conference (SQL Saturday South Island)
SQL Saturday conferences are awesome.
That is the opening line of this blog post – because it’s true and understated.
If you’re reading...
2017-04-01
221 reads
Answer to “Could not locate file ‘xxx_Log’ for database ‘xxx’ in sys.database_files”
This blog post is a form of resolution to the issue of not being able to shrink a transaction log...
2017-03-24
226 reads
Having OCD in Azure…
Everyone gives OCD a hard time. When in fact it is something to embrace.
I am of course talking about Operational...
2017-03-22
250 reads
I like data – so Azure SQL is (initially) my focus..
My journey with Azure has been around what it can do for me – and the company I work for (Jade...
2017-03-22
211 reads
Using Azure CLI to do stuff….
For this post I am going to talk about one of the methods I use to manage my Azure resources.
The...
2017-03-21
327 reads
Blogs
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Plan your 2026
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
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