Juan Moreno Romo
Microsoft, Support Escalation Engineer, SQL Server Core EMEA
Madrid, Spain
Actions
I born in IT as a developer. I worked in Data Modelling, as Consultant, Software Architect and Project Manager in a Consultancy Service Company, what leads me to create my own Consultancy Company. I worked on it for almost 15 years till an awesome company, Microsoft, knock my door.
I have delivered training in Developing Technologies, Programming Methodology, Software development process, ALM, different programming languages, Project Managing, Data Modelling, MySQL and SQL among other subjects
Currently I am happily working in Microsoft, based in Madrid (Spain), focused in SQL Server Business as Support Escalation Engineer for SQL Server Core in EMEA.
Links
Badges
Area of Expertise
PowerBI, DirectQuery and SQL Server. It is a good choice?
You will learn best practices, tips and tricks on how to successfully use SQL databases (OnPremise,IaaS, PaaS,SQL Managed Instance) with PowerBI on production environments.
How improve the performance, using for example, Read-Scale, HyperScale or Synapse, partitioning, ColumnStoreIndexes, Indexed views, etc..
How to monitor and diagnostic your database and find out issues with Query Data Store. These learnings are fruit of Microsoft CSS support cases, and customer field engagements.
Attention Contention!!!
In this session we will discuss about tempdb contention in SQL Server on-premises, Azure SQL Managed Instance and Azure SQL Database. We will analyze both, Allocation Contention and Metadata contention, describing in detail WHEN and HOW it occurs, How to diagnose it, Best Practices and how to prevent it. The session will have both approaches in on-premisses and in Azure Managed Instance: - Theoretical, to understand what and why it occurs. - Practical, with examples causing it, offering alternatives to solve it and to prevent it.
How to get the most from Azure SQL Database
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.
Monitoring SQL Server: from on-premises to Azure
Have you ever wonder how can you monitor your SQL Server no matter if it is on-premises or on Azure?
In this session we will show you the tools and techniques you could use to monitor your SQL Server environment, nevertheless where it is located on-premises or in Azure.
We will go through DMVs, Wait Stats, Performance Counters, Extended Events, Query Data Store, Management Studio, Azure Portal, SQL Azure Diagnostics, SQL Auditing and more...
We want to share with you what we have learnt from support cases and how we, Microsoft CSS, use these tools to help customers monitor and improve the performance of their SQL Server environments
Solving problems with the Azure Swiss Tool for SQL
Have you wondered how challenging is to monitor an Azure SQL Database? Actually, it is not that hard. But, what about dealing with 100 databases inside an elastic pool for a business-critical environment?
No matter how big your environment is, you need to go strategic with your monitoring technics and we want to share with you the lessons learned from support and architecture teams at Microsoft.
In this session you are going to see how real case scenarios behaves and how a DBA could react taking advantage of Azure Portal, Log Analytics, Azure Monitor, DMVs, PowerShell, etc. while you see live the changing operations in Azure Databases.
Query Store and Copilot, who is the fairest in the land?
Query store, which is the baddest query in my instance.
On-premises or Azure, it doesn't matter, Query Store will help you finding out how your queries are performing.
Get your performance to the next level knowing how to digg into Query Store data. Understand how it works, and how you can use Query Store data to solve performance issues and detect problems before they create a situation.
Do you want to know how to mine Query Store: plans, queries?
Learn how to get the best of it in an instance with several databases.
Based on Microsoft support experience, using Query Data Store and Microsoft Azure Copilot.
Query Store and Azure SQL Copilot, who is the fairest in the land?
Query store + Azure SQL Copilot, which is the baddest query in my instance.
On-premises or Azure, it doesn't matter, Query Store will help you finding out how your queries are performing.
Get your performance to the next level knowing how to digg into Query Store data. Understand how it works, and how you can use Query Store data to solve performance issues and detect problems before they create a situation.
Do you want to know how to mine Query Store: plans, queries?
Learn how to get the best of it in an instance with several databases.
We will also discuss the available options for troubleshooting using Azure SQL Copilot
Based on Microsoft support experience.
No encuentro donde esta el problema de la query
Muchas veces recibimos casos en soporte de Azure SQL Database donde nos indican que al ejecutar la query en la base de datos de producción tarda más que en la base de datos de preproducción con las mismas características de base de datos.
En esta charla explicaremos una serie de pasos que seguimos para encontrar cuál es la razón de este diferencia e intentaremos arreglar el entuerto.
Mastering Elastic Database Pools: Best Practices and Troubleshooting from Microsoft Support
Join us for an in-depth exploration of Elastic Database Pools, the game-changing technology that empowers developers and DBAs to efficiently manage and scale their databases. In this session, we'll delve into best practices and strategies for leveraging Elastic Database Pools to optimize your workload management and improve performance.
Drawing from real-world support cases at Microsoft, we'll demonstrate the significant impact and benefits of using Elastic Database Pools in various scenarios. Our talk will also cover essential troubleshooting techniques to identify and resolve incidents effectively.
Plus, don't miss our live demos showcasing practical examples and code in multiple programming languages. Whether you're a seasoned developer or a DBA looking to enhance your toolkit, this session is tailored for you! Gain valuable insights, practical tips.
Leveraging OpenAI in SQL Server Database Management
In the evolving landscape of database administration and development, the integration of advanced AI tools offers unprecedented opportunities for efficiency and innovation. This talk delves into the practical applications of OpenAI in key areas of database management, primarily focused on SQL syntax generation, automated scripting for test cases, the creation and management of extended events, and analysis of wait statistics.
Querying with AI is a fascinating topic that involves using artificial intelligence to optimize queries and automate resource management. There are many ways to use AI to enhance query performance,
Lessons Learned from the Trenches: Connectivity and Performance Tips&Tricks
In this session we are covering the troubleshooting steps that, as support engineers in Microsoft, we're doing to detect an performance and connectivity issue in a .NET application. We are going to cover the two main steps:
• Best Practices and debugging techniques we are going to debug the application to identify the module that is causing the performance and connectivity issue.
• Second as our application is connecting to Azure SQL Database, we are going to identify what is the query that is causing this performance issue.
High Availability
A trip digging on the most important SQL Server High Availability solutions. We will discuss and analyze their features, how to monitor it and how troubleshooting common issues.
We will travel from On-premises to Azure solutions visiting also hybrid solutions.
All you ever wanted to know about SQL Server High Availability.
Back to the future - Migrating our SQL Server OnPremise Database to Azure
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?
Azure SQL Journey: The daily routine of a Cloud DBA
In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database and SQL Managed Instance on production environments and how the DBA job changed versus administrating SQL Server.
You will learn how to monitor and improve Azure SQL Database query performance.
It will cover how to use Query Store, Extended Events, DMVs and Azure Monitor SQL Insights to help monitoring and improving 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.
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
Attention Contention!!!
In this session we will discuss about tempdb contention in SQL Server on-premises, Azure SQL Managed Instance and Azure SQL Database. We will analyze both, Allocation Contention and Metadata contention, describing in detail WHEN and HOW it occurs, How to diagnose it, Best Practices and how to prevent it. The session will have both approaches in on-premisses and in Azure Managed Instance: - Theoretical, to understand what and why it occurs. - Practical, with examples causing it, offering alternatives to solve it and to prevent it.
Ask the Experts
Stop by the Ask the Experts booth in the Expo Hall to engage in one-on-one conversations with subject matter experts - our speakers! Participants can sit down with an expert and receive immediate answers or feedback to their questions on a specific topic of interest. These discussions provide a unique platform for attendees to tap into the knowledge and expertise of industry professionals, fostering meaningful conversations and promoting learning in a personalized and accessible manner.
A Hybrid SQL Journey: The daily routine of a Hybrid DBA
In this session you will learn the best practices, tips and tricks on how to successfully to successfully manage on premises and Azure SQL Server environments and how the DBA job changed.
It will cover all the tasks you face in your daily job administrating on-premises, cloud and hybrid environments, helping monitoring and improving query response times when running your databases in any of these environments.
These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.
Data Saturday Gothenburg 2025 Sessionize Event
Copilot Days 2025 Sessionize Event
#DataWeekender 7.0 Sessionize Event
SQL Konferenz 2025 Sessionize Event
DataSaturday Madrid 2024 (SQLSatMadrid) Sessionize Event
Global Azure 2024 - Spain Sessionize Event
Global AI + Power Platform Bootcamps 2024 Lisboa Sessionize Event
Future Data Driven Summit 2023 Sessionize Event
Data Saturday Edinburgh Sessionize Event
Global Azure 2023 - Spain Sessionize Event
Global AI + Power Platform Bootcamps 2023 Lisboa Sessionize Event
Data Saturday Parma 2022 Sessionize Event
Granite State Code Camp 2022 Sessionize Event
Global AI Developer Days 2022 Lisboa Sessionize Event
Data Saturday Sofia 2022 Sessionize Event
NetCoreConf Barcelona 2022 Sessionize Event
Data Saturday Gothenburg 2022 Sessionize Event
SQLDay 2022 Sessionize Event
Global Azure 2022 Sessionize Event
DeveloperWeek Europe 2022 Sessionize Event
Virtual NetCoreConf 2021 Sessionize Event
Virtual NetCoreConf II 2020 Sessionize Event
CFS - Global 2020 Summer Azure DataFest Sessionize Event
Microsoft Techdays 2020 Sessionize Event
NetCoreConf Valencia 2020 Sessionize Event
NetCoreConf Barcelona 2020 Sessionize Event
Data Relay 2019 Sessionize Event
Juan Moreno Romo
Microsoft, Support Escalation Engineer, SQL Server Core EMEA
Madrid, Spain
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top