Israeli SQL Server User Group

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:





Next Meeting

Next meeting




April 2017 Israel PASS Group Meeting

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

1.  Built-in JSON Support in SQL Server 2016 and Tips to Improve Performance – Ronen Ariely (60 Minutes)

SQL Server 2016 provides built-in support for importing, exporting, parsing and querying JSON documents. However, JSON support is not the same as the native JSON type, and it is implemented using simple text with types like NVARCHAR.

Traditionally, NoSQL systems, which based on JSON documents (such as DocumentDB or MongoDB) are designed to store the data more effectively (using binary format like BJON and not as simple text) and are designed to increase performance (for example using built-in indexes' systems). Parsing text "on the fly" in relational database (like SQL Server), especially with long text types like NVARCHAR(MAX) and large number of rows, can be challenging!

In this session, we will give a glance on built-in JSON support functions in SQL Server 2016, and we will focus on tips and tricks to improve performance using JSON on SQL Server 2016 and above.

2.  It's 2017! Stop Doing This! – Matan Yungman & Guy Glantser (60 Minutes)

Many years ago, some SQL Server related operations were considered as best practices, and since then we've been doing many of them automatically. The problem is that things have changed. Some of them aren't considered best practices anymore, some of them are not suited to the hardware and software changes that have occurred, and some of them were overrated from the beginning.

In this session, we will go over those best practices, explain where they came from and why they are not relevant anymore. Among others, we will cover your maintenance processes, your code, your disk layout and your thoughts about where the time goes in your queries.


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