Expert Blogs - Toad World

Expert Blogs


Pinal Dave
Follow /26 Oct 2016 at 2:30am / SQL Server Blog

SQL SERVER – FIX Error 5120 – Database is in Read Only Mode After Attaching Files

Sometimes you need to know more about permissions on file, service account etc. to fix certain errors. In my recent visit to a customer location, one of the database developers came to me with a problem. He said that when he attaches MDF and LDF file...
40 0 /
Clarisa Maman Orfali
Follow /25 Oct 2016 at 11:53pm / Oracle Blog

Mostrar Mensajes y Noticias en nuestro Espacio de Trabajo

En este pequeño artículo quiero mostrarte cómo puedes fácilmente mostrar noticias y mensajes propios en tu Espacio de Trabajo. La región de Noticias y Mensajes de nuestro Espacio de Trabajo puede mostrar 3 tipos de...
41 0 /
Clarisa Maman Orfali
Follow /25 Oct 2016 at 9:41pm / Oracle Blog

Configurar el aislamiento de un Espacio de Trabajo para evitar ataques del Navegador

Un tema muy importante a la hora de trabajar con APEX es la seguridad. Hay muchas maneras diferentes para dar mayor seguridad a nuestras aplicaciones, en este caso vamos a hablar sobre como el administrador de la Instancia puede aislar el espacio de trabajo...
38 0 /
Syed Jaffar Hussain
Follow /25 Oct 2016 at 4:31pm / Oracle Blog

Wanna become an OCM? Go on read out Kamran's new OCM practical guide - MY TAKE

When I first heard about Kamran's new book, OCM practical guide, I said wow, because I was thinking on the same line a few years back, but, dropped the idea due to several factors, including the fact that the time and efforts required on this book...
44 0 /
Brendan Tierney
Follow /25 Oct 2016 at 3:45pm / Oracle Blog

Oracle Text, Oracle R Enterprise and Oracle Data Mining - Part 5

In this 5th blog post in my series on using the capabilities of Oracle Text, Oracle R Enterprise and Oracle Data Mining to process documents and text, I will have a look at some of the machine learning features of Oracle Text. Oracle Text comes with a...
38 0 /
Dan Hotka
Follow /25 Oct 2016 at 3:01pm / Oracle Blog

Oracle 12.2 New Features for Developers - Conditional Compilation

Hi, We continue this series of blogs on New Features for Developers with some updated conditional compilation features. This feature allows for you to get rid of the upper and lower functions when comparing character strings to literals. You can...
42 0 /
Arun Sirpal
Follow /25 Oct 2016 at 3:02am / SQL Server Blog

Azure App Service Companion for iOS

This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt like blogging about it. I saw an announcement recently and I was intrigued by it. All my excitement was over … Continue reading →
58 0 /
Pinal Dave
Follow /25 Oct 2016 at 2:30am / SQL Server Blog

SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time

Recently I was troubleshooting at a customer location something that looked trivial. When the customer approached me for a consulting requirement wherein they were saying their system was going unresponsive every day in the morning around a certain time...
59 0 /
Fernando Garcia
Follow /24 Oct 2016 at 11:33pm / NoSQL Blog

Análisis de datos con Python (I)

Cuando ingresamos al mundo del Big Data y el análisis de datos solemos comenzar a estudiar diversas tecnologías de infraestructura, almacenamiento y modelización. Así es como nos sumergimos en soluciones como Hadoop, HDFS,...
75 0 /
Follow /24 Oct 2016 at 7:38pm / SQL Server Blog

PowerShell : CSV – Disk Space Report – Excel

Abstract Monitoring disk space utilization of server(s) is a critical and important job for any administrator. Keeping things organized might improve application availability and server availability. Being a database administrator for 10 years, I have...
31 0 /
Steven Feuerstein
Follow /24 Oct 2016 at 5:46pm / Oracle Blog

Naming Conventions for Oracle Database Development

I occasionally am asked about naming conventions for PL/SQL program units. I did publish a document back in 2009 (link below), but there are also other sources for naming conventions from others, offering different ideas and excellent motivation for standardizing...
48 0 /
Kenneth Fisher
Follow /24 Oct 2016 at 2:00pm / SQL Server Blog

Synchronous vs Asynchronous

You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we care? Starting with simple definitions first: Synchronous occurring at the same time; coinciding in time; contemporaneous; simultaneous...
37 0 /
Follow /24 Oct 2016 at 12:43pm / Oracle Blog

Create new swap file to Linux

to add new swap file to Linux just follow the below steps , in my case i will add 32GB and i am not using LVM :- just create file by the below command :- touch /new.swap Write on the file :- dd if=/dev/zero of=/new.swap bs=1024 count=33554432 Format the...
66 0 /
Sten Vesterli
Follow /24 Oct 2016 at 12:02pm / Oracle Blog

ADF is a Strategic Choice

At OpenWorld, I gave my evergreen presentation "The Five Ways of Building Oracle Applications", but now expanded into seven ways. Oracle currently offers the following toolkits and frameworks for application development: Forms ADF ...
235 0 /
Follow /24 Oct 2016 at 8:00am / Oracle Blog

Direct NFS: please check that oradism is setuid

The above error appeared in Database Alertlog and it's related to permission, i am using DNFS as file system for Database :- ls -ltr $ORACLE_HOME/bin/oradism -rwxrwxr-x 1 sorabill oinstall 109247 Jul 7 2014 /u01/app/oracle/product/12.1.0/dbhome_1...
63 0 /
Nakul Vachhrajani
Follow /24 Oct 2016 at 4:30am / SQL Server Blog

#0391 – SQL Server – SSIS – OLE DB Destination – Table Fast Load – Performance – Table Lock option

The "Table Lock" checkbox on an OLE DB destination task works identical to the T-SQL TABLOCK table hint. I explore how to leverage OLE DB Table Lock setting to get better SQL Server data load performance.
65 0 /
Pinal Dave
Follow /24 Oct 2016 at 2:30am / SQL Server Blog

PowerShell – Script to Listing all Backups Taken with SQL Server

I always like to keep a number of scripts handy in my USB drive with my Laptop. These scripts are used for my internal use when I am suddenly looking for something interesting in customer environments. One of the scripts that I use is shown below. Many...
65 0 /
Deiby Gomez
Follow /23 Oct 2016 at 10:05pm / Oracle Blog

Invisible Columns in Oracle 12c

Starting in Oracle there are several new features, +500 I have heard, and one of a good features for developers is "Invisible Columns". Invisible Columns allows a developer create a table with some special columns. These special columns...
256 0 /
Abu Fazal Abbas
Follow /23 Oct 2016 at 8:50am / Oracle Blog

Oracle 12c: Customize your seed (pdb$seed) template PDB

Oracle has introduced multi tenant architecture with the release of Oracle database 12c ( In a multi tenant Oracle database, we have a ROOT container database (CDB$ROOT), a SEED database (PDB$SEED) and the potential to have a number of pluggable...
226 0 /
Porus Homi Havewala
Follow /23 Oct 2016 at 3:28am / Oracle Blog

MySQL Enterprise Monitor 3.3 generally available (GA)

The Oracle MySQL database has an Enterprise Edition , and included with that subscription is MySQL Enterprise Monitor which is a tool to monitor and manage MySQL databases. The latest release of MySQL Enterprise Monitor is version 3.3, recently released...
67 0 /
Pinal Dave
Follow /23 Oct 2016 at 2:30am / SQL Server Blog

Fastest Way to Display Code of Any Stored Procedure – Interview Question of the Week #094

A very common question I often see users not sure about the answer. This is indeed a tricky question, but a very simple one. If I am the interviewer, I may ask this question to the user, but if they do not know the answer of this question, I would not...
88 0 /
Nassyam Basha
Follow /22 Oct 2016 at 3:34pm / Oracle Blog

DB Link between Oracle and MSSQL and resulted “internal error in heterogeneous remote agent”

DB Link between Oracle and MSSQL and resulted “internal error in heterogeneous remote agent” This blog post based on the experience with one of customer, it is so simple but i rarely worked on these heterogeneous db links, so am writing for...
74 0 /
Nassyam Basha
Follow /22 Oct 2016 at 3:18pm / Oracle Blog

Know size of all databases from OMR – #EM

Know size of all databases from OMR – #EM I have been asked to know all the databases size and export them in excel file, that’s all!!!  We are using EM 11.1 of course old but that is no matter for me and in total we have 173 target databases...
74 0 /
Nassyam Basha
Follow /22 Oct 2016 at 2:58pm / Oracle Blog

ORA-3113 End of communication channel with Select query vs sqlnet.ora

ORA-3113 End of communication channel with Select query vs sqlnet.ora This blog post writing based on the recent issue i’ve seen, Let’s start, customer reported as connection to the database from the client version 11gR2 was successful...
60 0 /
Syed Jaffar Hussain
Follow /22 Oct 2016 at 10:53am / Oracle Blog

Is Fixed Objects Stats needed in PDB?

Doesn't matter if we are working on a new technology or something we are very family with. When we encounter tricky situations, sometimes neither we could find things in the manuals nor could find any useful references. All what you need is an action...
77 0 /