SQLSaturday #591 - Montreal 2017
Event Date: 03/18/2017 00:00:00
Event Location:
- MIcrosoft Montreal Offices
- 2000 McGill College, 5e étage, Montréal
- Montreal, Quebec, Canada
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Storage Spaces Direct : le géo-cluster SQL Server simplifié
Abstract: Le monde du stockage est en pleine ébullition. Les acteurs historiques ont vu de nouveaux concurrents proposer des solutions innovantes en terme de baie de disque. Le disques locaux (DAS) ont aussi connu des évolutions majeures. Les disques SSD ont succédé aux disques rotatifs. Le protocole AHCI laisse place au NVMe avec des performance impressionnantes et des latences extrêmement faibles. La virtualisation de stockage a permis de faire évoluer l’offre en matière de de tolérance de panne pour des systèmes géographiquement répartis en offrant une alternative au SAN mirroring. Les architectures hyper-convergées sont apparus ouvrant la porte à de nouvelles possibilités. Avec l’arrivée de Windows 2016 et de Storage Spaces Direct, Microsoft offre une alternative crédible au vSan et autres Simplivity et autres Nutanix. Au cours de cette session, nous allons découvrir cette fonctionnalité et explorer les bénéfices pour une infrastructure SQL Server hautement disponible.
Speaker(s):
- Christophe Laporte
Track and Room: BI Platform Architecture, Development Administration - Main room #2
Title: Dashboard in a day
Abstract: Le Dashboard in a Day n’est pas d’une formation en tant que telle. Il s’agit plutôt d’une présentation de différents rapports Power BI élaborés par l’équipe de Microsoft. Tout au long de la journée, nous allons naviguer à travers ces rapports et vous expliquer comment ils ont été construits, publiés et partagés. Vous serez donc en mesure de bien comprendre tout ce que peut vous offrir Power BI, en termes de fonctionnalités. Nous vous invitons à apporter vos ordinateurs portables pour être en mesure de naviguer par vous-mêmes dans ces différents rapports. Pour assister à cette portion de l’événement, vous devez absolument vous inscrire via le lien suivant http://sopmar01.polldaddy.com/s/dashboard-in-a-day , en plus de vous inscrire sur le site sqlsaturday.com, puisque le nombre de place est limité à 20 personnes. Une fois inscrit sur cette liste, vous recevrez un courriel pour vous informer si vous faites partie des chanceux ou si vous êtes sur la liste d’attente.
Speaker(s):
- Sophie Marchand
Track and Room: Power BI (Dashboard in a day) - St-Laurent
Title: Ways to handle large amounts of data
Abstract: Data and databases are growing fast. Some historical data is required for analysis and cannot be purged. In this session I will discuss ways to handle large amounts of data in SQL Server 2016 and the cloud. Some examples: Database partitioning, Stretch Database, Blob storage and more!
Speaker(s):
- Michelle Gutzait
Track and Room: Application Database Development - Main room #1
Title: Azure SQL Database - Scaling In and Scaling Out using elastic pool
Abstract: On this session will discuss how to configure the elastic pool Azure SQL Database to manage the use of resources and ensure high performance and scalability of your databases stored on Azure.
Speaker(s):
- Vitor Fava
Track and Room: BI Platform Architecture, Development Administration - Main room #2
Title: Partage et Collaboration avec Power BI
Abstract: Power BI offre de nombreuses solutions pour travailler à plusieurs sur un modèle, un rapport ou un tableau de bord. Cette session passe en revue les fonctionnalités de partage et de collaboration de Power BI avec leurs avantages et leurs inconvénients.
Speaker(s):
- Jean-Pierre Riehl
Track and Room: BI Platform Architecture, Development Administration - Main room #1
Title: SQL Server Transactional Replication: A Deep Dive
Abstract: Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there’s some interesting technology to be had in it that might you might want to leverage. In this session, we’ll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We’ll also see some common trouble spots and how to identify them. There will be plenty of examples and demos and, yes, even some PowerShell!
Speaker(s):
- Drew Furgiuele
Track and Room: Application Database Development - Main room #2
Title: Azure Data Lake, le big data 2.0
Abstract: Azure Data Lake est LA technologie “big data” maison de Microsoft. En provenance de MS Research (nom de code Cosmos), elle est utilisée en interne par les équipes X-Box, Bing, O365 depuis quelques années déjà. Cette technologie est disponible depuis l’été dernier dans Azure et s’enrichit mois après mois.
ADL, concrètement, c’est quoi ? C’est la possibilité de stocker et analyser une quantité illimitée de données et de requêter avec un nouveau langage : le U-SQL
Speaker(s):
- Jean-Pierre Riehl
Track and Room: BI Platform Architecture, Development Administration - Main room #1
Title: SQL Server dans un conteneur Docker
Abstract: Encore impensable il y a quelques années, la stratégie de Microsoft envers le monde libre n’en finit pas d’étonner la sphère informatique. Sur machine physique ou virtuelle, SQL Server peut à présent être installé sur un OS Windows ou … Linux. En parallèle, la culture DevOps et les micro services semblent s’imposer comme le modèle d’architecture pour les années à venir. Au cours de cette session découverte, au travers de quelques lignes de code, venez assister à la création d’un conteneur suivi de l’installation de SQL Server
Speaker(s):
- Christophe Laporte
Track and Room: BI Platform Architecture, Development Administration - Main room #2
Title: Azure SQL Database - Managing your database on the cloud
Abstract: In this session we will discuss the best practices for managing a database environment created in Azure, what are the available monitoring tools to start a troubleshooting process and how to find and resolve potential performance problems.
Speaker(s):
- Vitor Fava
Track and Room: BI Platform Architecture, Development Administration - Main room #2
Title: Seamless upgrade : mettre à jour un cluster SQL Server
Abstract: Chaque nouvelle version de Windows apporte son lot de nouvelles fonctionnalités, de gains en performance ou stabilité. La recherche de haute disponibilité nous pousse souvent à mettre en place un cluster. Cluster qu’il est difficile de faire évoluer sans interruption de service notable. Etait difficile à faire évoluer, devrais-je dire. Après avoir parlé des nouveautés apportées par Windows 2016, nous verrons comment effectuer la mise à jour de l’OS, ou l’ajout d’un nouveau nœud, dans un cluster Windows 2012R2.
Speaker(s):
- Christophe Laporte
Track and Room: BI Platform Architecture, Development Administration - Main room #1
Title: Scaling SSIS Package execution is the Server Deployment
Abstract: SSIS 2012 introduced a new way to deploy and execute SSIS package. But did you know that the execution can be done from a Stored Procedure? Come and see how we reverse engineer the server deployment model to horizontally scale the execution. Learn how you can scale your packages execution with elasticity.
Speaker(s):
- Jean Rene Roy
Track and Room: Application Database Development - Main room #1
Title: Stretch Database - Historical data storage in SQL Server 2016
Abstract: In this session I will display the new functionality of SQL Server 2016 called Stretch Database, with which you can optimize the storage and manipulation of historical data integrating an instance of SQL Server to SQL Azure.
Speaker(s):
- Vitor Fava
Track and Room: BI Platform Architecture, Development Administration - Main room #1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Vitor Fava
Twitter: - sqlservermaniacs
LinkedIn: Vitor Fava
Contact: https://www.vitorfava.com
I’m a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation, and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I’m a speaker at various technology events such as SQLSaturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I’m the Chapter Leader of SQLManiacs PASS chapter.
Jean Rene Roy
Twitter: - https://twitter.com/#!/DevTeachConfere
LinkedIn: Jean Rene Roy
Contact: http://www.softdesign.ca/blog
Jean-Ren#233; Roy has been developing IT solution for large and small enterprises since 1987. In 1991 he founded the consulting firm Technologies SoftDesign Inc.
Since that time he has worked on projects for House of Commons, Innovapost, Bell Canada, CGI, CNSC, Kraft, and many other clients assuming the responsibility of Business Analyst, Software Architect,ETL and BI Architect, Software Developers, Analyst, Team leader and mentor. Jean-Ren#233; Roy is a SQL Server Microsoft MVP.
Vitor Fava
Twitter: - sqlservermaniacs
LinkedIn: Vitor Fava
Contact: https://www.vitorfava.com
I’m a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation, and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I’m a speaker at various technology events such as SQLSaturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I’m the Chapter Leader of SQLManiacs PASS chapter.
Sophie Marchand
Twitter: - lecfomasque
LinkedIn: Sophie Marchand
Contact: http://www.lecfomasque.com/accueil-mon-cher-watson/
Instigatrice du CFO masqu#233;, Sophie Marchand est d#233;tentrice d’une M.Sc. en finance corporative, d’un titre comptable CPA, CGA et d’un titre MVP (Most valuable professional) Excel et d#39;un titre MVP Data Platform de Microsoft, et cumule de nombreuses ann#233;es d’exp#233;rience dans le milieu des affaires. Elle se sp#233;cialise particuli#232;rement en mod#233;lisation financi#232;re et en intelligence d’affaires. #192; ce titre, elle d#233;veloppe des mod#232;les financiers rigoureux, des tableaux de bord sophistiqu#233;s et des outils de gestion performants. Elle offre
Vitor Fava
Twitter: - sqlservermaniacs
LinkedIn: Vitor Fava
Contact: https://www.vitorfava.com
I’m a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation, and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I’m a speaker at various technology events such as SQLSaturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I’m the Chapter Leader of SQLManiacs PASS chapter.
Jean-Pierre Riehl
Twitter: - djeepy1
LinkedIn: Jean-Pierre Riehl
Contact: http://blog.djeepy1.net
Architect, Consultant, Trainer and also Manager, Jean-Pierre leads the Data BI Practice at AZEO, a French Microsoft “pure-player” partner. Jean-Pierre is MVP Data Platform since 2008 and speaks at many events in France and in Europe. JP leads the local community (GUSS) and organize events in France since 2011 : MS Cloud Summit, Les Journées SQL Server, SQLSaturday, etc. JP is passionate by data concerns in business like Data Governance, Data Quality or Data Vizualisation and since 2010, he’s specialized in Self-Service BI. His favorite topic is Power BI and business usages and technical architectures that go with.
Drew Furgiuele
Twitter: - pittfurg
LinkedIn: Drew Furgiuele
Contact: http://www.port1433.com
Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.
Christophe Laporte
Twitter: - conseilit
LinkedIn: Christophe Laporte
Contact: http://conseilit.wordpress.com/
Christophe Laporte is based in Toulouse, France and has worked with SQL Server since 1997, starting with SQL Server 6.5. Focusing on high availability, VLDBs, and virtualization, Christophe also delivers performance audits on SQL Server and helps companies in choosing the appropriate architectures (Cloud, OnPremise, or Hybrid). In addition to his MCM certification, Christophe is also a SQL MVP, speaker, and Microsoft Certified Trainer since 2000.
Christophe Laporte
Twitter: - conseilit
LinkedIn: Christophe Laporte
Contact: http://conseilit.wordpress.com/
Christophe Laporte is based in Toulouse, France and has worked with SQL Server since 1997, starting with SQL Server 6.5. Focusing on high availability, VLDBs, and virtualization, Christophe also delivers performance audits on SQL Server and helps companies in choosing the appropriate architectures (Cloud, OnPremise, or Hybrid). In addition to his MCM certification, Christophe is also a SQL MVP, speaker, and Microsoft Certified Trainer since 2000.
Michelle Gutzait
Twitter: - mgutzait
LinkedIn: Michelle Gutzait
Contact: http://Google me!
Involved in IT for more than 30 years as a developer, business analyst and database consultant. Worked exclusively with Microsoft SQL Server for the past 20+ years, consulting for many and diverse clients. Skills include everything related to SQL Server: infrastructure and database design, Performance tuning, security, High Availability, consolidation, Disaster Recovery, Cloud migrations and much more! Also active in the community as a speaker and a Blogger. One of the Organizers of the PASS Chapter in Montreal.
Jean-Pierre Riehl
Twitter: - djeepy1
LinkedIn: Jean-Pierre Riehl
Contact: http://blog.djeepy1.net
Architect, Consultant, Trainer and also Manager, Jean-Pierre leads the Data BI Practice at AZEO, a French Microsoft “pure-player” partner. Jean-Pierre is MVP Data Platform since 2008 and speaks at many events in France and in Europe. JP leads the local community (GUSS) and organize events in France since 2011 : MS Cloud Summit, Les Journées SQL Server, SQLSaturday, etc. JP is passionate by data concerns in business like Data Governance, Data Quality or Data Vizualisation and since 2010, he’s specialized in Self-Service BI. His favorite topic is Power BI and business usages and technical architectures that go with.
Christophe Laporte
Twitter: - conseilit
LinkedIn: Christophe Laporte
Contact: http://conseilit.wordpress.com/
Christophe Laporte is based in Toulouse, France and has worked with SQL Server since 1997, starting with SQL Server 6.5. Focusing on high availability, VLDBs, and virtualization, Christophe also delivers performance audits on SQL Server and helps companies in choosing the appropriate architectures (Cloud, OnPremise, or Hybrid). In addition to his MCM certification, Christophe is also a SQL MVP, speaker, and Microsoft Certified Trainer since 2000.
Sponsors
The following is a list of sponsors that helped fund the event: