It’s Optober – a time to look at all the SQL Server sp_configure options and figure out what they do and why they are there. In this post we look at ‘show advanced options’, just incase anyone can’t figure out what it does from the name.