César Pedro Zea Gomez

César is a seasoned technology expert with over 35 years of experience in full-stack application development. As a renowned senior SQL Server expert, he specializes in optimization, development, migration, and business intelligence systems, delivering top-tier solutions to clients.

https://www.linkedin.com/in/cesarzea

6 Posts

How to Fix DBeaver’s Over Escaping Issue When Copying JSONB Data in SQL Inserts

If you’ve ever used DBeaver to clone database records containing JSONB data in sql, you might have encountered a frustrating problem: the tool adds...

How to Reuse a Calculated Column in SQL Server

If you’ve ever written a SQL query where you needed to reference a calculated column multiple times, you might have run into a frustrating...

How to Use the SQL COALESCE Function in SQL

Hi there! Today, I want to break down a common SQL scenario I’ve encountered while working with databases: concatenating multiple rows into a single string....

How I Fix a Slow MySQL Query by Tackling Full Table Scans

Have you ever stared at a sluggish MySQL query, wondering why it’s taking ages to fetch results? I recently faced this exact issue, and...

How to Fix SQL Queries with LEFT JOIN

As someone who has worked on SQL queries to analyze and manipulate data, I understand the frustration of running a query only to discover...

12 Page 1 of 2