Expert Blogs - Toad World

Expert Blogs


Michael J. Swart
Follow /31 May 2016 at 3:28pm / SQL Server Blog

Some Thoughts On Logos

So today is the last Tuesday in May which means that next Tuesday is the first Tuesday in June. On that day, you can expect me to invite all SQL bloggers to participate in June’s T-SQL Tuesday. So I’m thinking about my invite post: What will...
32 0 /
Iggy Fernandez
Follow /31 May 2016 at 1:00am / Oracle Blog

NoSQL workshop at Oracle user group conference

Oracle NoSQL Database has been regularly featured at the conferences of the Northern California Oracle Users Group. But, at its most recent conference, the Northern California Oracle Users Group dared to play outside the Oracle sandbox with a whole day...
597 0 /
Michael J. Swart
Follow /30 May 2016 at 7:36pm / SQL Server Blog

One SSMS Improvement You Might Have Missed

Takeaway: Undocked query windows in SSMS are now top-level windows. SSMS Release Cycle As you may know, SQL Server Management Studio (SSMS) now has its own release cycle independent of SQL Server’s release cycle. This means the Microsoft team...
69 0 /
Follow /30 May 2016 at 2:10pm / Oracle Blog Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

trying to startup EBS R12.2. with the following error :- Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong. to solve this do the following :- [oracle@tiperp tsterp]$ cd $APPL_TOP...
58 0 /
Brendan Tierney
Follow /30 May 2016 at 9:36am / Oracle Blog

PREDICTION_DETAILS function in Oracle

When building predictive models the data scientist can spend a large amount of time examining the models produced and how they work and perform on their hold out sample data sets. They do this to understand is the model gives a good general representation...
76 0 /
Henrik Loeser
Follow /30 May 2016 at 8:34am / IBM DB2 Blog

New IBM Knowledge Center for DB2 and other products

29 0 /
Deiby Gomez
Follow /29 May 2016 at 10:15am / Oracle Blog

How to change the database name in 12c

To change the database name is a common task for every Oracle Database Administrator, however with every version some things change and it is necessary to review the process that we have been using in order to confirm if it is still valid or not in a...
94 0 /
Follow /28 May 2016 at 10:09am / SQL Server Blog

Restore a SQL Server Database with Different Methods

Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a common scenario that takes place every now and then lead to the loss of an enormous amount of data. In order to sustain the...
149 0 /
Paul Turley
Follow /27 May 2016 at 11:41pm / SQL Server Blog

Where are SQL Server 2016 Client Tools?

So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools all the components you needed.  You look for SSMS and, what the heck?  it’s not there.  OMG, what have they done?! SSMS is Gone...
89 0 /
Clarisa Maman Orfali
Follow /27 May 2016 at 10:51pm / Oracle Blog

Plantilla de Región Hero

Generalmente cuando creamos nuestras páginas en APEX, la región de la “Ruta de Navegación” se muestra con la plantilla “Title Bar”, como vemos en la imagen de abajo: Para que nuestras páginas se...
83 0 /
Deiby Gomez
Follow /27 May 2016 at 8:55am / Oracle Blog

TFA - Upgrading your latest version to the latest version

In my previous article about TFA, I showed how to upgrade TFA with the binaries from Oracle Metalink, this allowed us to use many of the diagnostic tools directly from TFA. However, my friend Gleb Otochkin provided me a tip that can be useful for all...
84 0 /
Follow /26 May 2016 at 12:00pm / IBM DB2 Blog

Deprecated, Discontinued, and Changed Defined for DB2

With each new release of DB2, there is a list of three different categories of old functionality that is somehow different in the new version. The use of these terms can be confusing if you don’t look at them every day. Discontinued Discontinued...
53 0 /
Deiby Gomez
Follow /26 May 2016 at 9:35am / Oracle Blog

How to Drop a Tablespace with deleted datafiles

Some times we have to deal with a tablespace that for some reason, its datafiles were deleted. In that case, we have two options, either restore the deleted datafiles and apply a recovery process or drop the tablespace if its data is not needed anymore...
103 0 /
Robert Catterall
Follow /26 May 2016 at 12:09am / IBM DB2 Blog

DB2 for z/OS: When Did You Last Check Your Checkpoint Frequency?

I have written in this blog a few entries about various DB2 for z/OS ZPARM parameters, including a post on DSMAX and another on EDM_SKELETON_POOL . Time for another such entry, this time focused on the parameters that determine when a DB2 subsystem will...
47 0 /
Follow /25 May 2016 at 10:29pm / SQL Server Blog

The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

“The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)” error may occurs when executing PowerShell scripts using WMI query. There can be a few reasons for this error: The remote computer is blocked by the firewall. Solution...
87 0 /
Sten Vesterli
Follow /25 May 2016 at 3:14pm / Oracle Blog

Oracle: Now Really in the Cloud

The "buying experience" for Oracle Cloud solutions has not been very cloud-like until now. Most services did not have the "Buy Now" button that other cloud vendors offer, but instead a list of phone numbers (yes, really!) for local...
275 0 /
Brad Wulf
Follow /25 May 2016 at 2:47pm / Toad for Hadoop - Blog

Toad for Hadoop – Easily Synchronize your Local Files with Hadoop File System (HDFS)

This was actually a user enhancement request . The idea was to take inspiration from an ftp client and use that same concept to keep local FS and HDFS in sync bi – directionally. Just go to the HDFS perspective in Toad for Hadoop, right click...
56 0 /
Kenneth Fisher
Follow /25 May 2016 at 2:00pm / SQL Server Blog

Connecting to Azure SQL Database

Recently I created my first Azure SQL Database . But now I need to connect to it. You can connect using any number of tools. We can actually see several options by going back to our Azure Portal . Select the SQL Databases list, a specific SQL Database...
173 0 /
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...
100 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...
177 0 /
Follow /24 May 2016 at 9:14pm / SQL Server Blog

Some Pester Tests for SQL Defaults

When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the slides and code here ) I found out about Irwin Strachans Active Directory Operations Test which got me thinking. I decided to do the...
82 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>...
126 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...
129 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...
138 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...
123 1 /