MS-SQL Server - Tail Log Backup, NTLM & Joins

Tail Log Backup.

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server?view=sql-server-ver16

Using NTLM Authentication to connect to SQL Server

https://learn.microsoft.com/en-us/sql/connect/jdbc/using-ntlm-authentication-to-connect-to-sql-server?view=sql-server-ver16

Joins

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

Additionally,

Not listening SQL Server Port 1433

https://learn.microsoft.com/en-us/answers/questions/201977/not-listening-sql-server-port-1433

Netstat

https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/netstat

WaitType

RESOURCE_SEMAPHORE_QUERY_COMPILE

SOSHOST_SEMAPHORE

XTPPROC_PARTITIONED_STACK_CREATE

XE_DISPATCHER_CONFIG_SESSION_LIST

XE_DISPATCHER_WAIT

DAC_INIT

HADR_SYNC_COMMIT

OLEDB

PAGEIOLATCH_DT

PAGEIOLATCH_EX

PAGEIOLATCH_KP

PAGEIOLATCH_SH

PAGEIOLATCH_UP

PRINT_ROLLBACK_PROGRESS

Configure IntelliSense

https://learn.microsoft.com/en-us/sql/ssms/scripting/configure-intellisense-sql-server-management-studio?view=sql-server-ver16

Actual Execution Plan

https://learn.microsoft.com/en-us/sql/relational-databases/performance/analyze-an-actual-execution-plan?view=sql-server-ver16

SQL Server 99% virtual memory used alert

https://social.msdn.microsoft.com/Forums/vstudio/en-US/a35627ab-f842-437c-b970-6ec1dec7e6b5/sql-server-99-virtual-memory-used-alert?forum=sqlgetstarted

PATINDEX

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

IDENTITY (Property)

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-ver16

Best Regards

T. Amit Vaid S.