Geovanny Hernandez
Merck - Senior Data Architect
Actions
Geovanny Hernandez is a Senior Data Architect, Microsoft Certified Trainer (MCT) and MCSE with more than fifteen years of experience in software development, passionate about Data Engineering and Data Architecture, and is involved in aspects like data modelling, performance tuning in Databases (MS SQL Server, PostgreSQL, etc), Python and Cloud technologies.
In addition, Geovanny collaborates as a speaker on different presential and virtual events around Europe and Latin America.
Links
Area of Expertise
Migrando estratégicamente nuestras Bases de Datos hacia Azure Cloud
Esta sesión se enfocará en el proceso de construir una sólida y consistente estrategia que nos permita migrar nuestras bases de datos on-premises hacia las mejores opciones en la nube de Azure.
Tomaremos como base un escenario donde utilizaremos MS SQL Server on-premises, a partir de este punto, haremos un recorrido sobre las principales etapas y objetivos que deben ser alcanzados para conseguir una migración exitosa. Iniciando desde la definición de la mejor opción disponible para nuestros requerimientos.
Finalmente, realizaremos una migración de una base de datos modelo, y explicare los aspectos fundamentales a tomar en cuenta en el proceso, incluyendo la post-migración.
Building a reliable Database Pipeline with Liquibase and SSDT
In this session, we are going to develop from scratch a fully functional approach for managing the development of changes on Azure SQL, keeping the principles of versioning and clean code.
Additionally, I am going to share a Python tool suite developed for helping Data professionals to automate the release of changes and control them through GIT.
Happy Journey = SSDT + Liquibase + GIT + Azure DevOps
Building a strategy for migrating our Database to Azure Cloud
This session is focused on the process of building a solid and consistent strategy that allows us to migrate our existing Database toward proper Azure Cloud offers.
We are going to take as a base a Microsoft SQL Server on-premise and walk through the main stages and milestones to be achieved for having a successful migration. It starts from setting up a baseline and determining the most convenient sort of option as a platform as a service (pass) or infrastructure as service (iass).
Finally, we are going to do a real-time migration of a sample Database and explain the interesting aspects to taking account as part of the post-migration process.
Aplicando Unit Testing en Visual Studio a nuestras Bases de datos SQL Server
Todos quienes hemos estado vinculados en el proceso de desarrollo en Bases de Datos hemos podido notar que tan desastroso puede ser un bug, especialmente cuando este tipo de bug o fallos pudieron ser evitados por medio del uso apropiado de pruebas unitarias. En esta presentación nos enfocaremos en como obtener un mejor rendimiento y mejores resultados a traves del uso de SQL Unit Test en Visual Studio, explicando la mejor manera de superar los principales retos asociadas al uso de Unit Testing y como un elemento adicional, estare explicando el uso de un framework de uso libre que desarrolle hace un tiempo atras (https://github.com/SimpleSqlUnitTesting/SimpleSqlUnitTesting)
Keeping your SQL Code safe – An introduction to GIT and SSDT for DB professionals
Imagine that you have been hard working in that amazing project, your SQL code has been tuned and contains new features and followed the standard that will be crucial for the success of this project. The deploy date has arrived and you have deployed early in the morning but some minutes after the deploy, the users started to call for reporting several issues in the different systems which are using the Databases that were part of your deployment, after stressful minutes, you realized some SQL code deployed were not the same that were tested and you must rollback your code.
In this session, I'm going to show you how to avoid problems derived of mistakes during the development process through the proper use of source control code strategy which can combine the potential of GIT and SQL Server Data Tools (SSDT) for managing latest version, detecting changes, code review and deploying through environment without stress.
Branching strategy for DB development: A practical case of GIT and Azure DevOps
Nowadays, the success of our projects is strongly tied to the quality of our processes, it doesn't matter how amazing our developers are and the last features that they are introducing into new projects if any new deployment is a random bet and it has a higher probability of failing on production. In the scope of Databases, the way that we managing the source code is extremely sensitive and the impact for the organization is so huge and could carry on devasting consequences.
In this session, I'm going to explain fundamental aspects of the branching strategy using a source control code tool as GIT for an efficient and agile workflow as so integrate this process with Azure DevOps from a development environment to Production.
First steps to go ahead with MS SQL Server on Linux
The Every beginning is difficult, but adopting the right strategy can mark the difference. In this session, I am going to share some of the most valuable lessons learned in my journey through the use of Linux as a platform together with MS SQL Server.
In this session, I will be explaining some fundamentals about Linux and subjects ranging from permissions to basic bash shell scripting and how we can use to maximize some routines and tasks on MS SQL Server, including the installation and configuration and practical examples and good practices for own mental health.
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