18
Oct
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 inside a FarPoint vaS...
SQL
02
Oct
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 j...
02
Oct
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: Numbe...
29
May
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 encoun...
29
May
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 needed the paren...
19
May
How to Fix ORA-00959 Table Space Does Not Exist in Oracle?
I was sure my script was fine. I copied it into Oracle SQL Developer, pressed Run, and watched the log… then Oracle yelled:
Error Co...
19
May
How do I Fix Codeigniter Database Error in SQL
I still remember the first time I hit Log In on my brand-new CodeIgniter app and, instead of a warm dashboard, MySQL slapped me with th...
12
Apr
How to Fix a Syntax Error in MySQL Workbench?
If you've been working with MySQL and are encountering errors in MySQL Workbench, don't worry you're not alone. I'll walk you through t...
27
Feb
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: t...
27
Feb
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 frustrat...