To Script or Not To Script
When approaching an automation problem the first questions you must answer is whether you should even invest the time to...
2011-03-15
687 reads
Chad Miller
Restore and Relocate Database Files Using PowerShell
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
2011-03-14
7,856 reads
SQLPSX 2.3.2.1 Release
We’ve released a minor update to SQLPSX which includes includes several bug fixes/enhancements as well as one new module. Here’s...
2011-03-13
1,027 reads
T-SQL Tuesday #15 Automation and the SSIS Dumper
This post is my contribution to T-SQL Tuesday, hosted this month by Pat Wright (blog | twitter).
In my previous post...
2011-02-08
1,056 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-07
3,226 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-03
11,053 reads
Tampa IT Camp Saturday
The first annual Tampa IT Camp will be held on Saturday, March 19th 2011.
What’s an IT Camp?
In the...
2011-01-22
570 reads
SQL Saturday #62
I presented a one hour session at SQL Saturday #62 in Tampa on SQL Server PowerShell Extensions (SQLPSX): “In this...
2011-01-15
417 reads
Making an Operations Manager Module
Operations Manager 2007 R2 ships with Operations Manager Shell which is simply a provider with associated cmdlets for working with...
2011-01-04
852 reads
Windows Cluster Scripting with WMI and PowerShell
Windows 2008 R2 includes a failoverclusters PowerShell module, but you’ll probably find normal usage limiting for several reasons:
Only works on...
2010-12-31
3,627 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