Event Location:
Universidad Politécnica de Madrid Campus Sur - ETSI Sistemas Informáticos
Calle Alan Turing s/n
, ,
Abstract:
Data science can be hard to grasp, complex and big, but making data science easy to understand and bringing it closer to all who want to tackle this new emerging field is an important task in world of data. Exploring, extracting and finding hidden gems from data using statistical and mathematical methods, computer science and several different technologies is essentially what data science is doing. In practice this means, data science is an iterative process of harvesting data, managing and cleaning the data, performing analysis and and at the end interpreting, visualizing and using information that will bring insights to end-user, business people and making decisions much easier. We will focus on answering 5 simple questions. 1) is this weird? 2) is A better than B, respectively? 3) how much / many of this is needed? 4) this belong to group A? 5) what is next? Session we will look into technologies that can be tackled using SQL Server 2016 and ML Azure. Es una sesión con algunas demos prácticas que, aunque no es obligatorio, si que necesitarás un portatil si quieres ponerte manos en la masa. ¡No te lo olvides en casa!
Speaker(s): Tomaž Kaštrun,
Abstract:
Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life! - Why performance degradation in spite of maintenance jobs? - just one more database in the result set and the query runs really bad - why? - usage of literals is completely different from the usage of variables - why? - identical data types but the query runs in part perfect and in part bad... - your execution plan shows an INDEX SEEK - but the table will be scanned! - you get a query from the business which performs really bad but when you test it it runs pretty cool - why?
Speaker(s): Uwe Ricken,
Abstract:
Kubernetes es mas conocido por hacer despliegues de contenedores no dependientes del estado, pero tambien es capaz de manejar cargas de trabajo que dependen del estado, como las bases de datos. Con Kubernetes es muy facil tener aplicaciones que tengan alta disponibilidad y que los cambios se hagan de una forma transparente. Pero, ¿Podemos/Queremos tener estos beneficios para las bases de datos? ¿Que pasa con los servicios gestionados como Azure SQL? En esta sesion mi objetivo es introducirte al mundo de Kubernetes respecto al manejo de aplicaciones dependientes del estado y cuales son las opciones junto a los conceptos que existen en el ecosistema. Luego, a travez de una demostracion podras ver si te vale desplegar tu base de datos en Kubernetes, o no.
Speaker(s): Christian Melendez,
Abstract:
With the multitude of isolation levels, concurrency models, and specialist technologies available in SQL Server, it is no surprise that transaction throughput and correctness can be directly correlated to the ability and knowledge of the person that wrote the code. In this session, we will reveal how SQL Server concurrency and correctness often goes wrong, how we can avoid this, and how we can use our knowledge to design and develop for optimal server throughput for our applications and processes using tips and tricks gained from real-world scenarios. We will cover SQL Server’s traditional locking model, In-Memory OLTP, Columnstore, Delayed Durability, and many other technologies and techniques you can use to make your transactions more robust.
Speaker(s): Mark Broadbent,
Abstract:
Con la presión de los entornos Enterprise, las herramientas actuales como Visual Studio o PowerBI Desktop, se pueden llegar a quedar cortas a la hora de automatizar tareas de desarrollo de PowerBI y agilizar el análisis de rendimiento. Durante esta sesión trabajaremos con diferentes herramientas como DAX Studio, Tabular Editor y Vertipaq Analyzer para convertirnos en unos masters de PowerBI. Conocimiento que nos permitirá introducirnos en el mundo del Performance Tuning, mejorando el rendimiento de nuestras consultas DAX en PowerBI. Además, compartiremos ejemplos de casos prácticos y experiencias reales en entornos de gran volumen de datos.
Speaker(s): Ruben Pertusa Lopez,
Abstract:
¿Estás trabajando con una de estas tecnologías: SQL Server on Premise, Azure SQL Database, Azure Managed Instance, Azure SQL Database for MySQL, Azure SQL Database for PostgreSQL, SQL Server on Virtual Machine, Azure SQL Datawarehouse, Azure Billing, Power BI, SSAS, SSIS, SSRS, ML y Windows - .NET Developer y necesitas respuestas sobre cómo migrar, implementar, depurar, controlar, monitorizar o mejorar tu entorno o simplemente complentarte lo aprendido de las sesiones de los speakers? Si es así, pásate un rato por el Data Clinic Ask-The-Expert y pregunta gratis directamente a los ingenieros de Microsoft y varios Speakers sobre estos y otros temas. Estaremos encantados de poder ayudarte. Y No olvides traer tu portátil! Tendremos en el equipo: Ingenieros Microsoft en: * SQL Server on Premise y SQL Server on Virtual Machine: * Azure SQL Database, Azure Managed Instance, Azure SQL Database for MySQL, Azure SQL Database for PostgreSQL, SQL Server on Virtual Machine * Azure SQL
Speaker(s): Jose Manuel Jurado Diaz,
Abstract:
EVERY client I engage with is taught to RUN 3 SCRIPTS IMMEDIATELY, WITHOUT THOUGHT AND WITHOUT DELAY as soon as a performance problem is noted. I am exceptionally good at performance tuning and forensics, but I (nor anyone else out there) cannot get at the root cause of a problem without information about the occurrence. These scripts will give you said information, which is very often transient in nature! I could be putting myself out of work teaching stuff like this! :-D Es una sesión con algunas demos prácticas que, aunque no es obligatorio, si que necesitarás un portatil si quieres ponerte manos en la masa. ¡No te lo olvides en casa!
Speaker(s): Kevin Boles,
Abstract:
Azure Machine Learning service is Azure based service with provided on-prem Python SDK, that combines both worlds, cloud and on-prem, and brings data scientists ability to quickly prepare data, train and deploy machine learning models and consume the predictions. Azure ML service provides broader usage of cloud and improves the productivity, helps burden the knowledge scarcity, reduces costs and does auto-scaling. Azure ML Service embraces also many open-source python frameworks and packages, such as Scikit-Learn, TensorFlow, Pytorch and MXnet. In this session we will explore many of the service features, the ability to combine on-prem with cloud work (using notebooks), connecting to Kubernetes Service, Databricks and other features.
Speaker(s): Tomaž Kaštrun,
Abstract:
• ¿cómo dices que…MySQL, MariaDB y PostgreSQL también están en Azure como un servicio administrado y que Microsoft da soporte? • ¿qué tengo un SQL Server como un servicio administrado para mí y que puedo ajustarlo en base a mis necesidades y mi dinero? ¿ cómo ? En este Hand-On-Labs daremos un repaso a las posibilidades de estos 6 servicios administrados de que disponemos, cómo: • Si eres un loco del Open Source Database o si eres más de SQL Server en cualquiera de sus ediciones: o Revisaremos los 3 sabores existentes de SQL Server, Azure SQL Database, ServerLess y Managed Instance sus ventajas e inconvenientes. o Crearemos y configuraremos dando un repaso a todos los puntos más importantes de estas bases en Azure. o Migraremos nuestras bases de datos a Azure o Revisaremos las mejores prácticas para nuestras aplicaciones y conectividad. o Resolveremos tus preguntas y ya sabes, si tienes una base de datos te ayudamos a migrarla. Es una sesión con algunas demos prácticas que, aunque no es obligatorio, si que necesitarás un portatil si quieres ponerte manos en la masa. ¡No te lo olvides en casa!
Speaker(s): Jose Manuel Jurado Diaz,
Abstract:
We will present an end to end solution for aeroplane turbine predictive maintenance in the edge Moreover, the session will cover the following points: - Introduction to predictive maintenance - How to use Deep Learning and RNN to solve predictive maintenance problems - Machine Learning workflow for the solution proposed. We will provide all the details of our model's implementation and the technology used: Databricks, Python and Tensorflow o Data Pre-processing and Feature selection •Normalization o Model selection o Training Testing o Evaluation Metrics o Deployment of the model using a lightweight version of Tensorflow: TFLite. This provides the tools needed to deploy a lightweight model in the edge without compromising its accuracy. - Development of different IoT edge modules and how to deploy them in a RaspberryPi o Sensor engine module o Predictive module for ARM32 Arch - How to send telemetry to the Cloud - Analytics BI: Data Visualization with PowerBI
Speaker(s): Rodrigo Cabello,
Abstract:
En este workshop de Azure Databricks veremos de forma práctica todos los pasos a seguir para crear una solución de IA con la idea de facilitar la comprensión de este servicio basado en Spark. También veremos cómo se integra con otros servicios de Azure necesarios para construir una solución completa. Constará de dos partes fundamentales: Adquisición de datos y creación del "data pipeline" necesario para el correcto procesamiento de los modelos. Creación y entrenamiento de los modelos desde Azure Databricks sobre Azure ML y despliegue de los más adecuados como API REST en un contenedor Docker. Es una sesión con algunas demos prácticas que, aunque no es obligatorio, si que necesitarás un portatil si quieres ponerte manos en la masa. ¡No te lo olvides en casa!
Speaker(s): Alberto Diaz Martin,
Abstract:
Microsoft's services in Azure helps us to leverage big data more easily and even more often accessible for non-technical users. Having UI in ADF version 2 - Microsoft added a new feature: Mapping Data Flow which resembles components of SSIS. This is a very user-friendly and non-code approach tool-set. But, has that been only UI introduction? Why and how Databricks does work under the hood? Do you want to know this new feature of ADF and reveal the power of modern big data processes without knowledge of such languages like Python or Scala? We will review this new feature of ADFv2, do deep dive to understand the mentioned techniques, compare them to SSIS and/or T-SQL and learn how modelled data flow runs Scala behind the scenes.
Speaker(s): Kamil Nowinski,
Abstract:
Taller de Robótica: Desafía tu mente ¿Cuántas operaciones puedes hacer seguidas?¿Superarás a tus amigos? Construye desde zero y programa tu consola de cálculo mental con Makecode y las placas Micro:bit. Desafía a tus amigos y supérales con este divertido juego. ¿te apuntas? Importante: - Esta actividad esta incluida de manera gratuita dentro del SQLSaturday Madrid 2019 bajo registro previo, para niñ@s entre 8 y 13 años. El taller incluirá un pequeño catering adaptado a los mas pequeños. - Para asistir, se requiere un registro extra en el siguiente formulario https://forms.gle/HNtbw7qpe9BGaUv26 - Es necesario traer un portátil para realizar la actividad. El resto de materiales del taller se dispondrán de manera gratuita. - El horario del taller es de 10:30h a 13:45h del Sábado 28 de Septiembre en el mismo recinto que el SQLSaturday Madrid 2019. Habrá un descanso de 45 minutos, de 11:15h a 12:00h que coincide con el descanso del café, para permitir a los tutores legales acompañar a los menores durante el descanso. - Tanto la entrada como la salida siempre se tiene que hacer con el tutor legal. El tutor legal deberá estar puntal en la recogida. - El taller estará impartido por dos profesionales cualificados de la empresa Possible (http://espossible.es/ ), organizadores habituales de los talleres en Microsoft. - Si tienes más dudas sobre el taller, puedes contactar Alba Rodriguez (lab@espossible.com), Directora Educativa de Possible Lab. - El taller esta limitado a un máximo de 30 niñ@s. Se confirmará el registro via email una vez rellenado el formulario.
Speaker(s): Ruben Pertusa Lopez,
Abstract:
As announced in September 2018, SQL Server 2019 expands the "adaptive query processing" features of SQL 2017 and relabels them as "intelligent query processing". This name now covers many features, such as batch mode on rowstore, memory grant feedback, interleaved execution, adaptive joins, deferred compilation, and approximate query processing. In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.
Speaker(s): Hugo Kornelis,
Abstract:
AI@Scale is a change and adoption approach to become an AI driven organisation. In this session we will speak about how develop and embed in your organisation the needed AI capabilities on people, process, data and technology to repeatedly bring data AI scenarios successfully from first idea and experiment to full and organisation-wide business adoption and value. No more Proof of Concepts or zero-sum MVPs. We will also explain how to apply concepts like DevOps for AI, Data governance, AI Center of Excellence, AI-driven culture ethics, AI champions and AI community.
Speaker(s): Pablo Peris,
Abstract:
Join this session to find out about the latest Azure SQL security innovations and learn about new customer scenarios and opportunities which the new security technologies unlock. You will get the first-hand look at the new cutting-edge capabilities in network security, authentication, data encryption, security management, and other areas that enable business-critical applications handling financial, healthcare, government and other sensitive data even better than before.
Speaker(s): Andreas Wolter,
Abstract:
Tus clientes son tus amigos, y a los amigos hay que tenerlos siempre cerca. Para evitar que se vayan de tu lado y seguir construyendo una preciosa amistad, ven a esta sesión en la que revisaremos el concepto de "churn" o abandono de clientes, qué lo define y cómo podemos atacar el problema usando técnicas de Machine Learning con Python y scikit-learn.
Speaker(s): Pau Sempere,
Abstract:
On PASS Summit 2017 Microsoft revealed a new tool for managing and developing SQL Server: Azure Data Studio. In his demo packed session German Data Platform MVP Frank Geisler will show how to use SQL Operations Studio, what is new compared with SQL Server Management Studio and he will show what capabilites this tool has not only to develop SQL Server Solutions but also how to monitor a SQL Server with Azure Data Studio. By the way: One of the biggest advantages is that Azure Data Studio is not only available for Windows but also for Mac and for Linux.
Speaker(s): Frank Geisler,
Abstract:
If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.
Speaker(s): Kevin Boles,
Abstract:
Una sesión para conocer, de una forma práctica, como modelar datos NOSQL en Azure Cosmos DB, con el objetivo de optimizar consultas y el consumo de RUs.
Speaker(s): Alberto Diaz Martin,
Abstract:
La interfaz de Power BI Desktop nos permite hacer potentes modelos de datos a base de clicks. Pero existen casos en los que esto no es suficiente y acabamos haciendo monstruosas metricas DAX para solucionar problemas que simplemente se podrían modelar de manera diferente. Hablaremos de patrones para medidas semiaditivas como el Stock. Nos pelearemos con el Distinct Count, y nos divertiremos con las relaciones Many to Many. Todo esto y más, en una sesión cargada de experiencias personales en proyectos reales con modelos gigantescos de datos.
Speaker(s): Ruben Pertusa Lopez,
Abstract:
¿Has tenido problemas a definir tus particiones de datos con SQL Api de Cosmos DB? . En muchos casos hacer JOINS entre particiones, y optimizar nuestras consultas se hace complicado. Veremos como trabajar con Cosmos DB Changes Feed y optimizar nuestras consultas y particiones.
Speaker(s): Sergio Hernandez Mancebo,
Abstract:
Power BI is an amazing BI platform out of the box, but there’ is a lot of things that you can do with Power BI that probably you don’t even imagine! Come to my session to find out….
Speaker(s): Rui Romano,
Abstract:
Do you want to access data from a REST API with Power BI? Willing to know more about data connectors and the Power Query M language? Welcome on board! This session will show you, with a real use-case, what’s a data connector and how to build it. Starting with the definition of a function, going through authorization and finally packaging the whole is a nice journey that we’ll follow during the next 60 minutes.
Speaker(s): Cédric Charlier,
Abstract:
El proceso de extracción, transformación, limpieza, preparación y carga de datos es muy importante para los modelos analíticos. La sesión analiza un conjunto de escenarios que quedan resueltos en esta etapa y no pasan como tareas al modelado tabular de Power BI. El lenguaje M ofrece una gran cantidad de oportunidades que se exponen en esta sesión.
Speaker(s): Ana Maria Bisbé York,
Abstract:
Estamos en un mundo de cambios continuos, los negocios y las herramientas evolucionan a gran velocidad, ¡Power BI tiene actualizaciones mensuales!. ¿En tu empresa tienen tecnologías actualizadas, pero las personas siguen con la misma mentalidad y métodos de hace años? Tienes un problema. En esta sesión te propongo las soluciones que estoy aplicando con éxito.
Speaker(s): Salvador Ramos,
Abstract:
¿Has oido hablar de Snowflake? Pero no del tradicional esquema de BI, sino de un producto que está rompiendo moldes en el mercado del DWH con una arquitectura puro cloud (100%, sin medias tintas) y unas funcionalidades que obligan a repensar la forma en la que se encaran este tipo de proyectos. ¿Qué es lo que le hace tan diferente? ¿Por qué merece la pena conocerle? En esta sesión trataremos de dar unas pinceladas que te hagan despertar la misma curiosidad que nos despertó a nosotros cuando lo vimos por primera vez. Que no te pase que cuando alguien te hable de Snowflake tú no sepas de qué están hablando
Speaker(s): Carlos Sacristán,
Abstract:
TBD
Speaker(s): Carlos Sacristán,
Abstract:
The goal of this workshop is to learn the potential of the PowerPlatform and its use cases, specifically you will learn how to use Power Apps to update the budget and visualize the update in realtime in a Power BI report. Es una sesión con algunas demos prácticas que, aunque no es obligatorio, si que necesitarás un portatil si quieres ponerte manos en la masa. ¡No te lo olvides en casa!
Speaker(s): Rui Romano,
Abstract:
Solo llevamos dos años en el mercado como empresa de consultoría IT, pero detrás de Aura está un grupo de consultores expertos, con más de 20 años de trayectoria en diferentes empresas de referencia en el entorno Microsoft. Pensarás: una compañía más. Si crees que todas las empresas priman la cooperación frente a la competición, facilitan una conciliación real y apuestan por la formación continua, entonces no tenemos nada más que contarte. De lo contrario, acércate a conocernos. Ponente: Gianluca Risi
Speaker(s): Ruben Pertusa Lopez,
Abstract:
SQL Server 2019 tiene novedades muy in teresantes en el motor relacional. Esta versión Microsoft ha puesto el foco en el auto-tuning, implementando features que llevamos años esperando como el inlining de funciones real, drásticos cambios de funcionamiento a nivel BATCH MODE,...En definitiva, no te puedes perder esta sesión donde vamos a ver cómo esta edición de SQL Server es la que mayor nº de cambios ha tenido en el motor desde la aparición de SQL Server 2014 con el motor In-Memory OLTP
Speaker(s): Enrique Bañuls,
Abstract:
Do you remember when in films humans are taken care of medical robots? Well, we are not yet there but we will be in time. AI is getting increasingly sophisticated at what humans do but depending on the area they can be more efficient. In addition, thanks to the NLP techniques the AI is getting better in understanding humans. So, in this talk an application of AI is presented for helping the diagnosis of rare diseases and helping doctors to making decisions in their treatments. In addition, the application is going to be taken to cloud in order to get accessible for any doctor to request it and help them to make a more accurate diagnosis.
Speaker(s): Eduardo Matallanas,
Abstract:
En esta charla de patrocinador Plain Concepts dará a conocer quiénes son. Actualmente, como empresa del sector tecnológico, está enfocada en las últimas tecnologías y se centra sobre todo en el desarrollo de proyectos relacionados con la Realidad Virtual y Aumentada, Big data e IA. Por ello en esta charla daremos a conocer algunos de nuestros proyectos más impactantes y hablaremos cómo se lo pasan los Plain Piggies dentro de una empresa que apuesta por las personas. Además, al final de la charla podrás participar en un Kahoot donde podrás llevarte un maravilloso premio sólo por asistir. ¡¡¡No te lo pierdas y ven a descubrir a Plain Concepts!!!
Speaker(s): Eduardo Matallanas,
Abstract:
La confianza en una solución se gana en mucho tiempo y se pierde en dos bugs... o menos. ¿que tal si generamos pruebas que nos avisen de los errores e informamos del nivel de confianza en los datos en cada ejecución? Quizá de esa manera, mientras se estabilizan las plataformas no perderemos esa confianza. Ven al taller y descubre que son los test anidados, test de negocio en el mundo del BI y llevate de paso una aplicación lista para instalar que te permitirá ejecutar fácilmente esos test.
Speaker(s): Miguel Egea,
Abstract:
"Habría que echar todo esto abajo y empezar de cero para hacerlo bien. Pero eso es imposible." ¿Os suena ese mantra? Logra modernizar tu sistema de información sin mover los datos de donde estén ni cambiar las aplicaciones, virtualizando la información, generando el nuevo modelo que te permita crecer y construyendo la plataforma de futuro que necesitas. Sin resistencia al cambio, ¡porque no hay cambio! (o eso les haremos creer). En esta sesión hablaremos de las grandes ventajas que plantea la virtualización, incluso son SQL Server 2019 (pero sin ser la única alternativa). Virtualiza... Conecta...
Speaker(s): Alberto López Grande,
Abstract:
Query store feature was presented in SQL Server 2016 to provide insights on query performance and simplify troubleshooting. This feature might be enough for small enterprise environments, but When managing hundreds of instances requiring top performance and zero down-time - it requires going an extra mile. In this session we'll present how at ChannelAdvisor we leverage the power of query store feature into a central store - proactively improving performance on an on-going basis.
Speaker(s): Efraim Sharon,
Abstract:
Learn how you can query your PowerBI models from Alexa, Google Assistant, and integrate it with Microsoft Teams for assisting the need of information from different channels.
Speaker(s): Fran Mercado,
Abstract:
It seems like Artificial Intelligence and Machine Learning are a must nowdays. For projects carrying a simple or well kown problem we can find a lot of ready-made solutions, but this extremne easy to use could be one of our best enemy when facing with specific custom problems. With this session we will cover how to apply best practices in configurin ML but much more, do we reaaly need it always? The second part will cover vulnerabilities of ML discovering how easy could be to fool a neural network by some techinques (Like pixel attack) and their implication in projects that requires no security issues.
Speaker(s): Sebastiano Galazzo,
Abstract:
En esta sesión se tratará cuales son las implicaciones de mantener entornos SQL Server 2008 y lo que nos aporta Azure SQL Managed Instance. También se abordará algunos aspectos en la configuración inicial de una Managed Instance y algunos tips encontrados durante su puesta en marcha
Speaker(s): Fran Lens,
Abstract:
Aunque la entrada de información de un modelo de Power BI suele ser una base de datos o un proceso local, PowerQuery está preparado para analizar información procedente de la Web, pudiendo usar APIs web como orígenes de datos para nuestros modelos. En esta charla veremos las distintas maneras que presenta Power BI para conectarse a datos en Internet, y veremos ejemplos con Twitter y Azure.
Speaker(s): Ernesto Luis Bisbé,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/tomaz.kastrun
Contact: http://www.tomaztsql.wordpress.com
Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.
LinkedIn: https://www.linkedin.com/in/alberto-l%C3%B3pez-grande-b756aa9/
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,...).
LinkedIn: https://es.linkedin.com/in/albertodiazmartin
Contact: http://blogs.encamina.com/negocios-sharepoint/
A professional with 15 years of experience in the IT Industry, all of them working with Microsoft Technologies. His principal activities are Development and Solution Analysts on his first years and as Team Leader and Solution Architect on the last 6 years. Currently Chief Technology Innovation Officer in ENCAMINA, leading Microsoft technology software development and member of the management board. For the Spanish Community, he works as organizer and speaker in the most important Microsoft technologies conferences which he is one of the most important leaders. Author of several books and articles in professional magazine, from 2013 he began a new career as co-director of CompartiMOSS, a Microsoft technologies magazine.
LinkedIn: https://www.linkedin.com/in/matallanas/
AI Lead en Plain Concepts. Emocionado por las nuevas tecnologías, la robótica y la inteligencia artificial. Tanto me apasiona que hice un doctorado en la Universidad Politécnica de Madrid en estos temas. Así que, llevo trabajando en este campo desde hace 9 años tanto en el ámbito universitario como en el empresarial. Entre los proyectos en los que he estado trabajando, he estado desarrollando redes neuronales para análisis de señales, procesamiento de imagen, procesamiento del lenguaje natural, chatbots, asistentes virtuales, etc. Desde que me incorporé a Plain Concepts me encargo de todos los proyectos relacionados con inteligencia artificial. A parte del software, disfruto mucho del ciclismo, escuchar música y leer.
LinkedIn: https://pt.linkedin.com/in/ruiromano
Contact: http://ruiromanoblog.wordpress.com/
Rui Romano lives in Portugal and he leads the Business Intelligence team at DevScope. He has been Developing amp; Architecting software solutions since 2003 always focused in the Business Intelligence area.
LinkedIn: http://nl.linkedin.com/in/hugokornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of "the Execution Plan Reference" (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey's "SQL Server Execution Plans, 3rd edition" and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present). When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background. When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
LinkedIn: https://www.linkedin.com/in/elbisbe/
Contact: https://mas140blog.wordpress.com/
95% Graduado de Ingeniería de Telecomunicaciones en UAM, Madrid. Apasionado de la tecnología, programación y servicios de comunicación, especializado en tratamiento y procesado de imágenes y señal. Aficionado del BI con un énfasis en visualización y modelados analíticos Actualmente becario en Telefónica de España.
LinkedIn: https://pt.linkedin.com/in/ruiromano
Contact: http://ruiromanoblog.wordpress.com/
Rui Romano lives in Portugal and he leads the Business Intelligence team at DevScope. He has been Developing amp; Architecting software solutions since 2003 always focused in the Business Intelligence area.
LinkedIn: http://www.linkedin.com/in/andreaswolter
Contact: http://www.andreas-wolter.com/blog/
Andreas Wolter is a Program Manager for SQL Server- and Azure Security at Microsoft. In this role he is working on Security features of SQL Server, Azure SQL Database and Managed Instance. He is currently focusing on “Separation of Duties”-concepts and RBAC-Integration. He has 18 years of experience with SQL Server before joining Microsoft and is the founder of Sarpedon Quality Lab, the Germany-based company specialized on SQL Server HA, Performance and Security. He is Microsoft Certified Master (MCM) for SQL Server and Microsoft Certified Solutions Master for the Data Platform (MCSM) and was recognized as MVP for multiple years in row.
LinkedIn: https://www.linkedin.com/in/kamilnowinski/
Contact: https://sqlplayer.net
Blogger, speaker, #sqlfamily member. Microsoft Data Platform MVP. Data passionate, Data engineer and Architect. Over 13 years of programming and experience with SQL Server databases, he worked both as developer and administrator big databases designing systems from the scratch. Passionate about tuning database engines, code transparency and maximising performance database engine. Currently, he is expanding new horizons as a contractor in the UK market, making troubleshooting, prototyping BI and Big Data solutions, enhancing existing processes among Microsoft stuff environments, popularizing the DevOps approach and efficient solutions in the cloud. An originator of the "Ask SQL Family" podcast and founder of SQLPlayer blog.
LinkedIn: http://www.linkedin.com/pub/ruben-pertusa-lopez/24/ba3/b0
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.
LinkedIn: https://www.linkedin.com/in/franmercado/
Data Visualization, BI and Analytics passionate. Combining cross-functional analysis with technical skills to deliver cost effective value to clients. Always looking for innovation, process automating and lean management to implement analytics solutions that provide the unlock of business insights. MCSE Business Intelligence
LinkedIn: https://es.linkedin.com/in/albertodiazmartin
Contact: http://blogs.encamina.com/negocios-sharepoint/
A professional with 15 years of experience in the IT Industry, all of them working with Microsoft Technologies. His principal activities are Development and Solution Analysts on his first years and as Team Leader and Solution Architect on the last 6 years. Currently Chief Technology Innovation Officer in ENCAMINA, leading Microsoft technology software development and member of the management board. For the Spanish Community, he works as organizer and speaker in the most important Microsoft technologies conferences which he is one of the most important leaders. Author of several books and articles in professional magazine, from 2013 he began a new career as co-director of CompartiMOSS, a Microsoft technologies magazine.
LinkedIn: http://be.linkedin.com/in/cedriccharlier
Contact: http://seddryck.wordpress.com
Cédric is a talented architect and Data Platform MVP active in the domain of Business Intelligence and Data warehousing. He has more than 10 years of successful experiences with SQL Server in European industrial groups and services companies. Driven by quality and reliability, he is the main developer of an open-source solution for testing BI solutions (cubes, etl, reports) named NBi (www.nbi.io). Cedric also advocates for the introduction and general usage of agile practices in BI’s world.
LinkedIn: https://www.linkedin.com/in/pabloperis/
Pablo Peris works for Microsoft as Digital Advisor In the manufacturing and utilities sector. He studied Computer Engineering and holds a master’s degree in Information Systems Management. Pablo has several years’ experience leading International IoT projects. Before joining Microsoft, he was 4 years in England as managing Director of a technology consultancy. Previously he was an analyst/programmer, a university professor and founded his own startup in 2007. With more than 16 years of experience in the sector his current mission is to help companies finally become data driven for real.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: https://www.linkedin.com/in/csacristan/
Data Geek. Creo que estas dos palabras es lo que mejor me definen. Que luego esto se aplique en el "mundo real" en trabajar con bases de datos relacionales, multidimensionales, nosql, big data, machine learning o cosas así es lo de menos. Pero eso sí, SQL Server siempre será mi favorito. No lo puedo evitar. Me tiene ganado.
LinkedIn: https://www.linkedin.com/in/rodrigocabello/
AI Team Lead at Plain Concepts and Microsoft MVP in Artificial Intelligence with more than 10 years of experience in web application development. Passionate about new technologies and applications that use techniques based on Artificial Intelligence.
LinkedIn: https://www.linkedin.com/profile/view?id=4839367
Contact: http://www.gdsbi.de
Frank Geisler is owner and CEO of GDS Business Intelligence GmbH. He is SQL Server MVP, MCT, MCSE – Business Intelligence, MCSE – Data Plattform and MCSE - Azure Solutions Architect. In his Job he is building Business Intelligence Systems based on Microsoft Technology, mainly on SQL Server and SharePoint.
LinkedIn: https://www.linkedin.com/in/csacristan/
Data Geek. Creo que estas dos palabras es lo que mejor me definen. Que luego esto se aplique en el "mundo real" en trabajar con bases de datos relacionales, multidimensionales, nosql, big data, machine learning o cosas así es lo de menos. Pero eso sí, SQL Server siempre será mi favorito. No lo puedo evitar. Me tiene ganado.
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 SQL Saturday 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
LinkedIn: https://www.linkedin.com/in/franlens/
Contact: https://aleson-itc.com/author/fran-lens/
Consultor SQL Server con 10 años de experiencia, MCSE Data Platform, con conocimientos de toda la herramienta y enfocado principalmente a la detección y mejora de problemas de rendimiento en Base de Datos. Entusiasta de la fotografía de lugares abandonados.
LinkedIn: http://www.linkedin.com/in/retracement
Contact: http://tenbulls.co.uk
Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK's SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.
Microsoft Azure MVP Ingeniero informatico por la universiad complutense de madrid, con amplia experiencia liderando proyectos .Net. Muy especializado en proyectos basados sobre Sharepoint, BI y desarrollo Web. Adem#225;s soy un activo colaborador con la comunidad escribiendo en blogs y publicando art#237;culos en la revista Compartimoss.
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: https://www.linkedin.com/in/matallanas/
AI Lead en Plain Concepts. Emocionado por las nuevas tecnologías, la robótica y la inteligencia artificial. Tanto me apasiona que hice un doctorado en la Universidad Politécnica de Madrid en estos temas. Así que, llevo trabajando en este campo desde hace 9 años tanto en el ámbito universitario como en el empresarial. Entre los proyectos en los que he estado trabajando, he estado desarrollando redes neuronales para análisis de señales, procesamiento de imagen, procesamiento del lenguaje natural, chatbots, asistentes virtuales, etc. Desde que me incorporé a Plain Concepts me encargo de todos los proyectos relacionados con inteligencia artificial. A parte del software, disfruto mucho del ciclismo, escuchar música y leer.
LinkedIn: http://www.linkedin.com/pub/ruben-pertusa-lopez/24/ba3/b0
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.
LinkedIn: http://www.linkedin.com/pub/ruben-pertusa-lopez/24/ba3/b0
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.
LinkedIn: https://it.linkedin.com/in/sebastianogalazzo
Passionate about Artificial Intelligence, Sebastiano @galazzoseba brings over 15 years of experience in AI and machine learning to his current position as CTO at Sistem-EVO srl. Sebastiano has dedicated the last few years to designing and developing algorithms to tackle the challenges of Natural Language Processing, image recognition and predictive analysis through machine learning. He is a Microsoft MVP and his work in AI has gained commendation in numerous publications and has received several national and international awards.
LinkedIn: https://www.linkedin.com/in/efraim-sharon-ab6ab433
Database Engineer / Application Developer / Oracle RDBMS Microsoft SQL Server Expert / Data Science passionate with experience in both SQL and NoSQL technologies. With over 12 years of working in the IT industry I tend to bring fresh perspectives for data management and utilization. I believe my most valuable skill is queries optimization.
LinkedIn: https://www.linkedin.com/in/jose-manuel-jurado-diaz-5a586014/
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.
LinkedIn: https://www.linkedin.com/in/ambynet
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 SQL Saturday, dentro y fuera de Espania, 24H SQL, IT Woman y Encuentros en Microsoft Espania.
LinkedIn: http://www.linkedin.com/pub/ruben-pertusa-lopez/24/ba3/b0
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.
LinkedIn: https://linkedin.com/in/SalvadorRamos
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.
LinkedIn: http://www.linkedin.com/in/enriquecatala
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)
LinkedIn: http://www.linkedin.com/tomaz.kastrun
Contact: http://www.tomaztsql.wordpress.com
Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.
LinkedIn: http://www.linkedin.com/profile/view?id=270775013amp;trk=tab_pro
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
LinkedIn: https://gt.linkedin.com/in/christian-melendez-6174454a
Contact: http://cmelendeztech.com/
Christian has been in the industry for more than fourteen years now. He started to get interested in software development at school when he was 15 years old. In 2013, he made the switch from developing software to managing infrastructure on the cloud. He helped his employer as they were spending too much money and having too many problems when releasing software. He was able to use his skills as a developer in a different context: infrastructure. Christian is now helping customers in their onboard journey to the cloud with the help of agile practices, DevOps culture adoption, and modern tools and technologies like containers, cloud, and serverless.
LinkedIn: https://www.linkedin.com/in/jose-manuel-jurado-diaz-5a586014/
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.
The following is a list of sponsors that helped fund the event.
Universidad Politecnica de Madrid
Kabel Sistemas de Información S.L.