Infrastructure at your Service

 
David Barbarin

Introducing Accelerated Database Recovery with SQL Server 2019

By | Database Administration & Monitoring, SQL Server | 2 Comments

SQL Server 2019 RC1 was released out a few weeks ago and it is time to start blogging about my favorite core engine features that will be shipped with the next version of SQL Server. Things should not be completely different with the RTM, so let’s introduce the accelerated database recovery (aka ADR) which is mainly designed to solve an annoying issue that probably most of SQL Server DBAs already faced at least one time:…

Read More
David Barbarin

Debugging SQL Server containers considerations

By | Database Administration & Monitoring, Docker, SQL Server | No Comments

When it comes to troubleshooting processes or to get a deeper look of how SQL Server works internally , I always used debugging tools as windbg on Windows and since SQL Server is available on Linux, I switched to strace tool. But let’s add containers in the game now. I didn’t want to touch any based image for applications including SQL Server with debugging tools added. So, my concern was to figure out how to…

Read More
Morgan Patou

Documentum – Encryption/Decryption of WebTop 6.8 passwords ‘REJECTED’ with recent JDK

By | Application integration & Middleware, Entreprise content management | No Comments

Recently, we had a project to modernize a little bit a pretty old Documentum installation. As part of this project, there were a refresh of the Application Server hosting a WebTop 6.8. In this blog, I will be talking about an issue that we faced in encryption & decryption of passwords in the refresh environment. This new environment was using WebLogic 12.1.3 with the latest PSU in conjunction with the JDK 1.8u192. Since WebTop 6.8…

Read More
Morgan Patou

Alfresco – Share Clustering fail with ‘Ignored XML validation warning’

By | Application integration & Middleware, Entreprise content management | No Comments

In a recent project on Alfresco, I had to setup a Clustering environment. It all went smoothly but I did face one single issue with the setup of the Clustering on the Alfresco Share layer. That’s something I never faced before and you will understand why below. Initially, to setup the Alfresco Share Clustering, I used the sample file packaged in the distribution zip (E.g.: alfresco-content-services-distribution-6.1.0.5.zip): <?xml version=’1.0′ encoding=’UTF-8′?> <beans xmlns=”http://www.springframework.org/schema/beans” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:hz=”http://www.hazelcast.com/schema/spring” xsi:schemaLocation=”http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd…

Read More
Jérôme Dubar

Useful Linux commands for an Oracle DBA

By | Database Administration & Monitoring, Operation systems, Oracle | 3 Comments

Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with Ctrl+C. And it’s even more useful with the – -diff parameter. All the differences since last run are highlighted. For…

Read More
Jérôme Dubar

Patching or reimaging your ODA?

By | Database Administration & Monitoring, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction One of the key features of the ODA (Oracle Database Appliance) is the ability to patch the entire stack every three months, the goal being to keep all the components up-to-date. Most of the customers won’t patch so often, but one patch a year is quite a good average. But when comes the time for patching, comes the time for anxiety for the DBA. And it’s totally justified. Why ODA patching can eventually be…

Read More
Daniel Westermann

EDB EPAS 12 comes with interval partitioning

By | Database Administration & Monitoring | No Comments

While community PostgreSQL 12 is in beta quite some time now (currently in beta 3) it usually takes some time until EDB EPAS will be available on top of the next major PostgreSQL release. Yesterday EDB finally released a beta and you can register for access here, release notes here. One of the new features is interval partitioning which you already might know from Oracle. Basically you do not need to create range partitions in…

Read More
Stéphane Haby

SQL Server 2019: Java in SQL Server hard to believe, no?

By | Development & Performance, DevOps, SQL Server, Technology Survey | No Comments

It has already been a few months that we are testing the next version of SQL Server: SQL Server 2019. I already blogged about a previous version of SQL Server supporting R and Python. With the new version of SQL Server 2019, Java will also be integrated. The Java runtime used is Zulu Open JRE and can be tested from the CTP3.2 of SQL Server 2019 Step 1: The installation Like a lot of people,…

Read More
Pierre-Yves Brehier

Feedback on the EMEA Red Hat Partner Conference 2019 in Prague

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

A few weeks ago I attended the Red Hat EMEA Partner Conference for the first time. The Red Hat Conference took place in Prague from June 25th to 27th. If you are interested in Open Source technologies and in Red Hat, feel free to read this personal feedback on trends at Red Hat and in the IT sector.

Read More