Expert Blogs


Clarisa Maman Orfali
Follow /21 Jul 2017 at 9:03pm / Oracle Blog

¿Quieres ser un Desarrollador? Tres Desarrolladores nos cuentan su historia

En el presente artículo quiero compartir con toda la comunidad las entrevistas que llevé a cabo a dos colegas amigos Mónica Godoy y Daniel Bozzolo junto con mi experiencia siendo desarrolladora. Nuestro objetivo, principalmente...
231 0 /
Clarisa Maman Orfali
Follow /21 Jul 2017 at 8:58pm / Oracle Blog

Do You Want to be a Developer? Three Developers Tell Us Their Stories

In this article, I want to share with all the community the interviews I conducted with two friends and colleagues, Monica Godoy and Daniel Bozzolo, as well as my own experience as a developer. Our main objective is to motivate young people and anybody...
232 0 /
Deepak Vohra
Follow /20 Jul 2017 at 9:40pm / NoSQL Blog

Storing Apache Solr 5.x Data in HDFS

Introduction Apache Solr is a leading enterprise search engine based on Apache Lucene. Apache Solr stores the data it indexes in the local filesystem by default. HDFS (Hadoop Distributed File System) provides several benefits, such as a large scale...
79 0 /
Deepak Vohra
Follow /20 Jul 2017 at 3:18pm / MySQL

Continuous Integration from AWS Code Commit to Amazon ECR with AWS CodeBuild

Introduction In an earlier article, Continuous Integration from AWS CodeCommit to Docker Hub with AWS CodeBuild , we discussed how Jenkins has some limitations as a build tool and how AWS CodeBuild overcomes those limitations. We discussed creating...
123 0 /
Mathew Phan
Follow /19 Jul 2017 at 11:37pm / Toad for SQL Server Blog

Running Scripts Across Multiple SQL Server Instances Using Toad Group Execute

Hi follow Toadies! As a SQL Server administrator you're likely managing dozens if not hundreds of databases. It's extremely time consuming to run a script on each and every one of those databases and then check the results. To make things even...
131 1 /
Deepak Vohra
Follow /19 Jul 2017 at 4:41pm / Toad Edge - Blog

Using Toad Edge with Oracle MySQL Cloud Service

Introduction MySQL is the #1 open source database. Oracle Cloud is a complete, integrated cloud and provides a wide range of services across Software as a Service (SaaS), Platform as a Service (PaaS), and Infrastructure as a Service (IaaS). Oracle...
78 0 /
Deepak Vohra
Follow /18 Jul 2017 at 4:26pm / Toad Edge - Blog

Using Toad Edge with MySQL Database on IBM Bluemix

Introduction IBM Bluemix is the cloud platform by IBM. Bluemix is a complete cloud platform that includes compute infrastructure, compute services, storage, network, data and analytics, DevOps, application services, and a catalog of services. Bluemix...
91 0 /
Brendan Tierney
Follow /17 Jul 2017 at 4:12pm / Oracle Blog

Part 4a - (Article 22: Profiling) Why me? and how Oracle 12c saves the day

This is the fourth part of series of blog posts on ' How the EU GDPR will affect the use of Machine Learning ' In this blog post (Part4a) I will discuss the specific issues relating to the use of machine learning algorithms and models. In the...
151 0 /
John Dorlon
Follow /14 Jul 2017 at 8:03pm / Toad for Oracle Blog

New in Toad 12.12 Beta: Updated Compare Multiple Schemas

The 12.12 beta cycle will begin soon, with a new Compare Multiple Schemas window. Sorry this isn't a "real" blog,....all the details are on the attached document. -John
149 0 /
Deepak Vohra
Follow /13 Jul 2017 at 8:23pm / Toad Data Point Blog

Using MongoDB with Toad Data Point

Introduction MongoDB is the most commonly used NoSQL database and one of the top five databases (relational or NoSQL). MongoDB is based on the Binary JSON (BSON) document store data model, which is a flexible, schema-less data format most suitable...
313 0 /
Jeff Podlasek
Follow /13 Jul 2017 at 2:34pm / Toad for IBM DB2 Blog

Toad for DB2 v6.3 is now available

We are pleased to announce the release of Toad for DB2 v6.3. This new version is now available for customers to download at Supportlink and at our Toad DB2 Trial Download Page on Toad for DB2 is a comprehensive solution to improve DBA and...
195 1 /
Bruce Momjian
Follow /13 Jul 2017 at 12:51am / Postgres - Blog

Allowing Only One NULL

While the SQL standard allows multiple NULLS in a unique column, and that is how Postgres behaves, some database systems (e.g. MS_SQL ) allow only a single NULL in such cases. Users migrating from other database systems sometimes want to emulate this...
214 0 /
Bruce Momjian
Follow /13 Jul 2017 at 12:41am / Postgres - Blog

Postgres Keywords

You might be aware that the SQL standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard, with slight modifications. For example, you cannot create a table called all: CREATE TABLE all (x INTEGER...
226 0 /
Mark Kurtz
Follow /12 Jul 2017 at 4:18pm / Toad for Oracle Blog

Toad for Oracle Code Road Map

As an Oracle developer you are working with a lot of lines of code. Some that you have written and some that you have inherited but are now responsible for. How do you document your work and decipher the code that you are working on? Yes you can use...
204 0 /
Brendan Tierney
Follow /12 Jul 2017 at 10:18am / Oracle Blog

PRECIS R package

If you use R then you are very familiar with the SUMMARY function. If you use R then you are very familiar with the name Hadley Wickham . He has produced some really cool packages for R. He has produced a new R package and function that complements the...
158 0 /
Porus Homi Havewala
Follow /11 Jul 2017 at 5:08pm / Postgres - Blog

A First Look at Amazon Aurora with PostgreSQL Compatibility - Benefits and Drawbacks - Part VI

by Porus Homi Havewala In the previous parts of this article series, we started to look at Amazon AWS and its Relational Database Service (Amazon RDS). This included Amazon’s own Aurora database with MySQL compatibility and Aurora with PostgreSQL...
460 0 /
Porus Homi Havewala
Follow /11 Jul 2017 at 4:56pm / Oracle Blog

Oracle Hybrid Database Cloud Using Enterprise Manager - Part II

by Porus Homi Havewala In this article series, we are looking at the steps for setting up the Oracle Hybrid Cloud via the latest version - Enterprise Manager Cloud Control 13c. We will follow the pre-steps, and then install a Hybrid Cloud Agent via...
354 0 /
Porus Homi Havewala
Follow /11 Jul 2017 at 4:49pm / Oracle Blog

Database as a Service Using Enterprise Manager - Part II

by Porus Homi Havewala In our article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database as a Service (DBaaS) Cloud – including the setup of such a cloud. In the previous part here...
480 0 /
Anju Garg
Follow /10 Jul 2017 at 9:22pm / Oracle Blog

Oracle Multi-tenant Application Containers - Part II - Create Application Container

Overview As I discussed in my last article Oracle Multi-tenant Application Containers Part-I , Oracle Database introduces the concept of multi-tenant application containers that enable many PDBs to share application objects such as code, metadata...
935 1 /
Brendan Tierney
Follow /10 Jul 2017 at 3:55pm / Oracle Blog

Part 3 - Ensuring there is no Discrimination in the Data and machine learning models

This is the third part of series of blog posts on ' How the EU GDPR will affect the use of Machine Learning ' The new EU GDPR has some new requirements that will affect what data can be used to ensure there is no discrimination. Additionally,...
132 0 /
Deepak Vohra
Follow /7 Jul 2017 at 6:03pm / Toad Edge - Blog

Using Amazon RDS Aurora DB with Toad Edge Preview and Toad Data Point

Aurora is a scalable, MySQL-compatible, RDS-managed relational database designed for high read and write performance and high transaction response time. An Aurora cluster consists of a primary node (instance) and one or more replicas (a maximum of 15...
527 0 /
Dan Hotka
Follow /6 Jul 2017 at 9:54pm / Oracle Blog

Oracle Coding Best Practices

Hi, I have a lot of PL/SQL tips to share. Here’s a first installment—perhaps more to come! Tip #1 The first thing I encourage all to use is %TYPE and %ROWTYPE on your variable definitions. In yesteryear, there was a tad bit of overhead...
775 1 /
Juan Carlos Olamendy
Follow /6 Jul 2017 at 9:06pm / MySQL

Table Partitioning in MySQL

By: Juan Carlos Olamendy Turruellas Introduction Today it's very common to store a lot of data in our MySQL databases. Common examples are: storing tracking information about your website to do analytics later, logging facts about your business...
704 0 /
Syed Jaffar Hussain
Follow /6 Jul 2017 at 1:33pm / Oracle Blog

A few useful Oracle 12cR2 MOS Docs

A few useful MOS Docs are listed below , in case if 12cR2 upgrade around the corner. How to Upgrade to/Downgrade from Grid Infrastructure 12.2 and Known Issues (Doc ID 2240959.1) Complete Checklist for Upgrading to Oracle Database 12c Release 2 (12.2...
230 0 /
Syed Jaffar Hussain
Follow /6 Jul 2017 at 10:27am / Oracle Blog

Oracle Clusterware 12cR2 - deprecated and desupported features

Having clear understanding of deprecated and desupported features in a new release is equally important as knowing the new features of the release. In this short blog post, I would like to highlight the following features that are either deprecated or...
178 0 /