SQL Server 2022 Workstation

Some notes from a SQL Server 2022 Developer Edition installation on a Windows 11 workstation.

• Place "Instance Root Directory" on another physical drive than Windows, e.g. "P:\Program_Files\Microsoft_SQL_Server\". This is to spread preassure on local storage units.
• Name the (Database Engine) instance, e.g. "SSDB2022". This will allow side-by-side installation of different SQL Server versions.
• Change Service Startup Type to "Manual". When running several instances this will help you control local resources on your workstation.
• Enable "Grant Perform Volume Maintenance Task priviledge to SQL Server Database Engine Service". This is to speed up database file (auto-)growths which might be when expanding the physical data model.
• Use collation "Latin_General_100 AS KS WS" with UTF-8.
• Add current user to SQL Server administration. Do not use (Local) Administrators.
• Define seperate paths for
• Data
• TransactionLog
• Backup
• tempdb
  where [tempdb] transaction log is with the other user database transaction logs.

If SQL Server ODBC 17 is already installed, it will most likely generate a error like "The feature you are trying to use is on a network resource that is unavailable.".

The solution is to uninstall SQL Server ODBC 17. This can be done by Control Panel > Remove Program.