Build Schedule

Advanced Filters:
  • Track

    clear all















  • Speaker


  • Level


  • Session Type


Sessions Found: 20
Le monde de la donnée est en pleine mutation. Le Data devient Big, le SQL devient NoSQL, la BI devient Analytics, le Data Mining devient Data Science…
Faux buzz ou vrais paradigmes, quoiqu'il en soit, de nouvelles architectures apparaissent pour traiter les challenges d'aujourd'hui. Microsoft propose ses solutions au travers de Cortana Analytics, veritable mashup des briques Data du Cloud Azure : Azure Data Catalog, Azure Stream Analytics, Azure Data Lake, Azure Data Factory, Azure ML, HDInsight, etc.
Que font ces briques ? Lesquelles choisir ? Comment s'interconnectent-elles ? Quelle architecture implémenter ? Ce sont ces questions que nous aborderons lors de cette session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Air - la puissance du Cloud

Level: Intermedia

Session Code:

Date: June 25

Time: 1:30 PM - 2:30 PM

Room: Air

Découvrir les multiples possibilités de dashboarding de Power BI 
 -intégration graphiques et tableaux croisés dynamiques depuis Excel
 -intégration images dynamiques 
 -insertion de graphiques personnalisés 
-Partage des dashboards 
-Intégration Power Point et Office 365
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Eau - Plongez dans la BI

Level: Beginner

Session Code:

Date: June 25

Time: 3:00 PM - 4:00 PM

Room: Eau

If you ask an expert about using a clustered index you will ALWAYS hear: Yes, you need a clustered index for your table. Last but not least Microsoft Azure Databases requires clustered indexes. But clustered indexes are not always a good choice for your database solution because of several different reasons. This session will start a debate about genius and madness of clustered indexes in your application.

This session will run several demos which will show in a very clear way why a clustered index isn't the best choice in several workload scenarios. "There's no lunch for free"! Not using clustered indexes will have ONE heavy drawback - this drawback will be demonstrated, too.

The session goal is to make decisions easier for you to use a clustered index or not!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Metal - la robustesse de SQL Server

Level: Intermedia

Session Code:

Date: June 25

Time: 11:30 AM - 1:00 PM

Room: Metal

Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.  

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

• XEvents, Profiler/Traces, and PerfMon 
• Using Dynamic Management Views (DMVs)
• Advanced Diagnostics Using Wait Stats
• Reading SQL Server execution plan 

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Feu - des performances brulantes

Level: Advanced

Session Code:

Date: June 25

Time: 3:00 PM - 4:00 PM

Room: Feu

Nous vous proposons une session qui sort des sentiers battus, à base d'une architecture dont voici quelques éléments :

- Des fichiers très volumineux
- Un stockage sur Azure Data Lake
- Un traitement en U-SQL
- Un ordonnancement avec ADF
- Un SQL Server 2016 avec Polybase 
- Et enfin un cube Tabular en DirectQuery

Pensez-vous qu'une telle architecture peut donner quelque chose de viable ? Venez le découvrir avec nous :)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Air - la puissance du Cloud

Level: Intermedia

Session Code:

Date: June 25

Time: 10:00 AM - 11:00 AM

Room: Air

In 1h we will understand the main concepts of Complex Event Processing, the "technological roots" of it at Microsoft (StreamInsight under SQL 2008 R2) then moving the implementation to Azure's corresponding service - Stream Analytics. Main use cases, including IoT but not only.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Air - la puissance du Cloud

Level: Advanced

Session Code:

Date: June 25

Time: 11:30 AM - 12:30 PM

Room: Air

The Tabular model in Power Pivot for Excel, Power BI and SSAS Tabular seems to offer only plain-vanilla one-to-many relationships, based on a single column. In 2015 there was the introduction of many-to-many relationships, yet the model seems somewhat poor when compared with SSAS Multidimensional. In reality, by leveraging the DAX language, you can handle virtually any kind of relationship, no matter how complex they are. In this session we will analyze and solve several scenarios with calculated relationships, virtual relationships, complex many-to-many. The goal of the session is to show how to solve complex scenarios with the aid of the DAX language to build unconventional data models.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Eau - Plongez dans la BI

Level: Intermedia

Session Code:

Date: June 25

Time: 10:00 AM - 11:00 AM

Room: Eau

