With each new release, SQL Server gets easier to manage. That doesn’t mean the product is growing simpler, however. To make upgrading a compelling prospect, Microsoft naturally introduces new features ...

Microsoft has updated Azure SQL Data Warehouse with the ability to change the default collation when creating a new database. Customers now have simple access to over 3800 database collations within ...

[!INCLUDE [sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw.md)] Is a single string that ...

Collation A Schema may contain zero or more Collations. An SQL Collation is a set of rules that determines the result when characters from a Character set are compared. Collations are dependent on ...

With the first public preview of SQL Server 2019, we announced support for the widely used UTF-8 character encoding as an import or export encoding, and as database-level or column-level collation for ...

I am trying to write a select statement that joins two tables from different databases on my SQL server. The issue is that the two databases are different collation types. <BR><BR>DataBaseA is ...

This blog post describes how collations might change during an upgrade from a Dynamics NAV 2009 database to Dynamics NAV 2013, why they change, and how to determine the destination collation. “Since ...