Whether you're extending a trail, purchasing a new license, or renewing an existing license, we want to make sure the process is as simple as possible so you can get to back to efficiently managing yo...
When working with large projects in Toad Data Modeler it is important to be able to organize your models. Through the use of categories you can color code your entities so that you can quickly identif...
Docker for Windows was introduced recently. Docker for Windows runs Docker containers on Windows OS similar to running Docker containers on Linux platforms. The novelty of Docker for Windows is Docker...
If you were at the PASS Summit, Live360 in November, or SQL Saturday in Slovenia in December, you may have noticed that I couldn’t make it to these events. It turns out that I had a medical issue that...
Near the end of the blog entry I most recently posted prior to this one , I mentioned that a specification of MEMBER CLUSTER for a Db2 for z/OS universal table space could help maximize INSERT through...
In this post we are going to create a project in Jenkins that drops all objects from a database to prepare it for a clean script deployment. In order to do this in Jenkins, we need the sql script tha...
This blog post highlights some of the essentials of Oracle cloud Database service offerings and its advantages. Also discuss about Database deployment (DBaaS) benefits and tools that can be used to au...
Introduction Toad for SQL Server is an integrated development environment (IDE) for accessing, administering and using SQL Server. The SQL Server may be on a local machine or may be on a remote platf...
Yesterday, I explained how we can access MySQL database from Zeppelin which comes with Oracle Big Data Cloud Service Compute Edition (BDCSCE). Although we can use Zeppelin to access MySQL, we still ne...
If you want to access MySQL Cloud Service using Zeppelin of Oracle Big Data Cloud Service Compute Edition (BDCSCE), you can use Spark DataFrames or Zeppelin interpreters. In this blog post, I’ll show ...
PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java language and hamper its adoption. First, there are a ...
Postgres supports both traditional join syntax, which uses the where clause to specify joined columns, and ansi join syntax, that uses the word join in the from clause. While both syntaxes can be used...
