Israeli SQL Server User Group

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:





Next Meeting

Next meeting




Researching the Past with Query Store, and Predicting the Future with Python

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

1. Answering the Question "What Happened?" with Query Store – Erin Stellato (60 Minutes, Remote Session)

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. It's been referred to as the "flight recorder" for SQL Server, because it tracks query information, namely plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature.

In this session we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, see how you can force SQL Server to use a specific plan for a query, and find out what happens when it can’t use the specified plan.

Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!

2. Python Revolution in the SQL Server World – Maria Zakourdaev (60 Minutes)

Python is one of the most popular languages these days, and we are very excited to have the ability to use Python inside SQL Server stored procedures starting with SQL Server 2017. Machine learning is not the only use case for this wonderful feature. It can solve many challenges when dealing with text files, handling bulk loads, and even simplifying ETL flows when you need to move data from databases other than SQL Server. Moreover, you can offload the big data querying to a NoSQL database, and use Python to get the results into SQL server.


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