Links
Usefull links
Tuning Performance, Migration & Azure Integration
Usefull links
It takes minimal effort to install a TLS certificate to encrypt the traffic between your client and the SQL Server. Every new operational database product provided by Microsoft now has encryption in flight by default. Why would you not do it for your current SQL installations? Do not expose your data especially when the amount of effort is minimal.
Message from the trenches: Placing tempdb on local (fast SSD) disk may seem beneficial, but it comes with a caveat. Since the disk is not part of the cluster resources, it will not initiate a failover when the local disk fails