| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:00:00 | Christophe Laporte | Red Room - Docker DBA | SQL Server Docker : les premiers pas |
| 10:00:00 | Alexander Klein | Blue Room - Cloud | BI in Azure one year live |
| 10:00:00 | Janusz Rokicki | Orange Room - Deep SQL | The Road to The Autonomous Databases |
| 10:00:00 | Olivier Marguillard | Yellow Room - BI Analytics | Le streaming, avenir de la B.I. ? |
| 11:30:00 | Rudi Bruchez | Orange Room - Deep SQL | What is hidden in the query plan ? |
| 11:30:00 | Bent Pedersen | Blue Room - Cloud | Automation and best practices for ADFv2 |
| 11:30:00 | David Barbarin | Red Room - Docker DBA | SQL Server et Docker, du développement à la production |
| 11:30:00 | Isabelle Van Campenhoudt | Yellow Room - BI Analytics | Power BI server and Office Online server, modernize your on-prem |
| 13:00:00 | Michael Roedeske | Blue Room - Cloud | Query performance monitoring and graphical analysis |
| 13:30:00 | Gregory Boge | Orange Room - Deep SQL | J'ai migré un publisher sans réinitialiser la réplication |
| 13:30:00 | Paul Bertucci | Blue Room - Cloud | Getting onboard with Azure Data Warehouse (ADW) |
| 13:30:00 | Christopher Adkin | Red Room - Docker DBA | Continuous Integration Pipelines With Jenkins, Docker and SQL Server |
| 13:30:00 | Joël Crest | Yellow Room - BI Analytics | Les règles d'or du Data Modeling avec Power BI |
| 15:00:00 | Thomas Hütter | Yellow Room - BI Analytics | Next first steps - selected applications of R |
| 15:00:00 | Sarah Bessard | Orange Room - Deep SQL | Industrialisation : Powershell pour SQL Server |
| 15:00:00 | Philippe Geiger | Red Room - Docker DBA | Tooling autour de SQL |
| 15:00:00 | Jean-Pierre Riehl | Blue Room - Cloud | Azure Data Lake : SELECT People FROM DataLake WHERE HappyFace = 1 |
| 16:30:00 | Jan Mulkens | Yellow Room - BI Analytics | Practical SQL Server Machine Learning Services |
| 16:30:00 | Michelle Gutzait | Red Room - Docker DBA | Improve query performance with the new SQL Server 2016 query store!! |
| 16:30:00 | Cédric Charlier | Blue Room - Cloud | Azure Cosmos DB, un univers multimodèle et multi-API |
| 16:30:00 | Chrissy LeMaire | Orange Room - Deep SQL | Simplifying XEvents Management with dbatools |
Event Date: 07-07-2018 - Session time: 10:00:00 - Track: Red Room - Docker DBA
Au cours de cette session de découverte de Docker, nous franchirons ensemble les premières étapes permettant d'installer et d'utiliser SQL Server dans un conteneur. A la fin de cette heure d'initiation didactique et progressive, vous aurez toutes cartes en main pour profiter de la virtualisation 2.0 avec SQL Server.
Event Date: 07-07-2018 - Session time: 10:00:00 - Track: Blue Room - Cloud
Now, after more than a year in live operation, a short summary and evaluation on the subject of BI in Azure.
Event Date: 07-07-2018 - Session time: 10:00:00 - Track: Orange Room - Deep SQL
Event Date: 07-07-2018 - Session time: 10:00:00 - Track: Yellow Room - BI Analytics
Venez découvrir une architecture Kafka, Event Hub, Stream Analytics, DataBricks.
Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Orange Room - Deep SQL
Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Blue Room - Cloud
As part of this session we will be looking into the automation functionality for ADFv2 and how you get started with data extraction and best practices using PowerShell for automation.
We will as well look into how this fits perfectly with Azure Logic apps for automation.
Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Red Room - Docker DBA
Dans le même temps, Microsoft a directement intégré le support des containers SQL Server 2017 dans différentes plateformes tels que Linux, Windows ou MAC. Mais passer du développement à la production avec des containers SQL Server nous fait entrer dans une toute autre dimension avec des contraintes et des considérations bien spécifiques telles que la maintenance, le patching, la performance ou la haute disponibilité.
Dans cette session, je vous propose un retour d'expérience sur la mise en place de Docker avec SQL Server dans le cadre d'un développement spécifique ainsi que certains scénariis d'implémentation en production.
Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Yellow Room - BI Analytics
How to refresh your BI solution by providing the beauty of Power BI reports on premises and the ability from the same place to consume your legacy reports or to share efficiently your data model through a unique place. Demo based session with a strong architecture introduction and a "from the field" real project feedback.
Event Date: 07-07-2018 - Session time: 13:00:00 - Track: Blue Room - Cloud
Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Orange Room - Deep SQL
Dans cette session, je vais expliquer comment j'ai réalisé cette migration. Si vous ne connaissez pas la réplication, cette session vous permettra de comprendre comment elle fonctionne et les différents agents. Si vous maîtrisez la réplication, vous découvrirez peut être une nouvelle méthode de migration.
Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Blue Room - Cloud
Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Red Room - Docker DBA
Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Yellow Room - BI Analytics
Event Date: 07-07-2018 - Session time: 15:00:00 - Track: Yellow Room - BI Analytics
and get your eyes and hands on some R code?
Let's elaborate on two topics you might have seen in my "From SQL to R and beyond" presentation, plus we'll check who obeys Benford's law and who doesn't.
Here are the three subjects that this slightly code-heavy session will cover: • How to create dynamic T-SQL using R functions, for example to query your multi-company database • Visualizations in R based on shapefiles (those geographic polygons) and some choropleth technique • Applying Benford's law, which actually is not about crime and fraud, but may help you to detect them
Event Date: 07-07-2018 - Session time: 15:00:00 - Track: Orange Room - Deep SQL
Event Date: 07-07-2018 - Session time: 15:00:00 - Track: Red Room - Docker DBA
SSMS, SSDT, VSCode, SQLOps, etc.
Event Date: 07-07-2018 - Session time: 15:00:00 - Track: Blue Room - Cloud
A travers différent médias et données brutes, nous analyserons les émotions des personnes et nous distillerons de la valeur ajoutée dans un tableau de bord Power BI, en utilisant Cognitives Services, CNTK, U-SQL et .NET Cette session sera centrée autour de Azure Data Lake et le langage U-SQL mais les démos impliqueront différentes technologies comme Azure Data Factory, Azure SQL Database, du Machine Learning, etc. Bien que cette session soit orientée démo, les concepts et les fonctionnalités de Azure Data Lake seront abordés.
Event Date: 07-07-2018 - Session time: 16:30:00 - Track: Yellow Room - BI Analytics
Enough of that, in this session we'll walk through a real SQL Server Machine Learning Services scenario from idea to code and from deployment to monitoring maintenance. Learn how you can easily roll out your own Data Science projects or support the data scientists and analysts at your company.
Event Date: 07-07-2018 - Session time: 16:30:00 - Track: Red Room - Docker DBA
This session will discuss the query store and what you can do on an ad-hoc basis or regularly.
Event Date: 07-07-2018 - Session time: 16:30:00 - Track: Blue Room - Cloud
Event Date: 07-07-2018 - Session time: 16:30:00 - Track: Orange Room - Deep SQL
Now, it's easier than ever to set up, control and inspect Extended Events sessions with dbatools! Not only does it simplify your basic interaction with XEvents, but it also helps solve your day-to-day problems, such as capturing and notifying deadlocks or blocking sessions.
Join DBA PowerShell MVP Chrissy LeMaire to see how PowerShell can simplify and empower your Extended Events experience. Say goodbye to #TeamProfiler and join #TeamXE with the power of dbatools.