(last updated: 2021-07-05 @ 14:00 EST / 2021-07-05 @ 18:00 UTC ) The sysname data type (in SQL Server) is a system-provided, though not built-in, alias for NVARCHAR(128). This alias is used for nearly all identifiers (i.e. names of tables, columns, indexes, databases, logins, etc.), starting in SQL Server 7.0 (for a full list of… Continue reading Is the [sysname] SQL Server System Data Type Alias Name Case-Insensitive?
(last updated: 2021-06-28 @ 02:30 EST / 2021-06-28 @ 06:30 UTC ) Many of us that work with Microsoft SQL Server, especially those of us working on systems with US English as the OS language, or anyone working with SQL Server Express LocalDB (commonly referred to as just “LocalDB”), have had to deal with the… Continue reading SQL Server Collations: What does “CP1” mean in “SQL_Latin1_General_CP1_CI_AS”?
Come explore the actual differences between the seemingly not-so-different binary collations...
Ever notice how IntelliSense in SSMS lists functions that don't work or aren't documented? Here's documentation for one that works: UNCOMPRESS
Need to change the collation at ALL levels? Prefer to avoid reloading all objects and data? Learn what the "sqlservr -q" option does, and doesn't, do.