Blogs - - Site Root - Toad World
Follow /28 Apr 2017 at 1:18am / Toad Data Point Blog


What is EDC or “Every Day Carry”? Wikipedia describes EDC as items that are carried on a consistent basis to assist in dealing with normal everyday needs of modern society, including possible emergency situations. Some of the most common...
13 0 /
Michael McLaughlin
Follow /27 Apr 2017 at 4:32pm / Oracle Blog

How to UPDATE Nested Object and Table Columns, Part 1

This two-part series covers how you update User-Defined Types (UDTs) and Attribute Data Types (ADTs). There are two varieties of UDTs. One is a column of a UDT object type and the other a UDT collection of a UDT object type. You update nested UDT columns...
50 0 /
Porus Homi Havewala
Follow /27 Apr 2017 at 4:09pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility - Benefits and Drawbacks - Part III

by Porus Homi Havewala In the previous parts of this article series , we started to look at Amazon AWS and the Relational Database Service (Amazon RDS) that it offers to customers around the world. We learned that Amazon’s own Aurora database...
54 0 /
Brendan Tierney
Follow /27 Apr 2017 at 2:23pm / Oracle Blog

OUG Ireland Meetup 11th May

The next OUG Ireland Meetup is happening on 11th May , in the Bank of Ireland Grand Canal Dock. This is a free event and is open to every one. You don't have to be a member to attend. Following on from a very successful 2 day OUG Ireland Conference...
56 0 /
Denny Cherry
Follow /26 Apr 2017 at 5:00pm / SQL Server Blog

Partitioned Tables and ColumnStore

ColumnStore indexes are all the rage with data warehouses. They’re fast, they’re new(ish) and they solve all sorts of problems when dealing with massive amounts of data.  However they can cause some issues as well if you aren’t very...
62 0 /
Porus Homi Havewala
Follow /25 Apr 2017 at 12:08am / Oracle Blog

Consolidation Planning for the Cloud - Part IX

by Porus Homi Havewala We started to detail the concept and workings of Consolidation Planning for the Cloud, using Oracle Enterprise Manager Cloud Control 13c, in the previous parts of this article series. This is Part IX. To recap, in the previous...
299 0 /
Kevin Dalton

What's New in Benchmark Factory 7.6

We are pleased to announce the availability of Benchmark Factory 7.6! There are many enhancements/fixes in this release, but below are a few of which I want to point out. REST API With this release BMF now has a REST API which will allow users...
47 0 /
Follow /20 Apr 2017 at 5:46pm / Postgres - Blog

The pg_rewind Improvements in PostgreSQL 9.6

By Vibhor Kumar The pg_rewind tool was first introduced in PostgreSQL 9.5. This is best used in a situation when a standby becomes a master, then the old master can be reattached to the new master as a standby without restoring it from the new base...
40 0 /
Gokhan Atil
Follow /19 Apr 2017 at 10:49am / Oracle Blog

Using EMCLI for Mass Update a Property Value

Here’s a quick and simple script which can help you to update a target property value of all targets running on a specific host. The script will expect you to enter 3 parameters: host name, property name and property value. Then it will search for...
284 0 /
Brendan Tierney
Follow /18 Apr 2017 at 3:55pm / Oracle Blog

ODM Model View Details Views in Oracle 12.2

A new feature for Oracle Data Mining in Oracle 12.2 is the new Model Details views. In Oracle and up to Oracle 12.1 you needed to use a range of PL/SQL functions (in DBMS_DATA_MINING package) to inspect the details of a data mining/machine learning...
268 0 /