We have all been there. We start making changes to data inside a table either manually or by running one or a series of queries, only to find out that we messed part of it up. We know we have our orig...
In Toad Data Modeler working with large data models is simplified by importing/exporting models into a format like Excel. Watch this video for a tutorial....
Prior to Oracle database 12.2.0.1, there could be following types of users in an Oracle multitenant container database (CDB) – Common User – A common user is created in the CDB root and has the same...
This post discusses creating a data redaction capability to comply with GDPR. It first appeared in article by Marc Linster on EDB’s website. I’ve republished it here with Marc’s permission. ** The GDP...
Last November saw our first launch of Toad DevOps Toolkit and since then we’ve seen a steady increase in interest and traction. For our latest Toad DevOps Toolkit release 1.1 we wanted to combine ...
Hybrid cloud management is an interestingly hot topic for today’s cloud world, since not all companies want to move everything to the cloud. In this article series, we are looking at the detailed step...
One of the new features of the Autonomous Data Warehouse Cloud (ADWC) service is Oracle Machine Learning. This is a Zeppelin based notebook for your machine learning on ADWC. Check out my previous blo...
Not all cloud providers are the same. Some are flexible and will grow and shrink with your needs and business (Azure, Amazon, Google Cloud), and some will not (IBM, Rackspace, Other Bare Metal clouds)...
It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming crutch. I have a theory as to why. Programmers are chiefly taug...
In this popular article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database-as-a-Service (DBaaS) cloud – including the setup of such a clo...
DevOps is everywhere, seemingly permeating every aspect of IT. The way that companies are building and managing their applications has become increasingly agile, and many of the comforts that DBA's u...
PostgreSQL database is an open source database that is almost fully SQL standard (SQL:2011) compliant. PostgreSQL provides features that are comparable or better than equivalent features in MySQL data...
