SQLSaturday #823 - Israel 2019

Event Date: 04/11/2019 00:00:00

Event Location:

  • Megamot College
  • Derekh Em Hamoshavot 94
  • Petah Tikva, HaMerkaz, Israel

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


Title: What’s New in SQL Server 2019: 100% Demos

Abstract: You haven’t installed SQL Server 2019 yet, and you don’t want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as little work as possible on your part. You don’t have time to rewrite all your queries or learn new languages - you just want the database to go faster.

I’m Brent Ozar, and I’ll give you the whirlwind tour. I’ll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I’ll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.

No slides here - not even an about-me slide. Let’s dive into some queries!

Speaker(s):

  • Brent Ozar

Track and Room: Enterprise Database Administration Deployment - Auditorium


Title: Move your database to the Cloud: Understand, Design and Migrate AzureSQLDat

Abstract: This Azure SQL Database pre-con provides you the knowledge and tools necessary to understand the capabilities and usage of cloud databases. It will help you get familiar with the Azure SQL Database concepts. It will also help to learn how to migrate, manage, monitor and troubleshoot your Azure SQL Database solution. You will learn the difference between the Azure SQL Database (PaaS) and SQL Server on-premises and which benefits Azure SQL Database can have for your applications and SQL environment. After attending this pre-con, you will be able to: • Understand how Azure SQL Database works • Know the newest and most important features to manage your Azure SQL Database • Design scalable architectures • Design Disaster Recovery plans • Manage security on your Azure SQL Database • Monitor and troubleshoot Azure SQL Database • Face a migration project

Speaker(s):

  • Jose Manuel Jurado Diaz

Track and Room: Cloud Application Development Deployment - Cloud room


Title: SQL Server Query Performance Tuning

Abstract: You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what? In this pre-conference session we will analyze common use cases of poorly performing queries, such as the improper use of scalar functions, inaccurate statistics and bad impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques. The topics in this session are relevant for SQL Server versions 2005 through 2017. We will also demonstrate some of the new features introduced in the latest versions of SQL Server, such as Adaptive Query Processing. At the end of the session, you’ll have a list of tips and techniques to apply in your environment.

Speaker(s):

  • Guy Glantser

Track and Room: Application Database Development - Auditorium


Title: Inside SQL Server Containers and Kubernetes SQL 2017/2019 - Lessons from the fields‏

Abstract: In 2017 I have session about SQL 2017 and Containers . Customers use Always On Availability Groups to provide varying levels of HA and DR support for their SQL Server deployments across different platforms, including containers . This session presents an view of how Docker containers work and how SQL Server runs in them. I will cover practical scenarios where with SQL Server and containers how to deploy and configure a highly available SQL Server solution using Availability Groups on containers in a Kubernetes cluster as follows :

· Using the Docker client · Exploring the Docker System · Customize a SQL Server Container · update a SQL Server Container · Multi-instance SQL Server using Containers · What’s New with SQL Server and Containers with 2019 · Using SQL Server containers on windows
· Databases, Containers, and Pods: SQL Server on Kubernetes

· SQL Server 2017 - Shared storage HA in Kubernet

Speaker(s):

  • Itshak David

Track and Room: Application Database Development - Auditorium


Title: What is CI/CD for databases or how to automate DB changes

Abstract: In the world of agile software development, the database development process introduces some challenges to the application development process. The delivery of changes at database level tends to be a different and separated process of the application delivery process or even an entirely manual process. This contributes to the perspective that the database is a bottleneck in the agile process. In this session, I will show how to build a deployment pipeline capable of delivering database and application changes. The pipeline includes the following steps: source control, continuous integration and continuous delivery. I will share methods and strategies that allow bringing together databases and applications in the delivery process reducing the delivery pain. The main goal is to understand that applications and databases can and should share the same deployment pipeline and that this pipeline will allow you not be afraid of making database changes.

Speaker(s):

  • Taras Kloba

Track and Room: Enterprise Database Administration Deployment - Cloud room


Title: Implementing a Hybrid Data Warehouse

Abstract: The last couple of years have seen the emergency of “Big Data”, “Cloud” and “Internet of Things”. Subsequently, Gartner at the 2016 Gartner Summit in Barcelona declared the Enterprise data warehouse (EDW) as dead. Which of course is silly. Sensible companies don’t just throw money out of the window. But they need to adapt and change when new opportunities arrive. Enter the hybrid data warehouse. Combining the power of big data and cloud with your trusty EDW. This session will take a look at a few different approaches to a hybrid data warehouse, with components such as SQLServer 2016, Azure Data Lake, HDInsight, Azure Analysis Services, Azure SQL Data warehouse and Polybase, with some scenarios where the approaches might become relevant. And some pitfalls you need to know about along the way.

Speaker(s):

  • Johan Ludvig Brattås

Track and Room: BI Platform Architecture, Development Administration - BI room


Title: The fact that I am an old Database Server does not mean I have no memory problems

Abstract: Having enough memory is critical to SQL Server’s performance, in this session we will try to answer some questions: how SQLOS of SQL Server manage its memory? SQL Server is using all of the memory available for it on the server, but is it enough? What could be wrong if SQL Server will have too much memory? Why Doesn’t SQL Server Release Memory? How to identify when the system was under external and/or internal memory pressure? What are the RING_BUFFER_RESOURCE_MONITOR telling me? Who is filling my memory? How much server memory is being wasted by storing empty space? Large-page memory (trace flag 834) could it help Columnstore indexes? How much memory can a single session have? What can I do with Out Of Memory error?

Speaker(s):

  • Dubi Lebel

Track and Room: Enterprise Database Administration Deployment - Auditorium


Title: Become a Power BI superstar under 1 hour!

Abstract: Power BI is Microsoft’s industry leading data analytics discovery and visualization tool that has disrupted the way data professionals interact and derive insights from their data. It is one of the most in-demand and sought-after tools to know in today’s IT career market. Join us for a fun and interactive learning opportunity to learn how to ingest, transform and visualize data from a wide variety of sources using Power BI. Learn how to create rich and interactive reports incorporating slicers, drill-down and drill-through actions. Attendees will also learn how to create, publish and share reports and dashboards for desktop and mobile consumption. Attendees will walk-away feeling like real Power BI *superstars, capable of tackling any data project in their paths! *Awesomeness may vary.

Speaker(s):

  • Ronen Chenn

Track and Room: Analytics and Visualization - BI room


Title: UTF-8 in SQL Server 2019: Theory, implementation for Hebrew, and internals level behind the scene.

Abstract: SQL Server started using Unicode with UCS-2 encoding (mapping range 0-65535, using 2 bytes). In time, support to UTF-16 added (mapping additional range up to 1114111, constructed from two UCS-2 Code Points using 4 bytes). Traditionally Unicode data types like NVARCHAR/NCHAR are marked with “National Character” N.

SQL Server 2019 introduced the Supplementary Character “_UTF8” to fully support UTF-8 under non-“National Character” Data types like CHAR/VARCHAR. UTF-8 potentially can reduce the data size dramatically up to 50%, but migrating to the new feature requires an in-depth understanding on how SQL Server store and use the data in order to prevent unwanted implications

In this presentation we will cover different string data types and Collations, supplementary characters and surrogate pairs, Code Pages, encoding (ASCII, Unicode, UCS-2, UTF-16, and UTF-8), Emoji, and more. We will dive into SQL Server internals and examine the way SQL Server store the data behind the scenes

Speaker(s):

  • Ronen Ariely

Track and Room: Application Database Development - Data Engineers room


Title: Cloud Powered SQL Server Performance Tuning Unleashed

Abstract: Monitoring SQL Server is a combination of knowing what you need to monitor in your environment and how to accomplish that monitoring. For most of us, we’ll need a way to detect blocking, finding long running queries, discover what filegroups need more space and which jobs failed and this is just as a start. We also need a way to capture more detail of how the system is being used at both the hardware and software level and hopefully be notified before a situation becomes critical to the overall system health. 

