DATEDIFF vs. DATEADD
Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates...
2017-01-25
13,207 reads
Superman
SQL Server DBA Tips that Can Save Your Ass
On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was...
2016-12-12
381 reads
A Recap of PASS Summit 2016
Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I...
2016-10-31
891 reads
Machine Learning – What is It Good For?
Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it,...
2016-10-20
417 reads
Recap of My 24HOP Session – From XML to JSON
Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...
2016-09-08
206 reads
Why Would I Want to Use JSON in SQL Server?
SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...
2016-09-04
641 reads
Query Timeout of the Distribution Agent
Last week I got a call from one of our clients. They issued an ALTER TABLE command in order to...
2016-08-22
3,778 reads
SQL Server 2016 Cumulative Update 1
On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to...
2016-08-04
323 reads
Who the Hell is Going to Listen to SQL Server on the Radio
About 3 years ago Matan Yungman contacted me and said he has an interesting proposition. We met and talked about...
2016-07-21
281 reads
We Must Wait for SP1 before Upgrading to SQL Server 2016
This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016
I’ve been...
2016-06-14
256 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