| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:55:00 | Guy Glantser | Application Database Development | Analyzing Execution Plans Like a Pro |
| 09:55:00 | Amit Rappel | Advanced Analysis Techniques | Make predictions using Azure Machine Learning Studio |
| 09:55:00 | Itshak David | Enterprise Database Administration Deployment | MSSQL on Linux and OPEN source full orchestra from 0 to hero! |
| 09:55:00 | Leonid Ore | BI Platform Architecture, Development Administration | Azure SQL DWH, from ingesting the data to providing analysis |
| 11:10:00 | Yossi Elkayam | Analytics and Visualization | Near/Real Time Analytics with Power BI |
| 11:10:00 | Matan Yungman | Application Database Development | Elegant T-SQL Solutions for Real World Problems |
| 11:10:00 | Adi Cohn | Application Database Development | TempDB behind the scenes |
| 11:10:00 | Gilad Mittelman | Application Database Development | Azure SQL Database: The Intelligent Cloud Database for App Developers |
| 13:15:00 | Dubi Lebel | Enterprise Database Administration Deployment | SQL Server engine under the hood |
| 13:15:00 | Nimrod Keinan | Other | MSSQL To Run On Linux Systems, Can It Be? Well, Are you ready for the vNext step in evolution? |
| 13:15:00 | Sharon Oliar | Strategy and Architecture | Hybrid SQL business continuity - Backup , DR and Monitoring |
| 13:15:00 | Ronen Ariely | Strategy and Architecture | SQL Server Internals - Binary (Stored) format of the data |
| 14:30:00 | Niv Feldman | BI Platform Architecture, Development Administration | How to Setup and Manage a Corporate Self-Service Analytics Environment |
| 14:30:00 | yehuda lasri | Enterprise Database Administration Deployment | Next generation Saas solution for extreme database performance monitoring |
| 14:30:00 | Danny Ravid | Enterprise Database Administration Deployment | Your Database at the speed of Flash |
| 14:30:00 | Erez David | Professional Development | SQL Server migration with Powershell and dbatools |
| 15:15:00 | Yuval Klein | Enterprise Database Administration Deployment | migrating from Sybase ASE data server to Sql Server 2016 VNext on Red Hat Linux |
| 15:15:00 | Satya Jayanty | Cloud Application Development Deployment | Big Data with Azure: where to begin? Concepts and best practices |
| 15:15:00 | shay shahak | Cloud Application Development Deployment | Secuiring Azure SQL |
| 16:30:00 | Ronen Chenn | BI Platform Architecture, Development Administration | Sql Server 2016 Tabular Architecture. Living On the Edge. |
| 16:30:00 | Pini Krisher | Cloud Application Development Deployment | Working with the SQL Azure DB |
| 16:30:00 | Jan Mulkens | Advanced Analysis Techniques | Enabling Citizen Data Science with Microsoft |
Event Date: 27-04-2017 - Session time: 09:55:00 - Track: Application Database Development
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…
Event Date: 27-04-2017 - Session time: 09:55:00 - Track: Advanced Analysis Techniques
Event Date: 27-04-2017 - Session time: 09:55:00 - Track: Enterprise Database Administration Deployment
. 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 .
Event Date: 27-04-2017 - Session time: 09:55:00 - Track: BI Platform Architecture, Development Administration
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.
Event Date: 27-04-2017 - Session time: 11:10:00 - Track: Analytics and Visualization
Event Date: 27-04-2017 - Session time: 11:10:00 - Track: Application Database Development
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.
Event Date: 27-04-2017 - Session time: 11:10:00 - Track: Application Database Development
Event Date: 27-04-2017 - Session time: 11:10:00 - Track: Application Database Development
Event Date: 27-04-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-04-2017 - Session time: 13:15:00 - Track: Other
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)
Event Date: 27-04-2017 - Session time: 13:15:00 - Track: Strategy and Architecture
Event Date: 27-04-2017 - Session time: 13:15:00 - Track: Strategy and Architecture
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.
Event Date: 27-04-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Adopting a data-driven approach through a corporate self-service analytics (SSA) environment is integral to strengthening your data and analytics strategy.
Event Date: 27-04-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-04-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-04-2017 - Session time: 14:30:00 - Track: Professional Development
Event Date: 27-04-2017 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-04-2017 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
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.
Event Date: 27-04-2017 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
Event Date: 27-04-2017 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
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 +++
Event Date: 27-04-2017 - Session time: 16:30:00 - Track: Cloud Application Development Deployment
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.
Event Date: 27-04-2017 - Session time: 16:30:00 - Track: Advanced Analysis Techniques
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.