Gather all that information, at a constant rate and keeping it long enough to understand trends - that is a challenge that was used to be handled only by expensive tools.

Join this session to learn how Quest used the Cloud power to build Spotlight Cloud monitoring solution. A fully managed, enterprise-grade tool that can do all of the above, at a price that is affordable by organizations of any size.

Speaker(s):

  • Anat Dror

Track and Room: Application Database Development - Cloud room


Title: Get To The Point - learn to plan and deliver a concise and engaging message

Abstract: Peoples attention span is getting shorter! If you want to to deliver a message that sticks - GET THE THE POINT.

Join this lecture and learn practical tools to design and deliver a shorter more effective message in an authentic and memorable style.

Speaker(s):

  • Daniela Liberman

Track and Room: Other - Architecture room


Title: Top errors in DB design and code that hurt our performance

Abstract: I’ve been working with SQL Server for over then 20 years and during that time I’ve made and also saw others make some mistakes that caused performance problems and some times might even caused SQL Server to return an unexpected data. In this presentation I’ll show few of those mistakes and I will use those mistakes to explain about key features such as creation of query plan, memory grant, etc’.

Speaker(s):

  • Adi Cohn

Track and Room: Application Database Development - Auditorium


Title: Azure Data Explorer - it is not your ordinary database

Abstract: Large and versatile data sources? unstable structure? Huge volumes of free text? In this session we will have a short overview of the tool, and the use cases it supports today. An introduction to the unique query language it uses Through out the entire session we will have demos for data ingestion, manipulation and query showing the tool capabilities.

Speaker(s):

  • Yoav Dobrin

Track and Room: Cloud Application Development Deployment - Cloud room


Title: Extended Events: Successful Troubleshooting recipes

Abstract: Since Profiler was set as deprecated Extended Events is becoming more and more the default tool for event capturing in SQL Server.

In this session you will see some very cool recipes for troubleshooting, such as deadlock capture, blocked process capture, page splits capture and more, besides queries to easily show the information captured by the XE session, allowing you to apply these techniques to immediately monitor your environment.

Speaker(s):

  • Dennes Torres

Track and Room: Enterprise Database Administration Deployment - Data Engineers room


Title: From Data to actionable business insights

Abstract: Data and Analytics- Overview:

  1. Why do organizations need data?
  2. What is Business Analytics?
  3. Business Analytics Vs. Business Intelligence
  4. Data- Trends
  5. Analytics Maturity Model
  6. Key Success Factors For Analytics Business Analytics Applications How to turn data into actionable insights:
  7. Building the analytics platform
  8. Analytics strategies

Speaker(s):

  • Ronat Omer

Track and Room: Analytics and Visualization - BI room


Title: Be a dynamic SQL dynamo!

Abstract: This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.

Speaker(s):

  • Joanna Wolthuis

Track and Room: Application Database Development - Data Engineers room


Title: Data Visualization: How to truly tell a great story!

Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…

Speaker(s):

  • Jonathan Stewart

Track and Room: Analytics and Visualization - BI room


Title: What’s new in Query Store 2017

Abstract: In SQL Server 2016, Microsoft introduced the Query Store. A repository that can hold overtime performance information about your queries, and cannot only tell you what is happening now, but also provide insights to what have been changed in the workload and plans.

In this session we look at the good, the bad and the ugly of query store: list its newest and powerful features introduced in SQL Server 2017, explains how to incorporate Query Store into the new SQL Operation Studio (SQLOps) for monitoring slow running queries and analyzing waits and also detail what you need to be aware of when using it.

Speaker(s):

  • Anat Dror

Track and Room: Application Database Development - Architecture room


Title: Lost in the wealth of database products? We will help you to make sense of them.

Abstract: 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 analyse typical use-cases and architectures. Last but not least - we will review few less popular technologies that are worth consideration and adoption.

Speaker(s):

  • Michael Zilberstein

Track and Room: Strategy and Architecture - Auditorium


Title: The Couchbase data platform - perform at any scale, manage with ease

Abstract: Couchbase is the NoSQL data platform for business critical applications where performance, scalability and agile development are a must, and also easy to use and administer. In this session we’ll take a peek at Couchbase and see how it incorporates multiple distributed and scalable engines such as caching, document based DB, full text search, analytics, eventing, active-active masterless replication - all in a single integrated platform. Couchbase also offers a full fledge SQL-like language (N1QL) supporting inner/outer joins, aggregations, subqueries and everything you know from SQL.

Speaker(s):

  • Lior King

Track and Room: Strategy and Architecture - Auditorium


Title: Azure Analysis Services - Why-When-How

Abstract: Azure Analysis Services - Why-When-How Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud. Use advanced mashup and modeling features to combine data from multiple data sources, define metrics, and secure your data in a single, trusted tabular semantic data model. The Session will discover usage , patterns and more…

Speaker(s):

  • Yossi Elkayam

Track and Room: Analytics and Visualization - BI room


Title: TDE And Encryption with Azure Key Vault from Zero to Hero

Abstract: Need to Follow Regulation ? need to store your keys in safe place ? at this session we will learn with a step by step approach how to use Azure Key Vault to implement TDE and encryption in complex production environment,identify pitfalls and problems and how to avoid them.

Speaker(s):

  • Danny Ravid

Track and Room: Enterprise Database Administration Deployment - Data Engineers room


Title: The algorithm for building the perfect multi-columned index

Abstract: We will learn the Optimizer’s decisions when choosing between the different index paths within the execution plan. We will learn how to analyze and chose the best ORDER of the columns within a multi column index according to the predicates, location in query, column statistics and more.

Speaker(s):

  • Ray Maor

Track and Room: Enterprise Database Administration Deployment - Data Engineers room


Title: Make sense of real-time data using Elasticsearch

Abstract: Elasticsearch is a data store built for addressing various data challenges using the foundations of speed, scale and relevance. It provides advanced querying, search and real-time analytics capabilities. Throughout this talk, Arthur Gimpel, Solutions Architect at Elastic, will introduce Elasticsearch and the Elastic Stack, demonstrate different use cases of using it as a main data store, or alongside with your current databases, using the polyglot persistence architectural approach.

Speaker(s):

  • Arthur Gimpel

Track and Room: Advanced Analysis Techniques - BI room


Title: Monitoring Azure SQL Database with Log Analytics and PowerBI

Abstract: Azure SQL Database Is a PAAS service of a database. You can not install agents, Maintenance or Outages are happening without letting us know and the monitoring is hard. Also, the servers are not available and you need to be creative to monitor it. Azure gives us Log Analytics. And I build PS scripts and PowerBI dashboards. In this session, i will go over those solutions and show some examples.

Speaker(s):

  • Pini Krisher

Track and Room: Cloud Application Development Deployment - Cloud room


Title: Explanatory analysis with Jupyter Notebooks

Abstract: Come to this session to learn about open-sourced, extensible and collaborative modern tool that empowers data professionals to create and share documents that contain live code, visualizations and text narrations.

Speaker(s):

  • Maria Zakourdaev

Track and Room: Analytics and Visualization - Architecture room


Title: Choosing the Right Database for Microservices Solutions

Abstract: The past years have seen the explosive growth of large-scale distributed systems, based on microservices architecture. The result is a competitive database marketplace with a huge variety of platforms for us to choose from. But how do we go about making the right choices? This talk is mostly focused on real life examples and best practices, related to microservices solution, based on Microsoft Azure

Speaker(s):

  • Mihail Mateev

Track and Room: Strategy and Architecture - Architecture room


Title: integration between Sql Server and big data

Abstract: Sql server is here to stay. the database in the cloud architecture or on premise is the heart of the business. SQL alone is not enough to allow us big insights from our data , insights we need in order to stay in competition. for these purposes we need data lake , we need search engines , columnar databases , predictive analytics tools etc. in this session we will discuss how we can move data in real time from our main SQL Server to the data lake , we will discuss several big data leading products such as Snowflake , Vertica , Elastic search etc and how we can integrate quickly from SQL server to these products.

Speaker(s):

  • Yuval Klein

Track and Room: Strategy and Architecture - Architecture room


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Johan Ludvig Brattås

Twitter: - intoleranse

LinkedIn: Johan Ludvig Brattås

Contact: http://brattas.org/sqlmusings

Johan Ludvig Brattås is a managing consultant at Capgemini, and a dedicated community guy. He has worked with MS SQL server since late 1999, mostly with BI in one form or another. The last 6 years, most of his work has been in Azure working on data platforms, Power BI and the last three years expanding to Azure IoT and Stream Analytics.

Combining his passion for Microsoft SQL Server with his passion for sharing knowledge, he has spoken at various events in the SQL Community. This is also a way to give back to the community for all the things he has learned over the years. When not working, Johan Ludvig either spends his time with his kids, playing with new technology, or teaching coeliacs how to bake glutenfree food.

Maria Zakourdaev

Twitter: - @Maria_SQL

LinkedIn: Maria Zakourdaev

Contact: http://sqlblog.com/blogs/maria_zakourdaev/default.aspx

I have been working with SQL Server for more about 20 years. I have experience managing enterprise-wide environments, both transactional and data warehouse flavors. This days, also working closely with other database technologies, including Postgresql, Redis, RedShift, CouchBase and ElasticSearch. However, my preferred technology is still an SQL Server.

Dennes Torres

Twitter: - Dennes

LinkedIn: Dennes Torres

Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/

Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.

Daniela Liberman

LinkedIn: Daniela Liberman

Daniela Liberman is a professional trainer and consultant at Barry Katz Ltd. Daniela facilitates workshops and lecture about interpersonal communication and effective presentations. She trains many presenters towards important presentations: TedX, Demo days, elevator pitch, local conferences and abroad. She works with Hi-Tech companies (such as Nice, Microsoft, Arm, Finastra, Radware, Marvel, etc), Pharma companies, ministry of education and the ministry of defense and more. Daniela gained substantial technological experience both as commanding officer in the IDF’s 8200 intelligence unit, and as a quality assurance engineer at IBM. During these years, she completed her B.A. in Psychology and M.A. in Organizational Consulting.

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.

Joanna Wolthuis

Twitter: - ochthenoodle

LinkedIn: Joanna Wolthuis

Joanna Wolthuis is an independent contractor specialising in T-SQL database development and reporting using SSRS and Excel based solutions for the last 8 years. She is passionate about data and learning everything about anything. Aside from SQL Joanna enjoys traveling, nice food and attempting to be an acrobat (not at the same time!).

Yuval Klein

LinkedIn: Yuval Klein

BigData presale leader at NessPro the product division of Ness. as a PreSale of Big Data products I am leading the division in all the business and technical aspects of big data products sales , handling POC to company clients , RFI , the focal point to all technical aspects of the products , helping in all technical asects of the big data products on top of hadoop , apache drill , hive , kafka , Cassandra etc.

Ronen Chenn

LinkedIn: Ronen Chenn

Contact: http://blogs.microsoft.co.il/bilive/

Ronen works with Microsoft BI tools since … ever(…) Since then, he professionalize with Cloud based BI. while serving in number of roles, one of them, as Microsoft Regional Director for Microsoft EPG and Microsoft Consulting Services.

Since Power BI was released to the market , Ronen is involved within the tool design, from its early stage, especially with the local dev team in ILDC ( Israel ). Ronen successfully implemented PowerBI implementations in some of the major strategical sites in the EMEA Area.

Ronen is an Architect Expert. Ronen’s quote of the day: “Forget about reporting. consider turns Data Into Value.”

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.

Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on

Anat Dror

Twitter: - anatdror72

LinkedIn: Anat Dror

A SQL Server and DB2 domain expert with over 20 years of experience in a long list of IT related roles including leadership, processes re-engineering, technical architecture, design, implementation, planning and deployment. As a subject matter expert, Anat has a broad and deep understanding of cloud computing, virtualization, database development and administration, performance management and storage. Today she plays a pivotal role in understanding customer requirements, fostering innovation and bringing Dell Software Database Performance Management solutions to life.

Dubi Lebel

Dubi Or Not To Be If you think you are too small and can not make a change, you probably never went to sleep with a mosquito

Ray Maor

LinkedIn: Ray Maor

Ray Maor is an experienced RD leader, developer and architect. Ray has over 20 years of experience as a senior DBA and a development Team Leader. He went on to consult to the RD teams of leading technology providers and other companies including HP Israel (Mercury), CA, EDS, Digital Fuel and Bank Hapoalim. Since joining Experda, Maor has led the development of the company’s product lines including Qure Profiler, Qure Optimizer, EZManage 4.0-5.5 and the newly EZManage cloud development. Maor is fluent with over 15 programming languages and has over 25 certificates for advanced computer science skills he has acquired over the years.

Brent Ozar

Twitter: - BrentO

LinkedIn: Brent Ozar

Contact: https://www.BrentOzar.com

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.

Lior King

Twitter: - Lior__King

LinkedIn: Lior King

I’ve started my career as a developer, but later I’ve discovered that my true passion lies in data platforms of all kinds (relational and non-relational). Since then I’m a DBA, an instructor, a team leader, a consultant and an architect of data platforms for more than 20 years. At first I was an Oracle DBA and on 2005 I fell in love with SQL Server and been using it ever since along with other platforms.

Today I work for Intercontinental Exchange (ICE) and deal with a wide variaty of platforms including SQL Server, Oracle, MySQL, PostgreSQL, Cassandra, Hadoop, Kafka and MongoDB.

Jose Manuel Jurado Diaz

Twitter: - jmjuradodiaz

LinkedIn: Jose Manuel Jurado Diaz

José Manuel Jurado currently works as SQL Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 20+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events such as SQLSaturday, SQL Nexus, SQLBits, Pass Summit, SQL Server Konferenze, TechReady, DotNetConference, and Azure BootCamp. In the past, he worked as Project Manager for large global retail company for more than 10 years developing projects using different Microsoft Technologies.

Guy Glantser

Twitter: - guy_glantser

LinkedIn: Guy Glantser

Contact: https://www.madeiradata.com/blog

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS Local Group, as well as the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant, or a speaker. His main area of expertise is SQL Server development and optimization. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQLSaturdays, and user groups around the world. He also co-hosts the SQL Server Radio podcast.

Shai Priva

LinkedIn: Shai Priva

.

Taras Kloba

Twitter: - klioba

LinkedIn: Taras Kloba

Contact: http://sql.ua

✅ Senior DBA and developer; ✅ Senior database architect; ✅ Business solutions expert; ✅ 9+ years of experience.

Senior database administrator and programmer. Consultant and certified database administrator and developer with 9+ years of experience working with SQL Server 2016, 2014, 2012, 2008, 2005, 2000 and SQL Azure. MySQL, PostgreSQL and MS SQL database performance tuning expert. Business solutions consultant and implementer. With many years of extensive experience in the IT and other business industries in a variety of roles. My objective is to use my experience to bring creative and top-level solutions to businesses that require SQL Databases.

Danny Ravid

LinkedIn: Danny Ravid

Danny Ravid is an Architect at eToro.com the biggest social trading company in the world.

Danny is a veteran architect, DBA, trainer, and speaker, working with SQL Server since 1993.

Danny has architected, led, and designed many Database projects for the last 25 years, from small size to enterprise level. Danny is among only a few dozen who have achieved both Microsoft Certified Architect (MCA) and Microsoft Certified Master (MCM).

Anat Dror

Twitter: - anatdror72

LinkedIn: Anat Dror

A SQL Server and DB2 domain expert with over 20 years of experience in a long list of IT related roles including leadership, processes re-engineering, technical architecture, design, implementation, planning and deployment. As a subject matter expert, Anat has a broad and deep understanding of cloud computing, virtualization, database development and administration, performance management and storage. Today she plays a pivotal role in understanding customer requirements, fostering innovation and bringing Dell Software Database Performance Management solutions to life.

Itshak David

Contact: Global Hebrew Virtual PASS Chapter : Data virtualization with SQL Server 2019 PolyBase https://www.youtube.com/watch?v=ixfwdZUj_A8feature=youtu.be https://globalhebrew.pass.org/MeetingDetails.aspx?EventID=15457   SQL Server 2019 Big Data Cluster BDC and Spark from Zero to an hero by David Yitzhak https://www.youtube.com/watch?v=iKgMqyPOVS0   David Izhak: Performance Improvements in SQL 2014 – lessons from the field https://www.youtube.com/watch?v=x4hGjYGBfkc   David Itzhak: Practical SQL 2014 Data Mining

David Yitzhak has over 24 years of experience with SQL Server, Oracle, and Sybase. He is an applicative infrastructure DBA for relational and Nosql solutions (MongoDB, Redis), Hadoop CDH and Spark. David is a specialist in HA and DRP solutions, tuning, Machine learning , security, High Performance Computing, replication (Oracle SQL Server), BI infrastructure and system engineering. David Yitzhak holds 3 Degrees from Technicon (Israel Institute of Technology): BSC Information System , MBA and ME (System engineering) and research associate in one of the enterprise Organizations. He presents in Oracle open world 2010, Organize Oracle ILOUG for 3 years , SQL Server forums, Microsoft BI forums, Sqlsaturday Israel 2016/17/18/19 , 3rd Israeli

Adi Cohn

Work as a SQL Server DBA since 1997

Yoav Dobrin

LinkedIn: Yoav Dobrin

Cloud Solution Architect with Microsoft. Over 19 years of experience. Loves to cook ride bikes.

Yossi Elkayam

LinkedIn: Yossi Elkayam

Engage with Customers to align their Business Strategies to IT Strategies through understanding their Business and Technology Capabilities. Identifying the gaps between the current state and the desired state based on their strategic needs and market trends. Leading a worldwide class of cloud End to End solutions. Deep experience with Cloud data platform and cloud solution architecture.

Michael Zilberstein

LinkedIn: Michael Zilberstein

Michael Zilberstein, CEO and founder of DBArt Ltd. Data architect and SQL Server database consultant with vast experience in all aspects of architecture, administration and complex performance troubleshooting.

Ronen Ariely

Twitter: - https://twitter.com/pitoach

LinkedIn: Ronen Ariely

Contact: http://ariely.info/Blog/tabid/83

Ronen Ariely is a senior consultant, an applications data architect. He has more than 15 years’ experience in variety programming languages and technologies, leading development teams and software companies in enterprise level solutions in the fields of Data Platforms, BI, and developing. Ronen is active in communities (aka pituach) in the fields of Microsoft Azure, SQL Server, T-SQL, and Dot.Net programming. He serves as Moderator at MSDN and as one of the Microsoft TechNet WIKI communities’ leaders. Ronen writes technical blogs, TechNet articles and blogs, he is co-admin of Microsoft’s blogs “TechNet WIki” and “MSDN Forum”, and has been awarded as Microsoft Most Valuable Professional.

Ronat Omer

LinkedIn: Ronat Omer

Contact: https://www.ronatomer.com

Data, Business Analytics and Performance optimization expert, with over 15 years of experience in Business Analytics and BI, supporting management’s decisions and optimizing processes. I held management and senior level roles in various companies, and in different maturity levels of their analytics’ capabilities. Consults companies who wish to plan or improve their data and analytics capabilities.

Arthur Gimpel

LinkedIn: Arthur Gimpel

I’m a data geek. I started my path in the industry as a SQL Server DBA. At around 2012, I decided to invest all of my time in NoSQL technologies, like Elasticsearch, MongoDB and a few others which I believed in. These days, I am working as a Solutions Architect at Elastic, aiming to solve various challenges with realtime search and analytics technology which is built for Speed, Scale and Relevance.

Pini Krisher

Twitter: - @krisherpi

LinkedIn: Pini Krisher

Contact: http://www.sqlazure.co.il

Manage DBA Teams and RD groups since 1996 lately work on: SQL Server 2000-2017 SQL Azure SSRS SSIS SNA DATA Architect noSQL GraphDB BIG DATA

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page