Configure Database Engine Instances Database Engine Instances (SQL Server) Log File Viewer Server Configuration Options (SQL Server) access check cache Server Configuration Options ad hoc distributed queries Server Configuration Option affinity Input-Output mask Server Configuration Option affinity64 Input-Output mask Server Configuration Option affinity mask Server Configuration Option affinity64 mask Server Configuration Option Agent XPs Server Configuration Option allow updates Server Configuration Option backup checksum default View or Configure the backup compression default Server Configuration Option blocked process threshold Server Configuration Option c2 audit mode Server Configuration Option clr enabled Server Configuration Option clr strict security Server Configuration Option common criteria compliance enabled Server Configuration Option contained database authentication Server Configuration Option Configure the cost threshold for parallelism Server Configuration Option Configure the cursor threshold Server Configuration Option cross db ownership chaining Server Configuration Option Database Mail XPs Server Configuration Option Configure the default full-text language Server Configuration Option Configure the default language Server Configuration Option default trace enabled Server Configuration Option disallow results from triggers Server Configuration Option EKM provider enabled Server Configuration Option external scripts enabled Server Configuration Option filestream access level Server Configuration Option Configure the fill factor Server Configuration Option ft crawl bandwidth Server Configuration Option ft notify bandwidth Server Configuration Option PolyBase Connectivity Configuration (Transact-SQL) in-doubt xact resolution Server Configuration Option Configure the index create memory Server Configuration Option lightweight pooling Server Configuration Option Configure the locks Server Configuration Option Configure the max degree of parallelism Server Configuration Option max full-text crawl range Server Configuration Option Configure the max text repl size Server Configuration Option Configure the max worker threads Server Configuration Option Configure the media retention Server Configuration Option Configure the min memory per query Server Configuration Option Configure the nested triggers Server Configuration Option Configure the network packet size Server Configuration Option Ole Automation Procedures Server Configuration Option open objects Server Configuration Option optimize for ad hoc workloads Server Configuration Option PH timeout Server Configuration Option precompute rank Server Configuration Option Configure the priority boost Server Configuration Option Configure the query governor cost limit Server Configuration Option Configure the query wait Server Configuration Option Configure the recovery interval Server Configuration Option Configure the remote access Server Configuration Option remote admin connections Server Configuration Option Configure the remote data archive Server Configuration Option Configure the remote login timeout Server Configuration Option Configure the remote proc trans Server Configuration Option Configure the remote query timeout Server Configuration Option Replication XPs Server Configuration Option Configure the scan for startup procs Server Configuration Option Server Memory Server Configuration Options server trigger recursion Server Configuration Option set working set size Server Configuration Option show advanced options Server Configuration Option SMO and DMO XPs Server Configuration Option transform noise words Server Configuration Option Configure the two digit year cutoff Server Configuration Option Configure the user connections Server Configuration Option Configure the user options Server Configuration Option xp_cmdshell Server Configuration Option View or Change the Default Locations for Data and Log Files (SQL Server Management Studio) View or Configure Remote Server Connection Options (SQL Server) View or Change Server Properties Server Properties - General Page Server Properties - Memory Page Server Properties - Processors Page Server Properties - Security Page Server Properties - Connections Page Server Properties - Database Settings Page Server Properties - Misc Server Settings Page Server Properties - FILESTREAM Page Server Properties - Advanced Page Soft-NUMA (SQL Server) Map TCP IP Ports to NUMA Nodes (SQL Server) Enable the Lock Pages in Memory Option (Windows) Manage the Database Engine Services Security Requirements for Managing Services Configure Windows Service Accounts and Permissions Configure File System Permissions for Database Engine Access Run SQL Server With or Without a Network SQL Server Browser Service (Database Engine and SSAS) Database Engine Service Startup Options Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service Start SQL Server in Single-User Mode Start SQL Server with Minimal Configuration SCM Services - Connect to Another Computer SCM Services - Set an Instance to Start Automatically SCM Services - Prevent Automatic Startup SCM Services - Change the Service Startup Account SCM Services - Configure Server Startup Options SCM Services - Change the Password of the Accounts SCM Services - Configure SQL Server Error Logs Change Server Authentication Mode SQL Writer Service Broadcast a Shutdown Message (Command Prompt) Log In to an Instance of SQL Server (Command Prompt) Server Network Configuration Connect to SQL Server When System Administrators Are Locked Out Default SQL Server Network Protocol Configuration Enable or Disable a Server Network Protocol Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager) Configure a Server to Listen on an Alternate Pipe (SQL Server Configuration Manager) Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager) Connect to SQL Server Through a Proxy Server (SQL Server Configuration Manager) Configure a Windows Firewall for Database Engine Access Hide an Instance of SQL Server Database Engine Configure the Database Engine to Listen on Multiple TCP Ports Determine Whether the Database Engine Is Installed and Started Connect to the Database Engine Using Extended Protection Register a Service Principal Name for Kerberos Connections Client Network Configuration Configure Client Protocols Create or Delete a Server Alias for Use by a Client (SQL Server Configuration Manager) Logging In to SQL Server Open the ODBC Data Source Administrator Check the ODBC SQL Server Driver Version (Windows) Troubleshoot Connecting to the SQL Server Database Engine Diagnostic Connection for Database Administrators SQL Server 2016 Express LocalDB Remote Servers SQL Server Monitor Overview Service Broker Buffer Pool Extension