sp_configure

Check Your SQL Server Configuration

I blog a lot about best practices, defaults and paying attention to your installations. It’s a huge pet-peeve of mine to see improperly configured instances. One of the things I always do when doing a health check is review an instances configuration options. On quite a few client environments, just a couple quick knob turns … Read more

How to use sp_configure in SQL Server

sp_configure is the "type set" of SQL Server

2018 Update –¬†Straight Up SQL Server Tips posts Not much has changed with sp_configure in SQL Server. The below post is still quite current as far as how to use sp_configure or sys.configurations to check and change your SQL Server settings. If you head to our , you’ll see many posts about things such as … Read more