Expert Blogs

Blogs

Debbie Peabody
Follow /20 Sep 2017 at 10:57pm / Toad Data Point Blog

Toad Data Point Automation on Intelligence Central

In Toad Data Point 3.6 we add the ability to execute Automation scripts on Toad Intelligence Central. This was a great enhancement as it freed up your working computer. In this version, 3.7 we have added a few more enhancements I think you will enjoy...
1397 0 /
Brendan Tierney
Follow /19 Sep 2017 at 5:39pm / Oracle Blog

My Oracle Open World 2017 Presentations

Oracle Open World 2017 will be happening very soon (1st-5th October). Still lots to do before I can get on that plane to San Francisco. This year I'll be giving 2 presentations (see table below). One on the Sunday during the User Groups Sunday sessions...
74 0 /
John Pocknell
Follow /19 Sep 2017 at 12:10pm / Toad for Oracle Blog

Introducing a Brand New Toad Product - Toad DevOps Toolkit

Back in July this year, I wrote a blog describing the challenges many organisations are facing as they try to embrace DevOps as a way to help increase their business agility through higher operational efficiency by enabling their IT departments to shorten...
132 0 /
skant.gupta
Follow /15 Sep 2017 at 8:38am / Oracle Blog

Oracle Cloud (DBaaS): Using dbaascli Utility for Reinstating Operations on Oracle Data Guard

This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we performed Switchover & Failover Operations on Oracle Data Guard using the dbaascli utility. You can read it here: Oracle Cloud (DBaaS...
101 0 /
Porus Homi Havewala
Follow /13 Sep 2017 at 8:11pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility – Benefits and Drawbacks – Part VIII

by Porus Homi Havewala In this eight-part article series, we have had a good look at Amazon AWS and its Relational Database Service (Amazon RDS), in particular Amazon’s own Aurora database with PostgreSQL compatibility. In the previous part VII...
400 0 /
Porus Homi Havewala
Follow /13 Sep 2017 at 7:36pm / Oracle Blog

Database as a Service using Enterprise Manager – Part IV

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 parts ,...
198 0 /
Porus Homi Havewala
Follow /13 Sep 2017 at 7:17pm / Oracle Blog

Oracle Hybrid Database Cloud Using Enterprise Manager – Part IV

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 installed on premises. The main intention is to install an Enterprise...
134 0 /
Denny Cherry
Follow /13 Sep 2017 at 7:10pm / SQL Server Blog

Your PASS Summit 2017 Speaker Idol Contestants Are…

In past years I’ve been really glad that I’m just the MC of the PASS summit speaker idol because of the strong group of speakers. This year I’m really damn glad that I’m just not a judge because of the amazing group of speakers...
76 0 /
Anju Garg
Follow /13 Sep 2017 at 5:52pm / Oracle Blog

Oracle Multi-tenant Application Containers - Part IV: Cross-Container Aggregation

Overview In my last article, Oracle Multi-tenant Application Containers Part-III , we learnt about data sharing among containers in an application container by means of metadata-linked objects, data-linked objects, and extended data-linked objects...
282 0 /
skant.gupta
Follow /12 Sep 2017 at 8:34pm / Oracle Blog

Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard

This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we performed Switchover , Failover & Reinstate Operations on Oracle Data Guard using the DBCS Console. You can read it here: Oracle Cloud...
107 0 /
Dan Hotka
Follow /11 Sep 2017 at 3:52pm / Oracle Blog

More Coding Best Practices - PL/SQL tips - posting rows quickly from an array & more

Hi, This month is a continuation of the Bulk Binding PL/SQL technologies from Oracle from last month. Click here to review the Bulk Collect syntax in loading arrays very quickly with rows. This article will show the rest of the Bulk Binding technology...
496 0 /
Mark Kurtz
Follow /8 Sep 2017 at 10:24pm / Toad Edge - Blog

Object Versioning in Toad Edge

Working with Toad Edge you can store versions of your database objects in a file system repository. This gives you a way to reference and compare database objects without having to use a Version Control System (VCS). You can always add these objects to...
87 0 /
skant.gupta
Follow /8 Sep 2017 at 6:49pm / Oracle Blog

Oracle Cloud (DBaaS): How to become OCP & OCM Cloud!!!

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Hi everyone If you are reading this article could be for several reasons..: 1.- Perhaps you have asked me or asked to my colleague Skant Gupta the typical question "How...
143 0 /
Deepak Vohra
Follow /8 Sep 2017 at 6:03pm / Toad Edge - Blog

Using CloudSQL on Google Cloud Platform with Toad Edge

Introduction Google CloudSQL is a lightweight managed service for databases with support for MySQL and PostgreSQL. CloudSQL supports most of the features supported by a local installation of MySQL and PostgreSQL databases. Second Generation instances...
110 0 /
John Pocknell
Follow /8 Sep 2017 at 12:35pm / Toad for SQL Server Blog

What’s New in Toad for SQL Server Editions 2017 (Toad 6.8)

The wait is over – Toad for SQL Server 6.8 is here! General Availability was August 17 th and you can download the new version from here if you are current on support and maintenance or from here if you’d like to download a trial version...
50 0 /
Deiby Gomez
Follow /6 Sep 2017 at 8:24pm / Oracle Blog

Why Certifications Are Important

By Deiby Gómez Introduction: Ever since I started my career in Oracle technology I’ve always wanted to deliver the best support to my clients. I have wanted to solve the problems quickly. I am not afraid of new challenges, I am not...
1193 0 /
Brendan Tierney
Follow /5 Sep 2017 at 11:59am / Oracle Blog

Interview at POUG

147 0 /
skant.gupta
Follow /5 Sep 2017 at 10:35am / Oracle Blog

Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console

This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we configure the oracle data guard in database cloud service. Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS ) Now...
134 0 /
Ondrej.Zizka
Follow /1 Sep 2017 at 10:56am / Toad for IBM DB2 Blog

Configure Db2 Data Server Driver to communicate with the Db2 server via SSL connection and how to use it in Toad for DB2 version 6.3.

In this post, we will go through the configuration of Db2 Data Server Driver v11.1 to communicate with the Db2 server via SSL. The pre-requirement for this post is to have a Db2 server configured for SSL. How to do it is described in my post Configure...
57 0 /
Pini.Dibask
Follow /31 Aug 2017 at 5:03pm / Oracle Blog

Common misconception about how Oracle handles deadlocks

Introduction In today's blog post, I'd like to uncover a common misconception about how Oracle handles deadlocks, but first let's talk about what deadlock is. Deadlock is a locking scenario that occurs when two or more sessions are blocked...
195 0 /
Robert Catterall
Follow /31 Aug 2017 at 4:27am / IBM DB2 Blog

Db2 12 for z/OS SQL Enhancements: Advanced Triggers

In this, the fourth of a set of four entries covering SQL enhancements introduced with Db2 12 for z/OS, I will describe new trigger capabilities delivered by way of what are called "advanced triggers" (the kind of trigger that you could define...
78 0 /
skant.gupta
Follow /29 Aug 2017 at 7:53pm / Oracle Blog

Background Processes in Oracle ASM

Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. Notice that all the ASM processes begin with asm, whereas the RDBMS instance processes begin with ora . On...
170 0 /
zaheer.appsdba
Follow /29 Aug 2017 at 12:54pm / Postgres - Blog

PostgreSQL/EnterpriseDB Inside Linux Containers (LXC)

Introduction: Virtualization is one of the core assets of today’s data center infrastructure. The benefits and capabilities of virtualization are driving organizations towards virtualization technologies. Virtualization offers efficient utilization...
160 0 /
Dan Hotka
Follow /28 Aug 2017 at 6:12pm / Oracle Blog

Toad Code Analysis

Hi, Code Analysis has been in Toad for a while now. If you are using a slightly older version of Toad, it might be called Code Review, found under the same menu path. Code Analysis gives you or your project team useful information about a particular...
176 0 /
Deiby Gomez
Follow /28 Aug 2017 at 5:58pm / Oracle Blog

Oracle Database 12.2 Statement-level Refresh for Materialized Views

By Deiby Gómez Introduction: Materialized views have been used for several years and they are being improved by Oracle with every database version or release. Up to Oracle Database 12cR1 Oracle Materialized Views supported the following...
315 0 /