MS-SQL Server - SSRS with HTTP & Buffer Pool extension

Buffer Pool Extension.

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/buffer-pool-extension

SSRS with HTTP

https://learn.microsoft.com/en-us/sql/reporting-services/security/configure-ssl-connections-on-a-native-mode-report-server?view=sql-server-ver16

Additionally,

Troubleshoot orphaned users (SQL Server)
https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/troubleshoot-orphaned-users-sql-server

RESTORE statements - HEADERONLY
https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-headeronly-transact-sql

Raid Recommentation
https://learn.microsoft.com/en-us/answers/questions/440499/raid-level-for-sql

What Default 'sa' SQL Admin user Password

https://learn.microsoft.com/en-us/answers/questions/602203/what-default-sa-sql-admin-user-password

IDENTITY (Property)
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property

ELSE (IF...ELSE)
https://learn.microsoft.com/en-us/sql/t-sql/language-elements/else-if-else-transact-sql

Troubleshooting Deadlocks Issues
https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-deadlocks-guide

Run Stored Procedure
https://learn.microsoft.com/en-us/sql/relational-databases/stored-procedures/execute-a-stored-procedure

Show Table
https://learn.microsoft.com/en-us/sql/relational-databases/tables/view-the-table-definition

Imp. Waittypes
FS_GARBAGE_COLLECTOR_SHUTDOWN

HADR_DBR_SUBSCRIBER_FILTER_LIST

PWAIT_HADR_WORKITEM_COMPLETED

Refresh data from an on-premises SQL Server database - Power- BI

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

7934 - DBCC Error related due to replication.

Imp. Error Msg 1430

XML related errors

Any query will be considered.

T. Amit Vaid S.