Expert Blogs


Follow /11 Dec 2017 at 5:58pm / Toad Data Point Blog

Toad Turnpike: Real Stories from the Road

Taking the Flame out of Flame-Throwing “She’s like a flame-thrower on legs.” With that one short sentence, Naomi had just scripted a vivid scene for my mind to visualize. Backdrop. Rewind life back about a year and a half. I’m...
11 0 /
Denny Cherry
Follow /11 Dec 2017 at 4:00pm / SQL Server Blog

Be sure to thank the sponsors

Conferences, no matter the size all have one thing in common, they all require the same thing to run from Br eakfast until Dinner for the day (or multiple days) that the event runs. That thing they need to run on is cash. The less expensive the event...
29 0 /
Brendan Tierney
Follow /11 Dec 2017 at 11:45am / Oracle Blog

Oracle Code Online December 2017

This week Oracle Code will be having an online event consisting of 5 tracks and with 3 presentations on each track. This online Oracle Code event will be given in 3 different geographic regions on 12th, 13th and 14th December. I've been selected to...
50 0 /
Syed Jaffar Hussain
Follow /11 Dec 2017 at 9:18am / Oracle Blog

OBIEE 12c ( post upgrade challenges - unable to save HTML based dashboard reports

Very recently, an OBIEE v12.2.1.1 upgraded to v12.2.1.3 on an Exalytics machine. Though it wasn't a major upgrade, we had to do it to fix some bugs encountered in v12.2.1.1. For sure, it wasn't a easy walk in the park during the upgrade and post...
44 0 /
Jeff Podlasek
Follow /7 Dec 2017 at 7:20pm / Toad for IBM DB2 Blog

Toad for DB2 v6.5 is now available!

We are pleased to announce the release of Toad for DB2 v6.5. 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...
47 0 /
Gregory Liss
Follow /6 Dec 2017 at 7:06pm / Toad DevOps Toolkit Blog

Toad DevOps Toolkit and PowerShell...step by step.

Introduction When first looking at TDT, it can be a very intimidating product. Of course, the same can be said of SQL*Plus. Both are very powerful but both require a level of understanding about what is going on behind the scenes in order to get the...
153 3 /
Deepak Vohra
Follow /5 Dec 2017 at 8:00pm / Toad Edge - Blog

Using Toad Edge 1.1 with MySQL Database – New Database & New Table Wizards,Text Search, Import Data Wizard

Introduction In an earlier article on using Toad Edge 1.1 with MySQL Database we discussed running MySQL on Docker Engine and connecting to the MySQL database with Toad Edge. In this continuation article we shall discuss some of the Toad Edge features...
42 0 /
Deepak Vohra
Follow /5 Dec 2017 at 4:58pm / Toad Edge - Blog

Using Toad Edge 1.1 with MySQL Database on Docker

MySQL database is the leading open source database. Toad Edge is a database development and administration integrated development environment (IDE) for MySQL database with support to be added for some of the other open source databases. In an earlier...
46 0 /
Clarisa Maman Orfali
Follow /4 Dec 2017 at 11:35pm / Oracle Blog

Cómo definir las preferencias del espacio de trabajo actual en Oracle APEX 5.1

Vamos a aprender en este artículo a conocer cómo definir y controlar las preferencias para el espacio de trabajo. Para definir las preferencias del espacio de trabajo debemos iniciar sesión con el usuario Administrador; es importante...
104 0 /
Deepak Vohra
Follow /4 Dec 2017 at 7:29pm / Toad Edge - Blog

Using Toad Edge 1.1 with MySQL on AWS EC2 - Part II

Introduction In the first of two articles on using Toad Edge 1.1 with MySQL database that is running on AWS EC2 we discussed creating an EC2 instance using a MySQL AMI. Subsequently we obtained the password for the MySQL root user and connected to...
44 0 /
Syed Jaffar Hussain
Follow /3 Dec 2017 at 2:45pm / Oracle Blog

Database direct upgrade from 11g to 12c to Exadata X6-2 from X5-2 - RMAN DUPLICATE DATABSAE WITH NOOPEN

At one of the customers recently, a few production databases migration from X5-2 to X6-2 with Oracle 11g upgrade to Oracle 12cR1 was successfully delivered. As we all knew, there are handful of methods available to migrate and upgrade an Oracle databases...
107 0 /
Follow /3 Dec 2017 at 10:11am / Toad for Oracle Blog

Oracle Exadata 18c and Database Machine X7-2

Oracle Exadata Database Machine consists of Oracle Database servers, Exadata Storage Servers , and the network components to connect to your network. Oracle Exadata Database Machine is available as a full rack, half rack, quarter rack or eighth rack...
111 0 /
Deepak Vohra
Follow /1 Dec 2017 at 7:47pm / Toad Edge - Blog

Using Toad Edge 1.1 with MySQL on AWS EC2 - Part I

Introduction MySQL database may be run on several cloud platforms that provide managed services for MySQL. AWS Relational Database Service (RDS) is one such managed service for relational databases, including MySQL. Google Cloud Platform provides the...
98 0 /
Dan Hotka
Follow /1 Dec 2017 at 6:23pm / Oracle Blog

How I became an author, how it helped my career--and how you can do it too

Hi, This is the time of year we look back and consider what we’re thankful for. I am thankful for the opportunity to be well-published. I have always enjoyed sharing my knowledge with others and I have done so for well over 20 years now. What...
157 0 /
Deiby Gomez
Follow /1 Dec 2017 at 2:58pm / Oracle Blog

Block Corruption in an Oracle Database

By Deiby Gómez Introduction Block corruption is a common topic when we are dealing with any software that stores data. In Oracle Database there are several types of logical structures that are mapped to a physical file named “datafile”...
133 0 /
Follow /1 Dec 2017 at 2:43pm / Postgres - Blog

PostgreSQL 10 first look and new features

Database is a key asset for business applications. In the beginning, database technologies were used for storing and managing large amounts of data from single/multiple business applications to efficiently manage the business transaction. In today’s...
79 0 /
John Pocknell
Follow /30 Nov 2017 at 9:53am / Toad DevOps Toolkit Blog

UKOUG TECH17 Coming Soon

Tech17 — UKOUG’s biggest event of the year — is coming to Birmingham, UK, 4–6 December, so if you're around, this is a great opportunity to gain insights into the latest developments within the Oracle space, direct from Oracle...
29 0 /
John Pocknell
Follow /28 Nov 2017 at 6:30pm / Toad DevOps Toolkit Blog

Getting Started with Toad DevOps Toolkit - Part1

Before you read this article, please make sure you’re familiar with what Toad DevOps Toolkit is and the problems it solves in bringing your Oracle development/deployment operations into an automated process. My previous blog post will introduce...
48 0 /
John Pocknell
Follow /28 Nov 2017 at 5:57pm / Toad DevOps Toolkit 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...
232 0 /
Denny Cherry
Follow /27 Nov 2017 at 4:00pm / SQL Server Blog

Should I be blocking outbound ports in Azure by default?

The short answer is that yes there are ports that you’ll want to block outbound by default.  There’s a variety of amplification attacks that you have the possibility of being a member of. These attacks aren’t against your systems, but...
108 0 /
Follow /27 Nov 2017 at 11:55am / Toad for Oracle Blog

Oracle Cloud: How to become "Oracle Exadata Database Machine and Cloud Service 2017 Certified Implementation Specialist"

This article was written by Skant Gupta and Joel Perez in Oracle OTN. If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: Skant Gupta's LinkedIn...
90 0 /
Follow /23 Nov 2017 at 8:40pm / Oracle Blog


HOW CARTESIAN JOINS IMPACT SQL QUERIES Author JP Vijaykumar Oracle DBA Date Nov 22nd 2017 We all know what is a "CARTESIAN JOIN", for further reference, pls refer the url mentioned in the references section. I worked on a tuning task of...
151 0 /
Brendan Tierney
Follow /22 Nov 2017 at 12:09pm / Oracle Blog

104 0 /
Robert Catterall
Follow /21 Nov 2017 at 8:07pm / IBM DB2 Blog

Db2 12 SQL Enhancement: Temporal Logical Transactions

Temporal data support, introduced with Db2 10 for z/OS, is one of the more interesting SQL-related Db2 enhancements delivered in recent releases of the DBMS. Temporal data support comes in two flavors (which can both be utilized for a single table): business...
63 0 /
Dan Hotka
Follow /20 Nov 2017 at 5:11pm / Toad for Oracle Blog

Oracle Coding Best Practices - Part 5

Introduction This article series illustrates two ways of doing dynamic SQL, that is, SQL that is programmatically generated and submitted for execution. I have used one of the methods to solve parallel SQL performance issues. I will also show how to...
273 0 /