You don’t often hear about references to Facets in SSMS, however this is a great feature which allows you to review and even change the SQL Server configuration.

I often use it to quickly access the good old SQL Server 2005 Surface Area Configuration settings.

Take a look at the various Facets available and you may be pleasantly surprised.

Previous
Next