Cortana Analytics is a fully managed big data and advanced analytics suite that enables you to transform your data into intelligent action. In this talk, you will get an underpinning of analytical modelling, along with demos of visualizing data and getting insights via Power BI and the challenges of building a SaaS service at scale. Major features of new Power BI will be covered with demos, including natural language query, and others, in the context of Cortana Analytics.  Come and learn what model to use when, and how to use data storytelling to display the results meaningfully.

Having spent time studying Artificial Intelligence at universities in the UK and in Paris, and then spending a good part of her early career as an Artificial Intelligence consultant,  Jen is happy to see that deep analytics and intelligence action is available to everyone in the form of Cortana Analytics. Join her as she demystifies this exciting technology so that you can get insights from your data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Air - la puissance du Cloud

Level: Advanced

Session Code:

Date: June 25

Time: 4:30 PM - 5:30 PM

Room: Air

In an enterprise, merging master data, like customer data, from multiple sources is a common problem. Typically, you do not have a single, i.e. the same key identifying a customer in different sources. You have to match data based on similarity of strings, like names and addresses. In this session, we are going to check how different algorithms for comparing strings included in SQL Server  work. We are going to use four different algorithms that come with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services. Finally, we are going to introduce how SQL Server Data Quality Services help us here.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Eau - Plongez dans la BI

Level: Advanced

Session Code:

Date: June 25

Time: 4:30 PM - 5:30 PM

Room: Eau

Do you want to know more about SQL Server and data consistency mechanisms? Please join this session ... We’ll talk about logical locking but also how SQL Server protects its physical data structures in memory with lightweight synchronization objects like Latches and Spinlocks.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Feu - des performances brulantes

Level: Advanced

Session Code:

Date: June 25

Time: 4:30 PM - 5:30 PM

Room: Feu

Mise à niveau du moteur de base de données
- Pourquoi migrer ? Fin de support, une nouvelle fonctionnalité stratégique...
- Évaluer les risques de régression du code : Upgrade Advisor
- Évaluer les risques de régression sur la performance : Profiler (Distributed Replay Utility), XEvent
- Préparer la mise à niveau : Inventaire des objets à migrer, méthodes de migration...
- Dans quel cas un rollback est possible ? Plan guide, traceflag...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Metal - la robustesse de SQL Server

Level: Intermedia

Session Code:

Date: June 25

Time: 3:00 PM - 4:00 PM

Room: Metal

Dataviz guru Stephen Few once stated that we should “save the pies for dessert”. What he meant is that pie charts are good in some specific use cases, but they should not be used in others. The same is true for other chart types. Using the wrong type of chart will make it harder for report users to understand the story behind the data. To enable insights, information has to be presented in the most intuitive way possible. You will leave this session with five easy-to-implement rules, which will guide you through the process of creating clear and attractive visualizations. Every rule will be applied through live demos in Excel, Reporting Services and Power BI Desktop, where you will learn how to avoid pitfalls from the defaults in those tools.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Eau - Plongez dans la BI

Level: Beginner

Session Code:

Date: June 25

Time: 11:30 AM - 12:30 PM

Room: Eau

In this session we will explore the new features introduced with SQL Server 2016 to enhance security. 
Always Encrypted is a new technology that protects your data not only at rest, but also throughout the whole interaction between the application and the database.
Dynamic Data Masking is another interesting feature that allows us to protect sensitive data by masking it to all users that don’t have enough privileges to see the actual contents.
Row Level Security allows showing to end users only the data they’re entitled to access, without changing the applications’ code.
We will demonstrate the use of these three features with example applications and we will explore the use cases where these technologies represent a big leap from previous custom implementations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Metal - la robustesse de SQL Server

Level: Intermedia

Session Code:

Date: June 25

Time: 4:30 PM - 5:30 PM

Room: Metal

La roadmap BI de Microsoft est rarement bien comprise. 
On premises nous avons SharePoint 2013 ainsi que de nouvelles fonctionnalités BI en SharePoint 2016. Dans le cloud nous avons la PowerBI ; la PowerBI elle-même a été révisée en profondeur par Microsoft de sorte qu’il devient assez compliqué de comprendre la différence entre la PowerBI v1 et la PowerBI v2. C’est ce qu’il sera clarifié lors de cette session où Serge Luca (SharePoint MVP) et Isabelle Van Campenhoudt (SQL Server MVP) décriront les fonctionnalités de Business Intelligence de SharePoint 2016 , les améliorations par rapport à SharePoint 2013; en seconde partie de session la nouvelle version de PowerBI (V2) sera également illustrée et expliquée, en ce y compris  les scénarios hybrides.

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Eau - Plongez dans la BI

Level: Intermedia

Session Code:

Date: June 25

Time: 1:30 PM - 2:30 PM

Room: Eau

Le Query Store, tout le monde en parle pour diagnostiquer les problèmes de performance en fonction de l'historique mais qu'est qui se cache en détail derrière cette fonction.
Pendant une heure, nous allons regarder en détail ce qui fait tourner ce moteur, ces cas d'usage et ses limites. Tout sera passé à l'analyse et nous verrons si la fonction tient ses promesses : trouver les problèmes de performancesen comparant avec ce qui s'est passé.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Feu - des performances brulantes

Level: Advanced

Session Code:

Date: June 25

Time: 1:30 PM - 2:30 PM

Room: Feu

What if migrating SQL Server instances was as simple as executing a single command? 

In this presentation, I'll cover the reasons companies migrate, the ways SQL migrations are usually performed, and the considerations that must be made when performing a migration.

Then I'll show you how to use the PowerShell dbatools module to simplify your SQL Server migrations. dbatools makes migrating databases, logins, linked servers, credentials, jobs, database mail, and other essential SQL components extremely easy. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Metal - la robustesse de SQL Server

Level: Intermedia

Session Code:

Date: June 25

Time: 1:30 PM - 2:30 PM

Room: Metal

Assurer la montée en charge d'une application fait partie intégrante des tâches qui incombent au DBA. Même si bon nombre de choix influant sur l'évolutivité de l'application sont inhérents au développement et à l'architecture de l'applicatif,  SQL Server offre portant bon nombre de possibilités afin de supporter la montée en charge. Techniques et retour d'expérience sur un domaine mêlant optimisation, architecture, infrastructure et ingéniosité.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Feu - des performances brulantes

Level: Intermedia

Session Code:

Date: June 25

Time: 11:30 AM - 12:30 PM

Room: Feu

Have you ever gotten tired of your database taking hours to back up? Are you sick of your users breathing down your neck because the database restore is taking too long? Now you won't have to worry about that anymore. In this session I show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. You'll learn about the backup "execution plan" and how to access it. Understanding how to tune the individual portions of your backup process will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15 years to tune my backups and I’ve had great success.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Feu - des performances brulantes

Level: Intermedia

Session Code:

Date: June 25

Time: 10:00 AM - 11:00 AM

Room: Feu

Vélib est un service public à grande échelle de location de vélos sur la région parisienne en France. Lancé le 15 juillet 2007, le service propose aujourd’hui environ 14 500 vélos et 1230 stations sur Paris. Grâce à la suite Azure Cortana Analytics Suite, nous allons mettre en place une solution d’analyse des données de ces Vélib de façon à répondre à 2 problématiques :
-       Obtenir une analyse descriptive en temps réel du réseau Vélib
-       Mettre à disposition une analyse prédictive permettant de prédire la disponibilité du nombre de vélos et de stations disponibles pour une station donnée. 

Dans la présentation nous montrerons comment nous avons mis en place la solution dans le Cloud Azure à l’aide des services suivants :
-       Azure Event Hubs
-       Azure Stream Analytics
-       Azure Data Factory
-       Azure Machine Learning
-       Azure SQL Database
-       Power BI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Air - la puissance du Cloud

Level: Intermedia

Session Code:

Date: June 25

Time: 3:00 PM - 4:00 PM

Room: Air

In this Session we will delve into the need to deploy and manage SQL Server Configurations using PowerShell Desired State Configuration and the immediate benefits that this can and will bring to your deployment and administration of this very much vital technology.
Believe me when I say that I am no SQL Expert but this session will leave those that attend in a position to go away and look to implement this in their organisation and really reap the benefits that managing your Infrastructure as Code brings to a flexible an more maintainable environment.

This session will also briefly cover the other core necessities that will be required to get this underway which include the importance of Source Control for the configurations, Community Developed Resources & more.
 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Metal - la robustesse de SQL Server

Level: Intermedia

Session Code:

Date: June 25

Time: 10:00 AM - 11:00 AM

Room: Metal

Sessions Found: 20
Back to Top