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-07
3,322 reads
Patrick LeBlanc
SQL Lunch #50 - Solitary Containment (An Overview of SSIS Containers)
Join us tomorrow on the SQL Lunch for a little SSIS.
Topic: #50-Solitary Containment - An Overview of SSIS Containers
If you’ve ever...
2011-03-02
752 reads
I travel, I work, I EAT
As most of you know I am a consultant with Pragmatic Works, which requires me to travel a bit. During...
2011-02-12
649 reads
Presentations: Slides and Demos
Over the past couple of weeks I have given several presentations. At each presentation I have promised to post the...
2011-02-09
658 reads
Second Book Available for Pre-Order
Over the past six months I have writing chapters for my next book. The book is titled SharePoint 2010 Business...
2011-02-07
765 reads
Speaking at the Houston SQL Server Users Group
Since I am working at a client this week in Houston, I begged Nancy Hide Wilson (President Houston SQL Server Users...
2011-02-07
591 reads
SSIS: Custom Folder in your Package Store
Recently at SQL Saturday #57 – Houston I explained how to add a custom folder to your SSIS package store. I...
2011-02-07
1,468 reads
The Many Faces of SQL Server
Well, one of my goals this year was to focus on branding myself a little more. So I decided to...
2011-02-03
445 reads
SQL Lunch - Introduction to Change Data Capture
Join me tomorrow for a little CDC.
#47-Introduction to Change Data Capture
Speaker: Patrick LeBlanc
Add To Outlook: Add To Calendar
Meeting URL:https://www.livemeeting.com/cc/usergroups/join?id=269DRP&role=attend
Date and...
2011-01-31
1,963 reads
SQL Saturday #57 Houston
So you don’t have anything to do this Saturday.Well, if you have an insatiable thirst for SQL knowledge like me,...
2011-01-28
468 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