SQLSaturday #751 - Santiago 2018

Event Date: 05/26/2018 00:00:00

Event Location:

Duoc Sede Antonio Varas
Antonio Varas 666, Providencia
Santiago, Región Metropolitana, Chile

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: SQL Server Query Tuning and Optimization

Abstract: El Práctico de SQL Server es un seminario de día completo en que con teoría y ejemplos prácticos se tratan distintas materias y técnicas que te permitirán analizar y mejorar el desempeño de tus consultas SQL Server 2008 y versiones posteriores.

El desempeño de una consulta depende de distintos factores, entre los cuales están algunas configuraciones del servidor, los índices que utilizamos y su mantención, cómo escribimos nuestras consultas, y cómo utilizamos los recursos que SQL Server pone a nuestra disposición, tales como tablas en memoria (Hekaton) para cargas OLTP o índices columnstore, para consultas de tipo analítico. Los temas son:

Configurando SQL Server para performance Principales Índices para performance Interpretando planes de ejecución Cómo hacer buenas queries Acelerando OLTP con tablas en memoria

Speaker(s):

Kamal Valero

Track and Room: Databases - Auditorio

Title: Encontrando el origen del problema

Abstract: ¿Recibiste una llamada a medianoche por inconvenientes de performance? O peor aún, recibes en la madrugada un correo de alerta de errores pero lo lees recién al día siguiente y la evidencia desapareció. Muchas veces no recibes la notificación en el momento preciso en que el problema sucede y te enteras después de que el proceso fue ejecutado otra vez o después de que falló.

Necesitas saber qué pasó y evitar que el mismo error suceda otra vez. Como un DBA de Producción o como Desarrollador, es importante conocer qué buscar cuando pasan los problemas de Performance o las ejecuciones fallidas. Necesitas buscar como un forense y tener la habilidad de decir precisamente quién fue el asesino.

Además…olvídate completamente de reiniciar el servidor para “solucionar” el problema

Speaker(s):

PABLO JAVIER FERNANDEZ

Track and Room: Databases - Sala205

Title: Inicia Performance Tuning con Wait Stats

Abstract: ¿Las alertas te despiertan a medianoche para preguntar qué hacer cuando el proceso se sigue ejecutando? ¿Parece un query tan simple pero nunca termina? Necesitas darle velocidad a tu servidor pero no estás seguro por dónde empezar la revisión.

Ya sea en los procesos de Desarrollo o en una revisión en Producción cuando las alertas vienen por todo lado, es vital obtener información que pueda dar una guía respecto a qué es lo que causa tiempo adicional en la ejecución de nuestros programas.

En esta sesión nos preguntaremos qué hace que un query no sea más rápido y qué factores pueden influir en su desempeño. Traduzcamos los WAITS STATS de SQL Server y entendamos lo que nos quieren decir para iniciar un camino del Performance Tuning.

Speaker(s):

PABLO JAVIER FERNANDEZ

Track and Room: Databases - Sala205

Title: From Zero to Cosmos

Abstract: Azure Cosmos DB was built from the ground up with global distribution and horizontal scale at its core. It offers turnkey global distribution across any number of Azure regions by transparently scaling and replicating your data wherever your users are. Elastically scale throughput and storage worldwide, and pay only for what you need. Azure Cosmos DB provides native support for NoSQL choices, offers multiple well-defined consistency models, guarantees single-digit-millisecond latencies at the 99th percentile, and guarantees high availability with multi-homing capabilities and low latencies anywhere in the world— all backed by industry-leading, comprehensive service level agreements (SLAs).

Speaker(s):

Patricio Cofre

Track and Room: Databases - Sala205

Title: Impementing CD with SQL Server on Linux, Docker Kubernetes

Abstract: DevOps is everywhere now days. Short development cycles with continuous delivery is the new black, leveraged by container based development. Nevertheless, relational databases were always a pain point when configuring an effective CD pipeline…. until now. In this session we will show you how can easily take advantage of the new SQL Server on Linux, to setup a high availability set with persistent storage on Kubernetes and put all this infrastructure as part of a CD pipeline.

Speaker(s):

Sergio Borromei

Track and Room: Databases - Auditorio

Title: Connecting SQL Server to R

Abstract: This presentation is about sharing my experience connecting SQL server to different procedure using R. How to interact as a data scientist, from R with SQL and how to interact from SQL with R and some good practices.

Speaker(s):

Daniel Fischer

Track and Room: Data Science BI - AulaMagna

Title: Working with Azure Data, BIG Data Services and Azure SQL for your Applications

Abstract: A Guide to Working with Data Services and Azure SQL for your Applications Although Microsoft Azure and the concept of Cloud Computing has been around for a while it is still a mystery to many.This talk takes a look at Azure Data storage – what it is, the types of storage options available and their advantages and disadvantages. We’ll take a look at the different options available for your SQL applications to see how to create and manage SQL databases in the Cloud. By the end of this talk you will be ready to get straight into Azure and start taking advantage of what it has to offer

Speaker(s):

Adnan Hendricks

Track and Room: Databases - Auditorio

Title: From SQL to Graph Databases

Abstract: Las bases de datos orientadas a grafos han crecido mucho en popularidad, y han demostrado ser de gran utilidad en escenarios de datos altamente jerárquicos, evolutivos e inter-conectados.

Si vienes desde las bases de datos relacionales y te interesa explorar las bases de datos orientadas a grafos esta sesión te será de mucha utilidad, pues haremos un paralelo entre consultas a ambos esquemas. Revisaremos ejemplos en Azure Cosmos DB (Gremlin) y SQL Server 2017 (Graph).

Azure Cosmos DB cuenta con una GRAPH API, basada en el Gremlin, lenguaje Open Source para bases de datos orientadas a grafos, desarrollada por APACHE. SQL Server 2017 incluye soporte para bases orientadas a grafos en base a una extensión del T-SQL.

Speaker(s):

Patricio Cofre

Track and Room: Databases - Auditorio

Title: Midiendo el exito en una implementacion Corporate de Power BI

Abstract: Mostraremos un reporte generado para el area de TI que permita capturar medidas e informacion acerca del uso y despliegue de Power BI. Listado de Wokspaces, usuarios por Workspace, reportes mas compartidos.

Speaker(s):

Gaston Cruz

Track and Room: Data Science BI - AulaMagna

Title: AzureML Services, Workbench and Model Management Service.

Abstract: This presentation that provides you the knowledge and tools necessary to understand the latest capabilities and usage new version of Azure Machine Learning Services “AzureML Services” and help you to get familiar with AzureML Workbench and Experimentation Service and learn how create a Machine Learning solution, understand how works Azure Machine Learning Workbench, capabilities with R and Python Packages for consumption and configuring and projects project for local, SQL Server 2017, Docker and HDInsight Spark environments.

Speaker(s):

Adrian Fernandez

Track and Room: Data Science BI - AulaMagna

Title: Microsoft - Plataforma de Datos e Inteligencia Artificial

Abstract: Visión de Microsoft en la plataforma de Datos e Inteligencia Artificial, roadmap de los productos mas relevantes y las innovaciones en SQL Server, Big Data, Servicios Cognitivos y Deep Learning.

Speaker(s):

Adrian Fernandez

Track and Room: Data Science BI - AulaMagna

Title: PreCon - Move your database to the Cloud

Abstract: Este PreCon de Azure SQL Database le proporciona el conocimiento y las herramientas necesarias para comprender las capacidades y el uso de las bases de datos en la nube. Le ayudará a familiarizarse con los conceptos de la Base de datos SQL de Azure. También le ayudará a aprender a migrar, administrar, monitorear y solucionar problemas de su solución Azure SQL Database

Más info y registro en: https://welcu.com/metric-learning/mueva-su-base-de-datos-a-la-nube-entienda-disene-migre-administre-y-monitoree-la-base-de-datos-sql-de-azure?utm_source=directory

Speaker(s):

Roberto Cavalcanti

Track and Room: Databases - Auditorio

Title: La evolución de SQL Server - Azure SQL Database Managed Instance

Abstract: Daremos una mirada al futuro de SQL Server como Servicio. Azure SQL Database Managed Instance es un nuevo servicio PaaS que nos permitira tener compatibiliad de casi el 100% con la plataforma SQL Server On-Premise, permitiendonos migrar rapidamente hacia la nube todas nuestras aplicaciones

Speaker(s):

Javier Villegas

Track and Room: Databases - Auditorio

Title: Text analytics con R y Term extraction Tool

Abstract: La minería de textos es un tema muy interesante que se utiliza para detectar patrones y analizar el texto. En la minería de textos, analiza, resume y obtiene información del texto, como comentarios, reclamos, noticias u otras fuentes de texto.

Usaremos una herramienta simple llamada Term extraction tool de SQLServer y R para analizar los reclamos de una cadena de comida rápida.

Speaker(s):

Juan Pablo Moraga

Track and Room: Data Science BI - AulaMagna

Title: PreCon - Dashboard in a Day

Abstract: DIAD - From Zero to Dashboard. A PreCon where the participant is going to create a Dashboard from scratch. ETL’s, M-Language, Visualizations, and Publish to Power BI Service

Más info y registro en: https://welcu.com/metric-learning/power-bi-day-2018?utm_source=directory

Speaker(s):

Gaston Cruz

Track and Room: Data Science BI - AulaMagna

Title: SQL Server in Docker a new defaince Linux

Abstract: En el nuevo desafío de implementar servicios de base de datos en la nube, SQL nos invita a explorar tecnologías emergentes como lo es Docker y Linux.

Speaker(s):

Carlos Aravena

Track and Room: Databases - Sala205

Title: Power BI in the New Age !

Abstract: La idea de esta sesión es mostrar las nuevas bondades que tiene Power BI tanto en seguridad, usabilidad y desarrollo.

Speaker(s):

Cristobal Ibarra

Track and Room: Data Science BI - AulaMagna

Title: SQL Server 2017 Adaptive Query Processing and Automatic Tunning

Abstract: SQL Server 2017 nos da la posibilidad de tener Intelligence Query Processing. Analizaremos y veremos en funcionamiento estas nuevas caracteresticas del motor de base de datos

Speaker(s):

Javier Villegas

Track and Room: Databases - Sala205

Title: SQL Server 2017 Automatic Tuning

Abstract: En esta sesión revisaremos el nuevo feature de SQL Server 2017 llamado Automatic Tuning. Revisaremos como ha evolucionado el proceso para mejora de rendimiento, desde las formas tradicionales, avanzando a la utilización del Query Store y terminando en el nuevo Automatic tuning. Una sesión para desarrolladores de T-SQL y DBAs en general.

Speaker(s):

Alejandro Cordero

Track and Room: Databases - Auditorio

Title: Azure SQL Database - Lessons learned from the trenches

Abstract: In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos

Speaker(s):

Jose Manuel Jurado Diaz

Track and Room: Databases - Auditorio

Title: TSQL Query Analytics Dashboard para DBA

Abstract: TSQL Query Analytics es un dashboard de PowerBI muy sencillo, donde los DBAs pueden identificar de forma rápida y sencilla donde enfocar sus esfuerzos de optimización de código TSQL. TSQL Query Analytics no te dice la solución del problema, sino te muestra qué consultas son las que causan la perdida de rendimiento en tu servidor.

Speaker(s):

Carlos Farias

Track and Room: Databases - Sala205

Speakers

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

Gaston Cruz

Twitter: - gastonfcruz

LinkedIn: Gaston Cruz

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

Adrian Fernandez

Twitter: - adrianfz10

LinkedIn: Adrian Fernandez

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.

Juan Pablo Moraga

Twitter: - @jp_moraga

LinkedIn: Juan Pablo Moraga

I am an expert in Business Intelligence and conceptualization, development and implementation of BI projects. My 10 plus years of experience in the area allowed me to specialize in the management of data mining tools and data management, as well as procedure management of change for the generation of useful information for decision-making and increasing value of the business processes of the companies I’ve worked for

Alejandro Cordero

Twitter: - @ale_corderocr

LinkedIn: Alejandro Cordero

Contact: http://sqlturbo.com

DBA with Over 10 years of experience. Focused on SQL Server development , performance tuning, High Availability. Scrum Master Certified, MCTS, MCSA, Entrepreneur and Author at SQLTurbo.com. Currently working as technical leader for database consultants in Pythian Company.

Regular speaker at SQLSaturdays in Latin America ( Costa Rica, Guatemala, Colombia) and virtual chapters( In-Memory chapter, Spanish Chapter). Have presented in SQLSaturday Ottawa in Canada.

Gaston Cruz

Twitter: - gastonfcruz

LinkedIn: Gaston Cruz

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

Ultimas experiencias en tecnologias Microsoft: Power BI, Power View, Power Pivot, Power Qu

Sergio Borromei

Con mas de 20 años de experiencia en las ciencias de la computación, Sergio ocupa el cargo de CTO en Lagash, una factoría de productos digitales con mas de 600 empleados y filiales en toda America. Siempre apasionado por la programación funcional, sus años de experiencia los convirtieron en especialista de arquitecturas de microservicios y sistemas altamente escalables basados en tecnologías de contenedores. Actualmente en su rol de CTO, lidera un equipo cuya misión principal es la generación de las capacidades estratégicas para llevar a cabo los procesos de transformación digital en los clientes de Lagash. #DigitalFactories #DesignThinking #DevOps #Kubernetes #Microservices #Serverless #GoLang #NodeJS #NoSQL #Containers #Docker

