OptimaData is a full-service, multi-platform data(base) service provider

Gerard Zuidweg

Open Source DBMS Feel free to choose but choose wisely

Open Source Database Management Systems are on the rise. Not only among newtech companies, but now also in banks, government departments and multinationals. Recent research among CIOs has shown that more than 60 percent want to drastically reduce licensing costs. Opting for more open source software helps, if well-considered choices are made. The most important points to consider are shown below.

Points to consider Open Source DBMS

Edco Wallet

The OptimaData top 8 database events in 2019

Numerous international and national events, conferences, congresses and symposia will take place in 2019 on open source database platforms. Because of the wide range and often limited time and resources, it can be difficult to determine what you will or will not visit. We are therefore happy to give you a hand with this overview of the 8 most important and interesting database events in 2019. We are of course present at these conferences and we hope to meet you there too!

See the Top 8 Open Source DBMS Events

Martijn Wallet

PostgreSQL 12 is taking shape; these are the most important new features

Each year there a new version of PostgreSQL is released. That’s the moment in which many new features and improvements become available for all users. During the last PostgreSQL meetup in Amsterdam, Devrim Gündüz, major contributor and passionate PostgreSQL consultant, explained the upcoming release of PostgreSQL 12. In this blog we list the most important changes in PostgreSQL 12 for everyone who does not closely follows all the commits in Github or who did’nt have the opportunity to visit the PostgreSQL Usergroup NL meetup.

More about PostgreSQL 12

Edco Wallet

Will Open Source be sunk by its own success?

In addition to the well-known databases such as Oracle, MySQL or MS SQL, Open Source databases are developing at lightning speed. In fact, they’re developing so quickly that more and more companies will be using open source databases such as PostgreSQL or MongoDB in their IT infrastructure, and an increasing number of IT brokerage and recruitment agencies will start working with open source professionals. On one hand, that is a nice compliment for the Open Source Community, but on the other, there is also a danger: market forces threaten to undermine the principle of Open Source.

Read more

Craig Healey

Introduction to Oracle Enterprise Manager (OEM)

OEM is designed to allow you to administrate large numbers of databases, and it benefits greatly from a consistent and well-thought-out strategy that enables you to apply the same process automatically to groups of servers and databases. If you only have a few Standard Edition databases, then OEM is going to be overkill, and there are better third-party solutions available. But if you have hundreds of Enterprise Edition databases to monitor, backup and patch then it becomes cost effective.

Read more

Taco Zoetemelk

De talenknobbel van de Multi-platform databasebeheerder

Als databasebeheerder bij Tennet ben ik op het ene moment met een Oracle database bezig, het andere moment krijg je een vraag over een Microsoft SQL Server en het volgende moment komt er een incident binnen dat betrekking heeft op MySQL. En net zoals op vakantie wanneer je met mensen in verschillende talen spreekt, moet je goed opletten en de focus erbij houden om te voorkomen dat je talen door elkaar haalt. Toch is het voor mij als multi-platform beheerder prima te doen en de geestelijke switch is inmiddels in een fractie van een seconde omgezet.

Read more

Gijsjan Baars

Migreren van Oracle naar PostgreSQL hoeft geen maatwerk te zijn

Steeds meer grote bedrijven willen af van het licentiemodel van Oracle. Het is dan misschien de meest complete databaseoplossing, maar 99,99% van de bedrijven maak geen gebruik van al de functionaliteiten die Oracle biedt. Waarom dan nog betalen voor al die extra, meestal onnodige functies? Daarbij biedt de PostgreSQL-community vele ‘plug-ins’ die deze extra functionaliteiten kunnen vervangen. PostgreSQL is zo volwassen inmiddels, dat er eigenlijk geen reden is om nog Oracle te gebruiken. Het aantal Oracle-databases dat ik vanuit OptimaData migreer wordt elk jaar groter. Maatwerk is dan geen optie: wij streven zoveel mogelijk naar standaardisering!

Rob Drent

Relationele stress bij DBA's? Niet nodig!

Wat is dit nu voor een rare kop, zul je misschien denken. Relationele stress? Maar toch is het wat ik regelmatig tegenkom als ik voor een groep met databasebeheerders sta en ze vertel over MongoDB. Laat ‘het relationele’ voor wat het is, want je hebt echt een andere mindset nodig. NoSQL? NoStress!

Taco Zoetemelk

My transition from a single platform DBA to a multiplatform DBA
Part 3 | My first encounter with MongoDB University

As a partner of MongoDB we have unlimited access to the MongoDB University (on demand). What does unlimited mean in this case? If you don't have this kind of access to the MongoDB university, then you can still do the courses for free, but the only limitation is that you can't do the courses on your own pace. New course subjects will be available on a per week basis. This means that if you've done one course subject, that you have to wait a week for the next subject to become available.

Read more

Martijn Wallet

An Expert's introduction to PostgreSQL and Databasemanagement

PostgreSQL is an advanced SQL database server, which is available on a wide range of platforms. It has an enviable reputation for performance, stability, and a wide range of advanced features, which have been developed over the course of more than 20 years. With that, PostgreSQL is one of the oldest open source projects in existence, completely free to use, and developed by a very diverse, worldwide community. And best of all, it just works!

Read more