Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 21
A lot of new functionality and features have been introduced with Azure Data Factory. Using regular SSIS packages you have great flexibility using BIML.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Blue Room - Cloud

Level: Beginner

Session Code:

Date: July 07

Time: 11:30 AM - 12:30 PM

Room: Blue

Seul Azure Cosmos DB vous permet d’utiliser à la fois des données de types valeurs/clés, de graphes, de famille de colonnes et de documents dans un même service. Cela parait cool mais quand utiliser quel modèle ? Quelle différence entre un modèle et une API ? Quelle sont les conséquences d'avoir une API compatible MongoDB ? Durant 60 minutes, cette session répondra à ces questions et bien plus encore. Après une brève introduction générale à Azure Cosmos DB, elle portera toute son attention sur les différents modèles et les API en vous faisant découvrir toutes les possibilités liées à cet univers !
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Blue Room - Cloud

Level: Intermedia

Session Code:

Date: July 07

Time: 4:30 PM - 5:30 PM

Room: Blue

Découvrez l'analyse avancée et le pattern Data Lake sur la plate-forme Azure Data à travers une démo complète : comment récupérer des infos dans du texte, des photos ou encore des vidéos ?
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Blue Room - Cloud

Level: Intermedia

Session Code:

Date: July 07

Time: 3:00 PM - 4:00 PM

Room: Blue

How can you bring your existing on prime data warehouse and reporting into the cloud? That is precisely what the question was more than a year ago. The aim was to use everything as a service. Azure offers many possibilities with Azuer SQL DB / Azuer SQL DW / Azure Data Factory / Logic Apps / Streamanalytics / Power BI. 

Now, after more than a year in live operation, a short summary and evaluation on the subject of BI in Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Blue Room - Cloud

Level: Beginner

Session Code:

Date: July 07

Time: 10:00 AM - 11:00 AM

Room: Blue

Docker has taken the world of IT by storm and looks to be ushering in the greatest platform paradigm shift since virtualisation and the public cloud. The transient nature of Docker containers makes them the perfect fit for spinning up and then tearing down SQL Server instances as part of continuous integration pipelines. Jenkins is the most popular build automation engine in the open source community, it has phenomenal plugin support, it is used by the likes of Netflix and eBay and excels in its ability to handle build pipelines as code. In this session you will learn how a simple build pipeline that takes a SQL Server data tools project checked out from source code control, built into a DACPAC which is then deployed to a SQL Server instance can be extended to use containers, multi-branch build pipelines, tSQt testing and much much more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Red Room - Docker & DBA

Level: Intermedia

Session Code:

Date: July 07

Time: 1:30 PM - 2:30 PM

Room: Red

Will cover the Azure SQL DW story from its on-premise MPP solution origins (PDW) to its migration to Azure as a "service". Then describe what a multi-dimensional data warehouse and SQL DW are, what patterns are met using ADW, how to get up and running on Azure Data Warehouse (live demo), data transformation/data loading patterns, table design patterns and best practices, and scaling out your Azure Data Warehouse to meet your company's demands.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Blue Room - Cloud

Level: Beginner

Session Code:

Date: July 07

Time: 1:30 PM - 2:30 PM

Room: Blue

The Query Store feature maintains a history of query execution plans with their performance data, allowing you to quickly identify queries that are performing slower recently, allowing administrators or developers to force the use of an older, better plan if required. The Query Store is configured at the individual database level and not on the instance level.
This session will discuss the query store and what you can do on an ad-hoc basis or regularly.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Red Room - Docker & DBA

Level: Advanced

Session Code:

Date: July 07

Time: 4:30 PM - 5:30 PM

Room: Red

Facilitez-vous la vie avec Powershell : tests unitaires, benchmark, génération de script, synchronisation, etc. La but de cette session est de présenter un éventail de scripts open-source et prêt à l'emploi pour gagner du temps pour l'exécution de tâches habituellement laborieuses.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Orange Room - Deep SQL

Level: Intermedia

Session Code:

Date: July 07

Time: 3:00 PM - 4:00 PM

Room: Orange

Récemment, suite à une panne matérielle, j'ai du migrer les bases d'un publisher et la distribution sur un autre serveur. Puisque ces bases sont très volumineuses et que je n'avais pas à ma disposition de failover cluster sur le distributeur, je ne souhaitais pas devoir réinitialiser la réplication transactionnelle pour éviter les interruptions de service.
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Orange Room - Deep SQL

