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 […]

2019-07-05 (first published: )

2,990 reads

Blogs

Converting Types in C#

By

I am not a great software developer. I’m OK, and I do know how...

Daily Coping 22 Mar 2023

By

Today’s coping tip is to appreciate your hands and all the things they do...

FIRST Robotics Competition 2023 - World Championships!

By

On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...

Read the latest Blogs

Forums

Help with calculating Percentages

By PS_Richard

Hello,  I'm currently at a loss trying to calculate percentages based on two fields...

Swapping coordinate pairs round

By Charlottecb

So I'm using SQL Server 2014 and I've been using Jeff Moden's excellent string...

DOP_FEEDBACK in SQL MI

By cooldude001

I'm changing the DB Compatibility mode to 2022 in SQL Managed Instance. below features...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers