LALeonardo AboinDatabase lab notes

Database administrator · Campinas

What each application does, on a page a client can try.

Multi-DB Studio is a Java workbench for PostgreSQL, MySQL, SQL Server, MongoDB and Apache Geode. SQL Enhancer is a T-SQL bench on Azure SQL and SQL Server on Kubernetes. The reliability lab is the platform under both.

SQL Enhancer hubLive capture
SQL Enhancer with the object explorer, a SELECT, and the result pane.

Three applications

Each manual names the screen, says what that screen is for, and gives one thing to try. None of these is a client engagement.

01 · Public app

Multi-DB Studio

One Java workbench for six database engines.

I use it to practice diagnostics, maintenance and moving a table between engines that do not share a type system. A reviewer can open the public app and try the explorer, the console and a connection test without me in the room.

  • Connections
  • Object explorer
  • SQL console
  • Session monitor
Read the manual

02 · Public app

SQL Enhancer

A T-SQL bench with two live SQL Server targets.

The public app talks to Azure SQL and to SQL Server on Kubernetes at the same time. You write a statement, ask for an estimated plan, and switch the target. The interface is in Portuguese.

  • Two targets
  • Object explorer
  • Editor
  • Plans and I/O
Read the manual

03 · Private network

Reliability lab

The platform under the other two applications.

Virtualization, two small Kubernetes distributions, backups, failure drills and a monitoring stack. There is no public URL, and there should not be one.

  • Proxmox
  • pfSense
  • Kubernetes
  • Data services
Read the manual

Paid work, briefly

The labs are practice. The employment is the production record.

  • Kyndryl, 2022–2024. SQL Server for large corporate estates. I took part in a multi-hour recovery of two billing databases after an accidental deletion.
  • The Methodical Group, 2024. SQL Server, PostgreSQL and MySQL on AWS and Azure, with a US team.
  • Microsoft certifications. DP-300 (Administering Microsoft Azure SQL Solutions), DP-900 and AZ-900. Issue dates stay on the certificates. I do not invent them here.

A fifteen-minute read

If you are deciding whether to interview me, this is the path.

  1. 1

    Open Multi-DB Studio

    Test a connection, open a table, then the session monitor and a maintenance action. The Geode grid is mid-move from host AG2 to host AG.

  2. 2

    Use SQL Enhancer on this site

    The manual embeds the running bench: Azure SQL and SQL Server on Kubernetes, an editor, an estimated plan and the result tabs.

  3. 3

    Read what the lab will not claim

    The reliability note names backups, drills and dashboards. Terraform, RDS for PostgreSQL and Aurora stay on the study list.