Monday, April 3, 2023

MS-SQL Server - NEANJ

NEANJ

 

- Name Change

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server?view=sql-server-ver16

- Events And Errors

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors?view=sql-server-ver16

- Authentication Mode

https://learn.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode?view=sql-server-ver16

- Network Configuration

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-network-configuration?view=sql-server-ver16

- Joins

https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16


Additionally,

Named Instance & Native Tools

I believe, there can be 49 Named instances per Stand alone server. Please also check the character policy and limit of a named instance.

Native Tools

- SQL Server Profiler
- SQL Server SSMS
- Configuration Manager
- Browser Service
- Powershell

Best Regards

T. Amit Vaid S.

No comments: