SQLSaturday #459 - Madrid 2015

Event Date: 11/21/2015 00:00:00

Event Location:

  • Microsoft Iberica
  • Centro Empresarial La Finca - Edificio 1, Pozuelo de Alarcón (Madrid)
  • Madrid, Madrid, Spain

PDF of Schedule

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: Advanced BIML - for the advanced ETL developer

Abstract: This is not your regular Agile yada yada BIML session. By now you already know that BIML is a great productivity enhancement to SSIS. You also know that you can build metadata driven solution and include C# code in your BIML scripts or snippets. If you don’t know what I’m talking about this session is not for you. If you - on the other hand - want to know how to build a modular BIML framework, do real C# development and include it in your BIML code so that you can pass custom objects around for optimized performance and code reuse then this session is for you. I promise you no more than 5 slides but a lot of demos and real life experience acquired from major BIML projects. We will also have a look at how to harness integration and unit tests in the setup with a twist of Continuous Integration.

Speaker(s):

  • Regis Baccaro

Track and Room: Business Intelligence - Isaac Peral


Title: Navision + PowerBI: Manage your business 365, anywhere and everywhere

Abstract: The Systems Manager SME and IT Manager of a large company shared challenges. The main thing is to find management solutions (ERP systems) that provide business value, which integrate well with other company applications and allow users to work without errors or interruptions of service … and of course: from anywhere and anytime. Microsoft Dynamics NAV is the strong, agile and flexible solution that allows us to have our company always managed, can be implemented at any stage (in the cloud, hybrid environments, on-premise) and is perfectly integrated with the rest of our infrastructure. The work of the department goes beyond solving problems and ensure efficient technological infrastructure, and every day is more strategic. A well-integrated, easy and intuitive management solution that enables the automation of processes can bring significant value to your business, saving many repetitive and unrewarding tasks.

Speaker(s):

  • Miguel Llorca

Track and Room: Cloud - Ramon y Cajal


Title: Pensando en BigData: Un paseo por el Modern Data Warehouse

Abstract: El Data Warehouse tradicional ha sido clave en las organizaciones durante mucho tiempo, siendo el punto central de toda la parte anal#237;tica.

Pero est#225;n apareciendo nuevos retos donde los desarrolladores van a entrar en juego: crecimiento masivo de datos; datos semi-estructurados; patrones de comportamiento ocultos y datos sociales.

#191;Cu#225;l son las tecnolog#237;as disponibles que podemos utilizar para tratar todos estos datos? El nuevo concepto de Modern Data Warehouse es la clave.

En esta sesi#243;n aprenderemos a activar e integrar en Power BI todas las piezas del Moder Data Warehouse, usando Cubos, Hadoop, NoSQL, Machine Learning y Stream Analytics.

Todo ello con un ejemplo real de un escenario del mundo Retail.

Speaker(s):

  • Ruben Pertusa Lopez

Track and Room: Big Data Analytics - Ramon y Cajal


Title: No todo en esta vida es PowerBI: SSRS 2016 + Datazen

Abstract: En la corriente actual de que el usuario trabaje sus propios informes, queda un nicho amplio donde los informes se hacen complicados obligando al usuario a necesitar ayuda del personal de TI para obtener la informaci#243;n. Aqu#237; entra en escena las herramientas m#225;s robustas de Reporting, donde el usuario necesita dar un paso m#225;s en la visualizaci#243;n y el an#225;lisis de la informaci#243;n.

Cuando nadie imaginaba que Reporting Services nos pod#237;a aportar nada nuevo (y algunos lo quer#237;an dar por muerto) nos encontramos que en 2016 aparecen novedades interesantes que pueden dar un giro en la utilizaci#243;n de la plataforma. Adem#225;s, la adquisici#243;n de Datazen por parte de Microsoft da un aire fresco a los especialistas de TI en la generaci#243;n de informes.

En esta sesi#243;n veremos las novedades que nos aporta la nueva versi#243;n de SSRS y como su nuevo compa#241;ero de juergas, Datazen, nos puede proporcionar una experiencia visualmente atractiva y con las capacidades m#243;viles que necesitamos a d#237;a de hoy.

Speaker(s):

  • Sergio Carrillo Vila

Track and Room: Big Data Analytics - Auditorium


Title: Los mejores patrones para cargas masivas en ETL

Abstract: Despu#233;s de hacer muchos proyectos de BI, en los que la parte m#225;s tediosa y larga siempre es la extracci#243;n transformaci#243;n y carga de datos, nos damos cuenta que realmente usamos los mismos esquemas en funci#243;n de una serie de condicionantes muy claros y determinados. Durante la sesi#243;n veremos cuales son esos patrones, que ventajas e inconvenientes tienen unos contra los otros. Veremos tambi#233;n, como esos patrones pueden servir para la automatizaci#243;n de la construcci#243;n de DataWarehouses. Adicionalmente veremos la resoluci#243;n que proponemos a problemas como la administraci#243;n de metadatos, el mantenimiento de las soluciones, y otros aspectos relacionados con el ciclo de vida de los procesos ETL.

Speaker(s):

  • Miguel Egea

Track and Room: Business Intelligence - Auditorium


Title: Columnstore in SQL Server 2016

Abstract: Operational Analytics In-Memory Analytics are the 2 new amazing options that Microsoft is offering in the upcoming SQL Server 2016. Build up Columnstore Analytics over your existing OLTP Clustered Table with a new updatable Nonclustered Columnstore Index, or use the In-Memory Updatable Nonclustered Columnstore Index over the InMemory OLTP Tables. Discover what features of manageability and monitoring are being added to the SQL Server 2016. This session will be delivering an overview of what is new and how it is going to change the landscape of OLTP OLAP.

Speaker(s):

  • Niko Neugebauer

Track and Room: Business Intelligence - Ramon y Cajal


Title: Windows 10 IoT y an#225;lisis de sensores en tiempo real con stream analytics

Abstract: Con Windows 10 IoT Core, un dispositivo y unos cuantos sensores veremos de forma pr#225;ctica c#243;mo recoger datos en Azure y analizarlos en tiempo real utilizando toda la potencia de los servicios disponibles: Event Hubs, Stream Analytics, WebSites, PowerBI y Machine Learning.

Speaker(s):

  • Juan Manuel Servera Bondroit

Track and Room: Big Data Analytics - Isaac Peral


Title: Detectando anomal#237;as de IoT con Machine Learning y Spark

Abstract: En el momento actual la implantaci#243;n de Big Data en cualquier organizaci#243;n es una prioridad y el valor de la anal#237;tica avanzada soportada por los algoritmos de machine learning una justificaci#243;n para adoptar a la inteligencia artificial como una ventaja competitiva en la empresa. La informaci#243;n procedente de sensores y el IoT son base tambi#233;n de este planteamiento y estos algoritmos hacen a#250;n m#225;s valiosos los datos en este contexto. En esta ponencia haremos un recorrido por el paradigma Big Data y algunos de los diferentes algoritmos de machine learning en un enfoque a IoT utilizando ejemplos con Spark y utilizando la plataforma Azure y HDInsight. Adem#225;s se mostrar#225;n ejemplos y casos de uso desarrollados en Altran.

Speaker(s):

  • Francisco Soler Flores

Track and Room: Big Data Analytics - Isaac Peral


Title: Pyramid Analytics-From Me BI to We BI, take your BI solution beyo

Abstract: One of the main challenges organizations face in the BI word is to allow, via a single platform, contradicting needs self-service BI with governance and Enterprise scale.

Come and see the game changing approach of Pyramid Analytics that allows organizations to obtain these impossible needs of business users and IT in a singular BI platform.

Pyramid Analytics the platform that Microsoft selected as a strategic partner for PowerBI.

Pyramid Analytics revolutionary platform provides a single platform that delivers: • Self Service – No code necessary. • Web based center administration and security. • Role based functionality for different roles in the organization ( Professional , Analyst and consumer). • Universal configuration – build once use anywhere (PC, Tablet and Mobile). • Enterprise scale – parallel processing, clustering and load balancing. • And more ….

Speaker(s):

  • Ruben Pertusa Lopez

Track and Room: Sponsor Session - Isaac Peral


Title: Como leer planes de ejecuci#243;n - Edici#243;n 2015

Abstract: Todo el mundo que trabaja con base de datos siempre se ha preguntado alguna vez qu#233; son los planes de ejecuci#243;n y como se leen. Saber leer un plan de ejecuci#243;n nos va a dar informaci#243;n valios#237;sima de cara a mejorar el rendimiento de una consulta. En esta sesi#243;n vamos a centrarnos en aprender a leer T-SQL para interpretar lo que est#225; haciendo SQL Server para devolvernos la informaci#243;n.

Speaker(s):

  • Enrique Bañuls

Track and Room: DBA - Auditorium


Title: Power BI and Reporting in Microsoft Project

Abstract: Project Online and Project Server provide easy, yet powerful, reporting options to create a variety of projects, resources, and portfolio reports. Learn how you can create real-time reports and dashboards using tools such as Microsoft Excel , Excel Services, Microsoft PowerPivot, Power View, and OData.

Speaker(s):

  • Rafael ansino lara

Track and Room: Business Intelligence - Santiago Dexeus


Title: Common TSQL Mistakes

Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over SEVENTY times now and it is always very highly rated!

Speaker(s):

  • Kevin Boles

Track and Room: DBA - Auditorium


Title: Cuadros de Mando: El todo es m#225;s que la suma de las partes

Abstract: No es suficiente con hacer tablas, gr#225;ficos y/o indicadores de forma individual. Debemos pensar en agregar valor a la visualizaci#243;n y el an#225;lisis con un conjunto de estos elementos que se complementen entre s#237; para enriquecer las respuestas. En esta sesi#243;n veremos diversas t#233;cnicas de visualizaci#243;n para mejorar los cuadros de mando, incluso algunas de ellas tambi#233;n se pueden aplicar sobre informes. Veremos tambi#233;n diversos ejemplos, en algunos de ellos partiremos de una mala soluci#243;n que iremos comentando y mejorando.

Speaker(s):

  • Salvador Ramos

Track and Room: Big Data Analytics - Santiago Dexeus


Title: Ye Olde Cluster Curiosity Shoppe - Clustering tips, tricks and oddities

Abstract:

Welcome to the strange and mysterious world of SQL Server Failover Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from nearly two decades of installing and troubleshooting SQL Clusters. Roll-up, roll-up! Come and see :- The horrifying “Shrunken Head”, the stomach turning “Bearded Lady”, the incredible “Many-Headed Cluster”, the mystifying “Marie Celeste”, the unbelievable “Zombie”, the doom ridden “Installation of Death”, the nightmare inducing “Bodysnatcher”, the malevolent “Montezuma’s Revenge” …and many more freakish exhibits and top tips from the field of SQL Server Failover Clustering!

Speaker(s):

  • Mark Broadbent

Track and Room: DBA - Santiago Dexeus


Title: Monitorizando SSISDB like a boss

Abstract: SQL Server 2012 trajo grandes cambios respecto a Integration Services, y con ellos nuevos retos. La monitorizaci#243;n de nuestros paquetes SSIS que se ejecutan en el servidor es una tarea habitual de todo profesional de BI que trabaje con la plataforma de Microsoft. Pero, #191;conocemos bien la estructura de esta nueva arquitectura? #191;C#243;mo podemos exprimirla y consultarla para tener una monitorizaci#243;n clara y eficiente? En esta sesi#243;n estudiaremos la estructura y veremos posibles soluciones para controlar nuestro servidor SSIS.

Speaker(s):

  • Pau Sempere

Track and Room: Business Intelligence - Santiago Dexeus


Title: Introducci#243;n a DAX, problema vs Soluci#243;n

Abstract: Cuando nos enfrentamos a la tarea de dise#241;ar modelos tabulares, ya sea con SSAS o PowerPivot, irremediablemente necesitamos emplear el lenguaje de expresiones DAX, tanto para consultar los modelos existentes, como para agregar funcionalidades mediante la creaci#243;n de columnas calculadas y medidas.

