Infrastructure at your Service


Cloud Archives - Blog dbi services

Franck Pachot

Running SQL Server on the Oracle Free tier

By | Cloud, Oracle, SQL Server | No Comments

By Franck Pachot The Oracle Cloud is not only for Oracle Database. You can create a VM running Oracle Linux with full root access to it, even in the free tier: a free VM that will be always up, never expires, with full ssh connectivity to a sudoer user, where you are able to tunnel any port. Of course, there are some limits that I’ve detailed in a previous post. But that is sufficient to…

Read More
Stéphane Haby

One day training @ Microsoft Azure Cloud Workshop

By | Big Data, Cloud, Database Administration & Monitoring, Database management, SQL Server, Technology Survey | No Comments

Today, with my colleague Christophe, we follow the Microsoft Azure Training Day: Data and Analytics @ Microsoft Zürich (Wallisellen to be exact). After a presentation of SQL Server 2019, we begin with the First Lab about SQL Server 2019 and new features and we going through intelligent query processing, Data Discovery and Classification for personally identifiable information (PII) and General Data Protection Regulation (GDPR) and secure enclave. One of my favorites part of the lab…

Read More
Daniel Westermann

Deploying your own PostgreSQL image on Nutanix Era

By | Database Administration & Monitoring | No Comments

Some days ago we had a very good training on Nutanix. Nutanix is a Hyper-converged infrastructure and that means that all is software driven and the system can be deployed on many hardware configurations. I will not go into the details of the system itself but rather look at one component/module which is called Era. Era promises to simplify database deployments by providing a clean and simple user interface (and an API) that provides deployment…

Read More
Mehdi Bada

A day at DevOps World in Lisbon

By | DevOps, Docker, Kubernetes | No Comments

On this second day here at DevOps World in Lisbon, I built a very interesting and intensive program of sessions to attend which I will explain to you more in detail below. This was also the opportunity for us (Arnaud and I) to meet our main customer from whom we are working with Jenkins X each day. It is always interesting to be able to meet physically the people with whom we collaborate, even if…

Read More
Stéphane Savorgnano

How to create an Azure SQL Database

By | Cloud, SQL Server | No Comments

Azure SQL Database is a relational database-as-a-service (DBaaS) which gives us the possibility to create application with a performant database without to take care of the relying infrastructure. Azure SQL Database is based on the latest stable version of Microsoft SQL Server Database Engine. We have the choose between 2 purchasing models: a vCore-based purchasing model and a DTU-based (Database Throughput Unit) purchasing model. 3 Deployment options possible: single database: has its own set of…

Read More
Stephane Biehler

OpenText Enterprise World Europe 2019 – Partner Day

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

First day of the #OTEW here at the Austria International Center in Vienna, Guillaume Fuchs and I where invited to assist to the Partner Global sessions. Welcome to OTEW Vienna 2019 Mark J. Barrenechea, the OpenText’s CEO & CTO, started the day with some generic topics concerning the global trends and achievements like: More and More partners and sponsors Cloud integration direction Strong security brought to customers AI & machine learning new trend New customer…

Read More
Oracle Team

Create a primary database using the backup of a standby database on 12cR2

By | Database Administration & Monitoring, Database management, Oracle | One Comment

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in nomount mode. rman target / restore primary controlfile from ‘backup_location_directory/control_.bkp’; exit; By specifying “restore primary” , will modify the flag into the controlfile, and will mount a primary role instance instead of a standby one….

Read More
Nicolas Jardot

AWS re:invent 2018 – Day 5 – Final day

By | Technology Survey | No Comments

On Friday, it’s the last day for AWS re:Invent convention in Las Vegas. I didn’t know in advance what to expect because I have to admit that even if I started to use AWS, there is still a lot to learn. And that’s why I personally think working with technology is interesting, it’s always moving and there is always something new to investigate or learn. This morning, I attended a very interesting session about the life of…

Read More
Nicolas Jardot

AWS re:invent 2018 – Day 4

By | Technology Survey | No Comments

Thursday morning it’s time for the keynote from Dr Werner Vogels. A big part of the keynote was about databases again. Maybe AWS people knows that there are still lots of DBAs out there! It’s also again a focus on Amazon Aurora (relational), Dynamo DB (NoSQL) and AWS Redshift that are replacing Oracle databases Amazon was using. There was also a focus on how S3 works to maintain the best durability for the data. I’ve seen…

Read More