Все публикации

0:09:36

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

0:04:18

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

0:09:40

Session 11: Spool operator in SQL Server

0:08:56

Session 10: Parallelism in SQL Server

0:06:20

Session 9: Join operators in SQL Server

0:07:58

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

0:09:11

Session 7: Parameterization and parameter sniffing in SQL Server

0:08:38

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

0:10:58

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

0:11:36

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

0:06:19

Session 2: SQL Server execution plan overview

0:15:55

Session 1: SQL Server Optimizer: deeper dive!

0:26:09

Understand and troubleshoot latency in AG synchronization in SQL Server

0:11:08

Understand Statistics in SQL Server for better performance troubleshooting

0:25:11

Professionally troubleshoot high CPU utilization in SQL Server

0:08:37

3.SQLOS

0:04:48

1. Multitasking, multiprocessing and multi-threading in Windows

0:03:13

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

0:16:54

Deeply Understand connectivity to VNN listener and troubleshoot connection failures efficiently

0:05:07

3. SSL Certificate types and requirements for SQL Server

0:07:42

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

0:04:01

2. Ways to encrypt connection to SQL Server

0:06:48

1. TLS Handshake in Windows.

0:06:25

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