13 min

Everything I Never Wanted to Know about Collation Dear SQL DBA

    • Technology

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.

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.

13 min

Top Podcasts In Technology

Lex Fridman
Jason Calacanis
NPR
Jack Rhysider
Gregg Phillips
The Verge