En esta sesi#243;n vamos a acercarnos a DAX, sus componentes y conceptos fundamentales. Vamos a demostrar su eficiencia en la soluci#243;n de problemas de modelado anal#237;tico y lo haremos desde Data Tools SSAS tabular, Power Pivot en Excel, DAX Studio y Power BI.

Speaker(s):

  • Ana Maria Bisbé York

Track and Room: Business Intelligence - Ramon y Cajal


Title: SQL Server Disaster Recovery Plan con Azure

Abstract: EL Plan de recuperaci#243;n ante desastres (DRP) es un elemento cr#237;tico que deber#237;a existir en cualquier entorno de cualquier compa#241;ia , pues sin este no est#225; garantizada la continuidad del negocio.

En esta sesi#243;n, repleta de demos, hablaremos de la importancia del DRP, de los mecanismos y tecnolog#237;as que provee SQL Server para ello y de su integraci#243;n en la nube con las m#225;quinas virtuales de Azure en IaaS.

Speaker(s):

  • Enrique Puig

Track and Room: Cloud - Isaac Peral


Title: La lucha contra el “Dame mi fichero”

Abstract: El usuario quiere su fichero. Existen 100 formas mejoras de acceder a la informaci#243;n pero s#243;lo quieren su fichero de siempre, en su ruta de siempre para hacer… aquello que hagan con sus ficheros. Dado que el BI se har#225; con o sin nosotros, propondremos un conjunto de estrategias para hacer frente al “Dame mi fichero”, para cambiarlo o sortearlo y llevarlo a nuestro terreno. Tenemos a nuestro alcance tanto herramientas m#225;s puramente de BI, como la elaboraci#243;n de una capa sem#225;ntica de acceso a la los datos, consumo de datos desde Excel y otras aplicaciones, como temas de administraci#243;n (uso de FileTables con contenido indexado).

Speaker(s):

  • Alberto López Grande

Track and Room: Business Intelligence - Isaac Peral


Title: SQL Azure Database - Lecciones aprendidas desde las trincheras con V12

Abstract: Options such as the data partition, XML handling, FullText, contained databases, CLR integration, Elastic Database Pool, know the performance of the database using Query Data Store, etc . are, among others, the new options that have version V12. In this session I will show how you can implement them in an environment of SQL Azure Database and the principal issues found.

Speaker(s):

  • Jose Manuel Jurado Diaz

Track and Room: Cloud - Auditorium


Title: Troubleshooting de bloqueos en SQL Server

Abstract: Los bloqueos son unos indeseables; aparecen cuando les parece y son dif#237;ciles de detectar. Cuando crees que lo has resuelto, se manifiesta de otra forma. En esta sesi#243;n ver#225; qu#233; m#233;todos utilizar para detectar bloqueos a trav#233;s de ejemplos muy claros.

Speaker(s):

  • Eladio Rincon

Track and Room: DBA - Ramon y Cajal


Title: Bases de datos NoSQL en Azure

Abstract: Cada vez tienen mas presencia las bases de datos NoSQL en nuestras aplicaciones debido a que suelen ser bastante m#225;s escalables que las bases de datos relacionales. Microsoft no se ha quedado a tr#225;s y en la plataforma de Azure nos proporciona un mont#243;n de posibilidades para trabajar con este tipo de bases de datos NoSQL. En esta charla veremos las distintas posibilidades de bases de datos NoSQL que tenemos en Azure. Compararemos las posibilidades que nos ofrece cada una de ellas y en que escenarios son mas #250;tiles unas u otras.

Speaker(s):

  • Roberto Gonzalez

Track and Room: Cloud - Ramon y Cajal


Title: SolidQ - Think big, Move fast

Abstract: SolidQ Sponsor session

Speaker(s):

  • Ruben Pertusa Lopez

Track and Room: Sponsor Session - Ramon y Cajal


Title: Maintenance Plans ad Hoc

Abstract: Maintenance Plans for Beginners (but not only) | Each of experienced administrators used (to some extent) what is called Maintenance Plans - Plans of Conservation. During this session, I’d like to discuss what can be useful for us to provide functionality when we use them and what to look out for. Session at 200 times the forward-300, with the opening of the discussion.

Speaker(s):

  • Tobias Koprowski

