Nr: 1014
SQLSaturday #1014 – Lima – Virtual 2020
SessionID: 107784
Event Date: 05-12-2020 - Session time: 09:00:00 - Track: EVA1
Speaker: Ana Maria Bisbé York
Abstract:
A partir de orígenes de datos diversos se llega a un hermoso modelo tabular con esquema estrella listo para realizar informes con Power BI.
SessionID: 108017
New Features in SQL Server 2019
Event Date: 05-12-2020 - Session time: 09:00:00 - Track: EVA2
Speaker: Javier Villegas
Title: New Features in SQL Server 2019
Abstract:
SessionID: 109004
Cosmos DB: An Azure Odyssey
Event Date: 05-12-2020 - Session time: 09:00:00 - Track: EVA00
Speaker: André Melancia
Title: Cosmos DB: An Azure Odyssey
Abstract:
In the vast IT Universe, there are two dominant types of particles: the SQL electron and the NoSQL positron. Everyone has seen SQL, but not many have seen NoSQL, or even understand it.
Spark your imagination in an IT Universe where replication works at a magical quantum level, and .Net planets coexist with Cosmos DB star clusters.
Disclaimer: Mixing SQL electrons with NoSQL positrons may lead to the destruction of the known universe. Doing it right however, you can create the brightest supernovas!
SessionID: 107740
How to get the most from Azure SQL Database
Event Date: 05-12-2020 - Session time: 10:00:00 - Track: EVA2
Speaker: Jose Manuel Jurado Diaz
Title: How to get the most from Azure SQL Database
Abstract:
In this session we will show how to get the most advantages out from Azure SQL Database.
We will learn how to monitor the performance of our workload, how to improve it and how to secure it using the tools and features at our disposal on the Azure portal without having to install 3rd party tools.
We will also see some ways to lower the costs or increase performance without having to also increase costs.
SessionID: 107835
Sex, Artificial Intelligence Rock n’ Roll
Event Date: 05-12-2020 - Session time: 10:00:00 - Track: EVA2
Speaker: Javier Menendez Pallo
Title: Sex, Artificial Intelligence Rock n’ Roll
Abstract:
SessionID: 108393
Quantum computing explained with demos!
Event Date: 05-12-2020 - Session time: 10:00:00 - Track: EVA00
Speaker: Damian Widera
Title: Quantum computing explained with demos!
Abstract:
This talk is inspired by the quantum revolution we will see in a moment.
I would like to introduce the topics:
- reminder why basic linear algebra (matrices and vectors) is important
- qbits, superposition, and quantum logic gates
- Show the simplest problem where a quantum computer outperforms classical methods
If time permits - quantum entanglement
I will do demos implemented in Q# with the Microsoft Quantum Development Kit.
I do not assume any special knowledge, but if you know basic linear algebra (matrices, vectors, matrix multiplication) than the topic will be more easily understand!
SessionID: 107735
¡Azure DevOps! Versionamiento, Integración y Entrega Continua de Bases de Datos...
Event Date: 05-12-2020 - Session time: 11:00:00 - Track: EVA2
Speaker: Edgardo Gutiérrez
Title: ¡Azure DevOps! Versionamiento, Integración y Entrega Continua de Bases de Datos...
Abstract:
El concepto de DevOps puede resumirse como una cultura de trabajo que permite la comunicación y colaboración entre el desarrollo y la operación (de los términos en inglés «development» y «operations»).
Azure DevOps nos permite integrar esta cultura de trabajo en nuestros proyectos incluso de bases de datos, nos enfocaremos en el control de versiones, integración continua (del inglés continuous integration) y en los «release» para la entrega continua (del inglés continuous delivery) que no es más que una extensión de la integración continua, donde se automatiza el proceso de entrega de un software, lo que permite conseguir implementaciones fáciles y confiables.
Este proceso se puede apoyar de una metodología ágil, lo que resulta en un engranaje que logra realizar entregas de forma continua y rutinaria, sin que suponga cambios en este proceso, sino en el producto de código que se implementa.
SessionID: 107797
Intro to Power BI
Event Date: 05-12-2020 - Session time: 11:00:00 - Track: EVA00
Speaker: David Patrick
Title: Intro to Power BI
Abstract:
For anyone new to Power BI, we'll cover all the main features and walk through getting data into the tool (using both the desktop and online versions), creating visualizations, turning them into reports and adding them to dashboards. When we're through we'll have several BI components available to share via the Cloud!
SessionID: 109326
Presentación de Productos IDERA: SQL Diagnostic Manager y SQL Compliance Manager
Event Date: 05-12-2020 - Session time: 11:00:00 - Track: EVA2
Speaker: Jose Castillo
Title: Presentación de Productos IDERA: SQL Diagnostic Manager y SQL Compliance Manager
Abstract:
Presentación de Productos IDERA.
SQL Diagnostic Manager : Monitoreo del rendimiento de bases de datos. Supervise sus entornos físicos, virtuales y en la nube. Seguimiento de querys para arreglar bloqueos. Alerta de forma predictiva y evita falsas alertas. Vea consejos de expertos con scripts ejecutables.
SQL Compliance Manager: Monitorea, alerta y registra el acceso a bases de datos y servidores. Escanea sus bases de datos para identificar datos sensibles. Crea registros e informes de auditoría confiables.
SessionID: 107847
Dax step by step with Power BI
Event Date: 05-12-2020 - Session time: 12:00:00 - Track: EVA2
Speaker: Martha Chávez
Title: Dax step by step with Power BI
Abstract:
En esta sesión se realizará un caso práctico enfocado a usar el lenguaje Dax con el fin de usar distintas funciones que nos ayuden a obtener el cálculo deseado. En esta sesión también se hará uso de Time Intelligence.
SessionID: 108070
Back to the future - Migrating our SQL Server OnPremise Database to Azure kik
Event Date: 05-12-2020 - Session time: 12:00:00 - Track: EVA2
Speaker: Jose Manuel Jurado Diaz
Title: Back to the future - Migrating our SQL Server OnPremise Database to Azure kik
Abstract:
We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise.
This session consists of:
-> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse.
-> Best Practices and best tools for our migration process depending on the platform chosen.
-> After the migration, we have several outstanding questions:
Can I keep both environments synchronized?
How is the performance of my database?
SessionID: 108950
Understanding the Statistics in SQL Server
Event Date: 05-12-2020 - Session time: 12:00:00 - Track: EVA00
Speaker: Deepthi Goguri
Title: Understanding the Statistics in SQL Server
Abstract:
This session will have awesome demos showcasing practical examples of how the optimizer uses statistical information for all those crazy queries you write.
SessionID: 107776
Query Store for SQL Server 2019 from zero to an hero lessons learned from the fields .
Event Date: 05-12-2020 - Session time: 13:00:00 - Track: EVA00
Speaker: Itshak David
Title: Query Store for SQL Server 2019 from zero to an hero lessons learned from the fields .
Abstract:
You'll Learn
• Best practices in implementing Query Store on production servers
• Detect and correct regressions in query performance
• Lower the risk of performance degradation following an upgrade
• Use tools and techniques to get the most from Query Store
• Automate regression correction and other uses of Query Store.
This is a demo session only with minimum theory lessons from the fields
SessionID: 108483
Utilizando Spark en Azure
Event Date: 05-12-2020 - Session time: 13:00:00 - Track: EVA2
Speaker: Raul Martin Sarachaga Diaz
Title: Utilizando Spark en Azure
Abstract:
En esta sesión aprenderemos a utilizar Spark sobre Azure y explorar sus principales caracterisitcas como Etls, machine learning, streaming , delta lake,etc
SessionID: 109324
Saca el maximo provecho a Dataflows en Power BI Pro o Premium
Event Date: 05-12-2020 - Session time: 13:00:00 - Track: EVA1
Speaker: Alejandro Humberto Sánchez Núñez
Title: Saca el maximo provecho a Dataflows en Power BI Pro o Premium
Abstract:
Conceremos caracterisitas imporantes de como hacer un buen uso de este servicio y revisaremos las principales updates del mes de noviembre.
SessionID: 108392
How to become a Data Scientist with Python and Jupyter notebook
Event Date: 05-12-2020 - Session time: 14:00:00 - Track: EVA00
Speaker: Damian Widera
Title: How to become a Data Scientist with Python and Jupyter notebook
Abstract:
I would like to present about how to start a journey with data science (using python) in an environment like a Jupyter Notebook. I am going to show you how to apply Machine Learning algorithms as an example of the Pima Indians and their problems with diabetes.
SessionID: 108786
AI Power - Cognitive Services and Power BI
Event Date: 05-12-2020 - Session time: 14:00:00 - Track: EVA00
Speaker: Alex Rostan
Title: AI Power - Cognitive Services and Power BI
Abstract:
SessionID: 107737
Integrating AI Cognitive Services with Power BI and PowerApps
Event Date: 05-12-2020 - Session time: 15:00:00 - Track: EVA00
Speaker: Mahesh Caroicar
Title: Integrating AI Cognitive Services with Power BI and PowerApps
Abstract:
Getting the Most of Azure cognitive services with data generated from a PowerApps Canvas Application and integrate the generated AI insights and analyze them using a Power BI report.
SessionID: 108004
Introducción al Internet de las cosas (IoT)
Event Date: 05-12-2020 - Session time: 15:00:00 - Track: EVA2
Speaker: Vladimir Guzman
Title: Introducción al Internet de las cosas (IoT)
Abstract:
En esta sesión se demostrara como implementar una solución e IoT, se desarrollara un caso practico, y relacion con servicios Azure.
SessionID: 108937
Power BI Composite Models
Event Date: 05-12-2020 - Session time: 15:00:00 - Track: EVA2
Speaker: Jose L. Rivera
Title: Power BI Composite Models
Abstract:
In this talk we will explore a very powerfull set of features called Composite Models and Aggregations. These two new features bring a new level of data modeling and data prep to Power BI Desktop and PowerBI Service. Join us to see it in action.
SessionID: 107806
Azure Sql DB Managed instance, a different sql server?
Event Date: 05-12-2020 - Session time: 16:00:00 - Track: EVA00
Speaker: Gonzalo Bissio
Title: Azure Sql DB Managed instance, a different sql server?
Abstract:
On this session we are going to cover Azure sql db managed instance service. Introduction, how to Migrate, limitations, best practices among other things :):):):)..
SessionID: 107809
Conociendo mas de Power BI dataflows
Event Date: 05-12-2020 - Session time: 16:00:00 - Track: EVA1
Speaker: Gaston Cruz
Title: Conociendo mas de Power BI dataflows
Abstract:
In this session we are going to cover best practices to start with Power BI dataflows. Study cases and different scenarios to implement them.
SessionID: 107811
Opciones de alta disponibilidad con Microsoft SQL Server
Event Date: 05-12-2020 - Session time: 16:00:00 - Track: EVA1
Speaker: Alberto De Rossi
Title: Opciones de alta disponibilidad con Microsoft SQL Server
Abstract:
Cada vez más empresas implementan sus bases de datos en la nube. Pero aun existe la necesidad de mantener bases de datos con SQL Server en servidores On-Premise o en máquinas virtuales. En esta sesión veremos las diferentes opciones de alta disponibilidad de SQL Server, aplicando estrategias que garanticen la continuidad de la operación de acuerdo a los diferentes requerimientos de las organizaciones.
SessionID: 107798
Intro to CDS inside of Power Automate (fka Microsoft Flow)
Event Date: 05-12-2020 - Session time: 17:00:00 - Track: EVA00
Speaker: David Patrick
Title: Intro to CDS inside of Power Automate (fka Microsoft Flow)
Abstract:
The Microsoft Common Data Service lets you securely store and manage data that's used by business applications. Data within Common Data Service is stored within a set of entities. An entity is a set of records used to store data, similar to how a table stores data within a database.
Learn how the CDS ties into Power Automate (Flow), what Triggers and actions are available and how you can use this all.
SessionID: 107850
Data Storytelling with Power BI
Event Date: 05-12-2020 - Session time: 17:00:00 - Track: EVA2
Speaker: Jorge Michael Muchaypiña Gutierrez
Title: Data Storytelling with Power BI
Abstract:
SessionID: 109123
Azure Synapse Analytics – Análisis de Datos Ilimitados
Event Date: 05-12-2020 - Session time: 17:00:00 - Track: EVA00
Speaker: Mariano Kovo
Title: Azure Synapse Analytics – Análisis de Datos Ilimitados
Abstract:
Revisaremos su evolución, arquitectura y componentes de esta pontente solución.
SessionID: 108300
Conceptos Básicos para Utilizar Grafos en AZURE SQL DB y POWER BI
Event Date: 05-12-2020 - Session time: 18:00:00 - Track: EVA1
Speaker: Wagner Crivelini
Title: Conceptos Básicos para Utilizar Grafos en AZURE SQL DB y POWER BI
Abstract:
Como crear un modelo de grafos en AZURE SQL DATABASE, con despliegue de nodos y relaciones, así como consultas y funciones especiales de grafos. Al final será presentado un dashboard de POWER BI incluyendo las imágenes de grafos.
SessionID: 108877
SQL en Docker paso a paso
Event Date: 05-12-2020 - Session time: 18:00:00 - Track: EVA2
Speaker: Maxi Accotto
Title: SQL en Docker paso a paso
Abstract:
Vamos a ver como usar SQL Server sobre contenedores Docker. Instalaremos imágenes, armaremos contenedores, usaremos volúmenes compartidos, emularemos una actualización de parches de SQL y crearemos imágenes personalizadas
SessionID: 109118
Synapse Analytics - Análisis de la nube en la era del autoservicio y la ciencia de datos
Event Date: 05-12-2020 - Session time: 18:00:00 - Track: EVA2
Speaker: Julio Enrique Urriola Barra
Title: Synapse Analytics - Análisis de la nube en la era del autoservicio y la ciencia de datos
Abstract:
En esta sesión mostraremos las funcionalidades que Synapse nos ofrece como un todo.
Desde como orquestar nuestros procesos de ingesta y transformación hasta como visualizar resultados por medio de Power BI.