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

14 Posts

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...

How to Fix SQL Error Invalid Parameter in Stored Procedures

I’ll walk you through the process of creating and enhancing a SQL Server stored procedure to analyze shipping data. We’ll start with a basic...

1 23Page 3 of 3