Jose Manuel Jurado Diaz

Information & Communications Technology

Madrid, Spain

Jose Manuel Jurado Diaz

Microsoft

José Manuel Jurado currently works as SQL Support Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 15+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events as SQL Saturday, SQL Nexus, 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.

Current sessions

Azure SQL Database - Lessons learned from the trenches

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


Back to the future: Moving on your database from On-premise to Cloud and go back?

This pre-con provides you the knowledge and tools necessary to understand the capabilities and usage of different solutions using SQL Server on Azure. It will help you get familiar with the Azure SQL Database concepts, Managed Instance, Infrastructure as a Service (Virtual Machine) using Windows or Linux, and, if you want, go back to On-premise.
It will also help to learn how to synchronize the data using different tools like Data Sync or Replication, between different SQL Server database solutions. After attending this pre-con, you will be able to:
• Understand what are the different features that you have to initiate the migration.
• Know the newest and most important features to manage your SQL Server.
• Design Disaster Recovery plans
• Face a migration project


MySQL & PostGreSQL as PaaS on Azure

Are you exploring Azure Platform as a Service for your MySQL and PostgreSQL databases?

if the answer is yes, please, come and review with us
all the options we have available for these two products in Azure.

We are going to cover options like Migration, Performance, Connectivity, Cost, High Availability, Backups, Security to better understanding the expectations for these product in Azure.


Ya tengo la nube, pero ¿ahora cómo lo migro?

En esta sesión cubriremos los principales aspectos para migrar a una de las diferentes arquitecturas disponibles para SQL Server en Azure desde SQL Server OnPremise.

Haremos un resumen de las opciones disponibles para IaaS, PaaS (incluyendo Managed Instance) y SQL Datawarehouse.

Mostraremos las mejores prácticas y herramientas para migrar nuestros datos a la plataform elegida.

Y después de la migración, resolveremos preguntas pendientes como:
++ ¿Puedo mantener mi base de datos sincronizada con mi entorno OnPremise?
++ ¿Qué nuevas opciones de alta disponibilidad tengo?
++ ¿Cómo puedo controlar el rendimiento de mi base de datos?


Connecting and securing a Azure SQL Database from Developer view - Best Practices

Did you have issues connecting to your Azure SQL Database?
Do you know that some features of Azure SQL Database could save a lot of time in your work as developer?
These and others questions will be resolved in our session, always from the developer perspective.


Could Azure SQL Database help me in my Data scientist role? The answer is.....Yes! Of course!

We are going to cover several topics to show you how Azure SQL Database will help you in your data scientist role:

++ How Premium RS is designed for your IO-intensive analytical workloads.
++ Microsoft R capability.
++ Our new database model: Managed instance.
++ What are Azure SQL Datawarehouse database model or Azure Data Factory feature?

Finally, we are going to share with you some lessons learned from the field working on support cases related with data scientist customers:

++ Automatic scaling up/down the database.
++ Faster loading data.
++ How to find out the expensive queries or how to use indexed views.


ADW - Que me pasa, doctor?

How to track, understand and resolve performance issues on ADW


Move your database to the Cloud: Understand, Design, Migrate, Manage, and Monitor Azure SQL Database

This Azure SQL Database pre-con provides you the knowledge and tools necessary to understand the capabilities and usage of cloud databases. It will help you get familiar with the Azure SQL Database concepts. It will also help to learn how to migrate, manage, monitor and troubleshoot your Azure SQL Database solution. You will learn the difference between the Azure SQL Database (PaaS) and SQL Server on-premises and which benefits Azure SQL Database can have for your applications and SQL environment. After attending this pre-con, you will be able to:
• Understand how Azure SQL Database works
• Know the newest and most important features to manage your Azure SQL Database
• Design scalable architectures
• Design Disaster Recovery plans
• Manage security on your Azure SQL Database
• Monitor and troubleshoot Azure SQL Database
• Face a migration project


Azure SQL Managed Instance - Experiencies from the Field

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Managed Instance on production environments. You will learn how to monitor, configure, restore, backup, VNET, NGS, created a replication environment, etc for Azure SQL Managed Instance. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.