All articles

Keep an eye on your SQL Agent jobs using T-SQL!

Introduction: A couple of weeks ago I had a customer who was interested in monitoring the duration of some of his SQL-Agent jobs. The jobs were running in a data warehouse environment and were executing some ETL processes for(…)

CloudNativePG – Scaling up and down

By now, if you followed the previous posts (here, here, here, here and here), we know quite a bit about how to(…)

CloudNativePG – The kubectl plugin

As we’re getting more and more familiar with CloudNativePG, now it’s time to get more information about our cluster, either for monitoring or troubleshooting purposes. Getting information about the general state of our cluster can be easily done by(…)

M-Files, Migrate Vaults to a High Available environment

If you read my previous blog, you know why I’m doing a migration 🙂 If not let’s explain it a bit, since 1 year I play with M-Files using an VM in the cloud,(…)

PosgreSQL + SQL Server = WiltonDB – Part 2 – Database Management

Few months ago I write about WiltonDB and how to install it. Now, I move one step forward with the Database Management. How to create a Database ? I test first with the T-SQL Command CREATE(…)

Oracle Forms: FRM-92290 after upgrade to 12.2.1.19

We are frequently involved in Oracle Fusion Middleware Forms and Reports installation or upgrade. For one of our customers, I upgraded Oracle Forms from version 12.2.1.4 to version 12.2.1.19, and this time I got an unusual issue...

Plotting SQL Server Performance counters with Python

As a consultant, I often use Performance Monitor (Perfmon) to collect performance metrics for SQL Server. After running Perfmon for, say, a week to capture a baseline of server activity, you can end up with(…)

CloudNativePG – PostgreSQL extensions

Now that we know how we can configure the PostgreSQL instance and access control, we’re going to look at what you can do when it comes to PostgreSQL extensions with CloudNativePG. As we have a(…)

CloudNativePG – Configuring the PostgreSQL instance

In the last post we’ve created a more detailed version of the cluster definition for CloudNativePG. This gave us a PostgreSQL cluster with enabled data checksum, the correct locale, an increased size of the WAL segments and the(…)

M-Files IMPACT Global Conference 2024 – Last Day

The last day of the conference The last day of the M-Files IMPACT Global Conference 2024 was full of customer presentations and the closing notes of course. One topic was really interesting to me, and I guess it will(…)