Level: Advanced

Session Code:

Date: July 07

Time: 1:30 PM - 2:30 PM

Room: Orange

2018 sera t'elle l'année de du Streaming et de la fin de la B.I. conventionnelle ? 

Venez découvrir une architecture Kafka, Event Hub, Stream Analytics, DataBricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Yellow Room - BI & Analytics

Level: Intermedia

Session Code:

Date: July 07

Time: 10:00 AM - 11:00 AM

Room: Yellow

Du modèle en étoile à l'utilisation de la dimension Temps, en passant par les granularités multiples (le tout saupoudré de DAX), cette session présentera les étapes successives à appliquer pour aboutir à un modèle de données parfait, optimisé pour l'analyse de données.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Yellow Room - BI & Analytics

Level: Intermedia

Session Code:

Date: July 07

Time: 1:30 PM - 2:30 PM

Room: Yellow

You enjoyed the walk-through for R newbies, now you want to take the next steps
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
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Yellow Room - BI & Analytics

Level: Intermedia

Session Code:

Date: July 07

Time: 3:00 PM - 4:00 PM

Room: Yellow

Your company is not-yet- ready for the cloud ?
 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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Yellow Room - BI & Analytics

Level: Beginner

Session Code:

Date: July 07

Time: 11:30 AM - 12:30 PM

Room: Yellow

Admit to yourself that you’ve seen enough basic “R is coming to SQL Server” sessions with the same old examples!
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Yellow Room - BI & Analytics

Level: Intermedia

Session Code:

Date: July 07

Time: 4:30 PM - 5:30 PM

Room: Yellow

Based on concrete practical examples, this lecture deals with the SQL Query Performance Monitoring and the analysis with the intuitive fully graphic DBPLUS Performance Monitor ™. The lecture answers the questions: How do you quickly identify among thousands of SQL queries the basics of CPU, logical, or physical IO at a specific time or in history? How to find changing execution plans and analyze them historically over time? Which queries were executed for the first time today or are responsible for a peak load at a certain time? Which queries access a specific table? How can I compare and visualize load profiles historically in seconds? And how does that even work starting with SQL Server Version 2005 without the Query Store and no need for knowledge of DMV's?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Blue Room - Cloud

Level: Beginner

Session Code:

Date: July 07

Time: 1:00 PM - 2:00 PM

Room: Orange

Extended Events are much more powerful than any other monitoring technology available in SQL Server. Despite this potential, many DBAs have yet to abandon Traces and Profiler. Partially because of habit, but mostly because the tooling around Extended Events was less intuitive until recently.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Orange Room - Deep SQL

Level: Intermedia

Session Code:

Date: July 07

Time: 4:30 PM - 5:30 PM

Room: Orange

Avec la sortie de SQL Server 2017 et le SGBD est devenu multiplateforme et est à présent supporté sur Windows, Linux et Docker.
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Red Room - Docker & DBA

Level: Intermedia

Session Code:

Date: July 07

Time: 10:00 AM - 11:00 AM

Room: Red

La vague Docker a commencé par le développement. En effet, de nos jours il n'est plus rare de voir des processus CI/CD inclure des containers qui offrent des avantages certains aux développeurs. 
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Red Room - Docker & DBA

Level: Intermedia

Session Code:

Date: July 07

Time: 11:30 AM - 12:30 PM

Room: Red

Autonomous means capable of existing independently. Think maintenance free, self-healing, auto-tuning databases able to detect and automatically mitigate security risks. Sounds like impossible dream, but here is the best part - Azure is gradually making that next level of automation possible. Cloud economy of scale combined with unique features of Azure Sql PaaS resources transform and enhance the way we collect, store and process data. And that also affects our professional lives. Find out where we are on The Road to The Autonomous Databases, what are main building blocks, what kind of obstacles we still have to overcome and how to turn these challenges into opportunities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Orange Room - Deep SQL

Level: Intermedia

Session Code:

Date: July 07

Time: 10:00 AM - 11:00 AM

Room: Orange

To be announced
SSMS, SSDT, VSCode, SQLOps, etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Red Room - Docker & DBA

Level: Intermedia

Session Code:

Date: July 07

Time: 3:00 PM - 4:00 PM

Room: Red

Sessions Found: 21
Back to Top cage-aids
cage-aids
cage-aids
cage-aids