Israeli SQL Server User Group

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:





Next Meeting

Next meeting




Another November Israel PASS Chapter Meeting

  • In-Person @ 2 HaPnina St. Raanana, HaSharon, Israel (map)
  • 17:30 - 20:30 (UTC+02:00) Jerusalem
  • Language: English

We are moving the December meeting to November 24 because Itzik Ben-Gan is coming to Israel and we simply cannot miss this opportunity!!

Featured Presentation:

SQL Server Scale-Out Solutions

Assaf Aviv, SQL Server DBA Madeira

SQL Server implementations can rapidly evolve and become more complex, forcing DBAs and developers to think about how they can scale their solution quickly and effectively. Scaling up is relatively easy, but can be expensive, while scaling out requires significant engineering time and effort. As your database server nears its load capacity, what can you do? This session will give you concrete, practical advice about how to scale SQL Server. We’ll go over some scale out solutions. We’ll also cover how we implemented transactional replication to increase the overall scalability of "AOL-On Network" very quickly.

About Assaf:
Asaf Aviv is a professional SQL Server DBA with a huge amount of knowledge and experience in the field. His favorite feature is SQL Server Replication, in which he is definitely a master. Asaf is a senior consultant at Madeira, serving as the database team leader at "AOL-On Network", where he deals with large-scale OLTP systems. BLOG:

Creative Uses of the APPLY Operator

Itzik Ben-Gan, T-SQL Trainer SolidQ

The APPLY operator is available in T-SQL for quite some time now, but for many people it’s off the radar. People who do know it can’t stop using it, and this session will show you why. The session starts with a brief overview of the operator and it’s fundamental optimization aspects. Then the session’s focus is to go over more creative uses of the operator.

About Itzik:
Itzik Ben-Gan is a mentor and Co-Founder of SolidQ. A Data Platform Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books including T-SQL Fundamentals, T-SQL Querying, and T-SQL Window Functions. Itzik’s speaking activities include PASS Summit, SQLBits, and various user groups around the world. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses, along with being a primary resource within the company for their T-SQL related activities.

Supplementary Materials

The following event attachments are available to you:


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




SQL Joke of the month:

DBAs make the best husbands. They understand relationships and know how to commit

Back to Top