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

vaSpread: Can You Populate FarPoint Spread 6.0 from a SQL Query

I ran into a very old but gold situation: I needed to show a SQL Server report exactly as it appears in SSMS, but...

How to Fix GitLab CI Not Fail When There Is an SQL Error

In a GitLab CI/CD pipeline, it's crucial to ensure that jobs fail correctly when SQL errors occur. However, the default behavior of a job...

How to Create a Foreign Key in SQL Server

I have been there: I copied a Postgres style foreign key into SQL Server, hit Run, and SQL Server clapped back with: Msg 8139: Number...

How I Fix PowerShell Generic ExecuteNonQuery SQL Error My Scripts

When working with SQL Server from PowerShell using the Microsoft.SqlServer.Management.Common.ServerConnection object, I've often encountered vague error messages when a SQL script fails. I'm going to...

How I Fix MySQL Error 1442 When Update a Parent Product Price from a Trigger

Recently, I was working on a project where I had to update a product’s price, and if that product had a parent item, I...

12 3 Page 1 of 3