Nr: 658
SQLSaturday #658 - Toulouse 2017
SessionID: 64737
High Availability and Disaster Recovery on SQL Server, Azure and beyond
Event Date: 16-09-2017 - Session time: 10:00:00 - Track: 1 - DBA Cloud-DBA
Speaker: Paul Bertucci
Title: High Availability and Disaster Recovery on SQL Server, Azure and beyond
Abstract:
Do you need five 9's or greater of up time? High Availability of applications and databases are rapidly becoming the "norm" around the globe. Clearly one of the hottest topics in the world to fully understand and to plan for. Mr. Bertucci will reveal a complete methodology around High Availability and present several architecture and technology solutions to HA that he showcases in his new Book (MS SQL Server 2016 High Availability Unleashed!). He will also cover Disaster Recovery options and Business Continuity considerations along the way. In particular, this presentation covers assessing, planning, choosing, implementing and administering a high availability solution along with the business justifications of different approaches to achieve high availability (Coverage includes MS SQL Server options such as AlwaysOn and Availability Groups, Azure/AWS options, and Big Data HA architectures and hybrid solutions).
SessionID: 67524
L'ALM pour les bases de données SQL Server grâce à Visual Studio, ReadyRoll et VSTS
Event Date: 16-09-2017 - Session time: 10:00:00 - Track: 3 - Dev Data
Speaker: Patrice Lamarche
Title: L'ALM pour les bases de données SQL Server grâce à Visual Studio, ReadyRoll et VSTS
Abstract:
Vous en avez marre d'effectuer vos mises à jour de BDD manuellement avec des SQL Compare :), venez apprendre comment automatiser le tout de manière simple !
SessionID: 67600
Azure Data Lake : SELECT People FROM DataLake WHERE Happy = TRUE
Event Date: 16-09-2017 - Session time: 10:00:00 - Track: 2 - BI Analytics
Speaker: Jean-Pierre Riehl
Title: Azure Data Lake : SELECT People FROM DataLake WHERE Happy = TRUE
Abstract:
Discover Azure Date Lake through a complete demo : how to get insights from tons of text, photos and videos ? From different media files and raw data, we will analyze sentiment of characters and get valuable information in a Power BI dashboard, using Cognitive Services, CNTK, .NET and U-SQL.
This session will mainly showcase Azure Data Lake and U-SQL language. But demos will involve different tools like Azure Data Factory for data supply chain and orchestration, Azure SQL Datawarehouse for corporate data and also Azure Machine Learning and Power BI.
Even if this session is demo-driven, we won't omit to present you concepts and features of Azure Data Lake.
SessionID: 66750
Les bases du dépannage SQL Server
Event Date: 16-09-2017 - Session time: 11:30:00 - Track: 1 - DBA Cloud-DBA
Speaker: Christophe Laporte
Title: Les bases du dépannage SQL Server
Abstract:
Au final, le logiciel est fiable et ne provoque que très rarement des erreurs, des "plantages".
Par contre, au quotidien, cela ne veut pas dire qu'il ne va pas y avoir de problèmes sur l'instance, principalement de connexion, d'autorisation ou de performance.
Au cours de cette session, nous allons aborder les bases du diagnostic et du dépannage SQL Server.
SessionID: 67352
SSAS Tabulaire - Optimisation
Event Date: 16-09-2017 - Session time: 11:30:00 - Track: 2 - BI Analytics
Speaker: Charles-Henri Sauget
Title: SSAS Tabulaire - Optimisation
Abstract:
SessionID: 67712
Des graphs partout! Microsoft se prendrait-il pour Banksy?
Event Date: 16-09-2017 - Session time: 11:30:00 - Track: 3 - Dev Data
Speaker: Cédric Charlier
Title: Des graphs partout! Microsoft se prendrait-il pour Banksy?
Abstract:
SessionID: 64703
Reporting Services 2016 and beyond
Event Date: 16-09-2017 - Session time: 13:30:00 - Track: 2 - BI Analytics
Speaker: Christian Cote
Title: Reporting Services 2016 and beyond
Abstract:
SQL Server Reporting Services has been completely revamped in 2016. This session will talk about the novelties of this version and how it can be used In conjunction with Power BI. We'll also have some glimpse of how vNext will go further with Power BI to facilitate it's use in corporate environments.
SessionID: 66886
Introducing SQL Server on Linux for DBAs
Event Date: 16-09-2017 - Session time: 13:30:00 - Track: 1 - DBA Cloud-DBA
Speaker: David Barbarin
Title: Introducing SQL Server on Linux for DBAs
Abstract:
Open source is definitely part of the Microsoft strategy. Indeed, you may run SQL Server either on a physical or a virtual machine, and recently on the top of Windows or Linux operation system as well. In this session, let’s see how Microsoft managed to move SQL Server on Linux and then let’s explore which features will be available in this new world.
SessionID: 67653
Scale-Out your SSIS Package Executions
Event Date: 16-09-2017 - Session time: 13:30:00 - Track: 3 - Dev Data
Speaker: Wolfgang Strasser
Title: Scale-Out your SSIS Package Executions
Abstract:
With a rising number of parallel SQL Server Integration Services (SSIS) package executions the resource requirements on the SSIS server can be a limiting factor. In older SQL Server versions, scale-out architectures needed to be implemented by hand and required a lot of manual implementation effort. Beginning with SQL Server 2017, SSIS provides a built-in scale-out functionality for package executions.
After the definition of scalability-types, the SSIS scale-out architecture and the involved system-parts are introduced. The attendees will learn the basics, get checklists and best practices when building up their own SSIS scale-out cluster. In addition to the configuration using SSMS other configuration options (command line, T-SQL,..) are presented. Behind the scenes information like logging, the programmability interfaces and configuration options will be shared.
SessionID: 67354
POWER BI PREMIUM : POUR QUELS USAGES ?
Event Date: 16-09-2017 - Session time: 15:00:00 - Track: 2 - BI Analytics
Speaker: Joël Crest
Title: POWER BI PREMIUM : POUR QUELS USAGES ?
Abstract:
Quelques mois après son annonce en General Availability, il est temps de revenir en détail sur l'offre Power BI Premium.
Présentée comme complémentaire des deux modes de licences actuels (Free et Pro), cette nouvelle offre adresse de nouveaux usages : quels sont-ils ? Pour quel public et quel type de clients ? Peut-on disposer de certains avantages de Power BI Premium sans avoir souscrit à l'offre ?
Autant de questions auxquelles je répondrai au cours de cette session.
SessionID: 67357
Scale out dans la vraie vie
Event Date: 16-09-2017 - Session time: 15:00:00 - Track: 1 - DBA Cloud-DBA
Speaker: Gregory Boge
Title: Scale out dans la vraie vie
Abstract:
Avec un nombre de batch requests par seconde qui augmente énormément et des connexions depuis le monde entier, on est obligé de distribuer les données sur plusieurs serveurs.
Ceci nécessite de faire des choix d'architecture, nous utilisons la réplication transactionnelle pour répondre à nos besoins mais ce n'est pas sans galère.
Dans cette session, j'essayerai de vous expliquer quelle est notre architecture et pourquoi nous sommes toujours on-premise, pourquoi nous utilisons de la double réplication transactionnelle, quelles sont nos problématiques et nos solutions (Intégration continue, déploiement, monitoring, migration de publisher, etc...).
SessionID: 64560
Real-Time Analytics: OLAP OLTP in the mix!
Event Date: 16-09-2017 - Session time: 16:30:00 - Track: 1 - DBA Cloud-DBA
Speaker: Stijn Wynants
Title: Real-Time Analytics: OLAP OLTP in the mix!
Abstract:
In this session we will talk about the Operational analytics possibilities using ColumnStore indexes with SQL Server 2016. This will be a deep-dive on how this works, and will give you an explanation on the new Columnstore features. We will also talk about the difference between hot warm data, and how to make this fit for your environment.
SessionID: 64742
Turn insight into action using Microsoft Flow and Power BI
Event Date: 16-09-2017 - Session time: 16:30:00 - Track: 2 - BI Analytics
Speaker: Isabelle Van Campenhoudt
Title: Turn insight into action using Microsoft Flow and Power BI
Abstract:
By combining the power of Power BI data alerts with the hundreds of actions available for Flow, we’re making it easier than ever to go from insight to deep, meaningful action.
Microsoft Flow is a SaaS offering for automating workflows across the growing number of applications and services that business users rely on. You can set up Flows to take care of the important, repeating tasks that take place daily in your organization. For example, you can create a Flow to text you via SMS when your manager sends you an e-mail marked as “high importance.” Or, automatically create a to-do item in Wunderlist when a customer e-mails your support line.
SessionID: 69118
Les nouveautés SAAS de la plateforme AZURE : Cosmos DB, MySQL et PostgreSQL as a service !
Event Date: 16-09-2017 - Session time: 16:30:00 - Track: 3 - Dev Data
Speaker: Sébastien Pertus
Title: Les nouveautés SAAS de la plateforme AZURE : Cosmos DB, MySQL et PostgreSQL as a service !
Abstract:
Cette session sera divisée en 2 parties : Une première partie pour découvrir les deux nouvelles offres SAAS d’Azure, concernant les bases de données relationnelles MySQL et PostgreSQL.
Nous verrons ensemble quelles sont les possibilités qu’offrent ce nouveau mode de fonctionnement pour ces deux bases de données extrêmement répandues.
Dans une seconde partie nous aborderons une grosse nouveauté dans le mode No SQL, apportée par Cosmos DB, l’évolution majeure de Document DB, avec l’adjonction de nouvelles fonctionnalités de scaling et un nombreux choix de modèles de données.
Chacune de ses deux parties vous permettra d’avoir une vision globale des possibilités que peut apporter une solution basée sur une infrastructure cloud comme AZURE, tout particulièrement les garanties de PRA, qui sont souvent un point très important dans le management de nos structures de données.