Failover cluster - 2 to 64 nodes
Maintenance tab
- edition upgrade
- repair corrupt instance
- remove node from cluster
If the instance will not start, use CLI:
setup.exe ACTION=REBUILDDATABASE
Advanced tab: install based on a configuration file
Can create cluster configuration file. Use Advanced Cluster Preparation on Advanced tab.
After running the Advanced Cluster Preparation Wizard on every possible node, run the Advanced Cluster Completion Wizard on any node. Needs to be done once.
SYSPREP allows deployable vanilla images with SQL/Server installed. 2019+ Needs Image Completion of a Prepared Stand Alone Instance of SQL/Server option.
Slipstream is now deprecated in 2019. (allows insatllation of patches at the same time as binary installation)
15 is edition (2019) of SQL/Server
Max length of instance name is 16. (MSSQLSERVER is default) Up to 50 standalone instance on a single server.
Virtual sccounts - local accounts based on computer name.
MSA (Managed Service Accounts) (AD)
Both can only be used on a single server.
Collation
- accent insensitivity
- Kana insensitivity. Hiragana = katakana
- case insensitivity
Windows authentication (best). Mixed mode is legacy.
Need at least one instance administrator. Ideally should be a Windows group to which all DBAs belong.
FILESTREAM and File Table are covered in Ch 8.