SQL Server default configurations that you should change
Who here takes the time to adjust default values for SQL Server Configuration after installing it? Unless your company has specific Post-Installation Tasks procedures/document, SQL Server configurations are left as is until an issue comes along. If you are doing your job diligently, there are a few items you'd want to configure after installation not just for security but also for performance. Whenever we have a new client, we'd like to do a Best Practice Check to make sure SQL Server is configured correctly and more often than not, changing these few SQL Server Configurations will already have a noticeable effect on performance. So here's my top list of things you should not leave as default and always configure accordingly. As with any advice, make sure to test any changes on your lower environments first and check on the behavior before implementing in production.