| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:50:00 | Alexander Karl | BI Information Delivery | Reporting Services with Geospatial Visualization |
| 09:50:00 | Alon Spiegel | Enterprise Database Administration Deployment | TDE - Encrypting your DB with PKI |
| 09:50:00 | Roei Basha | Analytics and Visualization | Revolutionizing Microsoft Analytics |
| 11:00:00 | Itshak David | Advanced Analysis Techniques | Practical SQL 2014\2016 Data Mining and introduction to R |
| 11:00:00 | Fabiano Amorim | Advanced Analysis Techniques | SQL Server execution plans – hidden and tricky optimizations |
| 11:00:00 | Adi Cohn | Application Database Development | Understanding latches |
| 12:10:00 | Hugo Kornelis | Application Database Development | T-SQL User-Defined Functions, or: Bad Performance Made Easy |
| 12:10:00 | Assaf Fraenkel | BI Platform Architecture, Development Administration | Inside Columnar Indexes in SQL Server 14 16 |
| 12:10:00 | Shy Engelberg | Cloud Application Development Deployment | Azure SQL DWH - is it just a big table? closer look into MSFT DWH solution |
| 13:20:00 | Niv Feldman | BI Platform Architecture, Development Administration | One BI Platform to Rule Them All! |
| 14:50:00 | Leonard Lobel | Cloud Application Development Deployment | No Schema, No Problem! – Introduction to Azure DocumentDB |
| 14:50:00 | Matan Yungman | Cloud Application Development Deployment | Understanding the Azure Data Stack |
| 14:50:00 | Dubi Lebel | Enterprise Database Administration Deployment | TempDB how its works? |
| 16:00:00 | Brent Ozar | Application Database Development | Watch Brent Tune Queries |
| 16:00:00 | Ronen Ariely | Strategy and Architecture | Built-in JSON support in SQL Server 2016 and tips to improve performance |
| 16:00:00 | Sharon Oliar | Strategy and Architecture | Datacenter modernization |
Event Date: 04-04-2016 - Session time: 09:50:00 - Track: BI Information Delivery
specifically: „from address data to data-presentation in SSRS Mapcontrol in 3 steps.“ Each company has address data in the relational form [street], [postcode] und [place]. In a first step the transition to Geodata is presented in the form of longitude and latitude. The question of data source and data quality is also an issue addressed in this section. The next step deals with the selection of appropriate maps. Of special note is the data-matching of the maps with the address data. Also the own production of map sections will be illustrated in an example. The third step is to conduct the use and configuration of the control and the reference to the report data
Event Date: 04-04-2016 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment
After this one session you will understand the most common encryption/decryption methods and you will be able to deploy them yourself. On top of using MSSQL's built-in API to create keys and certificates - you will be able to create and load external "stronger" keys thus dramatically increasing your security.
Event Date: 04-04-2016 - Session time: 09:50:00 - Track: Analytics and Visualization
Event Date: 04-04-2016 - Session time: 11:00:00 - Track: Advanced Analysis Techniques
Microsoft have acquired Revolution Analytics in order to help customers to find their "Big Data" value. Revolution Analytics is the leading commercial provider of software and services for R, the world’s most widely used programming language for statistical computing and predictive analytics. R will be integrated to SQL 2016 BI. I will give introduction to R and the advantages it gives to Microsoft Data Mining.
• An introduction to data mining
• SQL Server Data Tools (SSDT) Installations
• Demo : Creating a data mining solution with Microsoft association rules
• DEMO : Decision Trees example- In short
• Prediction with MDX queries , No need to know the syntax .
• Identifying Data Patterns – Predictive Models in SSAS
Event Date: 04-04-2016 - Session time: 11:00:00 - Track: Advanced Analysis Techniques
Event Date: 04-04-2016 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 04-04-2016 - Session time: 12:10:00 - Track: Application Database Development
The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.
Event Date: 04-04-2016 - Session time: 12:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-04-2016 - Session time: 12:10:00 - Track: Cloud Application Development Deployment
In this session we will take a look at how it is built, what are the steps we need to take so we can start using it, What are the scenarios it fits and what should we expect when using it.
Event Date: 04-04-2016 - Session time: 13:20:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-04-2016 - Session time: 14:50:00 - Track: Cloud Application Development Deployment
We begin by explaining NoSQL and document databases, and how they compare with traditional relational database platforms. Then we tour the many features of DocumentDB, including rich querying with SQL (that’s right, you query this NoSQL database using SQL!), and client development using the REST API and the DocumentDB SDKs. Next, learn about the server-side programming model and write fully transactional stored procedures, triggers, and user-defined functions. Also explore tunable consistency, scale-out partitioning, custom indexing, attachments, and more. Attend this session, and get up to speed on DocumentDB today!
Event Date: 04-04-2016 - Session time: 14:50:00 - Track: Cloud Application Development Deployment
With Azure as its front line, Microsoft pushes many new technologies out to the wild, and it’s important to understand their capabilities, strengths and weaknesses.
Why? Because when designing a solution, it’s important to choose the right tool for the right job, and SQL Server is not always the best choice. It’s also important to understand the new technologies in order to be able to explain why SQL Server IS the right tool when it is.
Among others, we will talk about Azure SQL Database, Stream Analytics, DocumentDB, Search, HDInsight, Machine Learning, Data Lake, U-SQL, and more.
Join this session to know how the DBA's role might be affected, get an understanding of the new technologies, when to use which one, and how to converge them into a robust data solution.
Event Date: 04-04-2016 - Session time: 14:50:00 - Track: Enterprise Database Administration Deployment
In this lecture we will light up a number of dark corners, explain how really TempDB works, what was the evolution of TempDB and where it arrived in 2016 and Azure.
Event Date: 04-04-2016 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 04-04-2016 - Session time: 16:00:00 - Track: Strategy and Architecture
SQL Server 2016 provides built-in support for importing, exporting, parsing, and querying JSON documents. However, JSON support is not the same as the native JSON type, and it implemented using NVARCHAR type. This might lead to bad performance. For example, there's no built-in option for indexing, which can give us direct use of data as structured data.
In this session we will demonstrate several built-in JSON support functions in SQL Server 2016, and we will finish with some tricks and tips to improve performance.
Event Date: 04-04-2016 - Session time: 16:00:00 - Track: Strategy and Architecture
(1) Hybrid Cloud Platform: Azure Stack - A new private Cloud that Integrates the public cloud domain and the Windows Server domain, where both Microsoft and clients have invested fair amounts over the years. (2) Modern Application Platform: How can the newly version of Windows Server improve and serve as better platform for public or private cloud-based applications. (3) Management Everywhere: Monitor and Control any asset, anytime, anywhere.