(Kenny Gryp) Following MySQL InnoDB Cluster as our first, fully integrated MySQL High Availability solution based on Group Replication, MySQL Shell 8.0.19 includes MySQL InnoDB ReplicaSet which delivers another complete solution, this time based on MySQL Replication.
Author: SSWUG Research
DS8000 4-Site Replication with IBM Copy Services Manager
(Thomas Luther, Peter Klee and Alexander Warmuth) This IBM Redpaper publication helps you design and implement a 4-site replication solution for IBM DS8000 environments. IBM Copy Services Manager is used to orchestrate the data replication and failover and failback mechanisms between the different s
JSON Values and the Joy of Scala
(Rafael Merino) In this article, we introduce json-values, a Scala library that makes use of persistent data structures to allow users to better handle JSON.
NULL complexities – Part 3, Missing standard features and T-SQL alternatives
(Itzik Ben-Gan) This article is the third installment in a series on NULL complexities. In Part 1 I covered the meaning of the NULL marker and how it behaves in comparisons.
Raw Websockets Minigame with Angular and ASP.net Core
(SleepyCrat) A asp.net core web project implementing websockets using .net core’s middleware. We implment the websocket client app using Angular and a aste of vanilla javascript.
Improve Power BI Performance with SQL Server Indexing
(Semjon Terehhov) What Power BI queries do to an underlying SQL Server data warehouse can be both complicated and confusing to understand. I am writing this tip to help DBAs and developers get the most out of their resources and avoid service degradation over time by providing an indexing strategy f
Part 2: Docker for Oracle Database Applications in Node.js and Python
(Christopher Jones) This is the second in a two part series on using Docker for Oracle Database applications.
Choose your shape
(Pieter Van Puymbroeck) A common thing we heard from customers is that it would be desirable to use different shapes in a Data Guard configuration in the Oracle Cloud.
Athena: Extracting data from JSON
(Anand) Suppose you have a table in Athena and its column contain JSON data. How can you extract the individual keys?
Printing all table preferences affecting dbms_stats.gather_table_stats
(Martin Bach) Oracle 11g introduced the abilty to control the behaviour of the dbms_stats package by setting preferences on the database, schema, and table level.