Track and Room: DBA - Santiago Dexeus


Title: Sex, PowerBI and RockRoll

Abstract: Status: Approved Level: 200 Track: IT Pro, Business In this session you will see the new Microsoft Business Intelligence Platform: Power BI. We will we will make a tour around the platform and in particular see how it connects with other services (both Microsoft and third-party) to obtain data. After this general tour you will see a very particular demo, about how a very “peculiar” company solves its problems using the Power BI platform and then tell the reality of a company that sells condoms and wants to know where to offer their products best. Fun guaranteed!

Speaker(s):

  • Javier Menendez Pallo

Track and Room: Business Intelligence - Auditorium


Title: Hewlett Packard Enterprise - Arquitectura sin barreras para entornos SQL

Abstract: Hewlett Packard Enterprise Sponsor session

Speaker(s):

  • Ruben Pertusa Lopez

Track and Room: Sponsor Session - Auditorium


Title: Query Store in SQL Server 2016

Abstract: Query Store is a new feature that will be released with SQL Server 2016 that will allow to store history of execution plans of each query with his performance counters. It will allow more easily to fix some performance problems about query plan changes. Join me in this session, to take a look and talk about this new great feature that will change the way we can fix and troubleshoot performance tuning problems

Speaker(s):

  • Andre Batista

Track and Room: DBA - Santiago Dexeus


Title: Hazle la competencia a Netflix con tu propio Azure Machine Learning

Abstract: A lo largo de la sesi#243;n vamos a entrenar un modelo para crear un recomendador con Azure Machine Learning. Con esto, podr#225;s adaptarlo a tu propia web, as#237; como ofrecer una API al servicio que crees. A#241;adiendo nuevos datos, haremos un ejemplo de ciclo de vida, reentrenando el modelo “en el aire” con las API que nos proporciona Azure para C#. Los conocimientos para la charla, son b#225;sicos, puesto que iremos de 0 a Netflix.

Speaker(s):

  • Carlos Gonzalez

Track and Room: Big Data Analytics - Isaac Peral


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Alberto López Grande

Twitter: - @qwalgrande

LinkedIn: Alberto López Grande

Contact: http://qwalgrande.com/

Data Platform MVP, sqlpass.es coordination team. But before all that, I am DBA. I write the blog quot;Diario de un DBAquot; (http://qwalgrande.com).

I am currently Head of Structured Systems in Grupo Catalana Occidente. Working with SQL Server since 1998 in many areas (management, architecture, infrastructure, high availability, tunning, SSIS, SSAS, data quality,…).

Ruben Pertusa Lopez

Twitter: - @rpertusa

LinkedIn: Ruben Pertusa Lopez

Contact: http://www.sqlpass.es

Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.

Sergio Carrillo Vila

Twitter: - @scarrillovila

LinkedIn: Sergio Carrillo Vila

Sergio Carrillo trabaja ahora mismo en Samp;G Consulting en el departamento de Inteligencia de Negocio como Senior BI Developer. MCTS de Microsoft Dynamics AX 2009 y SQL Server, realiza labores de aruqitecto en Inteligencia de Negocio, alrededor la plataforma de datos de Microsoft. Es ingeniero inform#225;tico por la universidad de Alicante, en la que continua sus estudios de Postgrado

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Roberto Gonzalez

Ingeniero T#233;cnico en Inform#225;tica y Developer en Plainconcepts con m#225;s de 15 a#241;os de experiencia en el desarrollo de aplicaciones. MVP de Azure.

Rafael ansino lara

Twitter: - @ransino

LinkedIn: Rafael ansino lara

Contact: http://cronicasdeungeek.azurewebsites.net/

Colaborador habitual en las comunidades t#233;cnicas de Espa#241;a, con especial presencia en la Comunidad Office 365 de la que es co-fundador y forma parte del equipo que la dirige. Varios a#241;os participando como speaker y organizador de distintos eventos tecnol#243;gicos incluyendo los IT Camps en torno a tecnolog#237;as y plataformas Microsoft como Office 365, Project ,Visual Studio, SharePoint, Azure o Skype para Empresas.

Salvador Ramos

Twitter: - https://twitter.com/salvador_ramos

LinkedIn: Salvador Ramos

Contact: https://elfuturodelosdatos.com

Más de 20 años trabajando con datos y aportando soluciones con ellos. Microsoft MVP desde 2003. Visita mi blog https://elfuturodelosdatos.com

Te ayudo a destacar frente a la multitud, como ANALISTA DE DATOS especializado en #PowerBI. Aprenderás a:

  • Desarrollar un modelo de datos único
  • Mantener los informes actualizados siempre sin el más mínimo esfuerzo
  • Conseguir analizar mayor cantidad de información en menos tiempo y con mayor facilidad.

En definitiva, tomar decisiones rápidas y seguras basadas en datos.

Mark Broadbent

Twitter: - retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.

Ruben Pertusa Lopez

Twitter: - @rpertusa

LinkedIn: Ruben Pertusa Lopez

Contact: http://www.sqlpass.es

Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.

Ruben Pertusa Lopez

Twitter: - @rpertusa

LinkedIn: Ruben Pertusa Lopez

Contact: http://www.sqlpass.es

Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

Miguel Llorca

Twitter: - @mllorcag

LinkedIn: Miguel Llorca

Contact: http://msdynamics.es

Microsoft Business Solutions MVP. Enterprise Architect, Project Manager, Senior Consultant and Business Analyst, with experience of over 20 years. Technology Strategist and Speaker at industry events. Large background in Public Sector, performing and leading integration projects based on Microsoft technologies (Microsoft Exchange, Sharepoint, SQL Server, System Center, etc.). Also experienced with Azure platform and Office365, and passionate about all Microsoft technology.

Tobias Koprowski

Twitter: - @KoprowskiT

LinkedIn: Tobias Koprowski

Contact: http://koprowskit.eu/geek/

Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.

Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.

Traveler. Coffee Addicted.

Ruben Pertusa Lopez

Twitter: - @rpertusa

LinkedIn: Ruben Pertusa Lopez

Contact: http://www.sqlpass.es

Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.

Andre Batista

Twitter: - @klunkySQL

LinkedIn: Andre Batista

Contact: http://klunkysql.info/

Andre Batista, with academic path in the course of Electronics, Telecommunications and Computers ( ISEL - Lisbon ) is currently in Crossjoin Solutions working as SQL Server DBA, performing functions on the client PT (Portugal Telecom). He is interested in all areas related to SQL Server and particularly in architecture, implementation, maintenance and performance. He is a member of the Portuguese SQL Server User Group, SQLPort (http://www.sqlport.com) and also one of the founders of TUGA.

Enrique Bañuls

Twitter: - @enriquecatala

LinkedIn: Enrique Bañuls

Contact: http://www.enriquecatala.com/

Mentor en SolidQ, Microsoft SQL Server MVP, Ingeniero en inform#225;tica, Microsoft Certified Trainer (MCT) y MCSE. Centrado en el motor relacional SQL Server, tanto en la resoluci#243;n de problemas de rendimiento y escalabilidad en sistemas OLTP como la definici#243;n e implementaci#243;n de entornos de alta disponibilidad confiables, en donde ha llevado con #233;xito m#225;s de 100 proyectos en diversos pa#237;ses (EEUU, Holanda, M#233;xico, Arabia Saud#237; o Austria)

Juan Manuel Servera Bondroit

Twitter: - @jmservera

Contact: http://jmservera.com

Passionated about IoT with more than 15 years experience as full stack developer, now technical evangelist at Microsoft

Ana Maria Bisbé York

Twitter: - @ambynet

LinkedIn: Ana Maria Bisbé York

Contact: http://amby.net/

Partner Microsoft en Power BI. Influencer en Pragmatic Works. Lic. en Cibernetica Economica con Master en Ciencias Economicas, Moscu; 1988. Master en Gestion del Conocimiento y Business Intelligence con tecnologia Microsoft(MS), y Master en Tecnologias de Desarrollo de MS. Colaboro activamente en grupos de usuarios de MS Visual FoxPro. Mantiene un blog personal. Actualmente es Consultora Business Intelligence con tecnologia MS, trabajando tanto en formacion como en proyectos. Ha sido ponente en eventos SQLSaturday, dentro y fuera de Espania, 24H SQL, IT Woman y Encuentros en Microsoft Espania.

Javier Menendez Pallo

Twitter: - JavierPallo

LinkedIn: Javier Menendez Pallo

I have over 23 years experience in technology, especially Microsoft. I have skills in Social Enterprise solutions based on SharePoint and Yammer, and BI on the Microsoft BI stack. I am PhD and during my career I have gained over 178 Microsoft certifications, MCSD, MCSE, MCITP, MCSA and more. I am a regular speaker at industry conferences, contributor to several publications such as CompartiMOSS (a leading SharePoint magazine). Experience as speaker: more than 150 sessions in the last 10 years

Regis Baccaro

Twitter: - @regbac

LinkedIn: Regis Baccaro

Contact: http://theblobfarm.wordpress.com

Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.

Miguel Egea

Twitter: - @miguelegea

Contact: http://www.portalsql.com

SQL Server MVP desde 2001 hasta la actualidad (con algunos años fuera del programa), trabaja como mentor en SolidQ en el departamento de BI. Es ponente habitual en eventos de comunidad de habla hispana. Apasionado de la tecnolog#237;a en general y de la relacionada con base de datos en particular.

Carlos Gonzalez

Twitter: - carlos_molotov

LinkedIn: Carlos Gonzalez

Contact: http://carlosis.me

Hola! Soy estudiante de ing. del Software en Madrid. Llevo programando desde los 14 a#241;os, empec#233; con robots y he ido pasando por casi todas las areas de este mundillo. Actualmente, trabajo como full stack developer, pero lo que de verdad me gusta es el mundo de los datos, haciendo an#225;lisis de los mismos y predicciones.

Eladio Rincon

Twitter: - @erincon

Contact: http://www.solidq.com/blogs

Eladio es MVP en SQL Server desde el a#241;o 2002; es director de bases de datos relacionales de SolidQ en Espa#241;a donde dirige proyectos para clientes de SolidQ en todo el mundo. Ponente habitual en conferencias Microsoft MSDN/TechNet, SQLPASS o grupos de usuarios; participa con sus compa#241;eros en los blogs tecnol#243;gicos de su empresa http://blogs.solidq.com/bigdata-hadoop , http://blogs.solidq.com/elrincondeldba y http://blogs.solidq.com/bigdata-hadoop

Jose Manuel Jurado Diaz

Twitter: - jmjuradodiaz

LinkedIn: Jose Manuel Jurado Diaz

José Manuel Jurado currently works as SQL Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 20+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events such as SQLSaturday, SQL Nexus, SQLBits, Pass Summit, SQL Server Konferenze, TechReady, DotNetConference, and Azure BootCamp. In the past, he worked as Project Manager for large global retail company for more than 10 years developing projects using different Microsoft Technologies.

Pau Sempere

Contact: http://www.solidq.com

Pau Sempere S#225;nchez is a Computer Science graduate, working at SolidQ as Data Platform Architect and is member of PASS Spanish Group. He#39;s worked in BI and database projects for top companies in the world, in diverse areas as communications, insurance, retail, transport, banking and automotive. He has been presenting in many Microsoft and community events such as SQLSaturday Madrid and Barcelona, the 12 hours of SQL Server, SolidQ Summit or TechNet Webcasts, and teaching in the SolidQ Master for 6 years in a row

Francisco Soler Flores

Degree in Mathematics PhD. in Computer Science. Artificial Intelligence. Solution Manager Data Analytics at Altran Assistant Professor at Technical University of Madrid

Enrique Puig

Twitter: - @epuignouselles

Contact: http://www.sqlserverpasion.com

Enrique is a computer engineer specialized on SQL Server. With more than 8 years experience, he has been working for top leading worldwide companies and challenging projects. He has presented at the SQL Server 2008 R2, 2012 and 2014 Spanish launch event, TechNet Webcasts, PASS 24 hours LATAM, Microsoft Partner Program and SolidQ Summit. Nowadays he works at Microsoft as a SQL Server Premier Field Engineer.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page