Expert Blogs - Toad World

Expert Blogs


Clarisa Maman Orfali
Follow /25 May 2016 at 3:29am / Oracle Blog

Acciones Dinámicas ejecutando Código PL/SQL

El siguiente ejemplo extraído del demo de las acciones dinámicas de APEX vamos a recrear un ejemplo en el cual usaremos una acción dinámica ejecutando código PL/SQL que actualice el informe interactivo de los empleados...
14 0 /
Fernando Garcia
Follow /25 May 2016 at 1:19am / NoSQL Blog

Big Data. ¿Por qué Hadoop?

Con el advenimiento de la era del Big Data estamos siendo testigos de la aparición de un sinfín de nuevas técnicas y tecnologías. Muchos profesionales de TI se encuentran ante el siguiente interrogante: ¿Por dónde...
63 0 /
Follow /24 May 2016 at 9:07pm / SQL Server Blog

XML-> JSON document Example

Convert the XML document to JSON document example <person> <name>John</name> <age>25</age> <address> <city>New York</city> <postalCode>10021</postalCode> </address> <phones>...
44 0 /
Colleen Morrow
Follow /24 May 2016 at 3:00pm / SQL Server Blog

SQL Server Service Broker – Internal Activation

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine. Previous posts: SQL Server Service Broker – Introduction SQL Server...
56 0 /
Follow /23 May 2016 at 8:12pm / SQL Server Blog

PowerShell : Scripting Logins, Role Assignments and Server Permissions Using PowerShell

This post is a continuation of Multiple DB refresh automation using PowerShell post . The OP requested me to automate the login transfer process as well. The script should generate an outfile and execute the file on the target server. <# .ProblemStatement...
75 0 /
Dan Hotka
Follow /23 May 2016 at 5:02pm / Oracle Blog

Oracle Optimizer Internals (Oracle12)

Last week I indicated a problem of poor performance with Oracle11.2’s cardinality feedback. Oracle12 expands upon this cardinality feedback to do ‘adaptive plan management’ or the ability to change the execution plan on the fly while...
81 1 /
Follow /23 May 2016 at 2:51pm / Oracle Blog

Exporting an Org Chart from HCM Cloud

Introduction Recently we were asked about the Directory within Oracle HCM Cloud. The online view within the system is fine, but in order to get approval that the hierarchy was correct they want to print out sections and get executive signatures on...
51 0 /
Follow /22 May 2016 at 11:37am / Oracle Blog

Ensuring Data Protection Using Oracle Flashback Features - Part 5

Introduction In the previous article we have reviewed Oracle 11g and 12c Flashback new features and enhancements. In this part (last one in this articles series) we will review the Oracle Flashback licensing. In addition, we will also summarize everything...
75 0 /
Jen Stirrup
Follow /21 May 2016 at 4:42pm / SQL Server Blog

The world of Analytics and crossing the Rubicon and the Acheron

49 years BC, the commander of the 13th Legion stood at the River Rubicon, and paused. The dilemma was over whether or not to enter Italy. for a man who had built a career on surmounting crisis point over crisis point, this move would change the Roman...
98 0 /
Follow /20 May 2016 at 12:00pm / IBM DB2 Blog

DB2 Basics: What Filesystems does my Database Actively Use?

If you only ever take the defaults, DB2 places all databases, data, and so forth on one filesystem – whatever filesystem is the home filesystem for the DB2 instance owner. If that is an isolated filesystem, this can be acceptable, but more often...
49 0 /

What is new in Spotlight on SQL Server Enterprise version 11.6?

Spotlight on SQL Server Enterprise 11.6 is here! So what’s new? Spotlight introduces Federation architecture A Spotlight Client can now monitor connections from multiple Spotlight Diagnostic Servers in a federation. Spotlight Clients in...
55 0 /
Brad Wulf
Follow /19 May 2016 at 3:57pm / Toad - Mac Edition Blog

Top MongoDB features in Toad – Part 6

The latest release of Toad Mac Edition is now available and its chock full of new MongoDB functionality. One of the major themes of this release is helping users edit JSON documents/collections stored in MongoDB in place – In Toads Object properties...
254 0 /
Brad Wulf
Follow /19 May 2016 at 3:56pm / Toad - Mac Edition Blog

Toad for Hadoop – Impala SQL Editor

With the release of Toad for Hadoop 1.3.0 we’ve introduced Impala SQL on Hadoop editor support! To configure, select Window | Preferences | Ecosystems | <your ecosystem with Impala> | SQL Check the ‘Use Impala’ checkbox and...
256 0 /
Norm [TeamT]
Follow /19 May 2016 at 12:26pm / Oracle Blog

Tnsnames.ora, IFILE and Network Drives on Windows

I’ve recently begun a new contract migrating a Solaris 9i database to Oracle 11gR2 on Windows, in the Azure cloud. I hate windows with a vengeance and this hasn’t made me change my opinion! One of the planned improvements is to have everyone...
82 0 /
Kellyn PotVin
Follow /18 May 2016 at 7:11pm / Oracle Blog

Changes to Configuration Management in EM13c

Change is difficult for technical folks.  Our world is always moving at blinding speed, so if you start changing things that we don’t think need to be changed, even if you improve upon them, we’re not always appreciative. Configuration...
49 0 /
Follow /18 May 2016 at 4:22pm / IBM DB2 Blog

Learn from Everyone’s Sessions at IDUG

Another IDUG conference is coming up, and the agenda of presentations looks great.  The IDUG conference planning Committee always does a great job, and the agenda shows many extra educational sessions. This year’s IDUG conference addresses the latest...
48 0 /
James Serra
Follow /18 May 2016 at 4:00pm / SQL Server Blog

Migrate from on-prem SQL server to Azure VM IaaS

Hopefully you went through my presentations  Should I move my database to the cloud? ,  Introducing Azure SQL Database  and  Implement SQL Server on an Azure VM and are convinced to move your databases to the cloud.  If you are going to migrate to Azure...
65 0 /
Jen McCown
Follow /18 May 2016 at 4:00pm / SQL Server Blog

Minion CheckDB Beta

Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is the time. We’re putting the finishing touches on the 1st beta and it’s looking great with some fabulous features. So this is the open call...
96 0 /
Denny Cherry
Follow /18 May 2016 at 3:00pm / SQL Server Blog

Move on Brogrammers, your comments aren’t welcome anywhere.

Recently Jen McCown received a speaker evaluation form from a SQL Saturday attendee.  Now normally this wouldn’t be a blog worthy event as this happens several times a year as there are easily 100 SQL Saturday’s a year..  The reason that this...
93 0 /
Kenneth Fisher
Follow /18 May 2016 at 3:00pm / SQL Server Blog

Re-Evaluating Best Practices

I was reading a blog post from my friend Randolph West ( b / t ) on Best Practices and a thought struck me. Starting with Randolph’s definition of a best practice (he got it from Wikipedia and it’s more than good enough) A best practice...
54 0 /
Craig Mullins
Follow /18 May 2016 at 2:39pm / IBM DB2 Blog

DB2 -- What's in a Name?

Versions of DB2 exist for a large array of platforms, of which the mainframe (z/OS) is only one. Of course, it is my favorite one since I’ve been working on mainframe technology now for decades and have worked with DB2 on the mainframe since Version...
112 0 /
Iggy Fernandez
Follow /18 May 2016 at 2:00pm / Oracle Blog

The best idea since 1992: Putting the C into ACID (We need your vote)

Oracle Corporation is asking for community feedback on the SQL-92 CREATE ASSERTION feature. If you would like them implemented in Oracle Database, please vote at (click on the up-arrow). Yuu need to log into your...
1547 0 /
Ajith Narayanan
Follow /18 May 2016 at 1:16pm / Oracle Blog

Remote Connect to MySQL Database Using 'MySQL Query Browser'

There was a recent requirement for giving remote access to the MySQL database to our ERP consultant for him to connect from home and do the work. Our MySQL database was running on our cloud “Omegha” and was by default restricted of any remote...
90 0 /
Sten Vesterli
Follow /18 May 2016 at 11:21am / Oracle Blog

The Seven Stages of Oracle Announcements

I just listened to an Oracle webcast, where they "announced" a product. It sounded great and I got all excited, but when trying to actually use the product, I found that it was in an earlier stage of announcement. Experience shows that there...
404 0 /
Fernando Garcia
Follow /18 May 2016 at 1:32am / NoSQL Blog

El talento del Big Data.

En los últimos años Internet, las redes sociales y los dispositivos móviles han conformado un combo explosivo: un torrente de datos digitales en continua generación. La explosión masiva de dicho combo da nacimiento a...
114 0 /