Expert Blogs

Blogs

skant.gupta
Follow /18 Jan 2018 at 2:00pm / Toad for Oracle Blog

Upgrading a Single Regular PDB from 12.1 to 12.2

Hi Readers Upgrading a Single Regular PDB from 12.1 to 12.2 For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-12cr2-upgrading-a-single-regular-pdb-from-12-1-to-12-2/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
55 0 /
zaida.villanova
Follow /18 Jan 2018 at 11:38am / Toad Edge - Blog

How to create an "Empty database" project in Jenkins with the help of Toad Edge

In this post we are going to create a project in Jenkins that drops all objects from a database to prepare it for a clean script deployment. In order to do this in Jenkins, we need the sql script that drops and recreate the database and the connection...
34 0 /
Syed Jaffar Hussain
Follow /18 Jan 2018 at 9:05am / Oracle Blog

Oracle Cloud - Database Services

This blog post highlights some of the essentials of Oracle cloud Database service offerings and its advantages. Also discuss about Database deployment (DBaaS) benefits and tools that can be used to automate backup/recovery operations and maintenance tasks...
79 0 /
Deepak Vohra
Follow /17 Jan 2018 at 9:48pm / Toad for SQL Server Blog

Using Toad for SQL Server with AWS RDS

Introduction Toad for SQL Server is an integrated development environment (IDE) for accessing, administering and using SQL Server. The SQL Server may be on a local machine or may be on a remote platform such as AWS RDS, EC2, Azure, or Google Cloud...
21 0 /
skant.gupta
Follow /17 Jan 2018 at 2:00pm / Toad for Oracle Blog

Controlling the Degree of Parallelism of Queries

Hi Readers Controlling the Degree of Parallelism of Queries For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-12cr2-controlling-the-degree-of-parallelism-of-queries/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
53 0 /
skant.gupta
Follow /16 Jan 2018 at 2:00pm / Toad for Oracle Blog

Local UNDO Mode Versus Shared UNDO Mode

Hi Readers Local UNDO Mode Versus Shared UNDO Mode For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-12cr2-tip-local-undo-mode-versus-shared-undo-mode/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB #AutonomousDatabase...
57 0 /
skant.gupta
Follow /15 Jan 2018 at 2:00pm / Toad for Oracle Blog

Oracle 12c R2 ( New Features ): NEAR-ZERO DOWNTIME PDB RELOCATION

Hi Readers Oracle 12c R2 ( New Features ): NEAR-ZERO DOWNTIME PDB RELOCATION For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-12cr2-new-features-near-zero-downtime-pdb-relocation/ #Oracle #CloudComputing #Cloud #Data #SelfDriving...
65 0 /
Gokhan Atil
Follow /15 Jan 2018 at 1:31pm / Oracle Blog

Using Spark to join data from CSV and MySQL Table

Yesterday, I explained how we can access MySQL database from Zeppelin which comes with Oracle Big Data Cloud Service Compute Edition (BDCSCE). Although we can use Zeppelin to access MySQL, we still need something more powerful to combine data from two...
101 0 /
Gokhan Atil
Follow /14 Jan 2018 at 5:19pm / Oracle Blog

Using Zeppelin to Access MySQL

If you want to access MySQL Cloud Service using Zeppelin of Oracle Big Data Cloud Service Compute Edition (BDCSCE), you can use Spark DataFrames or Zeppelin interpreters. In this blog post, I’ll show how we can edit JDBC interpreter to connect MySQL...
101 0 /
Bruce Momjian
Follow /11 Jan 2018 at 9:40pm / Postgres - Blog

PL/Java Adoption

PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java language and hamper its adoption. First, there are a limited number of people who know both Java and the...
49 0 /
Bruce Momjian
Follow /11 Jan 2018 at 9:36pm / Postgres - Blog

Outer Joins and Where Clauses

Postgres supports both traditional join syntax , which uses the where clause to specify joined columns, and ansi join syntax, that uses the word join in the from clause. While both syntaxes can be used for inner joins, only the ansi join syntax supports...
68 0 /
Bruce Momjian
Follow /11 Jan 2018 at 9:33pm / Postgres - Blog

When to Use Server-Side Logic

The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The question has always been what amount of logic should be encoded in the database vs. in client applications...
68 0 /
Gary.Jerep
Follow /11 Jan 2018 at 8:44pm / Toad Data Point Blog

Toad Turnpike: Real Stories from the Road- Interruptions Part 1

Real people. Doing real things. With Toad solutions. Who Likes Interruptions? Not me. I hate being interrupted. It’s fair to say that most people feel the same. There’s agitation and frustration when interruptions mess up our “flow”...
28 0 /
Porus Homi Havewala
Follow /11 Jan 2018 at 7:21pm / Postgres - Blog

PostgreSQL database for Enterprises – Part IV

In this article series, we are exploring why and how enterprises are starting to use the PostgreSQL database. In particular we are looking at an enterprise-ready version of PostgreSQL, namely EnterpriseDB Postgres Advanced Server (EDBPAS). This customized...
164 0 /
Porus Homi Havewala
Follow /11 Jan 2018 at 7:16pm / Oracle Blog

Oracle Hybrid Database Cloud using Enterprise Manager – Part VIII

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 installed on premises. The main intention is to install an Enterprise Manager Hybrid Cloud agent on...
117 0 /
Porus Homi Havewala
Follow /11 Jan 2018 at 6:40pm / Oracle Blog

Database as a Service using Enterprise Manager – Part VIII

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 parts here , we started the setup...
347 0 /
Juan Carlos Olamendy
Follow /11 Jan 2018 at 5:13pm / MySQL

Explaining InnoDB Explicit Locking Mechanisms

By: Juan Carlos Olamendy Turruellas Introduction Locking mechanisms are critical to keep the database consistent (a fact that is not well understood by some developers). However, unnecessary locks can have a negative impact on system performance...
108 0 /
skant.gupta
Follow /10 Jan 2018 at 11:35pm / Toad for Oracle Blog

Oracle Database Cloud: How to Start in Oracle Database Cloud Career

Hi Readers Oracle Cloud: How to Start in Oracle Database Cloud Career For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-cloud-how-to-start-in-oracle-database-cloud-career/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
76 0 /
Deepak Vohra
Follow /10 Jan 2018 at 7:15pm / Toad DevOps Toolkit Blog

Using Toad DevOps Toolkit with Oracle Database Cloud Service

Oracle Database Cloud Service is a managed service for Oracle Database on the Oracle Cloud Platform. Being a managed service, most of its administrative tasks, including installation, network access, and backup and recovery, are managed by the Oracle...
34 0 /
skant.gupta
Follow /10 Jan 2018 at 2:00pm / Toad for Oracle Blog

Oracle Cloud: How to Start in Oracle Database Cloud Career

Hi Readers Oracle Cloud: How to Start in Oracle Database Cloud Career For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-cloud-how-to-start-in-oracle-database-cloud-career/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
87 0 /
skant.gupta
Follow /9 Jan 2018 at 6:20pm / Toad for Oracle Blog

Oracle 12cR2: Enhancements in PDB Unplugging and Plugging

Hi Readers Oracle 12cR2: Enhancements in PDB Unplugging and Plugging For Reading, Click Here: http://blog.enmotech.com/2018/01/03/oracle-12cr2-enhancements-in-pdb-unplugging-and-plugging/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
76 0 /
Deepak Vohra
Follow /9 Jan 2018 at 5:36pm / Toad DevOps Toolkit Blog

Getting Started with Toad DevOps Toolkit - Running the PowerShell Demos

In an earlier article, Installing and Configuring Toad DevOps Toolkit , we discussed installing Toad DevOps Toolkit, installing PowerShell 3.0, and starting a Toad DevOps Toolkit instance. In a second article, Getting Started with Toad DevOps Toolkit...
43 0 /
Deepak Vohra
Follow /9 Jan 2018 at 4:01pm / Toad DevOps Toolkit Blog

Getting Started with Toad DevOps Toolkit - Installing and Configuring Oracle Databases

Introduction In an earlier article we discussed installing Toad DevOps Toolkit, installing PowerShell 3.0, and starting Toad DevOps Toolkit. As discussed in that article, Toad DevOps Toolkit is a command-line shell tool for creating and using COM programmable...
44 0 /
Anju Garg
Follow /8 Jan 2018 at 7:57pm / Oracle Blog

Oracle Multitenant Application Containers - Part VII Querying Data Across CDBs using Proxy PDB

Introduction In my previous article , I discussed conversion of a regular PDB to an application PDB so that applications that are already installed in it can also take advantage of application containers. In this article, I will discuss the use...
1526 0 /
jp_vijaykumar
Follow /6 Jan 2018 at 10:33pm / Oracle Blog

GLOGIN WITH COLOR DISPLAY

Date Jan 4th 2018 As a dba, I will be executing various scripts in multiple databases. Mostly in non-productions databases. In the event, if any of these scripts were executed inadvertently in the production database, it will be disastrous...
157 0 /