MCM – The Knowledge Exam
I recently took the knowledge exam, and I loved it. I thought it was a great exam. I have taken...
2011-03-11
1,674 reads
Blogs
SSRS: My Filter is not Working!!!
I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the...
2011-03-09
2,616 reads
SSRS – Creating and Using Shared Schedules Part 4
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-09
1,154 reads
Changes to the SSIS Slowly Changing Dimension Component
Probably not the kind of change you're expecting. I've recently been contacted by the Kimball Group, and they've asked me...
2011-03-03
2,559 reads
Some Suggested SQL Server 2008 R2 Instance Configuration Settings
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-03-02
2,690 reads
5 Things Every DBA Should NOT Do
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
2011-03-01
5,946 reads
Fundamentals of Storage Systems, IO Latency and SQL Server
A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...
2011-03-01
3,045 reads
Emailing tempdb Query Results to Paul Randal with PowerShell
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
2011-02-28
1,959 reads
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-28
2,838 reads
Renumbering Rows in a Table Variable (or Table/Temp Table)
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...
2011-02-24
2,097 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