In this, the fourth of a set of four entries covering SQL enhancements introduced with Db2 12 for z/OS, I will describe new trigger capabilities delivered by way of what are called "advanced triggers"...
Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. Notice that all the ASM processes begin with asm, whereas ...
Introduction Virtualization is one of the core assets of today’s data center infrastructure. The benefits and capabilities of virtualization are driving organizations towards virtualization technologi...
This post contains spoilers for new version of LiteSpeed! Read under your entire responsibility. Don't tell me I did not warn you! We know that with LiteSpeed for SQL Server 8.5 we can backup to Azure...
Hi, Code Analysis has been in Toad for a while now. If you are using a slightly older version of Toad, it might be called Code Review, found under the same menu path. Code Analysis gives you or your...
Introduction Materialized views have been used for several years and they are being improved by Oracle with every database version or release. Up to Oracle Database 12cR1 Oracle Materialized Views sup...
Have you have found running a workflow in Oracle Data Miner slow or running the scripts in the database slow ? No. Good, because I haven't found it slow. But (there is always a but) it really depends...
If your IT department or development team is like a lot of those I talk with (and have worked in), you have a lot of scripts that do all sorts of things. They are important to you, and that’s why yo...
Introduction Data changes frequently in OLTP environments and Oracle has to be aware of those changes or at least to try detect these changes in order to adjust the optimizer and execute sentences in ...
The Query Builder enables you to create a query without writing or editing SQL statements. Even if you are familiar with SQL, the graphical interface makes it easier to create relationships and visual...
Use the Database Diagram to view a high-level, visual representation of an object and those objects which may be related to it. This helps you easily identify relationships between tables via foreign ...
Fear and confusion: two emotions you probably don’t like associated with your job. I see it often in my line of work, and have seen it for many years since I started working with mainframe files and ...
