SQLSaturday #251 - Paris 2013
Event Date: 09/14/2013 00:00:00
Event Location:
- Campus EPITA/EPITECH
- 24 rue Pasteur
- Le Kremlin-Bicetre, , France
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: Proposer une interface de saisie dans un projet décisionnel sous SQL Server 2012
Abstract: Même si la théorie voudrait que les saisies de données soient traitées dans le monde applicatif, il nous ait tous arrivé d’avoir à offrir une petite interface de saisie à nos utilisateurs.
Cette session propose un rapide tour d’horizon des méthodes offertes dans l’univers SQL Server, avec démonstration:
- Listes SharePoint synchronisées par SSIS
- Pages ASP.NET déployées sur IIS
- Application LightSwitch connectée à SQL Server
- Fichiers Excel chargés régulièrement par SSIS
On parlera avantages et inconvénients, technique, licencing, et on évoquera également les autres solutions possibles (Access, InfoPath…).
Speaker(s):
- Florian Eiden
Track and Room: Track 1 - Business Intelligence - N/A
Title: Le métier de DBA
Abstract: Lors de cette session, venez découvrir le métier de DBA, ses contraintes, ses atouts. Rencontrez des DBA et découvrez leur quotidien et les quelques anecdotes qu’ils vous raconteront. Une session participative qui n’aura de limites que vos questions.
Speaker(s):
- GUSS GUSS
Track and Room: Track 3 - Spécial Etudiants - N/A
Title: Inside the Columnstore Index - Deep Dive
Abstract: You have heard the marketing speak. You may have seen the demos. And maybe you have even played with the feature - columnstore indexes, the amazing “go faster” switch in SQL Server 2012! But do you know how they work? Come to this session to find out. We will lift the hood to give you a fascinating in-depth view of how columnstore indexes are built and read, how batch-mode execution operates, and how these features work together to achieve an amazing performance boost.
Speaker(s):
- Hugo Kornelis
Track and Room: Track 2 - Database Engine - N/A
Title: SQL Traces vs Extended Events
Abstract: Les événements étendus sont apparus avec SQL Server 2008. Cette fonctionnalité tend même à remplacer les traces SQL Server depuis SQL Server 2012. Lors de cette session nous expliquerons pourquoi les évènements étendus est en passe de devenir l’outil de prédilection de débogage des administrateurs de bases de données et des développeurs.
Speaker(s):
- David Barbarin
Track and Room: Track 2 - Database Engine - N/A
Title: Data Visualisation with Hadoop Mashups, Power View and Excel 2013
Abstract: The Hadoop ecosystem is a valuable tool for Business Intelligence and Data Visualisation practitioners. It allows you to mashup unstructured data from Hadoop with structured data from more traditional relational and multi-dimensional sources. For Business Intelligence practitioners, this is an excellent tool to gain new business insights, and overcome data silos that come from within the organisation, whilst freeing you to make use of external data sources too. Join us at this session in order to see how your Big Data can empower your business users via familiar Business Intelligence tools such as Excel and Power View.
Speaker(s):
- Jen Stirrup
Track and Room: Track 1 - Business Intelligence - N/A
Title: Panorama de l’écosystème Microsoft Data Platform
Abstract: L’objectif de cette session est de faire le tour complet des outils et disciplines qui composent l’offre Data Business Intelligence de Microsoft. Centrée autour de SQL Server et SharePoint, l’offre est riche et implique différents métiers, compétences, approches, etc. Une bonne entrée en matière pour avoir une vision 360 du sujet.
Speaker(s):
- GUSS GUSS
Track and Room: Track 3 - Spécial Etudiants - N/A
Title: Les métiers de la Business Intelligence
Abstract: Lors de cette session, venez découvrir les métiers de la Business Intelligence. Chef de projet, développeur, architecte, data steward, MOA, etc. Rencontrez des experts du sujet et découvrez leur quotidien et les quelques anecdotes qu’ils vous raconteront. Une session participative qui n’aura de limites que vos questions.
Speaker(s):
- GUSS GUSS
Track and Room: Track 3 - Spécial Etudiants - N/A
Title: Let’s Jive with Hive
Abstract: Hive is to Hadoop what TSQL is to SQL Server. Microsoft have released their own distro of Hadoop which extends their offering around Big Data. Come to this session and learn how to use Hive against Hadoop. In this session you will learn how to perform DML DDL SQL Operations
Speaker(s):
- Allan Mitchell
Track and Room: Track 2 - Database Engine - N/A
Title: PowerBI
Abstract: Lors de la Worlwide Partner Conference, Microsoft a annoncé la sortie prochaine de PowerBI, une offre packagée de Self-Service BI clé en main dans Office 365. L’offre est composée de toutes les dernière briques disponibles ou à venir : Power Pivot, Power Query (ex Data Explorer), Power Map (ex GeoFlow), SharePoint 2013, BI Mobile, etc. Cette session pose le décor autour de cette offre et rentre dans les enjeux d’architecture Cloud/On-Premise qu’il va falloir relever.
Speaker(s):
- Jean-Pierre Riehl
Track and Room: Track 1 - Business Intelligence - N/A
Title: SQL2014, a new breath for SSAS ?
Abstract: Our aim is to show you the strengths and the weaknesses of three different SSAS architecture based on SQL 2014.This architecures can inculde Hekaton technologie, ROLAP or MOLAP implementation, Tabular model and so on.
Speaker(s):
- Charles-Henri Sauget
Track and Room: Track 1 - Business Intelligence - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
David Barbarin
Twitter: - mikedavem
LinkedIn: David Barbarin
Contact: http://www.dbi-services.com/index.php/blog/dbi-bloggers/blogger/listings/dab
David Barbarin is Consultant at dbi services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies and associated topics such as installation, migration, security audits, troubleshooting of performance issues, or high availability architectures etc. David Barbarin is SQL Server MVP (since 2010), Microsoft Certified Master (MCM) for SQL Server, and Microsoft Certified Trainer (MCT).
Jen Stirrup
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
Charles-Henri Sauget
Twitter: - SaugetCh
LinkedIn: Charles-Henri Sauget
Contact: http://www.sauget-ch.fr
Consultant décisionnel depuis 2009, j’ai eu l’occasion d’explorer certaines des fonctionnalités offertes par SQL Server, et cela est loin d’être terminé avec la croissance des volumes de données, et les nouveaux outils à disposition (Data Insights), de nouveaux défis vont très certainement s’offrir à nous. Même si la B.I. reste mon coeur de métier, je ne cache pas mon intérêt pour le Moteur SQL Server, surtout si l’on rajoute à ceci l’impact d’un hébergement en IaaS dans Azure !
GUSS GUSS
Des DBA viendront vous parler de leur métier et de leur quotidien
Allan Mitchell
Twitter: - @allanSQLIS
Contact: https://onlysearch.wordpress.com/
Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.
Florian Eiden
Twitter: - @fleid_bi
LinkedIn: Florian Eiden
Contact: http://fleid.fr
Data Platform Solution Architect for Microsoft in Western Canada
GUSS GUSS
Des DBA viendront vous parler de leur métier et de leur quotidien
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Jean-Pierre Riehl
Twitter: - djeepy1
LinkedIn: Jean-Pierre Riehl
Contact: http://blog.djeepy1.net
Architect, Consultant, Trainer and also Manager, Jean-Pierre leads the Data BI Practice at AZEO, a French Microsoft “pure-player” partner. Jean-Pierre is MVP Data Platform since 2008 and speaks at many events in France and in Europe. JP leads the local community (GUSS) and organize events in France since 2011 : MS Cloud Summit, Les Journées SQL Server, SQLSaturday, etc. JP is passionate by data concerns in business like Data Governance, Data Quality or Data Vizualisation and since 2010, he’s specialized in Self-Service BI. His favorite topic is Power BI and business usages and technical architectures that go with.
GUSS GUSS
Des DBA viendront vous parler de leur métier et de leur quotidien
Sponsors
The following is a list of sponsors that helped fund the event: