SQLSaturday #623 - Israel 2017
Event Date: 04/27/2017 00:00:00
- Megamot College
- Derekh Em Hamoshavot 94
- Petah Tikva, HaMerkaz, Israel
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).
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Analyzing Execution Plans Like a Pro
Abstract: The most powerful tool when tuning a query is the execution plan. In most cases, by analyzing the execution plan of a query, you can learn all you need to know about how the query processor has chosen to execute the query, what is causing the execution to take so long, and what you can do in order to make it run faster. But there are common pitfalls that you should be aware of when analyzing an execution plan, such as the fact that the operator cost values are always estimated, or the true meaning of the cardinality numbers within some of the plan operators. These pitfalls can be very misleading, and they might lead you to spend your tuning effort in the wrong direction. By understanding these pitfalls and avoiding them, you can save a lot of time and effort. You’ll become a performance tuning hero by getting the slow queries to run faster – faster…
- Guy Glantser
Track and Room: Application Database Development - Auditorium
Title: Enabling Citizen Data Science with Microsoft
Abstract: In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics.
Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure.
These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about fools-with-tools or should we embrace the democratization of data science as the golden age of data?
Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
- Jan Mulkens
Track and Room: Advanced Analysis Techniques - Auditorium
Title: MSSQL on Linux and OPEN source full orchestra from 0 to hero!
Abstract: Open source and Containers are fundamentally changing the way we develop, distribute, and run software. Developers can build software locally, knowing that it will run identically regardless of host environment. . In this session I will cover for Windows DBAs from the beginning : • Quick overview on Docker technology and Docker cluster : Kubernetes , Swarm Cluster and Apache • You will learn how from you windows machine install Dockers Ubuntu template from Docker hub with SQL server SQL Server vNext in minutes and then Compose anther NodeJS Docker . • SQL Server + Node.js what’s new and Demo • SQL Server on Linux with SQL Tools with SQL Server • See how to use the latest SSIS 2016 + vNext to modernize your traditional ETL workflows into scalable hybrid ETL / ELT workflow • Connecting your SQL server with logstash , Elastic Search and Kibana so you can drill down to audit history and performance with no charge and open source .
- Itshak David
Track and Room: Enterprise Database Administration Deployment - Green Room
Title: Azure SQL Database: The Intelligent Cloud Database for App Developers
Abstract: Your customers will be amazed at the intelligence built into Azure SQL Database - this session will clarify the true value of Azure’s PaaS database offering. The new built-in intelligent features in Azure SQL Database work around the clock to learn profile your unique app patterns, and make your apps run faster, make them more secure and cost-effective. The actionable recommendations provided to you are based on ML tuning models running against workload telemetry from millions of customer databases. The session will cover our most advanced features to-date including Threat Detection, auto-tuned performance and actionable recommendations across performance and security aspects. Case studies and live demos will help you understand how choosing SQL Database will make a difference for your customers’ apps and your businesses.
- Gilad Mittelman
Track and Room: Application Database Development - Blue Room
Title: MSSQL To Run On Linux Systems, Can It Be? Well, Are you ready for the vNext step in evolution?
Abstract: SQL Server vNext represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises and in the cloud, and across operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows. I would like to introduce to you the simplicity of step by step in the installation process of the vNext SQL Server Version on Linux. This with some changes in this version Vs. the windows version New language features: o String functions: TRIM, CONCAT_WS, TRANSLATE and STRING_AGG with support for WITHIN GROUP (ORDER BY)
- Nimrod Keinan
Track and Room: Other - Orange Room
Title: SQL Server Internals - Binary (Stored) format of the data
Abstract: There is a common confusion regarding “displayed format” and “stored format” of data using SQL Server. We can find lot of questions in the forums regarding “stored format” of dates, which are actually referring to the “displayed format”, in external application. For example questions like: I am getting the error “DateTime data type resulted in an out-of-range value”, or questions like: “how can I change the DateTime column format in the database”.
In this session, we will explore how SQL Server actually stored the data behind the scene.
We will read SQL Server data file directly using simple binary editor (notepad++), and we will explore the structure of several data types. We will focus on explore how DateTime2 data type is stored, which is probably one of the most common complex data type structure, and we will discuss other types in general (according to our time). During the demo, we are going to show and use several undocumented tools from different versions of SQL Server.
- Ronen Ariely
Track and Room: Strategy and Architecture - Green Room
Title: Azure SQL DWH, from ingesting the data to providing analysis
Abstract: Azure SQL DWH, from ingesting the data to providing analysis Azure SQL Data Warehouse is a massively parallel processing (MPP) cloud-based, scale-out, relational database capable of processing massive volumes of data. It combines the power of Data Analysis appliance with the flexibility in resources of the cloud. Who should use it, Who shouldn’t and Who is already using it? Transfer your data in from your own in-house systems and enrich your data with external sources from the public domain or cloud source and how about non-relational data. But what if we already have too much data and what we need is an Analytically processed and distilled information? How can we get intelligent decision based on all that data that we collected in our SQL Data warehouse? All these and other related questions we’ll try to explore together… See you there.
- Leonid Ore
Track and Room: BI Platform Architecture, Development Administration - Orange Room
Title: How to Setup and Manage a Corporate Self-Service Analytics Environment
Abstract: As companies face the challenges arising from a surge in the number of customer interactions and data, it can be difficult to successfully manage the vast quantities of information and still provide a positive customer experience. It is incumbent upon businesses to create a consumer-centric experience that is powered by (predictive) analytics.
Adopting a data-driven approach through a corporate self-service analytics (SSA) environment is integral to strengthening your data and analytics strategy.
- Niv Feldman
Track and Room: BI Platform Architecture, Development Administration - Auditorium
Title: SQL Server migration with Powershell and dbatools
Abstract: SQL Server migration with Powershell and dbatools
- Erez David
Track and Room: Professional Development - Orange Room
Title: SQL Server engine under the hood
Abstract: Understanding the SQL Server engine architecture, what is it NUMA and who it effect the Data and optimizer engines, how to read mini-dump file, using de-bug tools over SQL engine code. All these can help In a lot of troubleshooting ,so let’s roll up their sleeves, get into the garage and get dirty with grease
- Dubi Lebel
Track and Room: Enterprise Database Administration Deployment - Auditorium
Title: Next generation Saas solution for extreme database performance monitoring
Abstract: Come to this session to learn how to use AimBetter, cloud-based database performance monitoring tool for constant monitoring and analysis of your databases and servers. for Better database Performance, Efficiency and Uptime.
- yehuda lasri
Track and Room: Enterprise Database Administration Deployment - Green Room
Title: Working with the SQL Azure DB
Abstract: Working with the SQL Azure DB -PAAS can be done in many tools: Azure Portal, SSMS, VS, PS. Monitoring is also different from On-Premise SQL Server. SQL Server Agent is missing in SQL Azure DB. I will show how a DBA can and need to work in DB on the Cloud.
- Pini Krisher
Track and Room: Cloud Application Development Deployment - Green Room
Title: Sql Server 2016 Tabular Architecture. Living On the Edge.
Abstract: This session will do a brief overview of Tabular Mode 2016 performance topics, and drill into some common methods for investigating performance issues. Tabular performance and monitoring with Activity Viewer 2016 ( http://activityviewer2016.codeplex.com/releases) Performance investigation tools: Profiler, XEvents, MDX, ETW Tuning Tabular Mode for high end hardware Common pitfalls for processing performance Formula engine performance. Tabular Development LifeCycle Best Practice and +++
- Ronen Chenn
Track and Room: BI Platform Architecture, Development Administration - Blue Room
Title: Make predictions using Azure Machine Learning Studio
Abstract: Azure ML Studio is a powerful canvas for the composition of machine learning experiments and their subsequent operationalization and consumption. In this session we will understand the basic steps of developing a prediction model, and apply it to an exemplary use case.
- Amit Rappel
Track and Room: Advanced Analysis Techniques - Blue Room
Title: migrating from Sybase ASE data server to Sql Server 2016 VNext on Red Hat Linux
Abstract: success story of very big and unique migration project I led in Tnuva the biggest dairy in Israel , migrating data from Sybase ASE data servers(15 data servers across 10 different servers) to Sql server 2016 Vnext on Red Hat Linux. talking about the complexity of the project , the motivation from the project and the big advantages of using the new SQL Server Vnext in large companies all around the world.
- Yuval Klein
Track and Room: Enterprise Database Administration Deployment - Green Room
Title: Near/Real Time Analytics with Power BI
Abstract: BI Dashboards in the modern apps has the challenge of BI 3.0 \ Web 3.0. in this session we will cover core engines for Stream analytics with real time data trough Azure , iOT hubs and Power BI dashboards to achieve more fast and quick data analytics scenarios.
- Yossi Elkayam
Track and Room: Analytics and Visualization - Green Room
Title: Your Database at the speed of Flash
Abstract: we will see in a live demo how the right all flash storage architecture can speed your DB in a mixed workload environment - OLTP OLAP and accelerate business processes.
- Danny Ravid
Track and Room: Enterprise Database Administration Deployment - Blue Room
Title: Big Data with Azure: where to begin? Concepts and best practices
Abstract: In order to ascertain the abilities of cloud computing platform, let us overview what is available offered on Microsoft Azure.
Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
- Satya Jayanty
Track and Room: Cloud Application Development Deployment - Auditorium
Title: Secuiring Azure SQL
Abstract: Means of securing your Azure SQL as a service, concepts, protecting your data, Threat detection, data masking, Azure Security Center and Azure SQL Database service
- shay shahak
Track and Room: Cloud Application Development Deployment - Blue Room
Title: TempDB behind the scenes
Abstract: In this session, I’ll talk about the difference in logging of tempdb in compression to other databases. I’ll talk about the differences between temporary tables and table variables. Run demos that show why many of the information that can be found on the internet about table variables is simply wrong. Show some errors that are done when working with temporary tables that cause performance issues.
- Adi Cohn
Track and Room: Application Database Development - Auditorium
Title: Hybrid SQL business continuity - Backup , DR and Monitoring
Abstract: Microsoft Cloud, Azure, is a growing collection of integrated cloud services that developers and IT professionals use to build, deploy, and manage applications through our global network of datacenters. In Azure, Microsoft Operations Management Suite (OMS) is the all-in-one hybrid cloud management solution for any enterprise to manage their workloads and applications on Azure or AWS, Windows Server or Linux, VMware or OpenStack in the most cost-effective way. This session will guide you on how to enable Hybrid SQL business continuity (Backup , DR and Monitoring ) as a SAAS (Software as A Service)
- Sharon Oliar
Track and Room: Strategy and Architecture - Blue Room
Title: Elegant T-SQL Solutions for Real World Problems
Abstract: T-SQL can help solve many problems you are faced with at your job. Each problem can have many solutions, but not every solution is simple to write, understand and maintain, and not every solution is good in terms of performance. In this session, we will look at real world problems and solve them using T-SQL. We won’t settle for just A solution, but show elegant, simple solutions that will yield optimal performance.
- Matan Yungman
Track and Room: Application Database Development - Orange Room
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: Leonid Ore
BI Solution architect and BI development team leader for last 7 years. Strong background in Data Modeling, deep understanding of theories and practices of Data Warehousing, proven experience of 15 years in the field. Big data , Social analytics and Cloud based applications recent experience. Very experienced with Microsoft SQL Server (7-2016) including SSAS, SSIS, Reporting services, PowerBI and tabular data bases
LinkedIn: Amit Rappel
Amit is a Technion graduate with a BSc in Electrical Engineering and Physics. After working for 10 years in RD, Amit decided to focus on Data Technology. Amit’s experience includes leading various data technology projects, such as data analysis for solar fields, decision optimization for dairy farmers, and planning data structures for efficient algorithm implementation.
Work as a SQL Server DBA since 1997
Nimrod Keinan is a Senior Oracle DBA and consultant at NAYA Technologies. Nimrog has a B.A. in management information system and has a passion is to write, teach, and consult about Oracle DB, MySQL and SQL Server; focusing mainly on conferrable database development, high availability, performance tuning, and database design.
Twitter: - guy_glantser
LinkedIn: Guy Glantser
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.
MSSQL DBA Expert
Data engineer and architect
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.
Twitter: - @krisherpi
LinkedIn: Pini Krisher
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
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.
LinkedIn: shay shahak
Cloud Solution Architect, Focusing mainly in the field of Compute, Networking and Security for cloud environments (IaaS and PaaS) for more than 15 years.
LinkedIn: Ronen Chenn
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.”
Sharon works for more than 25 years in the fields of data center and cloud, specialized in the areas of monitoring, Operating systems, security, Virtualization and more. Sharon is Mamram programming course graduate and has M.Sc. degree in Technology Management. At Microsoft, Sharon works at the STU department, leading all datacenter and private Cloud solutions.
Twitter: - sqlmaster
LinkedIn: Satya Jayanty
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions
Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
Twitter: - https://twitter.com/pitoach
LinkedIn: Ronen Ariely
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.
LinkedIn: Meir Dudai
עושה כל מיני דברים
Twitter: - MatanYungman
LinkedIn: Matan Yungman
Matan Yungman is a Data Engineering Team Lead at Taboola
Principal Solution Architect
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
Twitter: - https://twitter.com/JanMulkens
LinkedIn: Jan Mulkens
Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).
Senior Program Manager in the SQL Security group at Microsoft. Our team is in charge of an array of products aimed at providing multiple security layers (ranging from auditing to dynamic data masking and threat detection) for SQL Server in the cloud, as well as within the engine itself.
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
LinkedIn: yehuda lasri
I am the owner of AimBetter.com and the CEO at RylTech.co.il . AimBetter developed the AimBetter Pro, a monitoring software (SaaS) that monitors MS-SQL and MS Windows Servers as an integrated environment. Using RylTech database administration skills and expertise, we help ISP, B2B, IT managers and database administrators to monitor core application environments in rral time in order to identify and troubleshoot any application availability problems such as: Database application performance, system performance and application code errors.
The following is a list of sponsors that helped fund the event: