Next Meeting

Sunday,

April

12

April 2015 Israel PASS Chapter Meeting

  1. Back to Basics - Locks Behind the Scenes (Dubi Lebel)

In a lot of sessions on performance improvements we heard about locks, lock management, lock mechanisms, lock escalation and more. What’s really going on behind the scenes? Do you really monitor all types of locks? Are all theories regarding locks will still be correct after drilling down into the mechanism?

Dubi Lebel is a DBA - Don't Bother Asking.

Dubi Lebel

 

  1. SQL Server Replication - Dive into the "Guts" (Idan Cohen, Madeira)

Although SQL Server Replication is a pretty useful tool and relatively "old", and despite the wide experience that most of us have with it, in fact most of us don't know much about replication or how it works, so we find it difficult to solve problems while facing them.

In this session, Idan will shortly review the technology and its various types, and will dive into the "guts" of the most common type of replication - the transactional replication, in order to provide the followers with enough knowledge that will enable them to trace problems that occur with replication and to fix them without having to recreate the replication. Finally, we will see a few tips on how it's possible to improve the performances of replication in certain cases.

Idan Cohen is a SQL Server DBA, working in Madeira, with wide experience and knowledge of various types of DBs and their related challenges. Besides being a SQL Server DBA, Idan is a student of bachelor degree in Computer Science at IDC Herzliya, and has an extensive knowledge and experience in various computer related issues, from security and communication protocols, and up to developing in Java, C#, Perl, web programing and more.

Idan Cohen

 

 

Israel Blogging Community:

Guy Glantser Dubi Lebel Matan Yungman Meir Dudai Geri Reshef Maria Zakourdaev Noam Brezis Eitan Blumin Asaf Aviv Michael Zilbershtein Itai Binyamin Ronen Ariely Pini Krisher