|Start Time (24h)||Speaker||Track||Title|
|09:30:00||Denis Reznik||Enterprise Database Administration Deployment||SQL Server Performance Tuning Nowadays|
|09:30:00||Hubert Kobierzewski||BI Platform Architecture, Development Administration||SSIS – Transform Your Data in Parallel|
|10:45:00||Grzegorz Łyp||Enterprise Database Administration Deployment||Tuning large queries|
|10:45:00||Pawel Potasinski||Analytics and Visualization||R'em All. Use R in Power BI to Deal with Data|
|12:00:00||Satya Jayanty||Enterprise Database Administration Deployment||2,4,8 16 - Upgrade your journey with SQL Server|
|12:00:00||Tomasz Libera||Analytics and Visualization||Reporting Services Power BI Server|
|14:00:00||Mikael Wedham||Enterprise Database Administration Deployment||A Masters view on Locking and blocking|
|15:15:00||Stephanie Locke||Information Delivery||Build your first bot – no code required!|
Event Date: 16-09-2017 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
In this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way, we will learn performance tuning practical techniques and solve a bunch of issues in real-time. And despite I'm a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice.
Event Date: 16-09-2017 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 16-09-2017 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 16-09-2017 - Session time: 10:45:00 - Track: Analytics and Visualization
Event Date: 16-09-2017 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment
Why Upgrade? Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.
In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.
What to-do and what not-to-do?
A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.
Event Date: 16-09-2017 - Session time: 12:00:00 - Track: Analytics and Visualization
During the session I’m going to explain licensing model and show how to use it. Finally, I’ll compare Power BI cloud service and on-premise capabilities.
Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.
Event Date: 16-09-2017 - Session time: 15:15:00 - Track: Information Delivery
I’ll be using Microsoft’s qnamaker.io site to build an FAQ bot and the putting it live with an Azure Bot Service and the Skype Web Control. The end result is a little snippet you can add to any web page, making implementation a breeze.
You can follow along as I build the bot live, or just soak it all in. Either way, you’ll see how easy it is to build a bot and you’ll know the next steps to follow to start building more complex bots.