sqlservr.exe – Error – “Multiple instances of SQL server are installed on this computer. Renter the command, specifying the -s parameter with the name”

Background Trying to change collation from binary to something easier to work such as case-insensitive.   Error Message Textual Multiple instances of SQL server are installed on this computer. Renter the command, specifying the -s parameter with the name   Remediation Specification Specify the Instance Name by utilizing MSSQLSERVER for the default instance; for named instance, … Continue reading sqlservr.exe – Error – “Multiple instances of SQL server are installed on this computer. Renter the command, specifying the -s parameter with the name”

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