SQLSaturday #843 - Québec 2019
Event Date: 04/12/2019 00:00:00
Event Location:
- Microsoft Quebec
- 1500 Place de la Cité-Tour Cominar, 2640, Boul. Laurier, Quebec City QC
- Quebec City, 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: An introduction to Data Mining with SQL Server 2017
Abstract: With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
1) Defining what questions we want answered and how to go about this in an effective and efficient manner.
2) Creating the data model.
3) How to gather the necessary data, discussing the training and testing aspect.
4) Processing the model.
5) Extracting information from our finished model, discussing the implications of this information.
Speaker(s):
- Steve Simon
Track and Room: BI Infonuagique - Salle 1
Title: Staging data for Azure SQL services
Abstract: Most companies are faced with the ever-growing big data problem. There have been two schools of thought on how to solve this problem.
Schema on write is represented by the traditional relational database table. Only a small portion of the total data owned by the company resides in the database.
Schema on read is represented by technologies such as Hadoop or PolyBase. All data owned by the company can reside in simple storage.
Today, we will learn how to stage data using Azure blob storage which can be ingested by both techniques.
1 – Grab some big data. 2 – Create blob storage account. 3 – Copy data to container. 4 – Azure SQL database plumbing. 5 – Loading data with BULK INSERT. 6 – Azure SQL data warehouse plumbing. 7 – Loading data with POLYBASE. 8 – Azure automation with RUNBOOKS.
Speaker(s):
- John Miner
Track and Room: Développement - Salle 2
Title: Azure Cosmos DB
Abstract: Azure Cosmos DB est une base de données multi modèles distribuée à l’échelle mondiale. En un seul clic, Azure Cosmos DB vous permet d’adapter de manière indépendante et flexible le débit et la capacité de stockage dans un nombre illimité de régions géographiques. Il offre une latence, une disponibilité, une cohérence et un débit garantis avec des accords sur les niveaux de service exhaustifs, un avantage qu’aucun autre service de base de données ne peut vous offrir. Azure Cosmos DB prend également en charge les connexions client MongoDB, ce qui vous permet d’utiliser le même code que pour les applications MongoDB en profitant des avantages d’un déploiement en nuage simple ainsi que d’une évolutivité accrue. Dans cet aperçu technique, vous découvrirez à quel point il est facile de commencer à concevoir des applications évolutives et déployées dans certaines régions géographiques grâce à Azure Cosmos DB. Nous examinerons également plus en profondeur certains aspects cruciaux de conceptio
Speaker(s):
- Franck Mercier
Track and Room: BI Infonuagique - Salle 1
Title: Migration de base données (fin de support 2008r2)
Abstract: Comment préparer et implémenter une migration d’une ancienne version de SQL Server vers une nouvelle version de SQL Server sans perte de données et pratiquement aucun temps d’arrêt. Et si vous avez un budget matériel limité pour l’effort de mise à niveau? Cette session couvrira plusieurs méthodes différentes pour migrer vos données vers la nouvelle version de SQL Server.
How do you design and implement a safe and successful migration from an older version of SQL Server to new version of SQL Server with no data loss and virtually no downtime? What if you have a limited hardware budget for the upgrade effort. This session will cover several different methods for migrating your data to new version of SQL Server.
Speaker(s):
- Manuel Pineda
Track and Room: Développement - Salle 2
Title: Continuous Deployment Continuous Integration with Azure DevOps Visual Studio
Abstract: Many companies are switching over from the waterfall model to the agile software development process with the hopes of bringing quality software quicker to market. Under this process, requirements and solutions evolve through the collaborative effort of cross-functional teams and their customer(s) or user(s). Some principle ideas of this process are adaptive planning, early delivery, continuous improvement, and flexible response to change.
Azure DevOps is the next generation of Visual Studio Team Services. This product combines sprint planning, task assignment, version control, testing, continuous deployment and continuous integration into one service.
During this presentation we will explore how to migrate the Adventure Works Data Warehouse schema to the cloud, create a database project in Visual Studio 17, setup development and production environments, check code into a Git repository and track new project features using agile techniques. Come and learn the power of DevOps.
Speaker(s):
- John Miner
Track and Room: Développement - Salle 2
Title: Running Microsoft Database Migration Assistant (DMA) on many inst
Abstract: The DMA tool allows you to run migration assessments for different migration types: upgrades, moving to Azure VMs, Azure Databases or Azure Managed Instances. The problem is that, when running the User Interface of the tool on many instances and/or databases, it take forever to run and if session disconnected or anything fails during the execution, you lose all the configurations and results. In this session, I will teach you how to run the tool as a scheduled task using PowerShell scripts, how to import results into a SQL database and how to run neat reports on those results.
Speaker(s):
- Michelle Gutzait
Track and Room: Développement - Salle 2
Title: DevOps 101 for DBAs and Database Developers
Abstract: This presentation will introduce DBAs and Database Developers to DevOps and DevOps concepts and show why embracing DevOps is important. The talk will cover the history of DevOps and define use cases relevant to DBAs and Database Developers. We’ll also show how existing database tools can be adapted to a DevOps environment.
Speaker(s):
- Clay Jackson
Track and Room: Développement - Salle 2
Title: Azure Database, Azure Machine or Azure Managed Instance? Why, whe
Abstract: So you have already decided to move to Azure but which platform is the best for your databases, from functionality perspective as well as price? In this presentation Michelle will present the advantages and disadvantages of each platform as well as how to choose the best one for your database(s).
Speaker(s):
- Michelle Gutzait
Track and Room: BI Infonuagique - Salle 1
Title: Using Database Replication to Make Your Oracle Data Available in SQLServer
Abstract: Learn how to use database replication tools to help “unlock” the data in your Oracle databases and make it available in SQLServer. This talk will cover the basics of database replication and how it can be used to move data between different database platforms. The talk will include a survey of available tools and methodologies and discuss the pros and cons of the various methodologies.
Speaker(s):
- Clay Jackson
Track and Room: BI Infonuagique - Salle 1
Title: Power BI Report Server dans votre entreprise
Abstract: Power BI Report server est permet de partager les visualisations Power BI on-premises. Cette session décrira en detail les possibilités d’utilisation du produit. Il vous permettra de connaître les avantages de Power BI Report Server comme portail pour vos rapports d’entreprises.
Speaker(s):
- Christian Cote
Track and Room: BI Infonuagique - Salle 1
Title: Déployer une solution complète et sécurisée d’analyses de données dans Azur
Abstract: Dans cette session, nous allons voir comment tirer parti des services Azure pour ingérer, stocker, transformer et présenter les données, peu importe leur structure d’origine. Je vous présenterai une solution complète mettant en œuvre les services Azure Data Factory, Azure Data Lake Gen2, Azure Databricks, Azure SQL Database ainsi que Power BI. Le tout sécurisé avec Azure Key Vault. On parlera aussi de DataOps et de la manière de paramétrer et automatiser toute la chaine de transformation de données.
Speaker(s):
- Franck Mercier
Track and Room: BI Infonuagique - Salle 1
Title: Efficient and Effective coding of Stored Procedures
Abstract: Data does not become information until decision makers are able to view it and make those decisions that affect the enterprise as a whole. Stored procedures are one means of getting the data from the database tables to the reports in an effective and efficient manner. In this hands-on presentation, we shall be looking at best practices with regards to creating and tuning stored procedures. We shall also be discussing parameter sniffing and other gotcha’s that affect us in our daily lives.
Speaker(s):
- Steve Simon
Track and Room: Développement - Salle 2
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Clay Jackson
Twitter: - n7qnm
Clay Jackson is a Database Sales Engineer for Quest, specializing in Database Performance Management and Replication Tools. Prior to joining Quest, Jackson was the DBA Manager at Darigold. He also spent over 10 years managing Oracle, SQLServer and DB2 databases and DBAs at Washington Mutual and was employee number 66 at Microsoft, spending time in Product Support, MIS and OS/2 Development. While at WaMu, Jackson was the Enterprise Database Compliance Officer, with responsibility for Database Security and Disaster Recovery. He also worked at Microsoft and Starbucks, is a CISM, and has a Masters in Software Engineering from Seattle University.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
John Miner
Twitter: - https://twitter.com/JohnMiner3
LinkedIn: John Miner
Contact: https://www.mssqltips.com/sqlserverauthor/154/john-miner/
John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.
He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.
He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.
Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Manuel Pineda
20 années d’expérience en informatique de gestion. Mon expérience di-versifiée couvre l’architecture, l’administration, la maintenance et l’optimisation de base de données et de systèmes informatiques.
John Miner
Twitter: - https://twitter.com/JohnMiner3
LinkedIn: John Miner
Contact: https://www.mssqltips.com/sqlserverauthor/154/john-miner/
John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.
He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.
He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.
Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.
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.
Clay Jackson
Twitter: - n7qnm
Clay Jackson is a Database Sales Engineer for Quest, specializing in Database Performance Management and Replication Tools. Prior to joining Quest, Jackson was the DBA Manager at Darigold. He also spent over 10 years managing Oracle, SQLServer and DB2 databases and DBAs at Washington Mutual and was employee number 66 at Microsoft, spending time in Product Support, MIS and OS/2 Development. While at WaMu, Jackson was the Enterprise Database Compliance Officer, with responsibility for Database Security and Disaster Recovery. He also worked at Microsoft and Starbucks, is a CISM, and has a Masters in Software Engineering from Seattle University.
Franck Mercier
Twitter: - FranmerMS
LinkedIn: Franck Mercier
Contact: http://aka.ms/franck
Je suis arrivé chez Microsoft en 1999 en tant qu’ingénieur support sur la toute suite Office. En 2002, j’ai intégré l’équipe avant-vente sur la solution EPM (Enterprise Project Management). J’ai eu pour mission de promouvoir les solutions de gestion de projets, de programmes et d’innovation (IPM : Innovation Process Management). En 2010, j’ai radicalement changé de Technologie pour rejoindre l’équipe Avant-Vente Business Intelligence. En 2013, j’ai rejoint l’équipe des évangélistes IT Pro sur les technologies SQL, SharePoint et Office pour évoluer ensuite en tant qu’architecte Azure pour les ISVs. Depuis 2018, j’ai rejoint les équipes de Montréal pour prendre un rôle technico-commercial sur la plateforme de données de Microsoft.
Christian Cote
Twitter: - Christian_SQL
LinkedIn: Christian Cote
Contact: http://bi-blogger.typepad.com/
Christian Coté is an IT professional with more than 15 years of experience working in data warehouse and business intelligence projects. Christian developed an expertise in data warehousing over the years and designed many ETL/BI processes using a range of tools on multiple platforms. He’s been presenting at several conferences and code camps. He currently co-leads the SQL Server PASS chapter in Montreal as well as Global French SQL PASS Chapter. He is also a Microsoft Data Platform Most Valuable Professional (MVP).
Franck Mercier
Twitter: - FranmerMS
LinkedIn: Franck Mercier
Contact: http://aka.ms/franck
Je suis arrivé chez Microsoft en 1999 en tant qu’ingénieur support sur la toute suite Office. En 2002, j’ai intégré l’équipe avant-vente sur la solution EPM (Enterprise Project Management). J’ai eu pour mission de promouvoir les solutions de gestion de projets, de programmes et d’innovation (IPM : Innovation Process Management). En 2010, j’ai radicalement changé de Technologie pour rejoindre l’équipe Avant-Vente Business Intelligence. En 2013, j’ai rejoint l’équipe des évangélistes IT Pro sur les technologies SQL, SharePoint et Office pour évoluer ensuite en tant qu’architecte Azure pour les ISVs. Depuis 2018, j’ai rejoint les équipes de Montréal pour prendre un rôle technico-commercial sur la plateforme de données de Microsoft.
Sponsors
The following is a list of sponsors that helped fund the event: