SQLSaturday #836 - Santiago 2019
Event Date: 04/13/2019 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.
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: Accelerating Artificial Intelligence with ONNX
Abstract: WinML enables the execution of pre-trained machine learning models in Windows 10 devices. By leveraging WinML, devices would be able to perform local computations without dependencies on centralized cloud services which should play a role streamline the implementation of intelligent edge computing applications. The magic of WinML is based on another super cool AI initiative that Microsoft has been working on: The Open Neural Network Exchange (ONNX) is a project created by Microsoft, Amazon and Facebook to define a computational graph model that can be used across different deep learning frameworks. Technologies such as Tensorflow, Keras, Microsoft Cognitive Toolkit or Caffe2 have been developing support for ONNX.
Speaker(s):
- Patricio Cofre
Track and Room: Data Science AI - Auditorio
Title: SQL Server 2019 Big Data Clusters
Abstract: SQL Server Big Data Clusters is a platform for simple deployment and operations of data at scale. It provides a full data platform on-premise, in the cloud, and as a hybrid architecture for structured and unstructured data.
SQL Server 2019 Big Data Clusters primary scenarios are:
- Easily scale out the data system to handle large volumes of data.
- Unlock business insights from multiple sources of structured and unstructured data .
- Apply real-time analytics for instant updates using Apache Spark.
- Infuse AI into apps to actively engage with customers using SQL Server Machine Learning languages and the Apache Spark infrastructure to create, train, and store models. It also provides an endpoint for scoring the predictions and classifications.
Speaker(s):
- Adrian Fernandez
Track and Room: Databases - Aula Magna
Title: LA FORMA (IN)CORRECTA DE HACER TESTING EN SQL SERVER
Abstract: ¿Cuántas veces te ha pasado que el desarrollo entregado que has probado y certificado funciona mal en producción? ¿Más lento, con timeouts, esperando por locks o, simplemente no como se esperaba?
O incluso has recibido esa llamada telefónica donde te aseguran que nada ha cambiado en los programas, que todo iba bien siempre pero justo hoy todo se encuentra más lento y debes solucionarlo.
Desde la perspectiva del Desarrollador y del DBA, necesitamos entender cuándo suceden estos hechos y el porqué de los mismos para direccionar correctamente el Testing antes de enviar cambios a Producción o para atender incidentes que ya están en nuestro ambiente productivo.
Esta sesión te mostrará los caminos adecuados para potenciar tus técnicas de Testing y de Troubleshooting para mejorar tus programas.
Speaker(s):
- PABLO JAVIER FERNANDEZ
Track and Room: Databases - Aula Magna
Title: ¿HACKING SQL SERVER?
Abstract: ¿Qué tan fácil es atacar una Base de Datos? Las amenazas son inevitables pero, ¿cuánto tiempo le toma a un atacante llegar al lugar más protegido del diseño multicapa de nuestra aplicación? ¿Qué tan protegidos estamos de ataques internos?
Existen muchos conceptos errados respecto a la garantía en la seguridad de base de datos donde muchas veces asumimos un grado de protección ideal. En esta sesión verás diferentes maneras en las que la información podría estar expuesta sin que muchas veces esto sea notado por quienes la protegen o administran.
Depende de nosotros fortalecer nuestros programas y hacer más duro el camino hacia una vulneración de nuestros sistemas.
Speaker(s):
- PABLO JAVIER FERNANDEZ
Track and Room: Databases - Sala V213
Title: Shiny apps and Databases
Abstract: How to create a shiny app hosted in shinyapps.io that extracts its data from a database in real-time. Simplify queries with dbplyr. Manage connections with dbpool. Hosting the app in the shiny server. Insert user input into a database. Firewall configuration.
Speaker(s):
- Milenko Brzovic
Track and Room: Data Science AI - Auditorio
Title: Metodologias Agiles en Data Analytics - Azure DevOps y Power BI
Abstract: Conexion a la API de Azure DevOps para la implementacion de metricas de equipos de desarrollo. Analisis de Bugs, Historias de Usuario, y deliveries desde un contexto de desarrollo con Power BI
Speaker(s):
- Gaston Cruz
Track and Room: Business Intelligence - Sala V213
Title: Migrating our old SQL Server to the modern platform
Abstract: En esta pre-conference trabajaremos sobre los pasos para migrar nuestro viejo SQL Server (desde SQL Server 2005 en adelante) hacia una plataforma de datos más moderna y en la nube. Veremos todas las opciones disponibles y realizaremos los pasos para llevar a cabo la migración en forma éxitosa.
Para registrarse a este pre-conference debes ir a este link: https://welcu.com/metric-learning/preconf-migrating-old-sql-server
Speaker(s):
- Javier Villegas
Track and Room: Databases - Aula Magna
Title: ShinyServer con Docker en Azure (Azure + R + ShinyServer + Auth0)
Abstract: Instalaremos y publicaremos en la web una aplicación con Shiny ocupando las tecnologías Docker. Además, le daremos autenticación con la tecnología de Auth0. Todo montado en arquitecturas Azure.
Speaker(s):
- Nicolás Calderón Díaz
Track and Room: Data Science AI - Auditorio
Title: Data Platform Unplugged
Abstract: Ask us everything about the Microsoft Data Platform
Speaker(s):
- Javier Villegas
Track and Room: Databases - Aula Magna
Title: Nuevas Caracterísiticas de SQL Server 2019
Abstract: SQL Server 2019 trae 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 se encuentran ‘Big Data Clusters’, que nos permite ejecutar módulos the advanced analytics y machine learning con Spark. También hay mejoras en consultas de grafos, intelligent query processing, Data discovery y classification, así como muchas otras mejoras. Discutiremos lo nuevo y veremos algunos ejemplos de SQL Server 2019 en acción.
Speaker(s):
- Kamal Valero
Track and Room: Databases - Aula Magna
Title: Diseño de motores de búsqueda con Azure Search y Cognitive Services
Abstract: Veremos cómo podemos diseñar un buscador que permita encontrar datos dentro de archivos aprovechando los servicios de la nube de búsqueda, en conjunto con los servicios cognitivos de Azure.
Speaker(s):
- Nestor Campos
Track and Room: Databases - Sala V213
Title: Lo Nuevo de Power BI
Abstract: En esta presentación vamos a hablar de las bondades que tiene esta maravillosa herramienta en un ambiente corporativo.
Speaker(s):
- Cristobal Ibarra
Track and Room: Business Intelligence - Sala V213
Title: Open Data Initiative / CDM Power BI Data Flow
Abstract: La idea es comentar sobre la iniciativa Open Data Microsoft + SAP + Adobe y mostrar un ejemplo práctico mediante Power BI Data Flow (CDM).
Speaker(s):
- Mauricio Gamboa
Track and Room: Business Intelligence - Sala V213
Title: PreConference: Advanced Power BI
Abstract: En esta sesión extendida de un día, queremos explicar como se puede utilizar Power BI con DAX, con servicios cognitivos de Microsoft Azure y visualización en tiempo real.
Para registrarse a este pre-conference debes ir a este link: https://welcu.com/metric-learning/preconf-advanced-power-bi
Speaker(s):
- Cristobal Ibarra
Track and Room: Business Intelligence - Auditorio
Title: Linux Services on Windows with-out Virtualization
Abstract: Veremos como configurar servicios no disponibles en windows como Rstudio-Server, Shiny y JupyterHub con JupyterLab con los kernels de R, Julia y Python. Realizaremos algunas pequeñas demostraciones dentro de estas plataformas, incluidas conectarse a SQL Server y terminaremos la demostración lanzando un escritorio Linux dentro de Windows.
Todo esto lo realizaremos utilizando una maquina virtual con windows 10 en Azure, la pantalla de este escritorio se grabará y se compartirá de modo que los participantes puedan replicar la configuración mas adelante en Azure.
Speaker(s):
- Daniel Fischer
Track and Room: Data Science AI - Auditorio
Title: Multi-Class Text Classification
Abstract: When working on a supervised machine learning problem on text analytics, we try different algorithms and techniques to search for models to produce general hypotheses, which then make the most accurate predictions possible about future instances.
Speaker(s):
- Juan Pablo Moraga
Track and Room: Data Science AI - Auditorio
Title: Machine Learning: Algoritmos de clasificación explicados con peras y manzanas
Abstract: Los algortimos de clasificación permiten determinar cual es la clase a la que pertenece un determinado individuo u objeto, mediante un modelo de Machine Learning.
En este modelo, el algoritmos entrena mediante un determinado grupo de datos en una fase de trainning, y luego se utiliza el aprendizaje para realizar predicciones en función de muestras aún no clasificadas.
Se trabajara en lenguaje de programacion Python con librerías SciKit Learn para los algoritmos de machine learning.
Speaker(s):
- Ricardo Solar
Track and Room: Data Science AI - Auditorio
Title: AZURE y la Industria 4.0
Abstract: Se estima que para el año 2022 alrededor del 40% de los procesos operativos de las industrias tendrá la capacidad de aprender y ser autónomos, esto gracias a los grandes avances en inteligencia artificial, pero por sobre todo a la capacidad de los dispositivos de estar conectados directamente a la nube enviando enormes cantidades de datos en tiempo real. Es aquí donde AZURE juega y jugará un papel importante, dadas las capacidades que nos ofrece para capturar esos datos, procesarlos y administrarlos con sus servicios de IoT y Cognitive Services.
Speaker(s):
- Hector Meza
Track and Room: Data Science AI - Room3
Title: Query Performance Insights - What’s New ?
Abstract: En esta charla discutiremos acerca de varias de las mejoras de SQL Server, enfocandonos en lo que respecta a Query Performance y tareas de mantenimiento en grandes tablas. Hablaremos sobre las inovaciones en el area de Intelligent Query Processing (IQP) y su implementacion practica.
Tambien recorreremos las nuevas funcionalidades relacionadas con la creacion y defragmentacion de indicies en forma online, rapida y efectiva.
Finalmente veremos como utilizar las nuevas herramientas de SSMS para poder realizar un upgrade en forma eficaz
Speaker(s):
- Javier Villegas
Track and Room: Databases - Aula Magna
Title: Nueva Solución para DBA - SQLWatch
Abstract: Presidente de la comunidad PASS Chile y actualmente soy Jefe de proyectos de Dataplatform en Cuatroi, donde tengo una experiencia de mas de 10 años en las tecnologia de base de datos y mision critica, gestionando diversos servicios y plataforma de continuidad operativa en la infraestructura de base de datos multiplataforma y en puedo destacar a varios clientes en que prestado mis servicios profesionales.
Speaker(s):
- Carlos Farias
Track and Room: Databases - Aula Magna
Title: SQL Server in Docker Containers
Abstract: Container en entornos de DevOps en una tecnologia que esta creciendo a gran velocidad. En esta sesion veremos como instalar Docker sobre Linux y Windows para luego hacer multiples deployments de distintas versiones de SQL Server en cuestion de minutos. Tambien veremos como crear y distribuir nuestros propios containers
Speaker(s):
- Javier Villegas
Track and Room: Databases - Sala V213
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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.
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
Hector Meza
Arquitecto en Plataforma de Datos
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
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.
Kamal Valero
Twitter: - kamalvalero
LinkedIn: Kamal Valero
Gerente de Business Intelligence en Punto Ticket. Microsoft MVP en Data Platform
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
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.
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
Mauricio Gamboa
Twitter: - mgamboaf1
LinkedIn: Mauricio Gamboa
MCT, MCSE: Data Management and Analytics. Actualmente me desempeño como Consultor en Data Analyticst en EY. Además, soy el lider de la comunidad de usuarios de Power Platform en Chile.
Ricardo Solar
Líder de equipos de Ingeniería, consultor y IT Architect, con más de 10 años de experiencia profesional trabajando para diferentes industrias como minería, telecomunicaciones, agroindustrial, bancaria, y TI.
Programación en C, C#, SQL, Python, Javascript, PHP, otros lenguajes y herramientas.
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
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)
Nestor Campos
LinkedIn: Nestor Campos
Software Architect with experience in Cloud Computing with Azure and Big Data with Hadoop, Spark and MongoDB.
Milenko Brzovic
LinkedIn: Milenko Brzovic
Passionate about using technology as an enabler to improve society.
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.
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
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.
Nicolás Calderón Díaz
LinkedIn: Nicolás Calderón Díaz
a
Sponsors
The following is a list of sponsors that helped fund the event: