Database Administration & Monitoring

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(…)

SQL Server vs MongoDB: When the cloud is your adversary (Always Encrypted vs Queryable Encryption)

When the cloud admin is the threat: how SQL Server and MongoDB let you query encrypted data, and what each approach costs.

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(…)

SQL Server: Automatic index compaction in Azure (preview) – Part 2

Why does index fragmentation matter less than before ? Logical fragmentation was a problem on spinning disks: an ordered scan on a fragmented index broke the read-ahead into smaller I/Os and each jump cost a disk head movement.

SQL Server: Automatic index compaction in Azure (preview) – Part 1

For years, we have all scheduled the same thing on our SQL Server environments: a nightly or weekly index maintenance job. We check the fragmentation level, we run a REORGANIZE between 5% and 30%, a REBUILD above 30% and(…)

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(…)

When an idle transaction starves the worker pool (THREADPOOL)

How a forgotten transaction exhausted SQL Server's worker pool, triggered THREADPOOL waits, and only DAC could fix it.