What we're about

This meetup is all about data. From small to big, SQL to NoSQL, BI, reports, development, design and more. If you're a developer, DBA, BI expert, data analyst or data scientist, this is a great place to meet and learn.

Upcoming events (4)

Database DevOps & Window Functions

Varonis

Agenda: • 17:30-18:00 - Gathering, Networking, Hugs and Kisses • 18:00-18:15 - Opening, Announcements, and More... • 18:15-18:45 - First Session (Database DevOps) • 18:45-19:00 - Break (More Networking) • 19:00-20:00 - Second Session (Evolution of Window Functions and Related Analytical Features from SQL Server 2005 to 2019 and Beyond) Sessions: 1. Database DevOps – Elie Muyal (30 Minutes) DevOps on databases presents particular challenges due to the very nature of databases. In this session, we will discuss how to overcome those challenges and to obtain the right balance between conflicting goals in a Database DevOps environment: • Security versus Freedom • Collaboration versus Personalization 2. Evolution of Window Functions and Related Analytical Features from SQL Server 2005 to 2019 and Beyond – Itzik Ben-Gan (60 Minutes) This session explores the way T-SQL’s support for window functions and related analytical features evolved from SQL Server 2005 to SQL Server 2019. It also covers related features from the ISO/IEC SQL standard that were not yet implemented in T-SQL, like row pattern recognition and nested window functions. Important: Itzik will be delivering his excellent course - Advanced T-SQL Querying, Programming & Tuning for SQL Server - the week before the meetup in Naya College. Don't miss this opportunity to learn T-SQL from the best. For information and registration: https://www.naya-college.co.il/courses/advanced-t-sql/. Parking: there is no dedicated parking for this event, but there are a lot of parking places in the area.

SQL Server Resource Governor and Hybrid Always On

Microsoft office

Agenda: • 17:30-18:00 - Gathering, Networking, Hugs and Kisses • 18:00-18:15 - Opening, Announcements, and More... • 18:15-19:15 - First Session (Resource Governor – We’ve Got a New Sheriff in Town) • 19:15-19:30 - Break (More Networking) • 19:30-20:45 - Second Session (Neither Here nor There – Hybrid AO SQL Architecture On-Prem/Azure) Sessions: 1. Resource Governor – We’ve Got a New Sheriff in Town – Sagi Amichai (60 Minutes) Sometimes an extra level of control is necessary for managing big environments’ resources. Resource Governor is here just for that, giving us interesting abilities to limit and manipulate our resources. Though there is another functionality that its name is not revealing. In this session, we will talk about the conventional and the potential usage of Resource Governor, the risks coming with this tool, and a short demonstration of it. 2. Neither Here nor There – Hybrid AO SQL Architecture On-Prem/Azure – Yitzchak Wahnon & Danny Ravid (75 Minutes) In today’s ever-changing environments, on-prem is still the default, but the cloud is fast becoming a requirement for organizations. We will take Always On from an on-prem only architecture to a hybrid on-prem/Azure cloud solution. Learn from eToro, the biggest social trading company. In this session we will cover and demonstrate Always On challenges, terminology, configuration, troubleshooting and pitfalls in a global architecture. We will also cover backup best practices, compliance and more... Important: In order to attend this meetup, you must RSVP. If your name does not appear on the list of attendees, you won't be able to enter the venue. So please RSVP. Registration will be closed two days before the event, on 03/08. Thank you!

Database Products and SSIS Error Handling

Microsoft office

Agenda: • 17:30-18:00 - Gathering, Networking, Hugs and Kisses • 18:00-18:15 - Opening, Announcements, and More... • 18:15-19:15 - First Session (Lost in the Wealth of Database Products? We will Help You to Make Sense of Them) • 19:15-19:30 - Break (More Networking) • 19:30-20:30 - Second Session (How to Make Sure Your SSIS Packages Will Never Fail) Sessions: 1. Lost in the Wealth of Database Products? We will Help You to Make Sense of Them – Michael Zilberstein (60 Minutes, Hebrew) Once upon a time there was Oracle. Few years later DB2 and Sybase were born. Sybase gave birth to SQL Server. The world was nice and simple. But ~10 years ago all hell broke loose. SQL, NoSQL and NewSQL; In-memory and Disk-based; Cloud and On-premises; Key-value store, Document store, Graph, Column store and Timeseries; Enterprise and Community; We will make sense of those buzzwords, review the most popular database technologies – when they are a good fit and when they aren't and analyze typical use-cases and architectures. Last but not least – we will review few less popular technologies that are worth consideration and adoption. 2. How to Make Sure Your SSIS Packages Will Never Fail – Guy Glantser (60 Minutes, Hebrew) There are many methods and options in SSIS to handle errors during a package execution. You can use event handlers, event propagation, package transactions, precedence constraints, error rows, and more. Things get more complicated when your package has multiple levels of containers, or even when one package executes another. It is very easy (and common) to get lost and do things the wrong way. In this session we will learn about all the options available for us to handle errors in SSIS, but more important – we will learn about the best practices and the way to do it right. Important: In order to attend this meetup, you must RSVP. If your name does not appear on the list of attendees, you won't be able to enter the venue. So please RSVP. Registration will be closed two days before the event, on 31/08. Thank you!

SQL Internals and Advanced Dynamic Search

Microsoft office

Agenda: • 17:30-18:00 - Gathering, Networking, Hugs and Kisses • 18:00-18:15 - Opening, Announcements, and More... • 18:15-19:45 - First Session (SQL Internals – Physical Table Structure Under the Hood and Implementation on Real Case Scenarios) • 19:45-20:00 - Break (More Networking) • 20:00-20:45 - Second Session (Advanced Dynamic Search Queries and How to Protect Them) Sessions: 1. SQL Internals – Physical Table Structure Under the Hood and Implementation on Real Case Scenarios – Ronen Ariely (90 Minutes, Hebrew) Understanding what we have under the hood is not only done for the sake of learning a theory, but it is directly impacts our daily work, and it can help us to improve performance and reduce resources dramatically. During this session we will go over the structure of tables behind the scenes. We will see the changes behind the scenes related to actions which we execute on the table. Using this information, we will demonstrate several real case scenarios, and the dramatic impact of understanding the internals on choosing our solution. Is order of columns important? Is dropping a column the right solution? Questions like these are very common in the forums, and usually do not get the right answer. This session is a live demo. 2. Advanced Dynamic Search Queries and How to Protect Them – Eitan Blumin (45 Minutes, Hebrew) No, it’s not yet another presentation about SQL injection. We all know how to protect from SQL injections already. But that’s only relevant when you know in advance which columns can be queried by the user and using what kind of operators (“equals”, “like”, “between”, etc.). Instead, what I really want to talk about is when you actually don’t know in advance which parameters to expect, you don’t know in advance the chosen operator to use per each parameter, and you actually want to give the user truly full unlimited control over search criteria. We’ll discuss different methods of achieving advanced scenarios, the pros and cons of each, and most importantly: how do you do it without fear of malicious attacks. Important: In order to attend this meetup, you must RSVP. If your name does not appear on the list of attendees, you won't be able to enter the venue. So please RSVP. Registration will be closed two days before the event, on 05/10. Thank you!

Past Events

Photos (95)

Find us also at