Expert Blogs - Toad World

Expert Blogs


Sten Vesterli
Follow /29 Aug 2016 at 3:36pm / Oracle Blog

APEX 5.1 Early Adopter 2 coming

If you've been working with APEX 5.1 early adopter 1 (EA1) at , you should have received notification from Oracle that it will be shutting down soon. As we were told when signing up, there is no way to transfer applications...
0 0 /
Follow /29 Aug 2016 at 12:59pm / Oracle Blog

CRS-5013 RAC 12c

When starting Oracle RAC 12c the following error appears :- [root@------ bin]# ./crsctl check cluster CRS-4535: Cannot communicate with Cluster Ready Services CRS-4530: Communications failure contacting Cluster Synchronization Services daemon CRS-4534...
19 0 /
Nakul Vachhrajani
Follow /29 Aug 2016 at 4:30am / SQL Server Blog

#0383 – SQL Server – Basics – Msg 1013 – The objects in the FROM clause have the same exposed names. Use correlation names to distinguish them.

A personal best practice to ensure that objects in a query are aliased properly avoids SQL Server error Msg 1013 - "The objects in the FROM clause have the same exposed names. Use correlation names to distinguish them"
54 0 /
Pinal Dave
Follow /29 Aug 2016 at 2:30am / SQL Server Blog

SQL SERVER – GetRegKeyAccessMask : Could Not Get Registry Access Mask For Registry Key – SQL Server Cluster

I have been getting many requests from my HIRE-ME page and a few of them are getting change to my blog. This is the outcome of one of my clients who was having a strange issue. They were having 2 nodes SQL Server Cluster (NODE1 and NODE2) and SQL Server...
4 0 /
Pinal Dave
Follow /28 Aug 2016 at 2:30am / SQL Server Blog

How to Get Started with SQL Server 2016? – Interview Question of the Week #085

Interviews are two way streets, sometime interviewer asks questions and sometime candidate asks questions. In a recent interview, I was asked by a candidate “How to Get Started with SQL Server 2016?”. I think it is a very good question. Let...
5 0 /
Follow /27 Aug 2016 at 1:35pm / SQL Server Blog

Understanding the Different States of SQL Database

Overview There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in SQL server. At once, the database is only in one state, which may be any one of the following: Online Offline Restoring...
95 0 /
Pinal Dave
Follow /27 Aug 2016 at 2:30am / SQL Server Blog

SQL SERVER – How to Fix Error 8134 Divide by Zero Error Encountered

Here is one of the most popular questions: How to overcome (Error 8134) Divide by Zero Error Encountered in SQL Server? Before we see the answer of this question, let us see how to recreate this error. Run following script in SQL Server Management...
74 0 /
Jen McCown
Follow /26 Aug 2016 at 3:24pm / SQL Server Blog

An MCM teaches COMMENTS at SQL Saturday OKC

Tomorrow (as of the blog’s publish date) at8:30am, I will be teaching “T-SQL’s Hidden Support Feature” at SQL Saturday Oklahoma City (totally free, did you know? Free IT training, y’all.) I said in a recent blog about comments...
135 0 /
Jen Stirrup
Follow /26 Aug 2016 at 9:23am / SQL Server Blog

Jen’s PASS Diary: A week in the life of a PASS Non Executive Director

As always, I don’t officially represent PASS here. As you will know, this week the application opens to be on the Board of Directors for PASS . I’ve held my post for two and a half years, and I am not up for election this time. If anyone has...
126 0 /
Norm [TeamT]
Follow /26 Aug 2016 at 8:33am / Oracle Blog

Oraenv for Windows

Having recently had to learn a whole new way of working when I took on a contract migrating a database to the Windows “cloud”, I realised that there’s no equivalent to the useful Unix oraenv utility. I had to write my own. Give me a...
71 0 /
Pinal Dave
Follow /26 Aug 2016 at 2:30am / SQL Server Blog

Restore or Attach Database Without Log File – SQL in Sixty Seconds #082

One of the most common question I get on blog is – how do I attach database without log file. I have previously blogged about it over here . I request you to read this blog post if you want a solution where you can learn how to attach database to...
73 0 /
Norm [TeamT]
Follow /25 Aug 2016 at 3:45pm / Oracle Blog

Which Extra Cost Oracle Options is my Windows Server Running?

It’s always nice to know which extra cost Oracle options are enabled, whether deliberately or silently as the result of some patching that has taken place. Copy and paste the code below into a Windows command file named – in my case –...
139 0 /
Vinoth Nm
Follow /25 Aug 2016 at 3:27pm / SQL Server Blog

