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 ...

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 ...

> Different `DATABASE SCOPED CONFIGURATION` options are supported in different versions and platforms of the SQL Database Engine. This article describes **all** `DATABASE SCOPED CONFIGURATION` options ...

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 ...

It’s important to configure your SQL Server instance and your AX databases properly in order to achieve optimal performance on your Dynamics AX environment. This blog post aims to help you do that by ...

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 ...