(Art van Scheppingen) SELECT … FOR UPDATE has a (not so) surprising side effect on non-existent rows: it could cause a (serious) performance penalty and even prevent you from inserting new rows at all.
Community
Learn Angular 8 Step By Step In 10 Days – HttpClient Or Ajax Call – Day Nine
(Debasis Saha) Welcome back to the Learn Angular 8 in 10 Days article series – Part 9. In the previous article, we discussed the different concepts of Service in Angular.
Wrapping The FusionReactor API (FRAPI) For Safe Consumption In Lucee CFML 5.2.9.40
(Ben Nadel) Over the weekend, I looked at how to use the FusionReactor API (FRAPI) to instrument ColdFusion code. In that post, I was referencing the FRAPI Java class directly; which, only works if you have the FusionReactor Java Agent installed.
Modernizing an Oracle Forms Application to an Oracle APEX Application
(Monica Godoy) Oracle Forms is an established technology that has been popular for building data applications for decades, particularly in South America you can find a vast array of companies working with Oracle Forms, even with an unsupported version.
MySQL Encryption: Master Key Encryption in InnoDB
(Robert Golebiowski) In the previous blog post of this series, MySQL Encryption: Talking About Keyrings, I described how keyrings work. In this post, I will talk about how master key encryption works and what the pros and cons are of using envelope encryption such as a master key.
Synchronously Refreshing a Power BI Dataset using Azure Logic Apps
(Koen Verbeeck) I’m able to refresh a Power Dataset in the Power BI service using the Power BI API. The solution is built in an Azure Logic App. However, when the action calls the API, it immediately succeeds without giving an indication if the refresh actually succeeded or not. Is it possible to do
Add a Turbocharged Data Grid to Your Angular Application
(Robert_Dyball) An article that explores how developers of enterprise web applications that need to display data in grids can use Wijmo FlexGrid, a mature, fully supported data grid.
Exporting Visual Studio App Center Data to Azure Application Insights
(Abhijit Jana) Visual Studio App Center allows continuous build, release, test, and monitor of our cross-platform applications. It has a robust integration with Azure DevOps. We can leverage the Continuous Integration and Continuous Deployment from Azure DevOps and, at the same time, deploy, distrib
SQL SERVER – Log Shipping Job Error: Failed to Connect to Server
(Pinal Dave) A few days ago, I wrote a blog about log shipping job failure due to missing permission. In this blog, I would share my experience with another log shipping error “Connection Timeout Expired” for which my client contacted me via Comprehensive Database Performance Health Check.
OCI Serverless Functions invoking other Functions – synchronous and asynchronously through API Gateway and Streaming
(Lucas Jellema) OCI allows for cloud native application development, using facilities such as serverless functions, a light weight API gateway, a streaming service for asynchronous communication based on event messaging and built-in monitoring.