MS-SQL Server - MAH of OS! Why?

MAH of OS! Why?

It's important to monitor windows server performance having SQL Server running.

- Monitor Windows Server Performance.

https://learn.microsoft.com/en-us/training/modules/monitor-windows-server-performance/

It's also important to keep and manage Admin account of windows.

- Administrator/Admin Account

There are some circumstances where we may have to apply Hotfixes for windows to fix SQL server related issues.

- Hotfixes

https://learn.microsoft.com/en-us/troubleshoot/windows-server/networking/windows-server-2012-directaccess-hotfixes

Additionally,

OLTP

Database Mirroring

https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-ver16

Name Change

https://learn.microsoft.com/en-us/sql/ssms/register-servers/change-the-name-of-registered-server-or-registered-server-group?view=sql-server-ver16

DBCC SHRINKFILE

https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-ver16

Create Materialised View

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-materialized-view-as-select-transact-sql?source=recommendations&view=azure-sqldw-latest

Year Data Type

https://learn.microsoft.com/en-us/sql/t-sql/functions/year-transact-sql?view=sql-server-ver16

Best Regards

T. Amit Vaid S.