| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:40:00 | Vitor Fava | Data warehouse and BI delivery | Implementing AI solutions using the cognitive services in Azure |
| 08:40:00 | Steve Simon | Data warehouse and BI delivery | SQL Server Reporting Services 2017 on Steroids!! |
| 08:40:00 | Franck Mercier | Data warehouse and BI delivery | Introduction to Microsoft Azure Databricks |
| 09:50:00 | Marcelo Adade | Database administration and performance management | Hybrid Theory - Synchronizing data between Azure SQL Database and SQL SERVER Instances |
| 09:50:00 | Gregory Boge | Database administration and performance management | J'ai migré un publisher sans réinitialiser la réplication |
| 09:50:00 | Denys Chamberland | Database Development and TSQL | Azure Cosmos DB + Gremlin API in Action |
| 09:50:00 | Marco Russo | Data warehouse and BI delivery | Time intelligence and date tables in Power BI |
| 11:00:00 | Steve Simon | Data warehouse and BI delivery | An introduction to Data Mining with SQL Server 2016 |
| 11:00:00 | Tim Gorman | Database administration and performance management | Accelerating Development and Testing Using Data Virtualization |
| 11:00:00 | John Miner | Data warehouse and BI delivery | Effective Data Warehouse Storage Patterns |
| 11:00:00 | Marco Russo | Data warehouse and BI delivery | My Power BI report is slow: what should I do? |
| 13:15:00 | Dan Clark | Data warehouse and BI delivery | Self-Service ETL with Power Query |
| 13:15:00 | Christophe Laporte | Database administration and performance management | Les bases du dépannage SQL Server |
| 13:15:00 | Warner Chaves | Data warehouse and BI delivery | Azure SQL Data Warehouse for the SQL Server DBA |
| 14:25:00 | Sophie Marchand | Data warehouse and BI delivery | Power BI : Un tour complet de la solution |
| 14:25:00 | Mohamed Mawla | Database administration and performance management | Mapping SQL Server Expertise to Azure Cortana Intelligence - Cases and Scenarios |
| 14:25:00 | Jean Rene Roy | Data warehouse and BI delivery | What Azure platform have to offer for your data |
| 15:35:00 | Edward Pollack | Database administration and performance management | Query Optimization Techniques |
| 15:35:00 | Dan Clark | Data warehouse and BI delivery | Power Query Deep Dive |
| 15:35:00 | Kellyn Pot'Vin-Gorman | Database administration and performance management | Screw DevOps, Let's Talk DataOps |
Event Date: 02-06-2018 - Session time: 08:40:00 - Track: Data warehouse and BI delivery
As well as the arrival of the personal computer, the cloud computing and smartphones, the AI is the artificial technology that takes you to where you're going so much faster, intuitive and smart. In this session we will discuss the basics of IA and how we can apply it in our business using the Azure Cognitive Services.
Event Date: 02-06-2018 - Session time: 08:40:00 - Track: Data warehouse and BI delivery
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Event Date: 02-06-2018 - Session time: 08:40:00 - Track: Data warehouse and BI delivery
As a first-class Azure services, you automatically benefit native integration with other Azure services such as Power BI, SQL Data Warehouse, Cosmos DB as well as from enterprise-grade Azure security, including Active Directory integration, compliance, and enterprise-grade SLAs. Azure Databricks is well design to modernizing your existing data warehouse solutions for querying and reporting on data, capitalizing on Spark-based analytics for advanced analytics workloads, and real-time analytics on streaming data. During this presentation, you will discover what A
Event Date: 02-06-2018 - Session time: 09:50:00 - Track: Database administration and performance management
Event Date: 02-06-2018 - Session time: 09:50:00 - Track: Database administration and performance management
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: 02-06-2018 - Session time: 09:50:00 - Track: Database Development and TSQL
forms for a long time, in a wide range of data analysis from science technology
to business scenarios. However, there may still be a small pool of T-SQL
experts with graph experience, especially dealing with Gremlin traversal query language.
That's fully understandable. The session is not aimed on encouraging users to stop
using T-SQL, but rather giving them a new performing blade on their data analysis Swiss knife so to
speak. This session will start with a quick overview of new Azure Cosmos DB - Graph API options
It will then expose main comparaison between T-SQL vs Gremlin, and reasons why
graph may be more beneficial.
It will then give a basic introduction of Gremlin Transversal topology in real context.
Finally a demo will cover how to create a new Azure Cosmos DB - Graph API project
from Visual Studio Code.
1.Generating Vertex and Edges through Core 2.0 Console Application +
2.Consuming Graph API data query in Core .2.0 Web client.
Event Date: 02-06-2018 - Session time: 09:50:00 - Track: Data warehouse and BI delivery
This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.
Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Data warehouse and BI delivery
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
Defining what questions we want answered and how to go about this in an effective and efficient manner.
Creating the data model.
How to gather the necessary data, discussing the training and testing aspect.
Processing the model.
Extracting information from our finished model, discussing the implications of this information.
Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Database administration and performance management
Because providing full databases for each developer on each project seems unrealistic, when each copy might require terabytes of storage, for decades everyone has limited themselves to working in shared non-production environments that are refreshed only every few months at best. Conflicts occur, quality suffers, and things move slowly.
Come learn why data virtualization is the solution to a problem everyone knows.
Good, fast, and cheap -- have all three with data virtualization. Clone things easily and quickly, and remove the biggest constraint to development and testing.
Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Data warehouse and BI delivery
Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval?
This presentation will review the following techniques to fix your woes.
Coverage:
1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?
Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Data warehouse and BI delivery
This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response. At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.
Event Date: 02-06-2018 - Session time: 13:15:00 - Track: Data warehouse and BI delivery
Event Date: 02-06-2018 - Session time: 13:15:00 - Track: Database administration and performance management
Au final, le logiciel est fiable et ne provoque que très rarement des erreurs, des "plantages". Par contre, au quotidien, cela ne veut pas dire qu'il ne va pas y avoir de problèmes sur l'instance, principalement de connexion, d'autorisation ou de performance. Au cours de cette session, nous allons aborder les bases du diagnostic et du dépannage SQL Server.
Event Date: 02-06-2018 - Session time: 13:15:00 - Track: Data warehouse and BI delivery
With a full T-SQL interface and compatibility with the rest of the Microsoft data stack, Azure Data Warehouse can fit transparently into your business data strategy and leverage already existing and familiar development and management skills.
In this session we will look at the main concepts of the Azure SQL Data Warehouse service, how it's different than SQL Server and the advantages it provides to an on-premises solution.
Event Date: 02-06-2018 - Session time: 14:25:00 - Track: Data warehouse and BI delivery
En cours de présentation, nous allons également illustrer certains concepts par le biais de démos, de façon à ce que cette session, d'une durée d'une heure, propose un contenu à forte valeur ajoutée tout en étant dynamique et divertissante.
Event Date: 02-06-2018 - Session time: 14:25:00 - Track: Database administration and performance management
In this session, we'll map Cloud offerings, mainly Azure, that corresponds to the current features SQL Server DBAs use, their use cases for each one based on our client projects, and how they are different to the different SQL Server features we are familiar with. The goal is to get SQL Server DBAs on the latest Azure offerings and the echo of Cortana Intelligence. If time allows, we will also show some offerings from Google Cloud.
Event Date: 02-06-2018 - Session time: 14:25:00 - Track: Data warehouse and BI delivery
Event Date: 02-06-2018 - Session time: 15:35:00 - Track: Database administration and performance management
The problem won't always be a bad query, but when it is, knowing how to dive in, diagnose its performance, and resolve the situation efficiently will turn a potentially frustrating situation into a fun one! Using that knowledge in development to prevent future performance issues will improve script quality and application design, while making your future self less burdened by performance emergencies.
This is an opportunity to identify common query mistakes and learn a variety of ways in which we can solve them. This discussion will include query rewrites, indexing, statistics, database design, monitoring, execution plans, and more!
Demos of poor-performing queries will be provided to illustrate key optimization techniques, design considerations, and the tools you need to fix them. Fast.
Event Date: 02-06-2018 - Session time: 15:35:00 - Track: Data warehouse and BI delivery
Event Date: 02-06-2018 - Session time: 15:35:00 - Track: Database administration and performance management
Reasons for this solution is required: -Data is getting bigger and more complex -Security concerns around critical data is becoming more evident every day -Data is created in silos in many sources, yet consumed in just as many locations, including on-premises and in the cloud.
We'll discuss the tech, the politics and the challenges of bringing data into DevOps and how to do so more successfully with culture changes, tools, scripting, and virtualization.
Takeaways from this session: