Event Location:
Duoc Sede Antonio Varas
Antonio Varas 666, Providencia
Santiago, Región Metropolitana, Chile
Abstract:
In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.
Speaker(s): Benjamin Nevarez,
Abstract:
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker(s): Benjamin Nevarez,
Abstract:
In this session we will see practical exemples on how we can, at the same time, decrease the our code complexity, increase the performance and speed up our time developing. Come to learn how to create more legible, cleaner and faster code. Developer Track.
Speaker(s): Dhiego Piroto,
Abstract:
Es una preocupación latente en los científicos de datos el hecho de tener que administrar infraestructura que soporte las plataformas de Big Data mientras corren SQL en R. Amazon Athena es un servicio interactivo de queries que trabaja directamente con datos almacenados en Amazon S3 y hace fácil analizar datos usando SQL estándar sin la necesidad de administrar infraestructura. Integrando R con Amazon Athena les da a los científicos de datos una plataforma poderosa para la construcción de soluciones analíticas interactivas.
Speaker(s): Mauricio Muñoz,
Abstract:
Microsoft R Server Data Science world. The presentation provides advanced topics for data scientists who will be using of the product suit (R open, R Server and R client), an introduction to the R code and will help familiarizing with the R server interface.
Speaker(s): Adrian Fernandez,
Abstract:
Veremos alguna caracteristicas de SQL 2016 para DBA : Query Store , Live Query Statistics, Cambios en el proceso de Setup, Mejoras en AlwaysOn y Scope Database Setting. Asi como tambien los ultimos mejoras introducidas con el Service Pack 1
Speaker(s): Javier Villegas,
Abstract:
Los modelos de salud son una muy interesante área de aplicación del advanced analytics dado su impacto en la mejora de nuestras sociedades. Azure Machine Learning ofrece una excelente alternativa para este sector dado que no se requiere de hardware ni software para comenzar a aprovecharlo, además de tener amplias capacidades para conectarse con fuentes públicas de datos, muy útiles en modelos de healthcare como son la contaminación, hacinamiento, temperaturas, precipitaciones, etc.
Speaker(s): Patricio Cofre,
Abstract:
SQL Server 2016 ofrece la posibilidad de ejecutar código R en Transact SQL, eliminando la tradicional fricción entre el mundo de la gestión de datos y la gestión analítica, al poner todo sobre un mismo ambiente. Con esto, es posible aprovechar lo mejor de ambos lenguajes, sin tener el costo de traspaso de datos desde un ambiente a otro. La sesión constará con ejemplos prácticos, a través de los cuales se buscará mostrar las ventajas de esta nueva característica de SQL Server 2016.
Speaker(s): Patricio Cofre,
Abstract:
En esta sesión veremos las herramientas y scripts disponibles para monitorear el desempeño y configuración de R Services por medio de DMV y Extended Events
Speaker(s): Eduardo Castro,
Abstract:
Introduccion a la Integracion de los Datos Queries Cross Plattform SQL Azure – SQL Server Excel – Google Analytics Utilizando un repositorio local como herramienta de integración Data Repository Compartido Migrando hacia una plataforma Microsoft Comparación de Estructuras Comparación de Datos
Speaker(s): Gustavo Boismoreau,
Abstract:
Monitoring: With any device, anywhere, Identify comsumpsion from MDX, Top SQLs Statements consumption detection, identifying fragmented indexes Analyzing: BI Users that consumes resources, also locks and blocks detections and actions to avoid this Rewriting: SQL Codes - changing executing plan Migrations: database comparison, schema comparison and data comparison
Speaker(s): Gustavo Carneiro,
Abstract:
La idea es explicar la virtudes de pig y hive.
Speaker(s): Cristobal Ibarra,
Abstract:
Uso de Hadoop y Data Lake en Azure como herramientas para analytics y reportería avanzada.
Speaker(s): Nestor Campos,
Abstract:
HDinsight es la solución de Azure para proveer clusters Hadoop de manera fácil. Un interesante siguiente paso puesto a nuestra disposición es Data Lake Analytics, servicio que permite realizar procesamiento analítico de datos pagando por el poder de procesamiento utilizado (pay per job) y escalando fácilmente, sin tener que provisionar ni configurar la infraestructura que realiza el procesamiento además de otras excitantes características. Veremos Data Lake Analytics y U-SQL, un lenguaje simple y familiar, poderoso y extensible, para procesar nuestros datos.
Speaker(s): Marco Ramirez,
Abstract:
Este seminario de un día completo mostrará cómo optimizar las consultas de SQL Server y crear aplicaciones de alto rendimiento. Aprenderás sobre el funcionamiento interno del procesador de consultas para poder escribir mejores queries y proporcionar al procesador de consultas información de calidad que necesita para producir planes de ejecución eficientes. También obtendrá sugerencias para solucionar las consultas de rendimiento inferior. En la memoria OLTP. Se cubrirán también nuevas características de SQL Server 2014/2016.
Speaker(s): Benjamin Nevarez,
Abstract:
En esta sesión veremos la forma que podemos integrar el uso de leguaje R ejecutando dentro de clusters de Spark para lograr soluciones de análisis de datos, así como la creación de soluciones de Machine Learning escalables.
Speaker(s): Eduardo Castro,
Abstract:
Tip para mover los Dts y SSIS en la diferente versiones
Speaker(s): Carlos Farias,
Abstract:
Algunas recomendaciones para entornos de SQL Server productivos Recomendaciones para Entornos de SQL Server Productivos Index Rebuild update stats sp_configure tempdb model backup trace flags importantes
Speaker(s): Javier Villegas,
Abstract:
Mediante una presentación dinámica, dar a conocer no solo Power BI como capa front end del stack de Microsoft sino también integrar la herramienta a través de FLOW generando un flujo en vivo que compile información en tiempo real y la vaya cargando en BD de Azure.
Speaker(s): Gaston Cruz,
Abstract:
SQL Server 2018 (vNext) viene con diferentes mejoras y características nuevas para el mundo del BI y Analytics, así como para el mundo de las BD transaccionales. Dentro de las novedades hay mejoras en consultas "In-Memory", funciones de agregación con datos de texto (concatenación agrupada), nuevas funciones para datos string, accesos a datos bulk, etc. Discutiremos lo nuevo y veremos algunos ejemplos de SQL Server 2018 en acción.
Speaker(s): Kamal Valero,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://cl.linkedin.com/pub/marco-ram#237;rez-melcherts/14/775/b04
Marco es Ingeniero Civil Industrial en Computaci#243;n. Su carrera profesional lo ha llevado a desempe#241;arse como desarrollador de software, arquitecto de Software y en los #250;ltimos 4 a#241;os, como consultor en Inteligencia de Negocios en Metric Arts, en donde tambi#233;n ha desarrollado su pasi#243;n por la ense#241;anza, en temas de BI y tecnolog#237;a en general. Como consultor, ha tenido contacto con diversas tecnolog#237;as, entre las cuales SQL Server y sus tecnolog#237;as asociadas son las m#225;s importantes
LinkedIn: https://ar.linkedin.com/in/adrianfz
Adrián Fernández, especializado en bases de datos y analítica avanzada, graduado en tecnología Informática, postgraduado en Big Data y científico de datos I.T.B.A (Instituto Tecnológico Buenos Aires), cursando Magister Data Science UDD. Especialista de Soluciones Microsoft en plataforma de datos e Inteligencia Artificial. Scope: SQL Server, Azure Machine Learning, Cognitive Services, Business Intelligence, Power BI, Big Data, (Python / R / Julia / Scala). Data Science: experto Microsoft R Server (MRS), colaborando con proyectos de investigación avanzada como científico de datos y participando en discusiones de grupo Microsoft Data Scientist en la búsqueda de desarrollo de nuevos productos y resolución de casos de negocio.
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
LinkedIn: https://ar.linkedin.com/in/javiervillegas
Contact: http://sql-javier-villegas.blogspot.com.ar/
Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. Javier has more than 20 years working with SQL Server on every version from 6.5 to SQL Server 2019, Including SQL Azure Database and SQL Azure Managed Instance. His specialization is Administration, Performance Tuning and High Availability. He is a Microsoft MVP in Data Platform. Javier is a frequent speaker in conferences and events such as SQL Saturday , PASS Virtual Groups, 24 Hours SQL PASS , vOpen(NetConf), GroupBy and DataPlatformGeeks. @sqlargentina
LinkedIn: https://www.linkedin.com/in/gaston-cruz-01bb434b/
Contact: http://www.gastoncruz.com
Especialista en implementacion de soluciones en Inteligencia de Negocios, con pasion para disenar soluciones corporativas trabajando en equipos distribuidos. Microsoft Most Valuable Professional (MVP) in Data Platform. Business Intelligence (BI) - Consultorias Estrategicas BI Arquitectura Technology Feasibility Analysis Data Management /Governance Roadmap BI Program Management Data Quality Management and Analy Especializaciones: Business Intelligence Solution / Technical Architect , SSIS , SSRS ,SSAS, SQL Server 2008 R2, 2012 , 2014, Power BI, Power View, Office 365, SharePoint 2013, Power View, Power Pivot ,Power Query, Power Map Ultimas experiencias en tecnologias Microsoft: Power BI, Power View, Power Pivot, Power Qu
LinkedIn: https://cl.linkedin.com/in/pcofre
Contact: http://www.metricarts.com/noticias/
Microsoft Data Platform MVP Regional Director. PASS Chile User Group Leader. Master of Engineering Management, Northwestern University and Master of Engineering Sciences, Catholic University of Chile. He has developed and led projects of Analytics for various companies in Latam, mainly in the areas of financial services and retail. He has specialized in Data Warehousing, and Machine Learning. He is co-founder and CEO of Metric Arts. He is also lecturer at the Catholic University of Chile, University of Chile, Catholic University of Peru, Louisville University in Panama, INCAE Costa Rica and FIU in USA
Contact: http://ecastrom.blogspot.com
Eduardo Castro, Microsoft Data Platform MVP and PASS Board of Advisor for LATAM, is well known LATAM SQL Server Expert and focuses on architecture, Business Intelligence and Data Analytics, Eduardo has an specialization and master degree in Data Analysis and Big Data. I have been speaker at PASS Summit delivering session about R and Data Science. Eduardo Castro has presented in United States, Costa Rica, Colombia, Guatemala, Mexico, Panama, El Salvador and South Korea.
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
LinkedIn: https://cl.linkedin.com/in/pcofre
Contact: http://www.metricarts.com/noticias/
Microsoft Data Platform MVP Regional Director. PASS Chile User Group Leader. Master of Engineering Management, Northwestern University and Master of Engineering Sciences, Catholic University of Chile. He has developed and led projects of Analytics for various companies in Latam, mainly in the areas of financial services and retail. He has specialized in Data Warehousing, and Machine Learning. He is co-founder and CEO of Metric Arts. He is also lecturer at the Catholic University of Chile, University of Chile, Catholic University of Peru, Louisville University in Panama, INCAE Costa Rica and FIU in USA
LinkedIn: https://ar.linkedin.com/in/gboismoreau
Contact: http://www.toadworld.com
Ingeniero en Sistemas recibido en UTN con 22 años de experiencia en la profesión. Estudio un MBA en el IAE. Trabajo en compañías como IBM, Telefónica, Sky, Global Crossing y Dell. Se ha desempeñado como implementador, desarrollador, Project Manager, Gerente de Desarrollo y Gerente de IT. Actualmente gerencia el equipo latinoamericano de sales engineers de la linea de negocio information management en Quest.
LinkedIn: https://cl.linkedin.com/in/nescampos
Software Architect with experience in Cloud Computing with Azure and Big Data with Hadoop, Spark and MongoDB.
LinkedIn: https://ar.linkedin.com/in/javiervillegas
Contact: http://sql-javier-villegas.blogspot.com.ar/
Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. Javier has more than 20 years working with SQL Server on every version from 6.5 to SQL Server 2019, Including SQL Azure Database and SQL Azure Managed Instance. His specialization is Administration, Performance Tuning and High Availability. He is a Microsoft MVP in Data Platform. Javier is a frequent speaker in conferences and events such as SQL Saturday , PASS Virtual Groups, 24 Hours SQL PASS , vOpen(NetConf), GroupBy and DataPlatformGeeks. @sqlargentina
LinkedIn: https://ar.linkedin.com/in/javiervillegas
Contact: http://sql-javier-villegas.blogspot.com.ar/
Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. Javier has more than 20 years working with SQL Server on every version from 6.5 to SQL Server 2019, Including SQL Azure Database and SQL Azure Managed Instance. His specialization is Administration, Performance Tuning and High Availability. He is a Microsoft MVP in Data Platform. Javier is a frequent speaker in conferences and events such as SQL Saturday , PASS Virtual Groups, 24 Hours SQL PASS , vOpen(NetConf), GroupBy and DataPlatformGeeks. @sqlargentina
LinkedIn: https://cl.linkedin.com/pub/kamal-valero/5/790/28b
Gerente de Business Intelligence en Punto Ticket. Microsoft MVP en Data Platform
LinkedIn: https://br.linkedin.com/in/gcarneiro
Contact: http://@toad_brasil
Gustavo is the Strategic Solutions Consultant from Quest Software with 18+ years of IT technical and commercial experience. Previously was Dell End User Computing 3th party Software Consultant
Contact: http://chile.pass.org
Profesional con 10 años de experiencia en TI, en donde a desarrollado en la administracion de base de datos, gestion de proyecto y gestion de operaciones en las Tecnologías de la Información (accenture, sonda, eds) Transporte Marítimo/Portuario (CSAV, Hapag Lloyd) Retail (johnson) Banca (banco estado) Manufactura (CMPC S.a)
LinkedIn: https://www.linkedin.com/in/dhiego-piroto-1a990629
Contact: http://dhiegopiroto.wordpress.com/
MCITP SQL Server 2008 (ADM amp; DEV). Atua com tecnologias SQL Server a 6 anos. Atualmente #233; consultor de performance, com foco em tecnologias Microsoft. Dentro dos clientes atentidos destacam-se institui#231;#245;es financeiras (nacionais e internacionais) e empresas de varejo. Contribui com a revista SQL Magazine e #233; membro atuante na comunidade SQL Server BR.
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
Contact: http://ecastrom.blogspot.com
Eduardo Castro, Microsoft Data Platform MVP and PASS Board of Advisor for LATAM, is well known LATAM SQL Server Expert and focuses on architecture, Business Intelligence and Data Analytics, Eduardo has an specialization and master degree in Data Analysis and Big Data. I have been speaker at PASS Summit delivering session about R and Data Science. Eduardo Castro has presented in United States, Costa Rica, Colombia, Guatemala, Mexico, Panama, El Salvador and South Korea.
LinkedIn: http://www.linkedin.com/in/mauricio-munoz
More than 16 years of professional experience on Information Systems and Technology positions. Working experience and certifications on Information Security, Cloud, Middleware Integration, SoA, WebServices, Telecommunications Networking and Operating Systems. Currently helping customers to achieve business goals by using AWS Cloud architectures.
LinkedIn: https://cl.linkedin.com/in/cristobal-ibarra-4755b42a
Professional Profile Empathetic, proactive and with a strong knowledge profile in the area of information technology (IT). Highlighting the skills of analysis, design, management and evaluation of technology solutions in both software development and Business Intelligence. Objectives My goal is to belong to an organization where I can develop and enhance my skills, where I can contribute with my strengths (such as academic skills and experience) and provide all my knowledge to the management processes of the organization.
The following is a list of sponsors that helped fund the event.