| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Ruslan Zolotukhin | BI Platform Architecture, Development Administration | Demystification of Calculation Groups in Analysis Services Tabular |
| 09:00:00 | André Melancia | Application Database Development | Hacking SQL Server Is Not Enough |
| 09:00:00 | Itshak David | Application Database Development | SQL Server 2019 on containers and Kubernetes(k8s) from zero to an hero ! |
| 09:00:00 | Ana Maria Bisbé York | Analytics and Visualization | Escenarios de modelado en DAX, el súper lenguaje de Power BI. |
| 10:15:00 | David Patrick | Application Database Development | 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access |
| 10:15:00 | Jose Manuel Jurado Diaz | Cloud Application Development Deployment | How to get the most from Azure SQL Database |
| 10:15:00 | Orlando Mezquita | Analytics and Visualization | Query folding in Power BI: maximizing the performance of database connections |
| 10:15:00 | Sam Nasr | Application Database Development | 14 T-SQL Functions You May Not Know |
| 11:30:00 | Alex Rostan | Cloud Application Development Deployment | Get data easily and fast with Cognitives Services |
| 11:30:00 | Tracy Boggiano | Enterprise Database Administration Deployment | SQL Server Configuration with dbatools and dbachecks |
| 11:30:00 | Mohammad Darab | Enterprise Database Administration Deployment | Big Data Clusters for the Absolute Beginner |
| 11:30:00 | Kenneth Urena | Application Database Development | SQL Server 2019: Estrategias de Indexación para alto desempeño |
| 13:30:00 | Javier Villegas | Enterprise Database Administration Deployment | Monitoring SQL Server using Community solutions (Free) |
| 13:30:00 | Eduardo Castro | Analytics and Visualization | Forecasting con SQL Server R Services y PowerBI |
| 13:30:00 | Deepthi Goguri | Enterprise Database Administration Deployment | SQL Engine: Its Working Style |
| 13:30:00 | Martha Chávez | BI Platform Architecture, Development Administration | Databricks for data engineers |
| 14:45:00 | Ahias Portillo | BI Platform Architecture, Development Administration | Delivering a Data Warehouse in the Cloud |
| 14:45:00 | Andrea Mascher | Professional Development | SELECT Questions FROM Diversity.Inclusion WHERE AfraidToAsk = 1 |
| 14:45:00 | MAYRA BADILLO VILLAMIZAR | BI Platform Architecture, Development Administration | Power BI and Common Data Service |
| 14:45:00 | Vladimir Guzman | Application Database Development | SQL DevOps |
| 16:00:00 | Ondrej Aubrecht | Enterprise Database Administration Deployment | Can really Naming Convention and standards save your environment ? |
| 16:00:00 | Ricardo Estrada | BI Platform Architecture, Development Administration | ¡Cross Selling con SQL Grafos! |
| 16:00:00 | Edwin Martinez | BI Platform Architecture, Development Administration | PowerBI Embedded First Steps |
| 16:00:00 | Jose L. Rivera | BI Information Delivery | Power BI Composite Models |
Event Date: 10-10-2020 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-10-2020 - Session time: 09:00:00 - Track: Application Database Development
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.
Event Date: 10-10-2020 - Session time: 09:00:00 - Track: Application Database Development
• SQL Server 2019 on containers and Kubernetes(k8s) from zero
• Install and Configure Docker on Windows Server
o Download and Install the Docker-Microsoft PackageManagement Provider
• Install and Configure Docker on Ubuntu Linux
• The Docker Ecosystem
• Managing and Administering Containers
• Persisting Data
• Working with SQL Server on Linux and Windows
• Creating Custom SQL Server on Windows\linux Container Images .
• Docker Networking for SQL Server DBAs
If time permits :
• What Is k8s?
o k8s internal and Objects
o k8s Deployment Options
o Deploying SQL Server on k8s
o SQL Server High Availability on k8s
o Updating SQL Server on k8s
o Using Helm Chart
o SQL Server Availability Groups on k8s
This is a demo session only with minimum theory lessons from the
Event Date: 10-10-2020 - Session time: 09:00:00 - Track: Analytics and Visualization
Event Date: 10-10-2020 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 10-10-2020 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
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.
Event Date: 10-10-2020 - Session time: 10:15:00 - Track: Analytics and Visualization
Event Date: 10-10-2020 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 10-10-2020 - Session time: 11:30:00 - Track: Cloud Application Development Deployment
Event Date: 10-10-2020 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
In this session, we will look at how to configure your SQL Server Instances using PowerShell and the dbatools module. Then we will look at how to use dbachecks to confirm the configuration of our instances and how to check for changes in the future of the configuration.
Attendees will see how easy it is to use PowerShell via dbatools to configure their SQL Server instances. Attendees will see how easy it is to use PowerShell via dbachecks and PowerBI to see if their servers are configured properly. Attendees will be given a set of scripts that take back to use to configure and test the configuration of their SQL Server instances.
Event Date: 10-10-2020 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
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
Event Date: 10-10-2020 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 10-10-2020 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-10-2020 - Session time: 13:30:00 - Track: Analytics and Visualization
Event Date: 10-10-2020 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Deepthi will show you how the SQL engine thinks – enabling you to think like it!
Event Date: 10-10-2020 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-10-2020 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
What you'll learn
Choosing a massively parallel processing architecture for a cloud-based data warehouse. Designing tables and indexes to efficiently distribute data in tables across many nodes. Loading data from a variety of sources, querying using PolyBase, securing and recovering data, and integrating into Big Data environments.
Event Date: 10-10-2020 - Session time: 14:45:00 - Track: Professional Development
This session will cover key concepts in DEI and how they apply to data practitioners.
Event Date: 10-10-2020 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-10-2020 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 10-10-2020 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Do you really know how is your SQL instance, permissions and servers configured and why are you still missing strong and persistence naming structure and standards?
This session will be focusing on the Naming convention and standards in the infrastructure environment and how to apply it correctly, which also includes SQL Database objects.
Event Date: 10-10-2020 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Esta sesión está hecha para que nosotros los técnicos podamos entender el valor de esta tecnología y que tengamos parámetros de: ¿Cómo? ¿Cuándo? y ¿Por qué? incluirlos entre nuestras bases de datos transaccionales. El código de las demos estará disponible al final de la sesión para el uso de discrecional de los participantes en sus trabajos, proyectos, experimentos o aprendizaje. ¡Los esperamos! fb: SeHablaSQL
Event Date: 10-10-2020 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-10-2020 - Session time: 16:00:00 - Track: BI Information Delivery