Listen "Everything I Never Wanted to Know about Collation"
Episode Synopsis
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.
More episodes of the podcast Dear SQL DBA
Jer and Kendar Explore Optimized Locking
04/09/2023
Erik Darling on Performance Tuning
21/08/2023
Data Roles: DBA, DBRE, and Data Engineer
04/08/2023
ZARZA We are Zarza, the prestigious firm behind major projects in information technology.