Database Administration & Monitoring

AWS Automation – Stop a RDS instance

Introduction I created a RDS SQL Server instance on AWS. I use it for test purpose and to minimize the costs I needed to ensure that my instance is stopped automatically at the end of the working day and also(…)

DynamoDB: adding a Local covering index to reduce the cost

By Franck Pachot . This is a continuation on the previous post on DynamoDB: adding a Global Covering Index to reduce the cost. I have a DynamoDB partitioned on “MyKeyPart”,”MyKeySort” and I have many queries(…)

DynamoDB: adding a Global covering index to reduce the cost

By Franck Pachot . People often think of indexes as a way to optimize row filtering (“get item” faster and cheaper). But indexes are also about columns (“attribute projection”) like some kind of vertical partitioning. In relational (“SQL”) databases(…)

About temp_tablespaces in PostgreSQL

There often is a discussion if tablespaces should be used in PostgreSQL. People used to work with Oracle are often a bit surprised by this discussion as there is no way around using tablespaces in that technology. PostgreSQL does not(…)

Upgrading SUSE Linux Enterprise online

One really good feature from SUSE Linux Enterprise (SLE) is that it allows you to upgrade from your running system to a new service pack online. Let's say from SLE 12 SP3 to SLE 12 SP4. No new installation is(…)

Collations in PostgreSQL – basics

When you work with databases sooner or later you will need to get in touch witch collations. It might be that you never needed to think about it as initdb picked a(…)

SQL Server: Collect Page Split events using Extended Event session

Earlier this week someone tried to show me how to capture page split events using Extended Events (XE) but unfortunately, the demo failed. This is a good opportunity for me to refresh my knowledge about page split and set up(…)

After login as administrator to the WebLogic console, impossible to run administration action

For a few weeks I was faced with a problem that I had never encountered before. On a Windows Server, browsing to the WebLogic Administration console, I was not able to do any modification or even check the monitoring screens.

WebLogic 12.2.1.4 software installation or upgrade, installs and configure Coherence cache in the domains

We are using silent installation to install WebLogic Server software based on a response file with “INSTALL_TYPE=WebLogic Server” but it looks like the coherence server is installed becuase when we start the WebLogic Server, the following can be seen in(…)

Java 1.8 Utility classes: XML, ZIP, BufferedImage and Download

When I write code, I usually need some utility classes to ease the development. So here I will share my most used classes. Hope this will help you as well! XML store and load I strongly use XML for storing(…)