sqlsathistory

Nr: 466

SQLSaturday #466 - Montreal 2015

Start Time (24h)	Speaker	Track	Title
09:45:00	Michael DeFehr	Application Database Development and Administration	Query Plans and Indexes in SQL Server
09:45:00	Charles Verdon	Azure ML	Analyse Pr#233;dictive - Partie 1
11:00:00	Charles Verdon	Azure ML	Analyse Pr#233;dictive - Partie 2
13:00:00	Jean Rene Roy	Application Database Development and Administration	The SQL Server Modern DBA
13:00:00	Sophie Marchand	BI Information Delivery	Visualisation de donn#233;es en mode libre-service
14:30:00	Michelle Gutzait	Enterprise Database Administration Deployment	Improve query performance with the new SQL Server 2016 query store!!

SessionID: 39605

Query Plans and Indexes in SQL Server

Back to calendar

Event Date: 21-11-2015 - Session time: 09:45:00 - Track: Application Database Development and Administration

Speaker: Michael DeFehr

Title: Query Plans and Indexes in SQL Server

Abstract:

Data access can be easy to set up in your applications with wizards and ORMs, but sometimes your queries are just not as fast as you think they should be – especially on those tables that are getting bigger and bigger. In this session, we will take a peek under the hood and see how SQL server answers the questions you ask of it. This is an introductory session, but it will be jam-packed with demos and useful tips that you will be able to use to make your applications more responsive.

SessionID: 40372

Analyse Pr#233;dictive - Partie 1

Back to calendar

Event Date: 21-11-2015 - Session time: 09:45:00 - Track: Azure ML

Speaker: Charles Verdon

Title: Analyse Pr#233;dictive - Partie 1

Abstract:

Positionnement des technologies de l'analyse pr#233;dictive sous la plateforme de Microsoft: Azure ML, Revolution Analytics (R), HDInsight Spark, SQL Server 2016. Discussion des avantages et differentiation de Azure ML par rapport aux plateformes SAS, IBM SPSS, et IBM Watson Analytics.

Introduction #224; l'approche requise pour l'analyse pr#233;dictive et presentation d'une d#233;monstration de Azure ML. Integration des donn#233;es dans Excel, Power BI et applications .NET.

SessionID: 40603

Analyse Pr#233;dictive - Partie 2

Back to calendar

Event Date: 21-11-2015 - Session time: 11:00:00 - Track: Azure ML

Speaker: Charles Verdon

Title: Analyse Pr#233;dictive - Partie 2

Abstract:

Discussion d'un sc#233;nario pr#233;cis: cr#233;ation d'un mod#232;le de donn#233;es pour pr#233;dire quels passagers ont surv#233;cu au naufrage du Titanic.

Exploration des donn#233;es dans Excel et Power BI Discussion des concepts statistiques : s#233;lection des variables (co-d#233;pendance) Performance de divers algorithmes, et explications de leurs comportements Comparaison de performance : faux positifs et faux n#233;gatifs, ROC, Recall, Lift Optimisation des param#232;tres d’un algorithme Op#233;rationnalisation du mod#232;le

SessionID: 39998

The SQL Server Modern DBA

Back to calendar

Event Date: 21-11-2015 - Session time: 13:00:00 - Track: Application Database Development and Administration

Speaker: Jean Rene Roy

Title: The SQL Server Modern DBA

Abstract:

What is a modern DBA? Well that depend on what you are doing in your day to day job. The modern DBA is the guy that uses the right tools for the job. SQL Server come with many tools (SSMS SSIS, SSRS) but these tools are not always the right tools for the job. This session will show you tip and trick and different tools for different job. Some of these tools tip and trick may become very useful in your day to day job.

SessionID: 40584

Visualisation de donn#233;es en mode libre-service

Back to calendar

Event Date: 21-11-2015 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Sophie Marchand

Title: Visualisation de donn#233;es en mode libre-service

Abstract:

Cette conf#233;rence a comme objectif de d#233;montrer comment cr#233;er des visualisations pertinentes dans Excel #224; l'aide de Power View et comment utiliser Sharepoint ou Power BI pour permettre aux membres d'une m#234;me #233;quipe de cr#233;er des visualisations sur des mod#232;les de donn#233;es partag#233;s et de consulter les visualisations des autres membres de leur #233;quipe. Depuis le 24 juillet dernier, Power BI (tout comme Power BI Desktop) utilise un engin de visualisation qui n'est plus Power View (et qui ne requi#232;re plus Silverlight) et cette conf#233;rence propose #233;galement d'illustrer les principales diff#233;rences entre les deux engins de visualisation.

SessionID: 39168

Improve query performance with the new SQL Server 2016 query store!!

Back to calendar

Event Date: 21-11-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michelle Gutzait

Title: Improve query performance with the new SQL Server 2016 query store!!

Abstract:

The Query Store feature maintains a history of query execution plans with their performance data, allowing you to quickly identify queries that are performing slower recently, allowing administrators or developers to force the use of an older, better plan if required. The Query Store is configured at the individual database level and not on the instance level.

This session will discuss the query store and what you can do on an ad-hoc basis or regularly.

This site is open source. Improve this page.