All articles

SQL Server CPU limitation for Express and Standard Edition

Introduction When performing an audit on an SQL Server VM the first thing the system administrator told me was that there’s no issue with the CPU on this box, the monitoring shows it’s always around 50% usage. Problem Here is(…)

SQL Server: Get email notifications for Error Log entries

Introduction In a previous blog post, I did a T-SQL script reading Audit files to send emails with valuable information about instance changes. In this one, you will see how to get nice emails from critical errors or(…)

Pass a variable to a trigger in PostgreSQL

By Franck Pachot . With Oracle there are many ways to set a state in the session: context variables, set with DBMS_SESSION.SET_CONTEXT and retrieved with SYS_CONTEXT, or package global variables, or global or private temporary tables with ON COMMIT(…)

SQL Server: How to delete the msdb backup history kindly

This week I noticed some slowness on queries related to backup history. The instance had a huge msdb database (more than 10GB size), the backup history had never been purged. I already wrote a post on this topic and(…)

Maven: Could not find or load main class org.codehaus.plexus.classworlds.launcher.Launcher

Working on Jenkins and Artifactory I often seen options suggesting Maven tool,but what is Maven purpose?How can we use and install it on a Windows system?During this install you may encounter some kind of issues Introduction Maven is a tool(…)

SQL Server: Replace the old SCOM login by the new one

It’s every time hard to replace a login who as role and permissions in every database like the service account for SCOM. In the previous version of Scom, you create a service account (dbiscom) to access the SQL Server(…)

Documentum – SSL Certificate based secure communication setup

Around four years ago, I did a few presentations, here, in Switzerland about “Security & Documentum”. In there, I talked about a lot of different subjects related to both security and Documentum (you guessed it…) like: ciphers, SHA, FIPS &(…)

Documentum – Configuration of an IDS Target Memory/RAM usage on Windows

A few months ago, I had to work on a Windows Server to setup an IDS Target. The installation and configuration of the target wasn’t that different compared to a Linux host, so it wasn’t difficult at all (if you(…)

DynamoDB / Aurora: sparse and partial indexes

By Franck Pachot . In a previous post I tried to build a glossary about Amazon DynamoDB terms that look like relational database terms, but with a different technical meaning. Here is more about it. If(…)

JENKINS : Update manually your Jenkins master

Hi there, What about keeping up to date your Jenkins 🙂 Such easy to perform that!Today we will check the manual update of our Jenkins master Check if updates are available You can see that(…)