| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:10:00 | Brent Ozar | Enterprise Database Administration Deployment | What's New in SQL Server 2019: 100% Demos |
| 10:15:00 | Yuval Klein | Strategy and Architecture | integration between Sql Server and big data |
| 10:15:00 | Joanna Wolthuis | Application Database Development | Be a dynamic SQL dynamo! |
| 10:15:00 | Ronat Omer | Analytics and Visualization | From Data to actionable business insights |
| 10:15:00 | Michael Zilberstein | Strategy and Architecture | Lost in the wealth of database products? We will help you to make sense of them. |
| 10:15:00 | Pini Krisher | Cloud Application Development Deployment | Monitoring Azure SQL Database with Log Analytics and PowerBI |
| 11:20:00 | Guy Glantser | Application Database Development | SQL Server Query Performance Tuning |
| 11:20:00 | Jose Manuel Jurado Diaz | Cloud Application Development Deployment | Move your database to the Cloud: Understand, Design and Migrate AzureSQLDat |
| 11:20:00 | Mihail Mateev | Strategy and Architecture | Choosing the Right Database for Microservices Solutions |
| 11:20:00 | Dennes Torres | Enterprise Database Administration Deployment | Extended Events: Successful Troubleshooting recipes |
| 11:20:00 | Ronen Chenn | Analytics and Visualization | Become a Power BI superstar under 1 hour! |
| 12:25:00 | Taras Kloba | Enterprise Database Administration Deployment | What is CI/CD for databases or how to automate DB changes |
| 12:25:00 | Johan Ludvig Brattås | BI Platform Architecture, Development Administration | Implementing a Hybrid Data Warehouse |
| 12:25:00 | Dubi Lebel | Enterprise Database Administration Deployment | The fact that I am an old Database Server does not mean I have no memory problems |
| 12:25:00 | Anat Dror | Application Database Development | What’s new in Query Store 2017 |
| 12:25:00 | Ronen Ariely | Application Database Development | UTF-8 in SQL Server 2019: Theory, implementation for Hebrew, and internals level behind the scene. |
| 14:15:00 | Arthur Gimpel | Advanced Analysis Techniques | Make sense of real-time data using Elasticsearch |
| 14:15:00 | Daniela Liberman | Other | Get To The Point - learn to plan and deliver a concise and engaging message |
| 14:15:00 | Anat Dror | Application Database Development | Cloud Powered SQL Server Performance Tuning Unleashed |
| 14:15:00 | Lior King | Strategy and Architecture | The Couchbase data platform - perform at any scale, manage with ease |
| 14:15:00 | Ray Maor | Enterprise Database Administration Deployment | The algorithm for building the perfect multi-columned index |
| 15:00:00 | Jonathan Stewart | Analytics and Visualization | Data Visualization: How to truly tell a great story! |
| 15:00:00 | Maria Zakourdaev | Analytics and Visualization | Explanatory analysis with Jupyter Notebooks |
| 15:00:00 | Adi Cohn | Application Database Development | Top errors in DB design and code that hurt our performance |
| 15:00:00 | Yoav Dobrin | Cloud Application Development Deployment | Azure Data Explorer - it is not your ordinary database |
| 16:00:00 | Itshak David | Application Database Development | Inside SQL Server Containers and Kubernetes SQL 2017/2019 - Lessons from the fields |
| 16:00:00 | Yossi Elkayam | Analytics and Visualization | Azure Analysis Services - Why-When-How |
| 16:00:00 | Danny Ravid | Enterprise Database Administration Deployment | TDE And Encryption with Azure Key Vault from Zero to Hero |
Event Date: 11-04-2019 - Session time: 09:10:00 - Track: Enterprise Database Administration Deployment
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!
Event Date: 11-04-2019 - Session time: 10:15:00 - Track: Strategy and Architecture
Event Date: 11-04-2019 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 11-04-2019 - Session time: 10:15:00 - Track: Analytics and Visualization
Event Date: 11-04-2019 - Session time: 10:15:00 - Track: Strategy and Architecture
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.
Event Date: 11-04-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
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.
Event Date: 11-04-2019 - Session time: 11:20:00 - Track: Application Database Development
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.
Event Date: 11-04-2019 - Session time: 11:20:00 - Track: Cloud Application Development Deployment
• 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
Event Date: 11-04-2019 - Session time: 11:20:00 - Track: Strategy and Architecture
This talk is mostly focused on real life examples and best practices, related to microservices solution, based on Microsoft Azure
Event Date: 11-04-2019 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment
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.
Event Date: 11-04-2019 - Session time: 11:20:00 - Track: Analytics and Visualization
Event Date: 11-04-2019 - Session time: 12:25:00 - Track: Enterprise Database Administration Deployment
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.
Event Date: 11-04-2019 - Session time: 12:25:00 - Track: BI Platform Architecture, Development Administration
Event Date: 11-04-2019 - Session time: 12:25: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: 11-04-2019 - Session time: 12:25:00 - Track: Application Database Development
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.
Event Date: 11-04-2019 - Session time: 12:25:00 - Track: Application Database Development
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
Event Date: 11-04-2019 - Session time: 14:15:00 - Track: Advanced Analysis Techniques
Event Date: 11-04-2019 - Session time: 14:15:00 - Track: Other
Join this lecture and learn practical tools to design and deliver a shorter more effective message in an authentic and memorable style.
Event Date: 11-04-2019 - Session time: 14:15:00 - Track: Application Database Development
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.
Event Date: 11-04-2019 - Session time: 14:15:00 - Track: Strategy and Architecture
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.
Event Date: 11-04-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
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.
Event Date: 11-04-2019 - Session time: 15:00:00 - Track: Analytics and Visualization
Event Date: 11-04-2019 - Session time: 15:00:00 - Track: Analytics and Visualization
Event Date: 11-04-2019 - Session time: 15:00:00 - Track: Application Database Development
Event Date: 11-04-2019 - Session time: 15:00:00 - Track: Cloud Application Development Deployment
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.
Event Date: 11-04-2019 - Session time: 16:00:00 - Track: Application Database Development
· 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
Event Date: 11-04-2019 - Session time: 16:00:00 - Track: Analytics and Visualization
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...
Event Date: 11-04-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment