Nr: 843
SQLSaturday #843 - Québec 2019
SessionID: 88294
An introduction to Data Mining with SQL Server 2017
Event Date: 12-04-2019 - Session time: 08:45:00 - Track: BI Infonuagique
Speaker: Steve Simon
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:
-
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.
SessionID: 89228
Migration de base données (fin de support 2008r2)
Event Date: 12-04-2019 - Session time: 08:45:00 - Track: Développement
Speaker: Manuel Pineda
Title: Migration de base données (fin de support 2008r2)
Abstract:
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.
SessionID: 88296
Efficient and Effective coding of Stored Procedures
Event Date: 12-04-2019 - Session time: 10:15:00 - Track: Développement
Speaker: Steve Simon
Title: Efficient and Effective coding of Stored Procedures
Abstract:
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.
SessionID: 88338
DevOps 101 for DBAs and Database Developers
Event Date: 12-04-2019 - Session time: 10:15:00 - Track: Développement
Speaker: Clay Jackson
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.
SessionID: 88340
Using Database Replication to Make Your Oracle Data Available in SQLServer
Event Date: 12-04-2019 - Session time: 10:15:00 - Track: BI Infonuagique
Speaker: Clay Jackson
Title: Using Database Replication to Make Your Oracle Data Available in SQLServer
Abstract:
SessionID: 91366
Azure Database, Azure Machine or Azure Managed Instance? Why, whe
Event Date: 12-04-2019 - Session time: 10:15:00 - Track: BI Infonuagique
Speaker: Michelle Gutzait
Title: Azure Database, Azure Machine or Azure Managed Instance? Why, whe
Abstract:
SessionID: 89040
Azure Cosmos DB
Event Date: 12-04-2019 - Session time: 11:30:00 - Track: BI Infonuagique
Speaker: Franck Mercier
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
SessionID: 91365
Running Microsoft Database Migration Assistant (DMA) on many inst
Event Date: 12-04-2019 - Session time: 11:30:00 - Track: Développement
Speaker: Michelle Gutzait
Title: Running Microsoft Database Migration Assistant (DMA) on many inst
Abstract:
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.
SessionID: 88905
Staging data for Azure SQL services
Event Date: 12-04-2019 - Session time: 13:30:00 - Track: Développement
Speaker: John Miner
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.
SessionID: 89039
Déployer une solution complète et sécurisée d’analyses de données dans Azur
Event Date: 12-04-2019 - Session time: 13:30:00 - Track: BI Infonuagique
Speaker: Franck Mercier
Title: Déployer une solution complète et sécurisée d’analyses de données dans Azur
Abstract:
On parlera aussi de DataOps et de la manière de paramétrer et automatiser toute la chaine de transformation de données.
SessionID: 88172
Power BI Report Server dans votre entreprise
Event Date: 12-04-2019 - Session time: 14:45:00 - Track: BI Infonuagique
Speaker: Christian Cote
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.
SessionID: 88906
Continuous Deployment Continuous Integration with Azure DevOps Visual Studio
Event Date: 12-04-2019 - Session time: 14:45:00 - Track: Développement
Speaker: John Miner
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.