T-SQL Tuesday #005: Monitoring Reports with SSRS
This post is a T-SQL Tuesday Entry, hosted this week by Aaron Nelson on the topic of “Reporting”. (It got...
2010-04-13
1,056 reads
Seth Phelabaum
Bug: Reporting Services 2K8, SSMS and Windows 7
[Edit] Since writing this, I've realized that the true reason behind this was that my account was not a member...
2010-04-12
1,124 reads
SCSUG April Meeting Follow-up
The April meeting went well. I had hoped that the prospect of a couple of Technet subscriptions would increase attendance...
2010-04-12
399 reads
2010 Goals – First Quarter Review
Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.
Community...
2010-04-07
477 reads
Date Manipulation with DATEADD/DATEDIFF
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
37,125 reads
SCSUG April Meeting Reminder
A reminder to anyone in the Brevard County Florida area:
The SCSUG monthly meeting is at 6:30 on Thursday, April...
2010-04-06
293 reads
A T-SQL Holiday Message
Totally pointless, but fun. Run it to decode the message.
DECLARE @Message varchar(20)
SET @Message = '????????????'
DECLARE @Decode Table(
DSeq tinyint,
DKey smallint
)
INSERT INTO...
2010-04-03
718 reads
The Best vs. The Good Enough
When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient...
2010-04-02
445 reads
Blog Topics - Where do you draw the Line?
I started blogging a few months ago and since I started writing my own blog, I've been a much bigger...
2010-04-01
491 reads
DBCC INPUTBUFFER vs fn_get_sql
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog...
2010-03-28
8,771 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