Infrastructure at your Service

Newsroom

Boost your knowledge!

How? Let's check our Oracle, Microsoft, Open Source DB and OS workshops 2016 in detail!

1
1

Newsroom – dbi services news & events

Press releases, upcoming events, papers and publications, and other news about dbi services. Please do not hesitate to contact us for any question.

Event Oracle 12cR2

By | Events | No Comments

Event Oracle 12cR2

22.03.17 in Olten / 23.03.17 in Lausanne

The release 2 of the Oracle Database 12c is available in the cloud since a few months. Now you surely expect the 12cR2 to be launched on-premises in the next weeks? Well, we’ll see when Oracle launches the version on-premises, then it’s not always easy to know what information really matters beyond the marketing messages.
In order to help you to plan future upgrades properly, our Oracle experts organize a breakfast dedicated to the Oracle Database 12cR2. This event is a great opportunity for DBAs and Developers to discover new features that are interesting from a technical perspective. The multitenant architecture will also be a specific topic in our discussions: the non-CDB , the one that we use for decades, is now deprecated and, by the way, may no longer be supported in the future.
If you are interested to understand how and when to move on safely to the 12cR2, then you are kindly invited to join our experts for a friendly breakfast with technical presentations and open discussions. The experts of dbi services are looking forward to sharing their knowledge with you and answering your questions.

SESSIONS AND PRESENTATIONS

Introduction to the 12cR2

Still awaited on-premises, the Oracle 12.2 is available partially or totally on different platforms, in particular on the new Oracle Database Exadata Express Service and on the Oracle public cloud.

Top 12.2 features for daily use

Besides the big new features targeting at a few big customers, each release comes with small improvements which daily help DBAs or developers:
new online operations, more automation, more efficient SQL functions, better SQL plan stability, etc.

With or without option, all you need to know about the multitenant architecture

Because non-CDB is deprecated, we need to start to look at multitenant. 12.2 brings new features which can be used on any edition even without options.

ONLINE REGISTRATION

EVENT SUMMARY  

Place:   Olten, Lausanne

Date:   22.03.17 Olten / 23.03.17 Lausanne

Time:   7.30 – 10.30, including breakfast

Price:   CHF 0.- / attendance is free

PROGRAM

7:30-8:00                                                                                                                                                      Welcome coffee

8:00-8:15                                                                                                                                                  Welcome speech & introduction to the 12cR2

8:15-8:45                                                                                                                                                     Top 12.2 features for daily use

8:45-9:30                                                                                                                                                 With or without option, all you need to know about multitenant architecture

9:30-10:30                                                                                                                                               Breakfast / questions and answers

 

xPloreDay HA

By | Events | No Comments

Implementing and managing SQL Server AlwaysOn availability groups

29.03.17 Lausanne / 30.03.17 Olten

SQL Server AlwaysOn is a multifunctional solution which can be configured in very various ways to meet requirements of high availability and data redundancy. This includes high availability outside the primary data center thanks to the multi-site Windows clustering. Such high available architectures require know-how which we will share with a dedicated event called “dbi xPloreDay”.
During our one-day event, David Barbarin as a MS Data Platform specialist will give you a comprehensive understanding of basics on the Windows Failover Cluster and the AlwaysOn Availability Groups (AAG).
The presentations also focus on how to build an architecture adapted to your needs, how to implement an AG in one or multi-subnet Scenario, how to monitor an AAG and maintain the AlwaysOn Infrastructure, how to manage the interaction with other external components such as SQL Server jobs and SSIS.
Finaly, you’ll be explained how to troubleshoot specific issues which may arise at different levels of this high available AAG architecture.
You want to benefit from expert knowledge and technical discussions with the xPloreDay dedicated to the SQL Server AlwaysOn AG?
Register and join us. dbi services’ experts are looking forward to sharing their experience with you!

TOPICS

  • Windows Failover Cluster basics
  • AlwaysOn Availabilitity Groups and Windows Failover Relationship
  • Planning for AlwaysOn Availability Groups
  • Implementing AlwaysOn Availability Groups
  • Managing and monitoring AlwaysOn Availability Groups
  • Troubleshooting common scenarios with availabitlity group scenarios

TARGET GROUP

  • SQL Server DBAs having first experience with AlwaysOn

PRICE

  • CHF 900.00 / participant
  • *15% discount for dbiFidelity customers

EVENT SUMMARY  

Speaker:                                                                                                                                                          David Barbarin, Microsoft MCM & MVP Data Platform 

Place:                                                                                                                                                           Lausanne (in French), Olten (in English)

Date:                                                                                                                                                    29.03.2017 Lausanne / 30.03.2017 Olten

Time:                                                                                                                                                  9 a.m. – 5 p.m.

Price:                                                                                                                                                CHF 900.00 *

PROGRAM

08:30-09:00                                                                                                                                                 Welcome coffee

09:30-12:30                                                                                                                                   xPloreDay presentations (incl. coffee break)

12:30-13:30                                                                                                                                   Lunch

13:30-17:00                                                                                                                                   xPloreDay presentations (incl. coffee break)

17:00-18:00                                                                                                                                   Apéro

ONLINE REGISTRATION

 

Oracle OpenWorld 2016 : what you need to know

By | Media releases & news | No Comments

Oracle OpenWorld 2016

What you need to know

The Oracle 12c is not released on-premises yet, but it is available since November 8th 2016 in the Oracle Cloud!

dbi services was present at the OOW16 in San Francisco from September 18th to 22nd. The OOW is considered as the most important yearly meeting of the Oracle community. Our experts have here the pleasure to keep you on track with the latest Oracle news and trends.

The long-awaited cloud version of the Oracle 12c Release is now available!

Larry Ellison (co-founder and Oracle CTO) finally announced the availability of the 12cR2 during his keynotes, but in a first step as a cloud version only (PDB as a Service). Furthermore, a new Oracle service was announced by Oracle’s CTO with the “Oracle Exadata Express Cloud Service”!

 

Good to know about the “Oracle Exadata Express Cloud Service!

There is no trial version and no access to the OS. A PDB can be quickly provisioned, though there is no access to the OS and some features are restrained (in order not to break the CDB). In fact, this new service will be entirely managed by Oracle and the version 12.2 will be launched afterwards. The « go life » date is not known so far.

If you missed a keynote or did not have the opportunity to participate in San Francisco, then you may wish to watch the keynotes online -> click here

 

Certification “OCM 12c”

By | Media releases & news, unclassified | No Comments

Congratulations!

Two Oracle Database 12c Certified Masters (OCM 12c) at dbi services

dbi services is proud to announce that two of its experts, Franck Pachot and William Sescu, successfully passed the exam “Oracle Database 12c Certified Master”, which is the expert level certification for Oracle Database.

It should be noted that Franck Pachot and William Sescu passed this exam just one month after the Upgrade Exam for OCM 12c was introduced (End of the year 2015).

Such an achievement is the result of a combination of a gained experience with customers, internal researches, their participation to the 12c beta program as well as a tremendous preparation on their side. It’s a hands-on exam that requires both: a wide knowledge and stress management as the given time for each topic is very short.

In addition, William Sescu passed the Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator (1Z0-068) exam. Consequently, being OCE RAC/GI 12c + OCE Data Guard 12c + OCM 12c, makes him de-facto an: Oracle Database 12c Maximum Availability Certified Master. This is the highest certification you can get on Oracle Database.

Franck Pachot, for his part became Oracle ACE Director”. This latter title is provided by Oracle to Oracle top-tier specialists making significant contributions to the Oracle community and interacting with Oracle product managers.

 

IT Tage 2016

By | Events | No Comments

IT Tage 2016

December 12th to 15th 2016 – Frankfurt am Main

With more than 160 sessions, the IT Tage 2016 are taking place from December 12th to 15th 2016 in Frankfurt am Main. Experts from dbi services are glad to present some interesting technical topics in Frankfurt. Discover the program of their sessions above. We look forward to seeing you there!

Our sessions

SQL Server 2016: Neue Sicherheitsfunktionen

  • Speaker: Stéphane Haby
  • Date: 13.12.16
  • Time: 11:00-11.45
  • Room: München

SQL Server Errorlog – Entmystifizierung

  • Speaker: Stéphane Haby
  • Date: 13.12.16
  • Time: 14:00-14:45
  • Room: München

SQL Server – Locks, latches and spinlocks

  • Speaker: David Barbarin
  • Date: 13.12.16
  • Time: 17:00-17:45
  • Room: München

SQL Server 2016: Availability Group Enhancements

  • Speaker: David Barbarin
  • Date: 13.12.16
  • Time: 18:00-18:45
  • Room: München

Breaking the deadlock: Migrating from proprietary databases to PostgreSQL

  • Speaker: Daniel Westermann
  • Date: 14.12.16
  • Time: 16:00-16:45
  • Room: München

Feasibility study for building a software factory based on GIT repository

  • Speaker: Philippe Schweitzer
  • Date: 14.12.16
  • Time: 17:00-17:45
  • Room: Berlin

Further information

 

DOAG Conference + Exhibition 2016

By | Events | No Comments

DOAG Conference + Exhibition 2016

November 15th to 18th, 2016 – Nuremberg

You wish to meet experts at the DOAG Conference + Exhibition 2016, from November 15th to 18th 2016 in Nuremberg?

Good news: dbi services will be present at booth 242!

Our experts inform you there on products, technologies, and standards for IT infrastructures with personalized explanations and Live-Demos! And if you are curious about the outstanding presentations our Oracle specialists produced for the DOAG 2016, check our conference program.

You may even be interested in being trained on Oracle Grid Infrastructure? Take the opportunity and register to our “Schulungstag”.

We look forward to seeing you at the DOAG Conference + Exhibition 2016!

Tuesday, 15th November 2016

Speaker:  Daniel Westermann

Time:          15:00-15:45 Uhr

Room:       Konferenzraum EG

Der GI Administrator hat meine Daten geklaut? Wie das?

In der heutigen Oracle Landschaft werden die Grid Infrastructure Installation immer breiter. Cluster mit mehr als 8 Knoten sind keine Seltenheit mehr und immer öfter gibt es auch noch mehrere von diesen, z.B. wenn mehr als eine Exadata zum Einsatz kommt. Wenn allerdings die Installationsbasis steigt, dann steigt auch zwangsweise die Anzahl der Benutzer. Seien es Administratoren, Anwender im Fall von ACFS oder Applikationen, die auf Services zugreifen. Wissen Sie wer was darf, wer wo zugreift, ob ihre Daten verschlüsselt sind und wenn ja: sind es die schützenswerten? Nein? Dann lassen Sie sich überraschen welche Mechanismen Sie heute einsetzen können um eine Grid Infrastucture sicher zu betreiben und vor allem was passieren kann wenn Sie sich darüber keine Gedanken machen.

Speaker:  Franck Pachot

Time:          17:00-17:45 Uhr

Room:       Tokio

Multitenant New Security Features Clarify DevOps/DBA roles

The CDB/PDB paradigm enforces role segregation between the container DBA and the application DBA. In DevOps environment, you need the finer access privilege definition that comes in 12.1 (common/local users) and in 12.2 (lockdown profiles, PDB isolation).Can we administrate a Cloud or on-premises database and give PDB administration rights to application teams for their application? And clearly define roles between system DBA and application DBA? The new features and best practices.

Speaker:  Matthieu Münch

Time:          17:00-17:45 Uhr

Room:       Oslo

GoldenGate-ODI: Verstärken Sie Ihr Business mit Real-Time BI

Daten in Real-Time zu analysieren gibt Ihnen heute einen entscheidenden Vorteil gegenüber der Konkurrenz. Leider bieten, stand heute, nur einige Reporting Lösungen diese Funktionalität auch an. Oracle kann seinen Kunden schon heute Datenanalysen in Real-Time anbieten in dem das Produkt GoldenGate und die EL-T (Extract, Load-Transform) Technologien von ODI kombiniert werden. In dieser Präsentation werden wir live Daten von Börsen-Systemen beziehen und Ihnen aufzeigen wie sich die Reports auf Grund dieser Daten dynamisch verändern.

Wednesday, 16th November 2016

Speaker:  Pascal Brand

Time:          10:00-10:45 Uhr

Room:       Prag

Monitoring von WebLogic 12C Domain mit RESTfull Interface

Eine der neuen Leistungsmerkmale in WebLogic 12C ist das RESTfull Interface, das es ermöglicht, die WebLogic ManagedBeans direkt über HTTP/S Requests abzufragen. WebLogic RESTfull Management Services gewährleisten ein umfassendes Interface für die Konfiguration, das Monitoring, die Implementierung von Applikationen und die Verwaltung des WebLogic Servers in allen unterstützten Umgebungen. Z.B kann der Server Status leicht über eine einfache URL überprüft werden und mit einem Monitoring Programm wie Nagios entsprechend verbunden werden. Zusätzliche Ressourcen (WLST Script oder JMX Java-Anwendungen) sind nicht erforderlich. RESTfull Modules sind auf dem WebLogic Domain Administration Server installiert.

Speaker:  Clemens Bleile

Time:          12:00-12:45 Uhr

Room:       Shanghai

In-Memory-Pläne für den 12.2-Optimizer: Teuer oder billig?

Mit In-Memory bekommt der Oracle Optimizer neue Plan-Alternativen. Wie werden diese im Vergleich zu “normalen” Plänen gewichtet? Was kosten z. B. fünf In-Memory-Zugriffe im Vergleich zu fünf logischen IOs im Buffer Cache? Tendiert der Optimizer eher zu In-Memory-Plänen oder haben traditionelle Full-Table-Scans noch eine Chance? Dieser Vortrag beschäftigt sich auch mit den Optimizer-Erweiterungen für In-Memory in 12.2.

Speaker:  Gérard Wisson

Time:          16:00-16:45 Uhr

Room:       Prag

Cloud Control 13c – Lifecycle Management Modul

Sie verwalten mehrere dutzend Weblogic Server und Domains. Sind alle richtig konfiguriert für die verschiedenen Anwendungen, die darauf laufen? Sind alle Voraussetzungen erfüllt? Sind die richtigen Versionen installiert? Welche Patches sind appliziert? Starten Sie von null, wenn sie einen neuen Managed Server installieren? Falls Sie sich solche Fragen stellen, kann wahrscheinlich Oracle Cloud Control 13c Ihnen helfen, und zwar mit dem Einsatz des Lifecycle Management Modul. In diesem Vortrag werden die verschiedenen Lösungen im Middleware-Rahmen erklärt und ein Teil davon tiefer angeschaut und demonstriert.

Thursday, 17th November 2016

Speaker:  David Hueber

Time:          10:00-10:45 Uhr

Room:       Tokio

Databases Clone Using ACFS

Test- oder Entwicklungs-Datenbanken neu zu erstellen, ist für DBAs fast schon zur täglichen Aufgabe geworden. Leider erfüllt die traditionelle DUPLICATE-Methode nicht mehr die heutigen Anforderungen, mit denen wir durch Datenmenge, Dauer und Flexibilität konfrontiert sind. File Systeme wie ACFS haben „Commit-On-Write“ Technologien für die Snapshot-Erstellung eingeführt, die das Paradigma der Datenbank-Bereitstellung und des DB-Klonens ändern. In diesem Vortrag wird präsentiert, wie die ACFS-Snapshot-Technologie es ermöglicht, einfach und schnell neue Kopien von Produktionsdatenbanken zu erzeugen.

Speaker:  David Hueber

Zeit:           14:00-14:45 Uhr

Raum:       Singapur

Oracle on Atomic Linux

Einer der aktuellen grossen Trends in Infrastrukturumgebungen ist die Container-Technologie und insbesondere Docker. Im Zuge neuer Container-Implementierungen, traten neue Anforderungen, wie Clustering, auf. Um diesen Herausforderungen gerecht zu werden, wurden spezielle Distributionen angeboten. Atomic Linux ist eine schlanke Linux Distribution dediziert für Container, die auch Clustering-Funktionalitäten bietet. In diesem Vortrag wird präsentiert, wie man eine Cluster-DbaaS-Umgebung für Oracle Datenbanken mit Atomic Linux aufbauen könnte.

Speaker:  William Sescu

Time:          15:00-15:45 Uhr

Room:       Neu Delhi

Effizientes Recovery mit Oracle Flashback Techniken in 12c

RMAN ist ein sehr mächtiges Tool, doch Oracle liefert viele weitere Möglichkeiten, um Ihre Umgebung zu schützen und schnell Daten wiederherzustellen. Ausversehen commited, obwohl Sie es nicht wollten? Was nun? Flashback Techniken können unter Umständen sehr hilfreich sein, um die alten Daten zurückzugewinnen. Wie man diese Techniken effizient nutzt, demonstriere ich in dieser Session.

Friday, 18th November 2016

Speaker:  Daniel Westermann

Time:         9:00-17:00 Uhr

Room:       Kopenhagen

Oracle Grid Infrastructure - SCHULUNGSTAG -

Mit der Grid Infrastructure bietet Oracle eine Cluster-Lösung mit der sich ziemlich alle Produkte hochverfügbar betreiben lassen. Gleichzeitig sind Cluster-Lösungen, egal von welchem Hersteller, jedoch Produkte, die nur dann verlässlich arbeiten wenn die darunter liegen Schichten richtig vorbereitet, konfiguriert und überwacht sind. Das betrifft nicht nur die Grid Infrastructure an sich sondern auch das Betriebssystem, die Kernel Parameter, die Anbindung der Speicherkomponenten und die optimale Konfiguration des Netzwerks. Erschwerend kommt hinzu, dass in einer Cluster Umgebung auch alle beteiligten Fachbereiche effizient zusammenarbeiten müssen; und je nach Betriebs-Organisation können das einige sein.
Zwei Oracle Grid Infrastructure Experten von dbi services werden im Rahmen des Schulungstages ihr Wissen, ihre Methoden, ihre Tools und die dbi Best Practices mit Ihnen teilen.
Zahlreiche Live Demos vermitteln Ihnen eingehendes Verständnis für die Arbeitsweise und den Anforderungen der Oracle Grid Infrastructure und Sie lernen, wie Sie das Beste aus Ihrer Umgebung herausholen können.

Zielgruppe: Datenbank-Administratoren, System-Administratoren, Storage Administratoren
Level: mittel
Vorkenntnisse erforderlich: Vorkenntnisse in Linux erforderlich

Further information regarding this event:

 

SQL Server 2016: what’s new ?

By | Events | No Comments

SQL Server 2016: what’s new ?

13.09 Lausanne / 14.09 Basel / 15.09 Zurich

SQL Server 2016

SQL Server 2016 recently arrived on the market. A good reason for our experts to propose you a free event in the presence of Microsoft. With 3 sessions, our specialists will present their researches and tests on security & performance, on the cloud and on the business intelligence, giving you the opportunity to discover this new version of MS SQL Server. Do you already work or intend to work on SQL Server? Then it’s definitely worth it to participate to our event dedicated to SQL Server 2016!

PROGRAM

08:30-09:00      Welcome coffee

09:00-09:15      Welcome speech

09:15-10:00      5 most popular functionalities of SQL Server 2016

10:00-10:45      Hybrid Cloud Scenarios with SQL Server 2016

10:45-11:05      Coffee break

11:05-11:50      Mobile BI & high-performant analytics

11:50-12:15      Open discussion

12:20-13:30      Apero

 EVENT SUMMARY  

   Place:   Lausanne, Basel, Zurich

   Date:   13.09.2016 Lausanne / 14.09.2016 Basel / 15.09.2016 Zurich

   Time:   9.00 – 13.30, including lunch

   Price:   CHF 0.- / attendance is free and non-binding

SESSIONS AND PRESENTATIONS

5 most popular functionalities of SQL Server 2016

During this session you will be told about 5 main functionalities from SQL Server 2016:

  • Temporal Tables: new SQL Server mechanism that allows to automatically keep the data history of a table
  • Query Store: functionality that allows optimizing the performance of requests through capture of specific information
  • Always Encrypted: SQL Server can carry out operations on encrypted data. Moreover, the data encrypted key is in the application and not on the server 
  • Row level security: allows to control the access to lines in a table depending on the user executing the request
  • Dynamic data masking: limits the exposition to sensible data by masking them

 

 

Hybrid Cloud scenarios with SQL Server 2016

Presented by

SQL Server 2012 and 2014 already proposed hybrid scenarios. With SQL Server 2016, this trend is kept as it gives access to new scenarios and to old ones having been improved.
In this session, we will show you the new scenarios available on SQL Server 2016 and inform you on possible utilization of the features as well as how to implement them.

 

 

(Mobile) Business Intelligence and high-performant analytics

Presented by

With the 2016 version, SQL Server now includes (Mobile) BI and high-performant analytics capabilities that aim at simplifying and reducing the cost of your underlying infrastructure. In this session we’ll talk about the advantages of combining in-memory columnstore and rowstore capabilities for fast analytical processing and exploration tools, such as Excel or Power BI to meet new customer business trends.

 

ONLINE REGISTRATION

September 13th in Lausanne

September 14th in Basel

September 15th in Zurich

 

“Transform your database to open source with PostgreSQL”

By | Events | No Comments

Transform your database to open source with PostgreSQL

Transform Your Database Tour : Geneva – 21.06.2016 / Zurich – 22.06.2016

How to migrate from a proprietary to an open source database? What are the key elements to take into consideration when migrating from a proprietary RDBMS to PostgreSQL? These questions will be answered by our EnterpriseDB certified experts who will explain you the main pitfalls to avoid.

Event program
Welcome coffee 08:30-09:00
Welcome message 09:00-09:10
Session: Integration of OpenSource technology in your company 09:10-09:25
Session: The main advantages / strengths of PostgreSQL 09:30-10:15
Coffee break 10:15-10:45
Session: Breaking the deadlock: Migrating from proprietary databases to PostgreSQL 10:50-11:30
Customer use case with testimonial 11:30-12:00
Lunch 12:00-13:30
Details for registration

Geneva

Zurich

June 21st

June 22nd

This event is organized by dbi services, in collaboration with EnterpriseDB.

 
Pierre-Yves Brehier
Pierre-Yves Brehier

Region Manager







captcha

Also read...

Exadata Express Cloud Service: PDB_ADMIN privileges

I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and…

Oracle 12cR2 – DataGuard and Backups to NFS

From the RMAN point of view, you have generally two possibilities to store your backups, on Disk or on Tape. In case of a single instance, it doesn’t really matter…

vagrant up – get your Oracle infrastructure up an running

By using Vagrant to manage your Virtual Machines and Ansible for configuration management and provisioning you can easily automate the setup of your whole test environment in a standardized way….

Partners

  • Logotype Oracle Platinum Partner
  • Logotype Microsoft Partner Gold Data Platform
  • Logotype EMC²
  • Logotype Dbvisit