In-memory OLTP internal architecture

Understand and troubleshoot latency in AG synchronization in SQL Server

Understand Statistics in SQL Server for better performance troubleshooting

Professionally troubleshoot high CPU utilization in SQL Server

3.SQLOS

1. Multitasking, multiprocessing and multi-threading in Windows

2. Why SQLOS created? Can Windows Schedular schedule SQL Server process like other processes?

Deeply Understand connectivity to VNN listener and troubleshoot connection failures efficiently

3. SSL Certificate types and requirements for SQL Server

4. Enable encryption in connections to SQL Server by meeting all certificate requirements

2. Ways to encrypt connection to SQL Server

1. TLS Handshake in Windows.

Apply the execution plan from one server to another in SQL Server

[Detailed/Advanced] Effectively troubleshoot SQL Server transactional replication latency (Part 1)

[Detailed/Advanced] Effectively troubleshoot SQL Server transactional replication latency (Part 2)

In-detail: Understand and effectively troubleshoot deadlocks in SQL Server

Database recovery in SQL Server: In-detail explanation and troubleshoot latency

In-detail explanation of SQL Server memory utilization: Wisely troubleshoot SQL Server memory issues

How to keep stable performance while changing database compatibility in SQL Server

Troubleshoot slow running queries with Pagelatch_* waits in SQL Server

Troubleshoot latency in SQL Server transactional replication

4. Create transactional replication with local distributor in SQL Server

3. Create transactional replication with remote distributor in SQL Server

1. SQL Server replication architecture and components

2. SQL Server replication types and replication agents