Database Administration & Monitoring

Install PL/JAVA in PostgreSQL 9.5.1

Some time ago I blogged about how to install PL/JAVA in Postgres Plus Advanced Server 9.5. This resulted in an interesting comment from the maintainer of PL/Java. After(…)

Configurer les “Bonnes Pratiques” de Windows Server avec PowerShell

PowerShell est un outil en ligne de commande dorénavant intégré à tous les environnements Windows. Cet outil est extrêmement puissant, et avec le vent en poupe, puisqu’il permet de simplifier l’exécution et l’automatisation des tâches de configuration et d’administration.

LVM : How to extend a Volume Group

In this article we’ll going to explore on how to extend a partition which resides in a Logical Volume. LVM (Logical Volume Manager) is a great tool for managing your storage devices on a Linux host. Lets(…)

Linux quick tip – What is the local time in Kolkata?

Quite easy if you know how to do it from the shell (I didn’t know it 🙂 ): dwe@dwe:~$ TZ='Asia/Kolkata' date Tue Mar 22 19:12:25 IST 2016 You can use “tzselect” to list the available combinations and get the local(…)

RAC to RON then RON to RAC and singleton service

By Franck Pachot . You will probably never do it, but let's imagine you have a RAC database, policy managed, with singleton service. Then you convert it to RAC One Node and you change your mind and convert it back(…)

SQL Server 2016: new database-scoped configuration parameters part 2

In this blog post, let’s continue with other database-scoped options shipped with the SQL Server 2016 RC0. We will first begin with the first one and my preferred option: setting the MAXDOP value for(…)

SQL Server 2016: new database-scoped configuration parameters

Do you remember new capabilities shipped with SQL Server 2016 CTP2 about tempdb? In this blog post, I talked about well-known trace flags 1117 and 1118 that become useless for tempdb because their related effects are(…)

RMAN 12c Push and Pull duplicate explained

By Franck Pachot . Oracle Database 12c introduced the 'restore from service' where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking(…)

Getting started with Ansible – Preparations

When your infrastructure landscape becomes larger and larger you definitely need a tool which helps you in managing your servers, no matter if pḧysical or virtual, running in the cloud or not. One tool (many others are around) which assists(…)

Windows Containers: Migration

In my last blog post (here), I explained how to configure a host for Windows Container as well as how to use some Windows Container cmdlets. Finally I demonstrated how to create a container with a SQL Server 2014(…)