John’s post-install configuration recommendations
Let me start by saying this is the procedure I perform when configuring a new SQL Server instance, immediately after installation. “Best Practice” is a term a lot of people love to throw around, but I will not definitively say performing the following is a “Best Practice” as your environment and situation could be wildly different from mine. I find though, that these steps work best for me in most situations. With that said a lot of the steps outlined below do have “Best Practice” associated with them from one source or another, but they could range anywhere from highly useful to absolutely worthless for your environment so keep that in mind as you read on.
View original post 4,183 more words