| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Etienne Lopes | Enterprise Database Administration Deployment | Query Store in SQL Server 2016 |
| 09:00:00 | Eduardo Piairo | Application Database Development | Road to database automation: Database source control |
| 09:00:00 | João Lopes | BI Platform Architecture, Development Administration | Integration Services Architecture - (SSIS) Modern Framework |
| 09:00:00 | Ricardo Cabral | Application Database Development | What is Windows Nano Servers ? |
| 10:30:00 | Johan Bijnens | Enterprise Database Administration Deployment | Moving your SQL Server backups to Azure Blob storage |
| 10:30:00 | Murilo Miranda | Cloud Application Development Deployment | Azure SQL Database - Migrating from On-Premise to Azure |
| 10:30:00 | Vitor Pombeiro | Strategy and Architecture | What is SQL Data Warehouse? Is it for me? |
| 10:30:00 | Filipe Coelho | Analytics and Visualization | Notebooks, notebooks everywhere! |
| 11:45:00 | Gerhard Brueckl | BI Platform Architecture, Development Administration | What's New in Analysis Services 2016 |
| 11:45:00 | Stijn Wynants | BI Platform Architecture, Development Administration | Real-Time Analytics: OLAP OLTP in the mix! |
| 11:45:00 | Andre Batista | Application Database Development | Polybase in SQL Server 2016: Let's query Big Data with T-SQL ! |
| 11:45:00 | Remus Rusanu | Enterprise Database Administration Deployment | How to monitor efficiently your SQL Server instances |
| 11:45:00 | Scott Klein | Application Database Development | Fun with SQL Server 2016 Stretch Database, Temporal, and Always Encrypted |
| 14:00:00 | Mark Broadbent | Enterprise Database Administration Deployment | Lockless in Seattle: In-Memory OLTP Transaction Processing |
| 14:00:00 | Ivan Campos | Enterprise Database Administration Deployment | Hiding your data with SQL Server 2016 |
| 14:00:00 | Niko Neugebauer | Strategy and Architecture | Hadoop's Architecture it's relation to Microsoft Data Platform |
| 14:00:00 | Pedro Perfeito | BI Information Delivery | Data Visualization through Microsoft platform |
| 16:00:00 | Christopher Adkin | Enterprise Database Administration Deployment | Super Scaling the LMax Queuing Pattern With SQL Server |
| 16:00:00 | Sander van der hoeff | BI Information Delivery | Unlock the Power of Pivot Tables |
| 16:00:00 | Cláudio Silva | Enterprise Database Administration Deployment | Squeezing SQL Server Management Studio |
| 16:00:00 | Pedro Sousa | Enterprise Database Administration Deployment | Docker Containers and SQL Server coexistence |
| 17:10:00 | Rui Quintino | Advanced Analysis Techniques | First steps with R in the Microsoft Data Platform |
| 17:10:00 | David Barbarin | Enterprise Database Administration Deployment | Troubleshooting scenarios with SQL Server availability groups |
| 17:10:00 | Dave Ballantyne | Application Database Development | An Introduction to Execution Plans and The Query Optimizer |
Event Date: 01-10-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
The new Query Store feature in SQL Server 2016 is a major enhancement, simplifying both the identification of performance issues and it's resolution. Throughout a set of 13 demonstrations I'll explain what Query Store is, how you can take advantage of it and also some alerts you should be aware of. If you're a performance troubleshooter I'm sure you'll like this session!
Event Date: 01-10-2016 - Session time: 09:00:00 - Track: Application Database Development
In this presentation I will discuss the DLM general concepts, with special emphasis on data management and migration, and present some strategies and tools (source control tools as Mercurial and Git and database migrations management tools as Flyway) that can be used to overcome the database source control phase. Using automation as key factor to achieve database source control, database continuous integration and database continuous delivery. This session will not only unlock continuous integration and delivery phases but also enable agile practices that allows to mitigate/manage the gap between application and database development.
Event Date: 01-10-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-10-2016 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 01-10-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
This session focusses on performing SQL Server backups directly pushing that backup files to Azure Blob storage and highlights considerations with regards to security and testing these backup files for recoverability, and cloud costs involved.
Event Date: 01-10-2016 - Session time: 10:30:00 - Track: Cloud Application Development Deployment
In this session, we will compare and contrast different migration strategies. We will cover different ways to migrate your SQL Server database from on-premises to Azure, and how to detect and solve potential migration blockers and issues.
Event Date: 01-10-2016 - Session time: 10:30:00 - Track: Strategy and Architecture
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: 01-10-2016 - Session time: 10:30:00 - Track: Analytics and Visualization
Event Date: 01-10-2016 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-10-2016 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-10-2016 - Session time: 11:45:00 - Track: Application Database Development
Attend my session if you want to learn how to take advantage of this technology and where we can use it in real life scenarios. I will also cover installation, configuration and troubleshooting.
Event Date: 01-10-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
I have worked with SQL Server as a developer in the Redmond team for more than 12 years and during this time I've investigated countless performance problems. In time I developed a strategy on how to use the performance monitoring data to analyze problems and identify the root cause. This session is going to to show you how I monitor SQL Server, what data do I look for, and how I interpret the collected data to analyze performance issues. Going beside the obvious CPU, Memory and IO counters, I will show you how to identify typical performance issues from monitoring data, all without overwhelming the captured data volume.
Event Date: 01-10-2016 - Session time: 11:45:00 - Track: Application Database Development
Event Date: 01-10-2016 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
In this session we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Event Date: 01-10-2016 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-10-2016 - Session time: 14:00:00 - Track: Strategy and Architecture
The initial releases of Hadoop have had huge deficiencies in the terms of work, performance and organisation, but the Hadoop 2.0 has brought the needed changes in the underlying architecture and its steadily becoming more and more interesting as a multi-purpose data platform.
Let us review what Hadoop, Spark, Hive, Pig, Tez, Ambari and others are and how can we get started with this data platform. Let us connect each of the pieces with the corresponding element in the current Microsoft Data Platform offerings to understand how can we be more effective in learning and understanding Hadoop.
Event Date: 01-10-2016 - Session time: 14:00:00 - Track: BI Information Delivery
Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-10-2016 - Session time: 16:00:00 - Track: BI Information Delivery
By means of using Excel the user gets very excited about the use of tabular Models. For a while the user uses Excel as a self-service business intelligence tool. Then all of a sudden the user starts asking if they can use the program to extract more and other information from the tabular model by the use of Excel. Now it is up to you to familiarize the user with all the possibilities of working with the tabular model by means of Excel.
Given the small amount of documented knowledge about the use of tabular models by means of Excel, I will show you how to get the best of your tabular models by using Excel as a self-service business intelligence and data science tool. Filters, named sets, and calculations in the pivot table: I will explain it all!
Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
I will show to you features that you do not even knew that exist and how they can improve your productivity. Come take a look to SSMS 2016 and understand how it will help you even if you don't have SQL Server 2016 instances. After this session I hope you have learnt at least one or two features of SSMS.
Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-10-2016 - Session time: 17:10:00 - Track: Advanced Analysis Techniques
Are you a BI Developer? DBA? BI Analyst or a data/analytics lover? Come along, join us in this session as we explore this powerful, sometimes even strange!... language , showing main differences from the typical SQL/BI development. This is a beginner level session to help you with R first steps challenges.
Event Date: 01-10-2016 - Session time: 17:10:00 - Track: Enterprise Database Administration Deployment
We will talk about a range of common and uncommon issues you may face concerning your availability group infrastructures. Then we will explain how to resolve them on the basis of real customer cases.
Event Date: 01-10-2016 - Session time: 17:10:00 - Track: Application Database Development
It is the component responsible for turning the logical actions (that are derived from your SQL statements) into physical actions that fetch and process the required data to form your results. Not only does it have to guarantee the correct results (no mean feat when you start to think about it) but it has to do this in a performant way and the route it takes to do this (the output of the optimization process ) is described within the execution plan.
This session will be an introduction to the Optimizer and Execution Plans and take you on a journey to a wider view of the Query Engine. Once you understand what physical actions are being taken on your logical requests (i.e. your TSQL Statements) then you will be better placed make changes to influence those actions with an end result of a better performing database system.