Learn how to create an alias in SQL Server Configuration Manager so that you can use an alternate name when connecting to an instance of SQL Server. Aliases for SQL Server are a client side ...

「SQL Server 2005 Express Edition」を使い始め，管理ツールの「SQL Server Configuration Manager（SQL Server構成マネージャ）」や「SQL Server 2005 Surface Area ...

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

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