SQL Server 2016: SQLServer Powershell Module and Get-SQLErrorlog CMDLET

With the latest update to SQL Server 2016 SSMS there are some new interesting features added to the SQL Server Powershell making managing SQL Server through Powershell more easier and efficient. The Detailed information on the addition can be found in...
50 0 /
Roel Hartman
Follow /25 Aug 2016 at 12:56pm / Oracle Blog

Creating an APEX plugin for an Oracle JET component - Part 2

In my previous blogpost I showed how you can embed an Oracle JET component in your APEX application. Now it is time to make a plugin out of the wisdom we gained doing so. First of all a disclaimer. My intention is to make this plugin and the inner workings...
62 0 /
Follow /25 Aug 2016 at 12:00pm / IBM DB2 Blog

A Physical DBA Reviewing DDL

My background comes largely from the physical DBA world, though I’ve gained logical DBA skills over the years. Any reasonably mature IT organization will have a DBA at some level or another review SQL and DDL before it is implemented in production...
60 0 /
Svetoslav Gyurov
Follow /25 Aug 2016 at 10:27am / Oracle Blog

Grid Infrastructure 12c installation fails because of 255 in the subnet ID

I was doing another GI cluster installation last month when I got really weird error. While was running on the first node I got the following error: 2016/07/01 15:02:10 CLSRSC-343: Successfully started Oracle Clusterware stack 2016...
68 0 /
Pinal Dave
Follow /25 Aug 2016 at 2:30am / SQL Server Blog

SQL SERVER – Fix Error – Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

Here is a recent email which I received from Madhu. He is a beginner in the SQL Server and when he tried to take a backup from SSMS (SQL Server Management Studio), he got error related to backup file. As soon as he sent me an email I knew what was the...
102 0 /
Deiby Gomez
Follow /25 Aug 2016 at 1:51am / Oracle Blog

Thank you OTN Tour 2016

Oracle Technology Network Latin American Tour (OTN LA Tour) 2016 is done. I started my journey in Montevideo Uruguay, it was my first time there, and I had the opportunity to visit my good friends Nelson Calero and Edelweiss Kammermann . It was good to...
149 0 /
Clarisa Maman Orfali
Follow /24 Aug 2016 at 11:14pm / Oracle Blog

Oracle Developers Tour Latinoamerica 2016 - Call for Papers is Open!!

The Call for Papers for the Oracle Developers Tour Latino America 2016 is now open!! Speakers, we encourage you to submit yours presentations into the form that the ODT organization team has made for all the countries that participate of the Tour. Make...
82 0 /
Clarisa Maman Orfali
Follow /24 Aug 2016 at 11:09pm / Oracle Blog

The pool named: apex…. is not correctly configured… - Error 404 ORDS instalación en GlassFish

En esta oportunidad quiero compartir un error típico que aparece cuando estamos lo más bien trabajando con Apex en una instalación en Glassfish y cada cierto tiempo no podemos conectarnos y nos aparece el error 404. En un post...
83 0 /
John Sterrett
Follow /24 Aug 2016 at 9:25pm / SQL Server Blog

Calculating DTU in Azure SQL Database

A few months ago, I posted a question over on In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL? No one answered, so this motivated me get off my butt and answer...
69 0 /
Denny Cherry
Follow /24 Aug 2016 at 5:00pm / SQL Server Blog

Releasing a Page Blog Lease in Azure

Sometimes when firing up VMs or moving VMs from the page or blob store you’ll get an error that there is still a lease on the file.  To solve this you need to release the lease. But waiting won’t do the trick, as the leases don’t have...
56 0 /
Steven Feuerstein
Follow /24 Aug 2016 at 4:47pm / Oracle Blog

PL/SQL at Oracle Open World 2016

If you work with PL/SQL, you will not want to miss any of these sessions : The Best Oracle Database 12 c New Features for Developers and DBAs [UGF2028] Alex Zaballa , Senior Oracle Database Administrator , Accenture Enkitec Group This presentation looks...
289 0 /
Follow /24 Aug 2016 at 4:37pm / IBM DB2 Blog

3 Consideration for Enjoying the Data Lake

With all the outside activities with friends and family, summer vacations are always wonderful. Being outside at the lake enjoying the warm weather and cooling off in the lake are a wonderfully relaxing great times. This is the safe, content image that...
57 0 /
James Serra
Follow /24 Aug 2016 at 4:00pm / SQL Server Blog

SQL Server 2016 real-time operational analytics

SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both analytics (OLAP) and OLTP workloads on the same database tables at the same time.  This allows you to eliminate the need for ETL...
74 0 /