Deleting packages from SSIS Catalog
I was fortunate to attend a training on SSIS by my good friend and SSIS expert Andy Leonard(b|t). We already use the tool for ETL purposes where I work...
2020-05-18 (first published: 2020-05-04)
960 reads
Mala Mahadevan
Learning Postgres:Installation
I had the opportunity of working on a project converting a postgres database to a sql server based one at work. I used this opportunity to learn more of...
2020-04-13 (first published: 2020-04-06)
317 reads
Telecommute Resources
This is a summary of potential resources for any tech person who is interested in working from home – temporarily or full time. It came about from a twitter...
2020-03-18 (first published: 2020-03-09)
455 reads
T-SQL Tuesday 123: Life Hacks to make your day easier
This month’s T-SQL Tuesday is hosted by Jess Pomfret. Jess’s theme is ‘Life Hacks to make your day easier’. She talks of some things we do to make life...
2020-02-17 (first published: 2020-02-11)
811 reads
T-SQL Tuesday #122: Being authentic
This month’s T-SQL Tuesday is hosted by Jon Shaulis – the topic is an evergreen one, dealing with Imposter Syndrome. I learned of this word via Mindy Curnett a.k.a...
2020-01-15
8 reads
Epic Life Quest – 2020 Update
I started keeping a written record on bigger goals in life from the year 2018 – following the example set by Steve Jones and Brent Ozar. This method of...
2020-01-06
19 reads
T-SQL Tuesday 121 – Gifts received – Summary
I got several responses for the last T-SQL Tuesday of the year that am honored to host. My topic was to blog on whatever you considered to be a...
2019-12-27 (first published: 2019-12-12)
313 reads
Querying database schema using graph tables
SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature more usable – although it is far from a full-fledged graph database. Graph tables are essentially […]
2019-12-23
15,335 reads
T-SQL Tuesday #121 Gifts received
I am hosting 2019’s last T-SQL Tuesday of the year. I chose to ask people to write on gifts they had received – by way of community, relationships, or...
2019-12-10
3 reads
T-SQL Tuesday #121: Gifts received for this year
It is December again. 2019 has gone by in a flash. I have the honor of hosting the last TSQL Tuesday blog party of the year. This monthly blog...
2019-12-03
3 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