Gaby Abed


Technical Article

Generate views to correct the column collation on a target DB's tables automatically

You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]

You rated this post out of 5. Change rating

2019-07-05 (first published: )

4,167 reads

Blogs

Moving T-SQL Tuesday to Jekyll

By

I got a message a few months back that Microsoft was deprecating the MySQL...

European Microsoft Fabric Community Conference announcements

By

A TON of new features announcements at the European Microsoft Fabric Community Conference help...

RDS Connectivity

By

I travel quite a lot for work. Most of it is in the US...

Read the latest Blogs

Forums

An error occurred while skipping data rows

By yrstruly

I am trying to build an ETL for an Existing Table. The ETL (SSIS)...

What is causing this error?

By Rod at work

(This is probably the wrong forum to be posting this question, so please forgive...

Changetracking disabled in database snapshot, new bug in ms sql 2019 ?

By FHoornaert

Hi, We are using database snapshot together with changetracking to keep a datawarehouse up...

Visit the forum

Question of the Day

Data Migration Assistant Targets

In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?

See possible answers