(Jean-François Gagné) This is Part #2 of the MySQL Master Replication Crash Safety series. In the previous post, we explored the consequence of reducing durability on masters with slaves using legacy file+position replication.
Community
18c and the ignoring of hints
(Connor McDonald) One of the new features in 18c is the ability to ignore any optimizer hints in a session or across the entire database.
URL Resolving in an Enterprise Deployment
(Martien van den Akker) A few blogs ago I wrote about issues we encountered with persistence of settings in an Enterprise Deployment with seperate Admin and Managed Server domains.
Executing PL/SQL with Array INPUTS via ORDS
(Jeff Smith) Today’s question: Does ORDS support PUT/POST with Array or Cursor as part of the payload? I need to call a procedure with 1 IN parameter defined as Array or Cursor (for a list of IDs).
Lesson to Learn: Introduction to Genetic Algorithms
(Dmitriy Gakh) An introduction to Genetic Algorithms with brief reference to biology and example of finding one solution for complex mathematical equation.
Azure Data Studio and XEvents
(Jason Brimhall) Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have finally gotten around to adding Extended Events (XE) to the tool – sort of. Now we have the power to run traces on SQL Server via ADS.
On The Irrational Demonization Of Two-Way Data-Binding In Angular
(Ben Nadel) The other day, I was listening to a JavaScript podcast on which a guest of the show pointed to two-way data-binding as one of the biggest “problems” in Angular.
MySQL High Availability On-Premises: A Geographically Distributed Scenario
(Marco Tusa) In this article, we’ll look at an example of an on-premises, geographically distributed MySQL high availability solution.
Exadata Cloud Machine – Hardware capacity
(Syed Jaffar Hussain) Everyone who is aware and utilizes Exadata Database Machine is certainly knew the performance it can deliver. I have involved in many Exadata migration projects, and witnessed how customers gained the database performance and satisfied post migration.
Automatically Create and Anonymize Downstream Databases from Azure DB
(Derek Colley) Your development, QA and production database environments are out of synchronization. Your present solution relies on a mix of scripts and manual actions to periodically restore production downstream.