Expert Blogs - Toad World

Expert Blogs

Blogs

Deiby Gomez
Follow /25 Jul 2017 at 7:08pm / Oracle Blog

Oracle Database 12.2 - How to track index usage

By Deiby Gómez Introduction Several articles have been written about how to track the usage of indexes and there are several scripts to determine which indexes are being used after monitoring for a while. In previous versions to 12cR2 of...
63 0 /
Deiby Gomez
Follow /25 Jul 2017 at 5:38pm / Oracle Blog

How to analyze Undo statistics to proactively avoid undo space issues

By Deiby Gómez Introduction In my previous articles I explained two very important concepts about Undo Data; one is how Oracle manages the retention time and the other is how Oracle reuses the undo extents . You can also check my presentation...
59 0 /
Ondrej.Zizka
Follow /25 Jul 2017 at 5:26pm / Toad for IBM DB2 Blog

Install Toad for DB2 version 6.3 using IBM Data Server Driver

In this blog post, I would like to show you how to install Toad for DB2 version 6.3 and IBM Data Server Driver. Using IBM Data Server Driver is a new option in Toad for DB2 version 6.3. Previously it was necessary to use IBM Data Server Client, but now...
45 0 /
Brendan Tierney
Follow /24 Jul 2017 at 4:19pm / Oracle Blog

Part 4b - (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 (Part4b) I will examine some of the more technical aspects and how the in-database machine learning functions saves...
75 0 /
Dan Hotka
Follow /21 Jul 2017 at 9:20pm / Oracle Blog

Oracle 12.2 New Features: Scheduler, Data Pump, and More

Hi, I’ve written a lot of articles on Oracle12 new features. This article will conclude the series with a list of miscellaneous new features for the various other tools like data pump, the scheduler, and SQL*Loader. Other Dan Hotka Oracle12...
159 1 /
Robert Catterall
Follow /21 Jul 2017 at 9:08pm / IBM DB2 Blog

Db2 12 for z/OS SQL Enhancements: Result Set Pagination

In this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and "Db2," versus "DB2," is officially the new form of the product name), I will describe useful functionality pertaining to...
42 0 /
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...
136 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...
148 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...
39 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...
34 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...
83 0 /
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...
35 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...
44 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...
110 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
95 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...
44 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 quest.com. Toad for DB2 is a comprehensive solution to improve DBA and...
129 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...
52 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...
67 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...
132 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...
124 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...
325 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...
159 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...
278 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 12.2.0.1 introduces the concept of multi-tenant application containers that enable many PDBs to share application objects such as code, metadata...
583 1 /