Info

Dear SQL DBA

Kendra Little's podcast for database administrators and developers who work with database, discussing performance tuning, software development, and working with data.
RSS Feed Subscribe in Apple Podcasts
Dear SQL DBA
2020
August
July


2019
June
January


2018
October
August
July
June
May
April


2017
December
November
October
September
August
May
April
March
February
January


2016
December
November
October
September
August
July
June
May


Categories

All Episodes
Archives
Categories
Now displaying: Page 1
Jul 16, 2020

I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more.

One small localization correction: the default collation on a SQL Server install will be "the oldest available version that's associated with each specific locale." So if your Windows installation has a different localization than mine (which are generally English USA), then you'll see a different default collation -- but it still won't be the recommended collation for *new* development.

0 Comments
Adding comments is not available at this time.