All articles

SQL Server connectivity issue – troubleshoot TLS configuration

In the blog post, I will share a case of troubleshooting a connectivity issue with SQL Server. The problem occurred in a migration context. The SQL Server databases (in version 2008 to 2014) from multiple applications were consolidated on a(…)

temBoard on SLES15 – 2 – The agent

In the last post we've installed the temBoard repository and the UI. As this alone is not so much fun, we'll be installing the temBoard agent on another SLES 15 machine in this post. We'll end up(…)

Rename your DB clone completely

Introduction Have you ever renamed your database? When you cloned a DB, you probably started it with a new name and cloning (duplicating) with RMAN provided a new DBID, right? So why should we need to rename a(…)

SQL Server – Contained Database

Introduction You may have encounter already case when an application offers the possibility to create and maintain SQL database users and consequently the associated SQL Server instance logins. That’s of course not especially really what a DBA likes, loosing control(…)

temBoard on SLES15 – 1 – The WebUI

During our last SwissPUG online meeting there was a presentation about monitoring PostgreSQL with temBoard. A question that came up afterwards was: How to install that on SLES 15 as there(…)

Clone a Terabyte Database in Seconds

Introduction Have you ever cloned a database using RMAN? Have you ever gotten the advice not to clone during daytime to avoid performance downgrade on the entire storage or network? For a proof of concept, we wanted to(…)

Some Artificial Intuition in Oracle SQL_ID?

By Franck Pachot . This post is something I discovered by chance when writing about tagging SQL statement with recognizable comments. We know that Oracle is introducing more and more artificial intelligence and machine learning in the database engine,(…)

Automating Linux patching with Ansible

Since the beginning of the year, several vulnerabilities have been discovered in the Linux Kernel as well as in others important and widely-used packages. Among them, there was the famous CVE-2021-3156 affecting the sudo package and allowing(…)

SQL Server: Create a Shared Storage for your Failover Cluster LAB

I’m currently working on the migration of a Failover Clustered SSAS instance from Windows Server 2012 to Windows Server 2019. The context is quite complex and in order to choose the right migration scenario I need to play with it(…)

Oracle Java Virtual Machine included in Oracle Database license ?

Introduction A customer of mine asked me a licensing question regarding the usage or Oracle Java (OJVM) in an Oracle database.  Basically this customer have an Oracle Database Standard Edition License and would like to use Oracle JVM in order(…)