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

  • Script

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: )

1,009 reads


Server vs Instance. A rant.


It’s a SQL Server Instance not a SQL Server. The product is SQL Server....

SQL Server and AKS


Following on from my last post after creating AKS, I now want to work...

Thoughts on Unique Resource Names in Azure


Each resource type in Azure has a naming scope within which the resource name...

Read the latest Blogs


Batchmode on rowstore: deadlock

By Jo Pattyn

Are there known issues with Batchmode on rowstore in CU11? One specific complex query...

CPU and Memory issues

By garryha

I am a DBA  trying to get to the bottom of some instances when...

Error shrinking database

By Ram

While trying to shrink a database using the command "dbcc shrinkdatabase ([db_name])", I get...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers