Infrastructure at your Service

Pierre Sicot

Oracle Database 12c: Oracle OEM express

By | Database management | No Comments
 

  Together with Oracle Database 12c, Oracle has introduced a new administration console named Oracle Enterprise Manager Express (Oracle OEM Express). This “light” version of Enterprise Manager Database Console – which is not supported in Oracle 12c anymore – is a management product built into Oracle Database 12c. There is no installation or management required, the database creation with dbca enables OEM Express and gives you the URL connect string. As there is no mid-tier or…

Read More
Stéphane Haby

SQL Server 2014 CTP1 is available

By | Technology Survey | No Comments
 

  Last week, I gave you some news about SQL Server 2014 (here). SQL Server 2014 Community Technology Preview 1 (CTP1) now is available for download on TechNet here (you need a TechNet subscription).   Attention: Only the new feature “in-memory OLTP – codename Hekaton” has been added to this CPT. I hope that other features will soon come with the next CTPs. If you don’t have a TechNet subscription yet, be patient, it should arrive…

Read More
Pierre Sicot

Discovering Oracle database 12c targets (CDB, PDB) in Cloud Control 12c

By | Technology Survey | No Comments
 

  In my consultant’s activity at dbi services, I had the opportunity to test the new databasion version Oracle 12c. As an Enterprise Manager Cloud Control 12c fan, when the 12.1.0.3.0 Oracle database plugin was made available, I decided to test the Cloud 12c behavior with the Oracle 12c database and also CDB and PDB (Container Database and Pluggable Database). Before installing the Oracle Database Plugin 12.1.0.3, the 12c databases are seen up but when…

Read More
Stéphane Savorgnano

Microsoft TechEd Madrid: Windows Server 2012 R2, High Availability, SQL Server Data Tools

By | Technology Survey | No Comments
 

  Let’s talk about my third day at TechEd 2013. I started with a session about: Windows Server 2012 R2 and High Availability The goal of High Availability is to deal with possible points of failure in your infrastructure. There are multiple ways to manage HA on the market: Server Server redundancy deployments Run server inside a clustered VM Backup Monitor via a SCOM Management Pack Database SQL Server 2012 AlwaysOn Mirroring, Replication, Backup Run…

Read More
David Hueber

Oracle 12c: Pluggable databases not that isolated

By | Database management | 12 Comments
 

  As you probably know, the multitenant databases is the new feature of Oracle 12c to solve the dilema of applications segregation. Thanks to a multitenant container database, it allows to manage many databases as one taking advantage of resources consolidation. A perfect way to manage several applications in a single container. However are these plugglable databases that isolated as expected? Not exactly: As I will show in this posting, a single PDB can, under…

Read More
Oracle Team

Oracle Database 12c: Grid Infrastructure, quoi de neuf?

By | Operation systems | One Comment
 

  A la lecture du New Features Guide, on trouve dans le chapitre sur Grid Infrastructure beaucoup de nouvelles fonctionnalités pour Grid Infrastructure, ASM et ACFS, mais l’événement est l’annonce d’une grosse évolution dans l’architecture du cluster. Flex Cluster En effet, cette version 12c introduit une nouvelle architecture nommée Flex Cluster dont voici un aperçu: Schema Oracle documentation Les objectifs annoncés sont “évolutivité, flexibilité et facilité de gestion”. Ainsi, nous pourrons choisir l’organisation “topologie” de…

Read More
Stéphane Savorgnano

Microsoft TechEd Madrid: Optimizing T-SQL & SQL Server 2014 Futures and Features

By | Technology Survey | No Comments
 

  Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternström, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance. There are 3 three different ways to run SQL: Physical machine can be scale-up full control roll your…

Read More
Oracle Team

Oracle Database 12c: Gérer le Password File avec ASM

By | Database management | No Comments
 

  En dehors de l’annonce de Flex ASM, ASM évolue peu dans Oracle 12c. La plus intéressante des améliorations pour les administrateurs de bases de données en cluster est l’introduction de la gestion des “Password Files” dans ASM. C’est l’objet de ce posting. Rappel Tout d’abord, un retour sur l’utilité du Password File et des éléments de configuration: Orapwd est l’outil pour créer un fichier de mots de passe pour authentifier les utilisateurs Oracle à qui…

Read More
Grégory Steulet

Oracle 12c now available for download on OTN and Oracle E-delivery

By | Database management | No Comments
 

  Finally after some months … The Oracle’s long-awaited 12c database (12.1.0.1) is now available for download on OTN and Oracle E-delivery ( http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html). Without any surprise the first platforms are Linux and Solaris! Weird, but until now no “official” announcement from Oracle has been made… Have a look on all new features integrated in this release: http://docs.oracle.com/cd/E16655_01/server.121/e17906/chapter1.htm#NEWFTCH1    

Read More
Stéphane Savorgnano

SQL Server 2014: In-memory OLTP project “Hekaton”

By | Technology Survey | No Comments
 

  I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I’m beginning with the SQL Server In-Memory OLTP project “Hekaton”! Microsoft has been working for four years on this new technology which will come with SQL Server 2014. The goal of this new feature is to: Memory optimized table and index structures…

Read More
Open source Team

PostgreSQL: PGDay France 2013 – un compte rendu

By | Technology Survey | No Comments
 

  La conférence PostgreSQL “PGday Francophone 2013″ s’est tenu jeudi 13 juin 2013 à Nantes. PgDay Fr est un événement organisé chaque année depuis 2009 par l’association ProgreSQLFr ayant pour objectif de mettre en relation les acteurs de la communauté PostgreSQL française et les utilisateurs de la base de données. L’event s’organise en une succession de présentations de 50 minutes et de pauses de 30 mn permettant aux participants d’échanger et de dialoguer. Un programme…

Read More
Microsoft Team

Three basic points on SQL Server Best Practice

By | Technology Survey | No Comments
 

  A few weeks ago, I went to the Swiss Database Days 2013 and followed the “Practical SQL Server Performance Troubleshooting” workshop. During this workshop, I have seen a different way of troubleshooting, but I was surprised to see that some participants were not aware that some basic SQL Server Best Practice do not depend on the instance settings. This blog posting is a reminder of some of these points. Swiss Database Days 2013: SQL…

Read More