Session 12: Data Update Operators: DELETE, INSERT, UPDATE and Halloween problem

Session 3: Why you should not trust live execution plan in SSMS ?

Session 11: Spool operator in SQL Server

Session 10: Parallelism in SQL Server

Session 9: Join operators in SQL Server

Session 8: Aggregate operators in SQL Server: Stream and Hash aggregations

Session 7: Parameterization and parameter sniffing in SQL Server

Session 6: Fine tune queries with Index scan and seek operations

Session 5: How SQL Server chooses which index and operators (seek, scan) to use for queries

Session 4: Data access operators in SQL Server: Scans, Seeks and Key/RID Lookup

Session 2: SQL Server execution plan overview

Session 1: SQL Server Optimizer: deeper dive!

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

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

1. Multitasking, multiprocessing and multi-threading in Windows

Deeply Understand connectivity to VNN listener and troubleshoot connection failures efficiently

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

3. SSL Certificate types and requirements for SQL Server

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 2)

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

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