Ozzie.eu

Ozzie.eu

Love to code although it bugs me.

31 Jan 2023

This is why you're not better off with a commercial database

When tackling a new enterprise project to support a given business, you face the challenge of choosing and committing to a database platform. The choice should be the one most adequate, given the needs and requirements of the new information system and data to be hosted and managed.
02 Dec 2022

MySQL vs MariaDB: Performance on Bug Management

Cleaning up the e-mail inbox, I discovered a 7-year-old bug report I made on the MySQL bugs database: Bug #79497. Someone verified it on the …
03 Nov 2022

ORA-01704: string literal too long

On an Oracle database with a table storing long strings as BLOB/CLOB, you might get an ORA-01704 error trying to perform manual updates.
21 Oct 2022

Award on Better Governance through Procurement Digitalisation

Four years ago, I was the technical lead in the development and support team for the Portuguese Public Contract Register. The platform won …
27 Jun 2022

Better Powershell SQL comand exection using Dbatools

Recently I chose to develop a quick batch solution, for working with SQL Server databases, using Powershell and the Invoke-SqlCmd cmdlet. I was faced with unexpected errors. After quick workaround on the code, I was able to get things done. However, recently I got to redo the batch resulting on a more performant solution. The key to this was the Invoke-DbaQuery Cmdlet.