SQLSaturday #990 - Chimbote, Perú – Virtual 2020

Event Date: 07/04/2020 00:00:00

Event Location:

  • Colegio de Ingenieros Ancash Chimbote
  • Av. Pacífico, Nuevo Chimbote 02711
  • Nuevo Chimbote, Áncash, Peru

PDF of Schedule

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

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


Title: Developing Cosmos DB for the Enterprise

Abstract: Azure Cosmos DB is an awesome multi-model database service that allows us to distribute our data on a global scale. It’s fairly easy to get started with Cosmos DB, but when it comes to implementing it for use within our Enterprise applications, there are many things that you will want to consider when developing a Cosmos DB database.

In this session, I’ll cover important topics that you’ll want to consider when developing and administrating Cosmos DB for Enterprise use, including security considerations, partitioning, provisioning throughput for your databases and collections, distributing your data and much more.

By the end of this session, you should be able to take these learnings and apply them when developing Cosmos DB applications for your business.

Speaker(s):

  • Will Velida

Track and Room: Big Data Analytics - Room 4 English


Title: Chatbots: La interacción entre tus clientes y tus datos

Abstract: Una de las aplicaciones de Inteligencia Artificial más atractivas son los chatbots, que interactúan con los usuarios en tiempo real ayudándolos en tareas tales como reservar un hotel, responder una pregunta o buscar información específica en Internet, mientras simulan que un humano real está detrás la escena.

Los datos son conocimiento, por lo que almacenamientos como Azure SQL se pueden usar como entrada para un bot que ayuda a los clientes de una empresa a procesar información y devolver resultados.

Esta sesión se enfocará en explicar a los actores involucrados al construir un bot capaz de obtener datos de su almacenamiento, incluyendo Azure SQL Database, Microsoft Bot Framework y LUIS (Language Understanding Intelligent Services). Una aplicación móvil creada con Xamarin se utilizará como parte de la demostración.

Speaker(s):

  • Luis Beltran

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: Achieving Wonders with Query Store

Abstract: Query Store, a new feature released with SQL Server 2016, can allow you to achieve wonders on the SQL Server query tuning universe: starting from ensuring that an upgrade will work and up to knowing exactly when a change on the database created a tuning problem, you will discover in this session how to find problems hidden in the middle of your server activity using T-SQL queries and Power BI to analyse the information and identify even complex problems such as parameter sniffing problems

Speaker(s):

  • Dennes Torres

Track and Room: DBA / Enterprise / Relational / SQL - Sala 2


Title: Hacking SQL Server Is Not Enough

Abstract: You already know how easy it is to hack SQL Server… But how do you protect your local and cloud servers against enemy agent attacks? This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.

Speaker(s):

  • André Melancia

Track and Room: DBA / Enterprise / Relational / SQL - Sala 2


Title: T-SQL Performance Guidelines for the optimal DB stress powers

Abstract: To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users nor adequate volume of data exist there but actually they seem totally strange once going to live where they become performing badly ending up eventually with and sharp skew of performance and standstill cases sometimes , this is due to the lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs in particular more therefore I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be explained within this session)

Speaker(s):

  • Shehab El-Najjar

Track and Room: Artificial Intelligence Business Intelligence - Room 4 English


Title: Getting Started with Apache Spark

Abstract: As companies work to gain insight from ever-increasing amounts of data, data platform practitioners need tools which can scale along with the data. Early big data solutions in the Hadoop ecosystem assumed that data sizes overwhelmed available memory, emphasizing heavy disk usage to coordinate work between nodes. As the cost of memory decreases and the amount of memory available per server increases, we see a shift in the makeup of big data systems, emphasizing heavy memory usage instead of disk. Apache Spark, which focuses on memory-intensive operations, has taken advantage of this hardware shift to become the dominant solution for problems requiring distributed data. In this talk, we will take an introductory look at Apache Spark. We will review where it fits in the Hadoop ecosystem, cover how to get started and some of the basic functional programming concepts needed to understand Spark, and see examples of how we can use Spark to solve issues when analyzing large data sets.

Speaker(s):

  • Kevin Feasel

Track and Room: Big Data Analytics - Room 4 English


Title: Data virtualization with SQL Server 2019 PolyBase

Abstract: Data virtualization with SQL Server 2019 PolyBase SQL Server has provided features like linked servers, replication, and integration services to integrate data from other data sources. In this session we will learn about the improvements to PolyBase in SQL Server 2019, which allows you to extend the querying capability to data sources like SQL Server, Oracle, MongoDB, Redis, Hadoop CDH, and other data sources. You also get insights on the design, capabilities, and performance advantages of PolyBase, save ETL Processes as follows: • Installing and Configuring PolyBase Windows Linux • Connecting to Hadoop • Using Predicate Pushdown to Enhance Query Performance • Packet Capture With\Without Predicate Pushdown • When to use Predicate Pushdown • Limitations on Pushdown with Complex Filters • MapReduce Vs Pushdown

Built-In Integrations: Oracle, MongoDB , Radis and More Integrating via ODBC : Apache Spark , Apache Hive, Microsoft Excel Monitor PolyBase with Dynamic Management Views .

Speaker(s):

  • Itshak David

Track and Room: DBA / Enterprise / Relational / SQL - Room 4 English


Title: Big Data Clusters for the Absolute Beginner

Abstract: Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today’s ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts

Speaker(s):

  • Mohammad Darab

Track and Room: DBA / Enterprise / Relational / SQL - Room 4 English


Title: Processing Tabular Models

Abstract: We are going to cover options to process our models using different methods. Create an app registration to use as a service principal and then link Azure Data Factory, and Logic Apps to process our DB/Tables/Partitions in Azure Analysis Services

Speaker(s):

  • Gaston Cruz

Track and Room: Artificial Intelligence Business Intelligence - Sala 3


Title: Azure DevOps duet (60 minutes version)

Abstract: Welcome to Azure DevOps Duet, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for SQL Server related deployments.

This session will cover the process of developing a CI/CD process starting at getting the team on board and ending with making an actual release.

We will discuss

  • the challenges of implementing DevOps
  • setting up a database solution project
  • getting started with source control
  • testing your database releases using tSQLt
  • setting up your Azure Devops pipelines

After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.

Speaker(s):

  • Kevin Chant

Track and Room: DBA / Enterprise / Relational / SQL - Room 4 English


Title: SQL Curiosities: La curiosidad mató al gatito

Abstract: There are weird things in life. Even weirder for developers… “It should work!”… What you see is NOT what you get… There’s a bug, a feature, a workaround… Disclaimer: No feline was harmed in the making of this session. Please do not report it to the Comité Nacional de Ética para el Bienestar Animal.

Speaker(s):

  • André Melancia

Track and Room: DBA / Enterprise / Relational / SQL - Sala 2


Title: Azure Vs. AWS: And the winner is!!!

Abstract: You’ve been given an awful task of comparing two of the most prominent cloud vendors. What would you do?

Amazon Web Services (AWS) and Microsoft Azure are two of the biggest names in public cloud computing. Which one is right for you? To help you make that decision, let’s talk about what each provider brings to the public cloud table, and key differences between them. We will look into the following aspects and more:

  • Computer Power
  • Storage
  • Network
  • Pricing Models
  • Support Plans
  • Integration and Open Source
  • Database
  • Big Data
  • Containers and Orchestration Support
  • Compliance
  • User-friendliness
  • Licensing
  • Intelligence
  • IoT
  • Management and Monitoring
  • Mobile Services
  • Security
  • Developer Tools
  • Hybrid Cloud Capabilities

Speaker(s):

  • Paresh Motiwala

Track and Room: DBA / Enterprise / Relational / SQL - Room 4 English


Title: Power BI dataflows : Going beyond the self-service

Abstract: What was already good has became even better. We were already able to make ETL in Power BI using M, now, using the Power BI Data Flows we are able to store the ETL on the Power BI Portal, control the ETL execution, the data among many ETL steps and share the result with many Power BI files, instead of having to duplicate M scripts across different .PBIX files

This feature allow us to create a more complex and re-usable ETL solution, creating small dataflows and allowing them to be reused in a dataflow hierarchy, which can be re-used in many different datasets, creating a more robust and reusable architecture.

In this session you will understand better how the dataflows are an important feature in making Power BI go way beyond the self-service

Speaker(s):

  • Dennes Torres

Track and Room: Artificial Intelligence Business Intelligence - Sala 3


Title: T-SQL: Escribiendo código de alto desempeño

Abstract: Es muy común en el campo de TI que un desarrollador de aplicaciones cambie a un rol de administrador/desarrollador de bases de datos. Incluso cuando los conceptos de programación son los mismos, las habilidades requeridas para escribir correctamente código T-SQL son diferentes.

En esta sesión, aprenderemos algunos consejos básicos para crear código de alto desempeño y mejorar el rendimiento de nuestras bases de datos, desde las primeras etapas de planificación de aplicaciones hasta las aplicaciones existentes que requieran mejoras de rendimiento.

Speaker(s):

  • Eduardo Pivaral

Track and Room: DBA / Enterprise / Relational / SQL - Sala 2


Title: Integration SCRUM + Microsoft Tools

Abstract: ¿A veces piensas que construyes castillos de arena con tus proyectos? ¿Se te dificulta ver los avances de los miembros de tu equipo y como generar sinergia entre ellos?

Entonces, esta es la sesión ideal para ti. Te mostraremos casos puntuales de la implementación de metodologías ágiles, haciendo uso de la suite de Microsoft y otras herramientas tecnológicas para potencializarlos.

Speaker(s):

  • Bryan Medrano Ruiz

Track and Room: Artificial Intelligence Business Intelligence - Sala 3


Title: Machine Learning is full of stars: An Azure Story

Abstract: Want to get started with Machine Learning and have no idea what technologies to use? Don’t hybernate your career. Learn about some of technologies available, focusing on Microsoft’s offering, such as Azure Machine Learning (Service) workspace, Spark using Azure Databricks and HDInsight, Azure Synapse Analytics, and many more. Disclaimer: All these worlds are yours except Cognitive Service, that’s for a different session.

Speaker(s):

  • André Melancia

Track and Room: Artificial Intelligence Business Intelligence - Room 4 English


Title: El verdadero poder de Power BI como herramienta de Business Intelligence

Abstract: Power BI es una gran herramienta, no es perfecta, se hace camino al andar. El equipo de producto y la comunidad que lo arropa lo están haciendo realmente bien. En la sesión se recorren todas las etapas de un proceso Business Intelligence con Power BI. A través de ejemplos se muestra Power BI como herramienta Business Intelligence al completo. Veremos consultas (ETL), Modelado, Informes, Colaboración, Integración con R y Machine Learning

Speaker(s):

  • Ana Maria Bisbé York

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: Mejorando la seguridad de datos sensibles con técnicas de enmascarado en Azure SQL Database

Abstract: Según las técnicas modernas de gobierno de datos, los datos sensibles deben ser tratados correctamente. Ya sea en entornos de producción o de calidad de datos, SQL Azure Database ofrece mecanismos para que los datos puedan ser enmascarados de forma que no puedan ser vistos cuando se hacen consultas a las tablas. En esta sesión veremos cómo implementar esta técnica

Speaker(s):

  • Alberto De Rossi

Track and Room: DBA / Enterprise / Relational / SQL - Sala 2


Title: Microsoft Genomic Analytics

Abstract: En esta sesion nos introduciremos al nuevo mundo del analisis genómico usando el poder de la computacion en la nube Azure.

Speaker(s):

  • Nicolas Nakasone

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: Keynote

Abstract: Keynote - Novedades en Data Platform / AI

Speaker(s):

  • Juan Rafael

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: Escenarios de modelado en DAX, el súper lenguaje de Power BI.

Abstract: En el camino a la creación de buenos cuadros de mandos y modelos analíticos, se impone la necesidad de contar con un buen modelado tabular. En la sesión se analizan y solucionan un grupo de escenarios de modelado con DAX y Power BI. Estos escenarios son los que nos encontramos con frecuencia en proyectos.

Speaker(s):

  • Ana Maria Bisbé York

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: Gráficos animados en R

Abstract: Uso de gráficos animados en R empleando el paquete gganimate.

Speaker(s):

  • Edison Lecca

Track and Room: Big Data Analytics - Sala 3


Title: Machine Learning con Databricks

Abstract: En esta sesión se mostrará como crear modelos predictivos con Databricks y explorar otras características como MLFlows

Speaker(s):

  • Raul Martin Sarachaga Diaz

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: Consolidando históricos en Power BI

Abstract: Se consolidará historicos en formato CSV, para su carga incremental automática en Query Editor de Power BI.

Speaker(s):

  • Alfredo Diego Amez Mendes

Track and Room: Artificial Intelligence Business Intelligence - Sala 3


Title: Lo nuevo en SQL Server 2019

Abstract: SQL Server 2019 es la nueva version en el mercado desde Noviembre 2019 . Veremos todas las mejoras en el area de performance y alta disponiblidad. Tambien conoceremos las nuevas plataformas donde podemos correr SQL Server

Speaker(s):

  • Javier Villegas

Track and Room: DBA / Enterprise / Relational / SQL - Sala 2


Title: Introduccion a la Plataforma de Datos de Microsoft Azure

Abstract: Azure Data Platform ofrece diversos servicios para todos los profesionales de datos (Data Scientist, DBA , Developers, etc.) Conoceremos todos estos servicios para así poder seleccionar el más conveniente para nuestro proyecto

Speaker(s):

  • Javier Villegas

Track and Room: DBA / Enterprise / Relational / SQL - Sala 2


Title: Power BI con MS Dynamics 365 FO

Abstract: El poder de PowerBI en Dynamics 365 Finance and Operations para los Workspace.

Speaker(s):

  • Juan Rafael

Track and Room: Big Data Analytics - Sala 3


Title: Arquitectura de Datos con Azure Synapse Analytics

Abstract: En esta sesión se mostrará como empeza a dar tu primeros pasos con Azure Synapse Analytics y como esta herramienta se integra con los otros servicios que tiene Azure

Speaker(s):

  • Raul Martin Sarachaga Diaz

Track and Room: Artificial Intelligence Business Intelligence - Sala 3


Title: IA Data Sience con SQL Server

Abstract: Data being an important asset for all businesses to apply data science and why it is important to the database person and how to encapsulate machine learning and AI models as part of SQL Server stored procedure enables SQL Server serve AI with data

Speaker(s):

  • Miguel Arturo Valle Pelaez

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: Azure Machine Learning en 60 minutos

Abstract: En esta charla aprenderemos ¿Que es Azure Machine Learning? , ¿Que soluciones puedo desarrollar?. Para finalizar realizaremos una implementación para entender el potencial de esta gran herramienta.

Speaker(s):

  • Ahias Portillo

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: Intelligent Query Processing in sql server 2019

Abstract: The intelligent query processing (IQP) feature family includes features with broad impact that improve the performance of existing workloads with minimal implementation effort to adopt.

Speaker(s):

  • Mariano Lopez

Track and Room: DBA / Enterprise / Relational / SQL - Sala 2


Title: Levantar Data Warehouse Moderno en Azure

Abstract: En esta demo levantaremos una arquitectura de datos en Azure usando SQL SERVER, DATAFACTORY, AZUREDATALAKE GEN2, Y POWER BI

Speaker(s):

  • Walter Calcagno

Track and Room: Artificial Intelligence Business Intelligence - Sala 1


Title: DAX As Power BI Visualization Weapon. Virtual Relationships And Time Intelligence Analytics

Abstract: At the session, I will show you what problems in building complex analytics and its visualization we encountered while working in a Power BI project. Then about how we easily solved them using the DAX language. We will talk about virtual relationships and time intelligence tricks in DAX

Speaker(s):

  • Ruslan Zolotukhin

Track and Room: Artificial Intelligence Business Intelligence - Room 4 English


Title: Tips que todo amante de Power BI debe conocer …

Abstract: En esta sesión veremos técnicas de recopilación de datos, moldeamiento y visualización de datos. Técnicas muy puntuales pero de mucha ayuda en los proyectos.

Speaker(s):

  • Jorge Michael Muchaypiña Gutierrez

Track and Room: Artificial Intelligence Business Intelligence - Sala 3


Speakers

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

Kevin Chant

Twitter: - kevchant

LinkedIn: Kevin Chant

Contact: https://www.KevinRChant.com/

Senior Database Architect originally from the UK and now living in the Netherlands.

Over 23 years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.

In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications. In addition, was probably the last ever person in the world to gain the MCSD Azure Architect certification and has gained the latest Microsoft DevOps Engineer Expert certification.

Has real life experience with SQL Server and Azure Devops. Currently SQL Server Product Owner of around 1,900 instances.

In addition, done various things over the years for the Data Platform Community.

Dennes Torres

Twitter: - Dennes

LinkedIn: Dennes Torres

Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/

Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.

Edison Lecca

LinkedIn: Edison Lecca

I am a graduate of the Systems and Computer Engineering career at the Universidad Nacional del Santa. I love nature and also diverse reading and research in general. I have a professional certification in Data Science from IBM (and Coursera), as well as being a certified R programmer and having a couple of years of experience working with data. I have had the happiness of having been an exhibitor, mainly, at the Global Azure Bootcamp 2019, at the Global Power Platform Bootcamp 2020 and anothers.

Mohammad Darab

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

LinkedIn: Mohammad Darab

Contact: https://mohammaddarab.com

Mohammad Darab is a Microsoft Data Professional, speaker and blogger with over 19 years of IT professional experience, 10+ years of that working with SQL Server. Some areas of his focus are the database engine, HA/DR, and security. He is currently an MCITP, MCP, as well as an IDERA ACE Class of 2019.

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

Luis Beltran

Twitter: - darkicebeam

LinkedIn: Luis Beltran

Contact: https://luisbeltran.mx

I am a Microsoft MVP in AI and Developer Technologies who is currently pursuing his PhD in Engineering Informatics at Tomas Bata University in Zlín, Czech Republic.

Juan Rafael

Twitter: - @jlc_rve

Contact: http://geeks.ms/blogs/juanrafael/

MCT- MCSA-MCITP-MCP-MTA-MCTS. Consultor Microsoft Dynamics con m#225;s de 4 a#241;os de experiencia en ERP y mas de 7 a#241;os en tecnolog#237;as Microsoft como SQL Server, Windows Server y SharePoint. Ha participado en proyectos de implementaci#243;n de ERP Microsoft Dynamics AX para empresas de Peru como EuroMotors, C#225;mara de Comercio de Lima, Consorcio Minero Horizonte, SIka Peru, entre otras, tambi#233;n con menci#243;n en implementaciones de ERP Microsoft Dynamics GP para diferentes industrias del Per#250;.

Raul Martin Sarachaga Diaz

LinkedIn: Raul Martin Sarachaga Diaz

Contact: https://aprendebi.wordpress.com/

Raúl es consultor en Inteligencia de Negocios y Plataforma de Datos, Ingeniero en Informática en la Universidad Nacional de Trujillo, Perú. Tiene experiencia en áreas de Salud y Retail, donde ha realizado proyectos que incluyen integración, modelado, análisis y visualización de datos basándose fundamentalmente en Tecnología Microsoft. Ha participado en una serie de Webcasts sobre Inteligencia de Negocios y Plataforma de Datos. Asimismo, ha impartido diversas cursos de certificación en SQL Server. Ponente habitual en eventos organizado por la comunidad del SQLPASS Lima y Perú BI and Analytics Group y Power BI User Group Lima. Es autor del blog Aprende BI (https://aprendebi.wordpress.com/).

Eduardo Pivaral

Twitter: - EduardoDBA

LinkedIn: Eduardo Pivaral

Contact: http://www.sqlguatemala.com/

I am an MCSE, MCSA SQL Server Database Administrator/Developer with experience in large environments.
I have worked in IT for nearly 15 years in different areas.

Currently dedicated to Administer Production, QA, Development SQL Server Databases, and components for all Microsoft supported versions.

Regular technical writer for different sources and developer/reviewer of Open Source tools for SQL Server database administration, development, and productivity.

Board member of PASS Guatemala SQL Server users group. MSSQLTips.com Rookie of the year 2018

Bryan Medrano Ruiz

LinkedIn: Bryan Medrano Ruiz

Contact: https://octanalytics.com/

Con más de 6 años de experiencia en la implementación de proyectos de inteligencia de negocios, Kaizen y Lean Six Sigma, en distintos rubros empresariales y áreas entre ellos: banca, finanzas, retail, correduria de seguros , call center, digital markerting, crédito, sales operation etc.

  • Certificado en Business Intelligence Big Data by Florida International University
  • Docente en la Facultad de Ciencias Tecnología y Ambiente- Universidad Centroamericana
  • Fundador de OCTA
  • Tableau Data Rockstar/ Tableau Community Forums
  • Miembro de Space Generation Advisory Council
  • Miembro de la comunidad Wordpress

André Melancia

Twitter: - AndyPT

LinkedIn: André Melancia

Contact: http://Andy.PT

Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.

19+ years’ fun developing information and multimedia systems, DBA, project and IT management.

Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.

Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.

Go to http://Andy.PT and you’ll know the same as the NSA…

Ana Maria Bisbé York

Twitter: - @ambynet

LinkedIn: Ana Maria Bisbé York

Contact: http://amby.net/

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

Itshak David

Contact: Global Hebrew Virtual PASS Chapter : Data virtualization with SQL Server 2019 PolyBase https://www.youtube.com/watch?v=ixfwdZUj_A8feature=youtu.be https://globalhebrew.pass.org/MeetingDetails.aspx?EventID=15457   SQL Server 2019 Big Data Cluster BDC and Spark from Zero to an hero by David Yitzhak https://www.youtube.com/watch?v=iKgMqyPOVS0   David Izhak: Performance Improvements in SQL 2014 – lessons from the field https://www.youtube.com/watch?v=x4hGjYGBfkc   David Itzhak: Practical SQL 2014 Data Mining

David Yitzhak has over 24 years of experience with SQL Server, Oracle, and Sybase. He is an applicative infrastructure DBA for relational and Nosql solutions (MongoDB, Redis), Hadoop CDH and Spark. David is a specialist in HA and DRP solutions, tuning, Machine learning , security, High Performance Computing, replication (Oracle SQL Server), BI infrastructure and system engineering. David Yitzhak holds 3 Degrees from Technicon (Israel Institute of Technology): BSC Information System , MBA and ME (System engineering) and research associate in one of the enterprise Organizations. He presents in Oracle open world 2010, Organize Oracle ILOUG for 3 years , SQL Server forums, Microsoft BI forums, Sqlsaturday Israel 2016/17/18/19 , 3rd Israeli

Juan Rafael

Twitter: - @jlc_rve

Contact: http://geeks.ms/blogs/juanrafael/

MCT- MCSA-MCITP-MCP-MTA-MCTS. Consultor Microsoft Dynamics con m#225;s de 4 a#241;os de experiencia en ERP y mas de 7 a#241;os en tecnolog#237;as Microsoft como SQL Server, Windows Server y SharePoint. Ha participado en proyectos de implementaci#243;n de ERP Microsoft Dynamics AX para empresas de Peru como EuroMotors, C#225;mara de Comercio de Lima, Consorcio Minero Horizonte, SIka Peru, entre otras, tambi#233;n con menci#243;n en implementaciones de ERP Microsoft Dynamics GP para diferentes industrias del Per#250;.

Jorge Michael Muchaypiña Gutierrez

LinkedIn: Jorge Michael Muchaypiña Gutierrez

Contact: https://jorgemuchaypina.wordpress.com/

Especialista de Inteligencia de Negocios y Plataforma de Datos, reconocido como MVP Data Platform de Microsoft. Soy apasionado en compartir conocimientos en talleres, congresos y charlas. Actualmente me encuentro certificado como MCT, MCSE Business Intelligence,MCSE Management and Analytics, MCSA SQL 2016 Development, MCSA BI Reporting, MCSA BI Developer,MCSA SQL Server 2012/2014, MCP, Itil Foundations y Scrum Foundations. Soy entrenador de los cursos oficiales de Microsoft.

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

Raul Martin Sarachaga Diaz

LinkedIn: Raul Martin Sarachaga Diaz

Contact: https://aprendebi.wordpress.com/

Raúl es consultor en Inteligencia de Negocios y Plataforma de Datos, Ingeniero en Informática en la Universidad Nacional de Trujillo, Perú. Tiene experiencia en áreas de Salud y Retail, donde ha realizado proyectos que incluyen integración, modelado, análisis y visualización de datos basándose fundamentalmente en Tecnología Microsoft. Ha participado en una serie de Webcasts sobre Inteligencia de Negocios y Plataforma de Datos. Asimismo, ha impartido diversas cursos de certificación en SQL Server. Ponente habitual en eventos organizado por la comunidad del SQLPASS Lima y Perú BI and Analytics Group y Power BI User Group Lima. Es autor del blog Aprende BI (https://aprendebi.wordpress.com/).

Alfredo Diego Amez Mendes

LinkedIn: Alfredo Diego Amez Mendes

Apasionado por los datos, y sobre todo con muchas ganas de aprender, enseñar y generar una correcta cultura de datos

Mariano Lopez

LinkedIn: Mariano Lopez

I have 2 years of experience in the use of microsoft technologies, I am currently mct

Dennes Torres

Twitter: - Dennes

LinkedIn: Dennes Torres

Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/

Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.

André Melancia

Twitter: - AndyPT

LinkedIn: André Melancia

Contact: http://Andy.PT

Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.

19+ years’ fun developing information and multimedia systems, DBA, project and IT management.

Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.

Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.

Go to http://Andy.PT and you’ll know the same as the NSA…

Paresh Motiwala

Twitter: - pareshmotiwala

LinkedIn: Paresh Motiwala

Contact: https://pareshmotiwala.wordpress.com/wp-admin/post.php?post=2amp;action=editamp;message=6amp;postpost=v2

Paresh Motiwala a Azure/Big Data enthusiast, Manager of Database Platform teams has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He has also been a Sr. SQL DBA and a Solutions Architect in Fortune 100 companies. He helps/organizes and speaks at many SQLSaturdays, Azure Bootcamp, Azure Datafests and User Groups(Boston BI UG, NESQL, PASS PD VG and PASS DBA VG).

He is certified in Big Data Analytics, FinTech, PMP, Public Speaking, Business Communications. He is a avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills and mentors children around the globe via www.circlesofgrowth.com

Ahias Portillo

Twitter: - PortilloAhias

LinkedIn: Ahias Portillo

Soy un loco entusiasta por aprender nuevas tecnologías asociadas a base de datos, análisis de datos, Big Data y Ciencia de datos, cuento con más de 15 años de experiencia.

Cuento con una maestría en Base de datos, certificación profesional de Microsoft en ciencia de datos y Big Data, actualmente estoy estudiando una maestría académica en ciencia de datos.

Me gusta compartir el conocimiento lo que me ha permitido ser nombrado como MVP de plataforma de datos desde el 2014, también he participado como conferencista en países de El Salvador, Guatemala, Costa Rica, Panamá, Estados Unidos y España.

Ana Maria Bisbé York

Twitter: - @ambynet

LinkedIn: Ana Maria Bisbé York

Contact: http://amby.net/

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

Javier 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

Miguel Arturo Valle Pelaez

Twitter: - mavpelaez

LinkedIn: Miguel Arturo Valle Pelaez

Microsoft MVP IA Experiencia 19 años en tecnologías Microsoft. Director SQL PASS Peru Chimbote Director Colegio de Ingenieros - IEPI. CDA. Chimbote Director General Instituto Catedrático Universitario Maestría Gerencia de Operaciones y Logística UPC Maestría en Sistemas de información UPAO Diplomado en Gerencia de Proyectos UPC Diplomando en Investigación Científica Master Solution Developer Microsoft tecnologias: en IA, Azure Machine learning, Mineria de Datos, Mineria de Texto, Microsoft Sql Server, Cognitive Services, Computacion distribuida.

Will Velida

LinkedIn: Will Velida

Will Velida is a Software Engineer working at ASB Bank in Auckland New Zealand. While at ASB Bank, he has worked in a variety of teams, including working in the Big Data team, Data Science and Analytics team and in the Payments team doing some awesome things in the cloud using Azure Functions and Cosmos DB! In his down time, he likes to hike around New Zealand and do the odd kayaking when the opportunity arises.

Walter Calcagno

Twitter: - wcalcagno

LinkedIn: Walter Calcagno

Citizen Developer, Microsoft MVP Data Platform, Microsoft Certified Trainer, MCSA BI Reporting

Ruslan Zolotukhin

Twitter: - zoloturu

LinkedIn: Ruslan Zolotukhin

Contact: https://www.zoloturu.com

BI Engineer at Jabil Software Services Power BI Consultant MCT, MSCA: BI Reporting Speaker at SQLSaturday, Data Monsters and UNETA, PUG and PASS UG Meetups Advisor at Power BI Community Forum Leader of Kharkiv Power BI User Group Former DAX, Excel VBA trainer Blog: www.zoloturu.com

My passion is:

  • to learn new technologies in data management, analytics and science
  • to wrangle data and provide meaningful output
  • to automate routine processes and to build reporting systems
  • to share my experience and knowledge in all these areas

Shehab El-Najjar

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

LinkedIn: Shehab El-Najjar

Contact: http://sqlserver-performance-tuning.net/

Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts to broadcast Microsoft SQL Server technologies all over the Gulf such as KSA and Emirates and other Gulf cities ahead ..)

 He is now Professional Services Manager at Saudi Emircom

 He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years

 He is an influencing Database community leader all over the region  A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region

Nicolas Nakasone

Twitter: - @nicolasnakasone

LinkedIn: Nicolas Nakasone

MVP Data Platform y MCT, consultor e instructor en Inteligencia de Negocios con mas de 17 años de experiencia en este rubro. Expone regularmente sobre Metodologias de Datawarehouse, Datamart, Datamining, BigData,Ciencia de Datos en eventos y talleres en Universidades e Institutos Tecnologicos y Comunidades. Ha desarrollado importantes implementaciones de Inteligencia de Negocios, desempeñandose como Arquitecto de Datawarehouse y ETL, Datamart-Olap, Datamining, Big Data y Ciencia de Datos

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

André Melancia

Twitter: - AndyPT

LinkedIn: André Melancia

Contact: http://Andy.PT

Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.

19+ years’ fun developing information and multimedia systems, DBA, project and IT management.

Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.

Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.

Go to http://Andy.PT and you’ll know the same as the NSA…

Alberto De Rossi

Twitter: - @albertoderossi

LinkedIn: Alberto De Rossi

Contact: http://dblearner.com

I have 20 years of experience in IT, orientated towards project management, functional and process consultancy. I am professional in computing and Informatics from Universidad San Mart#237;n de Porres. I#39;m SQL Server MCP and MCT and MVP from 2017. I teach SQL Server MOC in Instituto Tecnol#243;gico Cibertec and collaborate with SQL Server communities and user groups in all of the country. I am also founder of dbLearner, a community where knowledge of database technologies are shared through the blog dblearner.com

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page