|Start Time (24h)||Speaker||Track||Title|
|09:00:00||Dr. Subramani Paramasivam||Data Science Track||Think work like a Data Scientist with SQL 2016 R|
|09:00:00||Regis Baccaro||BI Track||Advanced BIML - for the advanced ETL developer|
|09:00:00||Peter ter Braake||DEV Track||Top SQL Server Performance tips|
|09:00:00||Pedro Sousa||Azure Infrastructure Track||SQL Server Monitor and Maintenance with Azure Operations Management Suite|
|09:00:00||Ivan Campos||DBA Track||Sneak Peak on SQL Server Tools for Linux|
|10:40:00||Markus Ehrenmueller-Jensen||DEV Track||A Game of Hierarchies: From GROUP BY to Recursive CTEs|
|10:40:00||Peter ter Braake||Data Science Track||Combining the Power of Machine Learning with the ease of PowerBI|
|10:40:00||Kendra Little||DBA Track||Troubleshooting Blocking for Beginners|
|10:40:00||André Kamman||Azure Infrastructure Track||SQL Server and Docker. What, How and Why|
|10:40:00||Tillmann Eitelberg||BI Track||RAD with MDS|
|12:00:00||Eduardo Piairo||DEV Track||Delivering changes for databases and applications|
|12:00:00||Etienne Lopes||DBA Track||SQL Server real-life bizarre things|
|12:00:00||Ricardo Cabral||Azure Infrastructure Track||New Azure SQL DB with blades or scripts? Humm what should I use?|
|12:00:00||Rui Romano||BI Track||Power BI from the Trenches|
|12:00:00||Rui Quintino||Data Science Track||First steps with R RStudio for SQL Developers DBAs|
|14:10:00||Markus Ehrenmueller-Jensen||BI Track||My Favorite Pie (Chart): Simple Rules for Clear Visualizations|
|14:10:00||Tomaž Kaštrun||Data Science Track||Data Science for beginners|
|14:10:00||Cláudio Silva||DBA Track||Best practices validation with DBATools|
|14:10:00||Sandro Pereira||DEV Track||BizTalk Server and SQL Server Together: For Developers Admins|
|14:10:00||Tiago Costa||Azure Infrastructure Track||Introduction to Microsoft Azure Search|
|15:50:00||Vitor Pombeiro||Azure Infrastructure Track||What is SQL Data Warehouse? Is it for me?|
|15:50:00||Dr. Subramani Paramasivam||Data Science Track||Revolution R models in SQL 2016 Reporting Services|
|15:50:00||Kendra Little||DEV Track||Tuning Problem Queries in Table Partitioning|
|15:50:00||Kalen Delaney||DBA Track||Recovery Models Made SIMPLE|
|15:50:00||Gabi Münster||BI Track||Quo vadis SSAS – What's new with SQL Server 2016 SP1 and SQL Server vNext?|
|17:10:00||Tomaž Kaštrun||Data Science Track||Microsoft Azure Machine Learning Algorithms|
|17:10:00||Murilo Miranda||Azure Infrastructure Track||High Availability and Disaster Recovery patterns with SQL Server and Windows Server 2016|
|17:10:00||Kalen Delaney||DBA Track||A Look Inside SQL Server Distribution Statistics|
|17:10:00||António Lourenço||DEV Track||New features for devs in SQL Server 2016|
|17:10:00||Gabi Münster||BI Track||Columnstore killed the OLAP-Star: Did it really?|
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: Data Science Track
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: BI Track
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: DEV Track
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: Azure Infrastructure Track
Event Date: 11-03-2017 - Session time: 09:00:00 - Track: DBA Track
Join me in this session and see how to start working with SQL Server on Linux, what tools are available for Linux and how to use them. Let's see how Microsoft has "cooked" this new solution for Linux
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: DEV Track
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: Data Science Track
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: DBA Track
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: Azure Infrastructure Track
Event Date: 11-03-2017 - Session time: 10:40:00 - Track: BI Track
MDS makes the administration and maintenance of your master data quite easy and comfortable. But in more and more projects, we no longer use MDS only as a master data system. Every time you need a small list, a maintainable table, something where somebody can store in any manner manageable information – we use Master Data Services. From the simple management of SSIS jobs to a complex forecasting or annual planning system. With MDS you can create very quickly and easily applications for the processing of well-structured data. And together with the Excel AddIn directly for an environment with a high degree of acceptance. With SQL Server 2016, many more features have been added, to even more simplify the rapid application development process. In this session, we will show different development approach
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: DEV Track
In this session, we will explore the aspects that bring closer and distinguishes databases from the applications. We will share methodologies and strategies that allows to bring together databases and applications in the development process reducing the delivery pain. The final purpose is to understand that applications and databases do not need to live in different worlds with different development processes.
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: DBA Track
Some influence integrity, others performance or even both! Well, I’ve compiled some of them to show you while explaining why they happen and how to avoid/correct them. Yep it’s not magic, there is an explanation for it! Come and get it
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: Azure Infrastructure Track
Anyone of them has the desired result but what surprise effect has automation in store and why is it used more and more? Come and find out in this session.
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: BI Track
This session is targeted to whom is using or start using Power BI and want to take home some really good tips tricks ;)
Event Date: 11-03-2017 - Session time: 12:00:00 - Track: Data Science Track
This is a beginner level session to guide you on why when to use R, and help with the very first steps typical challenges.
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: BI Track
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: Data Science Track
We will focus on answering 5 simple questions.
Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure.
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: DBA Track
Have you ever need to verify if best practices are in use? How do you do it when you have dozens if not hundreds or thousands of SQL servers? One by one? And, what if you have to apply the best practices on those SQL servers? You will also do it one by one?
In this session we will see how easy, fast, precise and less error prone can be validate if a set of SQL servers is respecting the best practices and if not how we can configure them to just by using a set of commands from DBATools module.
This module is one of the most popular tools among DBAs and is developed and maintained by more than 30 contributors from the community. We have PowerShell and SQL Server MVPs, DBAs, developers and QA people. If you do not know this tool or if you want to learn more this is a great oppo
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: DEV Track
The first parts of this session I will address some of the topics that a SQL Admin needs to know to administrate a BizTalk Server platform at the SQL level, I will demonstrate some of common mistakes, how we can avoid them and some of the best practices.
But BizTalk Server also have a strong development component, so in the second part I will introduce and explain how can we connect and exchange messages with SQL Server: How to consume messages from SQL Server and how to send messages to SQL Server.
Event Date: 11-03-2017 - Session time: 14:10:00 - Track: Azure Infrastructure Track
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: Azure Infrastructure Track
This and many more questions will not be answered in this session but you will leave with the information to answer yourself those questions and many more.
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: Data Science Track
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: DEV Track
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: DBA Track
Event Date: 11-03-2017 - Session time: 15:50:00 - Track: BI Track
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: Data Science Track
Focus on this session will be mathematical and graphical explanation of algorithms available for predictive analytics in Azure Machine Learning service. Algorithms - grouped by learning type - will be examined and crossed referenced through all available and ready-to-use. Understanding the the basics - data inference, data splitting, data stratification, to sweeping, to theory of algorithms: regression, decision trees, Clustering and Naive Bayes. We will clarify the confusion over algorithms, suitable data for algorithms and what type of problem can be tackled with.
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: Azure Infrastructure Track
Windows Server 2016 and SQL Server 2016 can together broader the capabilities of your systems. With regards to High Availability and Disaster Recovery, we have more flexibility by taking advantage of the improved AlwaysOn Availability Groups, Windows Server Failover Cluster and, of course, Azure's integration.
During this session we will explore those new possibilities, checking what is new, the current limitations and what we can build by taking advantage of all the improvements.
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: DBA Track
Goals: • Explore the output of DBCC SHOW_STATISTICS • Describe when the density information is useful • Look at some problem scenarios for which the statistics can’t give good estimates • Understand why cardinality estimation involves more than just the statistics
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: DEV Track
Event Date: 11-03-2017 - Session time: 17:10:00 - Track: BI Track