Skip to main content

Free Online Training for SQL Server 2005 from Microsoft

As part of Microsoft’s push to improve dba/developer knowledge and uptake of SQL Server 2005, Microsoft have released free training for SQL Server 2005 available online until 1st November 2006. There’s currently seven free courses covering installation, administration, programming and other features of SQL Server 2005. Included in each course are hands-on virtual labs, and […]

COLLATE

COLLATE Keyword used to define string collation used for a database, column or server. Can also be used to cast the collation of a column or variable when used in a t-sql expression. SQL Server 2000 and SQL Server 2005 allow you to use Windows Collation Names or SQL Collation Names. To see a list […]

Collation Conflicts

If you’ve ever worked with databases from different sources, or with different collation settings, you’ve probably encountered an error like this: Msg 468, Level 16, State 9, Line 1 Cannot resolve collation conflict between ‘Latin1_General_CI_AS’ and ‘SQL_Latin1_General_CP1_CI_AS’ in equal to operation. The error is cause by having different collation settings for the columns in the […]