Event Location:
Microsoft Quebec
1500 Place de la Cité-Tour Cominar, 2640, Boul. Laurier, Quebec City QC
Quebec City, Quebec, Canada
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/profile/view?id=2796867
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 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.
LinkedIn: http://www.linkedin.com/in/stephenrsimon/
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 SQL Saturday circuit and he is a contributor on SQLShack.com
LinkedIn: https://www.linkedin.com/in/minerjohn/
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.
LinkedIn: http://www.linkedin.com/in/stephenrsimon/
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 SQL Saturday circuit and he is a contributor on SQLShack.com
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.
LinkedIn: https://www.linkedin.com/in/minerjohn/
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.
LinkedIn: https://www.linkedin.com/profile/view?id=2796867
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 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.
LinkedIn: https://www.linkedin.com/in/mercierfranck/
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.
LinkedIn: https://ca.linkedin.com/in/ccote
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).
LinkedIn: https://www.linkedin.com/in/mercierfranck/
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.
The following is a list of sponsors that helped fund the event.