As a dba, I will be executing various scripts in multiple databases. Mostly in non-productions databases. In the event, if any of these scripts were executed inadvertently in the production database...
Introduction Toad DevOps Toolkit is a Windows-based command-line tool for DevOps. DevOps was introduced in an earlier article. Toad for Oracle is an integrated development environment designed for Or...
The first impression TDT seems to give is that it is just like the other Toad products–but it is not. Toad DevOps Toolkit (TDT) is not like the other Toad products, which include a Graphical User Int...
As a former DBA, I don’t like surprises. DBAs always want to know ahead of time if an issue is about to occur or is occurring, and we never want to be surprised by hearing there is an issue. When a de...
Learn how you can access any menu, window, Toad World forum or support article with the Jump Search feature of Toad for Oracle....
SQL Navigator (affectionately know as SQL Nav) is an awesome tool for application developers. It has all of the features a developer needs: SQL tuning, PL/SQL debugging, schema browser, code completi...
Here is a series of videos by CJ Date on Relational Theory. Introduction video An Introduction to set theory (videos on O’Reilly website) Nullology (Videos on O’Reilly website) ...
Exadata comes with two types of servers, cell (storage) and compute (db). Its important for Database Machine Administrators (DMAs) to manage and configure servers for various purposes. For cell server...
Database statistics describe and give information about the data within a database. When the data is retrieved from the database via a query, the query optimizer generates an execution plan for the qu...
Two X6-2 Elastic Full capacity Exadata systems were deployed recently. Due to the following BUG, cell names were not properly updated with the client provided names after executing the applyElasticCon...
Introduction In the first part of this two-article tutorial on integrating an AWS CodePipeline with a Jenkins pipeline we introduced the importance of using a Jenkins pipeline to build and test code b...
It’s 2018 and welcome to it. Here’s hoping that 2018 is a easier year than 2017 was. For me, that means no brain tumor this year. Hopefully that’s a easy bar to hit. Denny The post appeared firs...
