SQL Server – Changing Sql Instance Collation – via sqlservr/-q – Little Traps

Preface In an earlier post we spoke about discovering that we can change our SQL Server Instance by restarting SQL Server with the /q option. That post is here.   Real life experience If truth be told, our first use-case was a recently installed SQL Server instance without any user databases. In this post we … Continue reading SQL Server – Changing Sql Instance Collation – via sqlservr/-q – Little Traps

SQL Server – Changing Sql Instance Collation – via sqlservr/-q

Background Reviewing SQL Server Alwayson requirements and as should be expected Collation Uniformity is needed (at the SQL Instance level). Keep in mind not just at the database level, but at Instance level. Curious Curious as to the means to change Collation. Familiar with doing so via re-running setup.exe. UnDocumented Method Was fascinated that there appears … Continue reading SQL Server – Changing Sql Instance Collation – via sqlservr/-q