Database management

Archiving 5 TB from Oracle into SQL Server: a migration logbook (part 1)

Loading 5 TB from Oracle into SQL Server with SSMA: type overflows, heaps, and the settings that took 788 rows/s to 42,170.

Oracle LDAP Timeouts

Introduction, Setup You are using 2 or more LDAP servers for Oracle name resolution to be highly available? Do you kown what happens if an ldap server is down or not reachable? You probably expect that it tries the(…)

Setup an LDAP server for Oracle naming on Enterprise Linux 9

Introduction To centralise Oracle naming resolution, you can use an LDAP server. You can use the commercial products from Oracle like Oracle Internet Directory (OID) or Oracle Universal Directory (OUD). Alternatively, you can also use OpenLDAP from your Linux(…)

Fixing ORA-00904 on Oracle hidden columns during SSMA data migration

SSMA fails with ORA-00904 on Oracle SET UNUSED columns. Fix it with a custom select aliasing NULL, no source DDL required.

Green SQL Server DBA Tips #3 – The hidden cost of forgotten databases

How many times have I found, during a migration, that I also have to clean up the databases no more used?Why keep them for so long if we’re not going to use them? This is something we often(…)

PostgreSQL Snapshot Backup and Restore with Proxmox ZFS (4/4)

In the blog series I previously wrote, I did not answer all the customer’s questions. The last one was the following: Can this also be applied to PostgreSQL? In short, yes, it is possible. Let’s see(…)

SQL Server:  msdb is in Suspect State

This Monday morning, we begin our SLA Support with a customer call.He cannot do a select on a table in his database… After creating the Ticket, I connect to the instance and see that the msdb system(…)

Green SQL Server DBA Tips #2 – When logs and history records cause your database to growth and crash

How often do I come across this sort of problem when visiting clients? Even more with our customers’ service desk (support) SLAs. We turn up on a Monday morning and there are alerts from the weekend saying(…)

Green SQL Server DBA Tips  #1 – Are unnecessary indexes cluttering up your database?

This summer I start a series of blog posts on the ‘green SQL Server DBA’, as it’s a topic that continues to interest me and one that hasn’t been covered very much so far. I hope you’ll enjoy my(…)

Highly Available, Load-Balanced PostgreSQL with Patroni, HAProxy, and Keepalived

Patroni runs your PostgreSQL cluster and handles failover, promoting a replica the moment the primary dies and recording the change in its distributed store (etcd, Consul, or ZooKeeper). That part works on its own. Your applications still need(…)