Using SSIS to zip files and email the zipped files
I have often needed a means to send zipped files via email. This article shows one method to do just this.
Happy New Year 2010
The first day of 2010 has Steve Jones blooper reel in addition to some well wishes.
Happy New Year 2010
The first day of 2010 has Steve Jones blooper reel in addition to some well wishes.
Query Optimizer and Cartesian Products
In his continuing quest to bring a deeper understanding of Query Optimizer to the world at large, Fabiano Amorim takes a moment to point out a potential pitfall you may encounter. A light read, but one worth persuing.
A New Beginning
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
Pre Check List for 64 BIT SQL Server 2008 Cluster Installation
My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.
A New Beginning
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
A New Beginning
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
A New Beginning
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
Connection strings for SQL Server 2008
A set of different connection strings for using with different providers for SQL Server.
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