Israeli SQL Server User Group

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:





Next Meeting

Next meeting




October Israel PASS Chapter Meeting

  • In-Person @ 2 HaPnina St. Raanana, HaSharon, Israel (map)
  • 17:30 - 20:30 Jerusalem Daylight Time
  • Language: English

1. TempDB – Do We Really Know All We Need to Know About It? (Adi Cohn, Naya Technologies) 2. Small Changes Can Make a World of Difference (Matan Yungman, Microsoft)

Featured Presentation:

TempDB – Do We Really Know All We Need to Know About It?

Adi Cohn, DBA

Here are some of the key points that will be discussed in the presentation: Why is TempDB so special? What did Microsoft do in order to boost it's performance? What mistakes in our code degrade the performance? What happens when TempDB cannot be accessed and how can we fix it? What are some of the myths that exist about table variables? How many files should TempDB include and why?

About Adi:
Adi Cohn worked at various places as SQL Server DBA since 1997.

Small Changes Can Make a World of Difference

Matan Yungman , SQL Server DBA Microsoft

As DBAs, we all know about the big new features, like AlwaysOn Availability Groups, Columnstore Indexes and In-Memory OLTP ("Hekaton"). But there are other "small" hidden features you may have not heard about that can make your lives a lot easier. In this presentation, we will go over some of the cool "small" features that were introduced in SQL Server 2012 and SQL Server 2014, and see how they can help us.

About Matan:
Matan Yungman is a SQL Server DBA at the Microsoft Protection Services operations team. Over the last few years he has taken part in various challenging projects around SQL Server. He is passionate about SQL Server and technology in general. Blog: Twitter:

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