|Start Time (24h)||Speaker||Track||Title|
|10:15:00||Dejan Sarka||BI Platform Architecture, Development Administration||Forecasting with MS BI Suite|
|10:15:00||Dejan Dular||Application Database Development||In the name of the resources: Aggregating data|
|11:30:00||Mario Meir-Huber||Cloud Application Development Deployment||Doing Hadoop with Azure HDInsight|
|11:30:00||Hugo Kornelis||Application Database Development||T-SQL User-Defined Functions, or: How to kill performance in one, easy step|
|11:30:00||Roman Rehak||Enterprise Database Administration Deployment||Building Disaster Recovery solution with AlwaysOn|
|13:30:00||Marek Chmel||Strategy and Architecture||Running SQL Server as a Container|
|14:45:00||Dr. Subramani Paramasivam||Analytics and Visualization||Beginning Data Science-From Novice to Professional|
|14:45:00||Miloš Radivojević||Application Database Development||Parameter Sniffing Problem with Stored Procedures|
|16:00:00||Andrea Martorana Tusa||BI Information Delivery||Mobile BI with Microsoft tools|
|16:00:00||Dejan Dular||Application Database Development||Window functions are your friends|
Event Date: 24-06-2017 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 24-06-2017 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 24-06-2017 - Session time: 11:30:00 - Track: Cloud Application Development Deployment
Event Date: 24-06-2017 - Session time: 11:30: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: 24-06-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-06-2017 - Session time: 13:30:00 - Track: Strategy and Architecture
Event Date: 24-06-2017 - Session time: 14:45:00 - Track: Analytics and Visualization
How can we see and try using a data scientist statistical model in our day to day familiar tool like Microsoft SQL Server?
Thanks to Microsoft for integrating R Revolution within SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016 and also to utilize it for any applications and/or Reporting services.
Event Date: 24-06-2017 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 24-06-2017 - Session time: 16:00:00 - Track: BI Information Delivery
They also released the Mobile Report Publisher for authoring and creation of mobile reports. This application is based on Datazen technology, a company that Microsoft acquired in 2015. As Microsoft stated, using only one mobile BI app users will access dashboards and reports on mobile devices.
Now developers must choose a tool for developing BI optimized for mobile devices: SSRS, Mobile Report Publisher (former Datazen) or Power BI? The question is: which one to choose? What are the key factor for supporting the correct decision? We will provide a clear and understandable overview of each product, highlighting strengths and weaknesses. Based on some real examples we will set out a comparison matrix to find the best way to meet your needs with the right mobile reporting tool.
Event Date: 24-06-2017 - Session time: 16:00:00 - Track: Application Database Development
Window functions are great! They open a whole new world of elegant data analysis. Their only problem is that they seem complicated at first glance. In this session we will get OVER() them and see how can we use them together with aggregation, analytic and ranking functions. After this session creating queries with things like running totals will be a piece of cake!