(Hemant K Chitale) Building on the example of an Index having been created on a Materialized View in my previous blog post in this series, I’ve captured some information from the AWR report in 19c when this code is executed :
Community
fixing a failed APEX installation
(Martin Berger) Today I tried to install APEX 19.2.0.00.18 into a 19.5 database, but apexins.sql failed with
Guru: RDi V9.6, Part 6 – The New Object Table Gets Even Better
(Susan Gantner) RDi V9.6 seems to be the gift that keeps on giving. I started this series about this release of RDi almost two years ago. You may have thought my last (fifth) tip in the series was the last on this subject, but it turns out there’s still more!
Developing SPAs with ASP.NET Core v3.0
(Daniel Jimenez Garcia) This tutorial demonstrates how to integrate four different SPA frameworks within ASP.NET Core v3 for Angular, React, Vue and Svelte. This ASP.NET Core tutorial also demontrates how to create your own custom SPA template.
Trying To Debug ‘Deadlock found when trying to get lock; try restarting transaction’ Errors In Lucee CFML 5.2.9.40
(Ben Nadel) The other day, Josh Siok and I were running into a strange problem: we were executing a ColdFusion page that was immediately terminating in a Transaction Deadlock error in MySQL.
VS Code Previews JavaScript Debugger, Search Editor, Timeline View, More
(David Ramel) The January 2020 update of Visual Studio Code, v1.42, is out with a bunch of new features and previews of an upcoming JavaScript debugger, Search editor, Timeline view and more.
MySQL Docker Containers: Quick Async Replication Test Setup
(Arunjith Aravindan) This blog discusses a few concepts about Docker and how we can use it to run a MySQL async replication environment. Docker is a tool designed to make it easier for developers and sysadmins to create/develop, configure, and run applications with containers.
Track and Monitor SQL Server View Usage
(Rick Dobson) I recently was tasked with tracking and monitoring views in the SQL Server databases that I administer. Among the attributes that I am required to track are code module name, defining T-SQL for a module, created and last modified dates, and last run datetime. Please demonstrate how t
Can’t Move Team Services (VSTS) between Resource Groups in Azure
(OwenDavies) This morning I tried to move our VSTS (Visual Studio Team Services) account, from one Resource Group, to another.
Unpivoting Oracle APEX meta-data
(Scott Wesley) There are APEX dictionary views for most of the data that represents the ‘source’ that is your APEX application meta-data.