If you’ve recently installed SQL Server and discovered that the SQL Server Configuration Manager is missing, you are not alone. Many administrators encounter this issue, particularly in newer versions ...

Modifies global configuration settings for the current server in [!INCLUDEssNoVersion]. :::image type="icon" source="../../includes/media/topic-link-icon.svg" border ...

Learn how the Customer Experience Improvement Program (CEIP) helps Microsoft identify ways to make our software better. You can configure tools to opt in or out at any time. Note For an explanation of ...

In the previous post in this series, I provided some T-SQL scripts that can check key settings and highlight possible issues you need to address. This post aims to provide some feedback and ...

The Maximum Degree of Parallelism (MAXDOP) is an advanced configuration option in SQL Server that controls the number of processors used to execute a single query in a parallel plan. It directly ...

This part covers the SQL Server installation and configuration for a SCCM 2012 R2 environment. SQL server will be installed on a dedicated server. (If SQL server is installed on the same server as the ...

This file is generally found at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\Polybase\Hadoop\conf. In order to use the new configuration, you will need to add a new property ...

This part covers the installation of SQL Server on Core node (with the creation of a SQL Configuration INI file). If you are using a standard AD Account (not a MSA), you have to Assign “Deny logon ...