Javier Villegas

Twitter: - https://www.twitter.com/javier_vill

LinkedIn: Javier Villegas

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 SQLSaturday , PASS Virtual Groups, 24 Hours SQL PASS , vOpen(NetConf), GroupBy and DataPlatformGeeks. @sqlargentina

PABLO JAVIER FERNANDEZ

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

LinkedIn: PABLO JAVIER FERNANDEZ

Contact: https://www.datoptim.com

Pablo Fernández as Data Management and Analytics MCSE has dedicated his professional time to SQL Server Databases and Security Analysis. As a senior DBA who has finished the IT Security Master degree, he worked at banking business for the last 9 years. He has a big passion for knowledge and for sharing it with no limits. With this idea he worked as a teacher at high school, university and as a private consultant for the last 13 years also with a special focus on SQL Server during the last 8 years as a Microsoft Certified Trainer. Pablo loves spending time on Performance Tuning and making webcasts with students and friends. His goal is to make his local community bigger and be an influence around the world.

Adnan Hendricks

Twitter: - @Microspecialist

LinkedIn: Adnan Hendricks

Adnan is co-founder www.AzurePlatformExperts.com and one of the world’s leading infrastructure experts a Microsoft MVP ,MCT (Regional Lead in NL 2014-2017)Member Microsoft Onedrive Experts Program (MODE), Microsoft Windows Technical Experts Program Follow him on twitter @Microspecialist

Carlos Aravena

LinkedIn: Carlos Aravena

Consultor y Asesor Senior que en la actualidad se desempeña como Director de Negocios y asesor, del área de servicios, principalmente en los ámbitos de ecommerce y el desarrollo e implementación de medios de pago electrónico, con una trayectoria paralela en Consultoría de Gestión de Servicios, Riesgo y Tecnologías de la Información.

Profesional con estudios en Ingeniería Informática, desde 2001 ha estado apoyando grandes empresas, que se desenvuelven en diversos sectores productivos, entre los que destacan telecomunicaciones, energético, retail, financiero y la banca.

Carlos Farias

Twitter: - ChilePass

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)

Patricio Cofre

Twitter: - pcofre

LinkedIn: Patricio Cofre

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

Daniel Fischer

LinkedIn: Daniel Fischer

Contact: http://geekosas.com

I’m Daniel Fischer, I’m a very passionate data scientist, the kind of data scientist that liked working with data before it was cool. I have experience in Telco and Portfolio Management building models and processes in Python and R usually backed by SQL Server. Since I was in university, I have been doing consultancy using SQL Server. I got vast experience using it and connecting to the server from different platforms like: Linux, Python, R. I have worked on projects like: VaR, Performance Attribution, CHURN prediction, Real Time Campaigns triggered by events, Customer Segmentation, Customer Valuation, Multiple Dashboards. Noways I work full time in Entel (Telco) and I participate as speaker in courses and events about data science.

Patricio Cofre

Twitter: - pcofre

LinkedIn: Patricio Cofre

Contact: http://www.metricarts.com/noticias/

Cristobal Ibarra

LinkedIn: Cristobal Ibarra

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.

Adrian Fernandez

Twitter: - adrianfz10

LinkedIn: Adrian Fernandez

Kamal Valero

Twitter: - kamalvalero

LinkedIn: Kamal Valero

Gerente de Business Intelligence en Punto Ticket. Microsoft MVP en Data Platform

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.

Roberto Cavalcanti

Twitter: - rocavalc

LinkedIn: Roberto Cavalcanti

Roberto Cavalcanti is an Azure Cloud Solution Architect with the Customer Architecture and Engineering team at Microsoft. He is a database specialist with 20+ years of experience. He focuses on helping customers to be successful in Microsoft’s Azure cloud and on improving Microsoft Azure products. Roberto has written many articles about SQL Server/Azure SQL DB for MSDN/TechNet, SQL Magazine, and has been a speaker in events such as TechReady, Microsoft Insights/TechEd, SQLSaturday. He has delivered Azure training in multiple countries in the Americas, and in Europe. Roberto is based on the Microsoft Las Colinas, Texas, USA office.

PABLO JAVIER FERNANDEZ

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

LinkedIn: PABLO JAVIER FERNANDEZ

Contact: https://www.datoptim.com

Javier Villegas

Twitter: - https://www.twitter.com/javier_vill

LinkedIn: Javier Villegas

Contact: http://sql-javier-villegas.blogspot.com.ar/