Aliases for SQL Server are a client side configuration. Each client computer that uses the alias must have an identical alias configuration, and SQL Server Configuration Manager isn't the only tool ...

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

You can manage and optimize [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] and [!INCLUDE [ssazuremi-md](../../includes/ssazuremi-md.md)] resources ...

Here, I am going to discuss some basic and most important configurations of the SQL Server Instance and Database Level which might be ignored and can cause performance issues. Although this is not the ...

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

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