Tuesday, 17 October 2017

Oracle Enterprise Manager Cloud Control 12c Release 1 Installation on Oracle Linux 5.7 and 6.1

Enterprise Manager Cloud Control is the new name for what was previously know as Enterprise Manager Grid Control. Depending on the source of the material, you may still see the product described as Grid Control. This article describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 1 on Oracle Linux 5.7 and 6.1. (x86_64).

Monday, 16 October 2017

MySQL 8.0 RC1 Now Available

Oracle has announced the availability of the first release candidate of MySQL 8.0, which focuses on making MySQL better for modern apps.

The 8.0 also marks a departure from the 5.x numbering series, which has been used since 2005. Skipping 6.x and 7.x was intentional to avoid confusion with a previous alpha release and MySQL Cluster, and also to communicate the depth of some of the core changes, writes Tocker.

Thursday, 12 October 2017

Azure SQL Database Long-Term Backup Retention

Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. You can take advantage of this functionality in order to perform backup, restore, and failover tasks, which help you recover from human errors, service outages, or even regional disasters. We have already described some of the corresponding features on this forum, including Point-in-Time Restore as well as Geo-Restore and Active Geo-Replication. Each one of them is an integral part of the Azure SQL Database service offering, regardless of the pricing tier. However, it is important to note that automatic backups created by Point-in-Time Restore, while convenient, have a relatively limited retention period (up to 35 days, with the Premium pricing tier). While this typically suffices to accommodate scenarios that involve restores due to an accidental data loss, it is not sufficient to satisfy archival and compliance requirements of an overwhelming majority of customers. To remediate this shortcoming, you have the option of implementing long-term backup retention of Azure SQL Database.

Wednesday, 11 October 2017

A Recent Innovation in NoSQL Data Modeling: Forward and Reverse Engineering Combined

Many organizations would like to develop and incorporate a NoSQL data model in their existing architectures, and to hire staff with Data Modeling skills. Unfortunately, there is a significant lack of data modelers with NoSQL experience, and reliable NoSQL Data Modeling tools are only just beginning to emerge into the market. The shortage of experienced NoSQL data modelers, combined with the scarcity of appropriate tools and delayed projects, can stunt a company’s growth.