Invitation to startup meeting for PASS Scania and SQLUG
A new user group in Sweden. Read for more details.
Optimising “Ends With” searches with REVERSE
A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text
All About the Crosstab Query
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
That DARN TOMCAT
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
Why Can't We Go Backwards?
How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.
Why Can't We Go Backwards?
How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.
Why Can't We Go Backwards?
How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.
Goal Tuesday
Almost halfway into the first month of the new year, Steve Jones reminds us of the power of goals. Today he encourages you to set up your own goals for the coming year.
Run SSIS packages from remote client with stored procedure
By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.
10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
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