| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Lior King | Professional Development | SPECIAL KEYNOTE: The DBA is DEAD! Long live the NEW DBA ! |
| 10:15:00 | Ronen Chenn | BI Platform Architecture, Development Administration | PowerBI Sql Server 2017 Tabular Architecture. Living On the Edge. |
| 10:15:00 | Itshak David | Enterprise Database Administration Deployment | Practical data science and Performance patterns for a DBA with SQL Server 2017 |
| 10:15:00 | Alexander Arvidsson | Professional Development | Speak your hands – using body language for effective presentations |
| 10:15:00 | Murilo Miranda | Cloud Application Development Deployment | Azure and SQL Server: Getting the best out of the cloud |
| 10:15:00 | Matan Yungman | Other | The Future of the DBA Panel with Lior King Asaf Aviv |
| 11:15:00 | Dubi Lebel | Enterprise Database Administration Deployment | The fact that I am an old Database Server does not mean I have no memory problems |
| 11:30:00 | Michelle Gutzait | Enterprise Database Administration Deployment | Top 10 FREE performance troubleshooting tools for SQL Server |
| 11:30:00 | Yuval Klein | Analytics and Visualization | Sql Server and Big Data : the Hybrid approach |
| 11:30:00 | Matan Yungman | Other | Database Continuous Integration Panel with Amir Fourey Hila Bar |
| 11:30:00 | Ray Maor | Enterprise Database Administration Deployment | Monitor your SQL Servers from anywhere |
| 11:30:00 | David Leichner | Advanced Analysis Techniques | Radically Boosting SQL Queries with GPU Acceleration |
| 12:45:00 | Elad Luvka | Application Database Development | Always Encrypted |
| 12:45:00 | Liran Eisenberg | Analytics and Visualization | Machine Learning Services on SQL Server 2017 |
| 12:45:00 | Anat Dror | Application Database Development | The freedom to choose. Selecting the correct SQL Server flavor for you |
| 14:15:00 | Vitor Fava | BI Platform Architecture, Development Administration | What is the SQL Datawarehouse? |
| 14:15:00 | Mohamed Mawla | Enterprise Database Administration Deployment | SQL Server on Linux? Yes, Linux! |
| 14:15:00 | Andrey Zavadskiy | Application Database Development | Database Modeling In Practice |
| 14:15:00 | Adi Cohn | Application Database Development | Adaptive query processing |
| 14:15:00 | Matan Yungman | Other | Big Data in SQL Server Panel with Ronen Chenn Elad Shwarchberg |
| 15:25:00 | Maria Zakourdaev | Application Database Development | The extraordinary effect of Python support in SQL Server |
| 15:25:00 | Ronen Ariely | Cloud Application Development Deployment | Azure Elastic Databases Azure Elastic Jobs |
| 15:25:00 | Noam Brezis | BI Platform Architecture, Development Administration | The true limitations of AI’s current technology |
| 15:25:00 | Assaf Fraenkel | Cloud Application Development Deployment | Azure SQL Managed Instance - Paas or IaaS? |
| 15:25:00 | Matan Yungman | Other | SQL Server in the Cloud Panel with Itai Binyamin Pini Krisher |
| 16:35:00 | Leonid Ore | Cloud Application Development Deployment | Real world usage of Azure cognitive services with SQL Server 2017 Analytics for operational insight |
| 16:35:00 | Leonard Lobel | Cloud Application Development Deployment | Learning Azure Cosmos DB |
| 16:35:00 | Fabiano Amorim | Application Database Development | 13 reasons why my query is slow |
| 16:35:00 | Janusz Rokicki | Strategy and Architecture | The Road to Autonomous Databases |
| 16:35:00 | Matan Yungman | Other | Programming Best Practices Panel with Shy Engelberg Maria Zakourdaev |
Event Date: 26-04-2018 - Session time: 09:00:00 - Track: Professional Development
Are DBAs no longer needed? (spoiler: they still are). What should you do to stay relevant amidst the technology changes in the industry? We will talk about the new industry trends that are changing the DBA's role, about new career paths that the "new DBA" can take and what new skills DBAs should acquire for each of these paths.
Event Date: 26-04-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Along with the duet of Tabular Model 2017 PowerBI + upcoming cool features.
Development LifeCycle Best Practice and +++
Event Date: 26-04-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
• Learn about how the extensibility mechanism in Microsoft SQL Server 2016/2017 enables you to run R and Python scripts from T-SQL.
• Programming patterns that will allow you to leverage the best of SQL Server and R/Python. We look at how parallel query execution integrates with external script execution and how it can be used to scale your training/scoring scenarios.
• Integration Power Bi Desktop and R scripts.
• Real-time Predictions using Native Scoring using PREDICT function with No dependency on R or Python runtime. New in SQL Server 2017.
This Minimum theory maximum practical examples session!
Event Date: 26-04-2018 - Session time: 10:15:00 - Track: Professional Development
In this hour I go through several pointers for using your hands to convey and reinforce your message. I give ample examples of both good and bad body language and show you several tips and tricks to seriously enhance your stage presence. Attend this session to learn about how body language can make sure you convey what you think you do!
Event Date: 26-04-2018 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
For example, by taking advantage of services like Azure Blob Storage or Azure VMs we can increase the availability of our services or distribute data in smart ways that benefit our performance and decrease cost.
In this session, you will learn the strongest use cases for hybrid scenarios between on-premises and the cloud, and open a new horizon of what you can do with your SQL Server infrastructure.
Event Date: 26-04-2018 - Session time: 10:15:00 - Track: Other
Lior King is going to present the keynote in SQL Saturday Israel 2018, and the topic is “The Future of the DBA”. We are going to grab him right after the keynote, and develop a fascinating discussion with him and with the audience. If you are a DBA today, and you are not sure what you are going to be tomorrow, then this session is for you…
Event Date: 26-04-2018 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment
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?
Event Date: 26-04-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Many DBAs and IT professionals are not aware of the greatness and strength of some of the FREE performance tools that are out there! Those tools, used individually or combined, can help us improve performance significantly by assisting in identifying bottlenecks. In this session I will discuss the top 10 FREE Performance Troubleshooting tools for Windows and SQL Server and will show how to use them, also providing real-world examples.
Event Date: 26-04-2018 - Session time: 11:30:00 - Track: Analytics and Visualization
Event Date: 26-04-2018 - Session time: 11:30:00 - Track: Other
Event Date: 26-04-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 26-04-2018 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
Event Date: 26-04-2018 - Session time: 12:45:00 - Track: Application Database Development
Always Encrypted allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Always Encrypted available in all editions of SQL Server 2016 SP1. You'll learn the diffrence between existing encryption features that have been available in previous versions of SQL Server. You'll learn how Always Encrypted works. Also, there will be a demonstrating of how to implement Always Encrypted with SSMS and PowerShell
Event Date: 26-04-2018 - Session time: 12:45:00 - Track: Analytics and Visualization
Event Date: 26-04-2018 - Session time: 12:45:00 - Track: Application Database Development
Nowadays, while virtualized or not is almost always answered “virtualized”, there are much more questions to answer before you can finalize your decision: where will the database be hosted, will it be on-premise or in the cloud, on windows or on Linux, do I want to create the database engine myself or use a managed database and many more. Join this session to get an overall view of all options available including Azure DB, APS, RDS, Azure IASS, Azure managed instances, hybrid solutions and more. We will talk about the considerations for choosing any of the options and discuss the relative benefits of each.
Event Date: 26-04-2018 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration
SQL Data Warehouse: Combines the SQL Server relational database with Azure cloud scale-out capabilities. Decouples storage from compute. Enables increasing, decreasing, pausing, or resuming compute. Integrates across the Azure platform. Utilizes SQL Server Transact-SQL (T-SQL) and tools. In this session we will discuss about this awesome feature from Microsoft Azure and how we can use it to help on our day to day.
Event Date: 26-04-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
The session will explore the essential skills needed to manage SQL server on Linux. It will also explore the most common tasks and procedures DBAs commit on Windows and their equivalents on Linux. Some troubleshooting skills on Linux will be explored, as well
Event Date: 26-04-2018 - Session time: 14:15:00 - Track: Application Database Development
In this session, we look at some issues that arise in database modeling. We'll try to look at a database from different angles – model, implementation, performance, application that works with that database and business value. We'll touch a logical and physical design, and such things like an "entity vs attribute" problem, denormalization, table splitting, strategy of primary key implementation, how to provide history of data changes, archiving, etc. This session would give you some thoughts and ideas about what to consider when you create a database.
Event Date: 26-04-2018 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 26-04-2018 - Session time: 14:15:00 - Track: Other
On the other hand, SQL Server offers a lot of features and capabilities to handle Big Data scenarios, and in many cases, it can be the best solution.
Event Date: 26-04-2018 - Session time: 15:25:00 - Track: Application Database Development
If you are Database Administrator - you need to get to know this wonderful feature! Learn how it can solve DBA's everyday challenges when dealing with text and json files, bulk loads and even simplify ETL flows when you need to get data from database systems other than SQL Server. Moreover, you can offload the big data querying to nosql database and use Python to get the results into SQL server. Have you ever dreamed about receiving emails from SQL Server stored procedure? Yes, Python can do that! This session will answer questions like:
Event Date: 26-04-2018 - Session time: 15:25:00 - Track: Cloud Application Development Deployment
Azure SQL Database Elastic Pool enables to manage and scale multiple Azure SQL Databases as a group. Databases in a pool share resources (eDTUs). It's a powerful and a cost-effective option for databases that have varying and unpredictable usage demands. During the meetup, we will review “Azure Elastic Pools” and “Azure Elastic Database jobs”, which enable us to execute queries across a group of databases, aggregate data from multiple databases, and improve performance. We will demonstrate the use and discuss cases, which can be optimized by using these features, including a real-life case where we reduce the cost dramatically. Join the meeting and learn how to improve performance and reduce the cost of your Azure databases
Event Date: 26-04-2018 - Session time: 15:25:00 - Track: BI Platform Architecture, Development Administration
Event Date: 26-04-2018 - Session time: 15:25:00 - Track: Cloud Application Development Deployment
Come and learn why this new Instance can help you in migrating your workload to the cloud.
Event Date: 26-04-2018 - Session time: 15:25:00 - Track: Other
Event Date: 26-04-2018 - Session time: 16:35:00 - Track: Cloud Application Development Deployment
Event Date: 26-04-2018 - Session time: 16:35:00 - Track: Cloud Application Development Deployment
We tour many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON, graph, key/value, and columnar data models. You’ll learn about global distribution, scale-out partitioning, tunable consistency, custom indexing, and more. We’ll also explore client development using the many available SDKs and APIs. Attend this session, and get up to speed on Cosmos DB toda
Event Date: 26-04-2018 - Session time: 16:35:00 - Track: Application Database Development
1- There is a nonsargable filter 2- An index is missing 3- It is a query optimizer mistake 4- The subquery is unnecessary 5- Query join order is incorrect 6- A filtered statistic is missing 7- Scalar functions are running twice per each row 8- High number of reads on worktable 9- An unknown syntax could be used 10- Memory grant wasn’t enough 11- Distributed query doesn't look good 12- Residual predicates 13- Avoid window spool ondisk
Event Date: 26-04-2018 - Session time: 16:35:00 - Track: Strategy and Architecture
Event Date: 26-04-2018 - Session time: 16:35:00 - Track: Other