(Pinal Dave) Another day and another win against a difficult SQL Server Problem while I worked with my clients on Comprehensive Database Performance Health Check. The best part of my job is that I get to work with different performance problems every time with new clients.
Author: SSWUG Research
Installing Oracle GoldenGate Microservices – Part 1 of 2
(Bobby Curtis) Recently I was exchanging emails with a few community members about Oracle GoldenGate Microservices. One of them commented on that Oracle GoldenGate Microservices was difficult to install; at the time, I was puzzled.
Testing a 99.999% Availability Distributed In-Memory Database
(Tiago L. Alves) MySQL Cluster is an open-source distributed in-memory database. It combines linear scalability with high availability, providing in-memory real-time access with transactional consistency across partitioned and distributed datasets.
A technique for building high-performance databases with EF Core
(Jon P Smith) As the writer of the book “Entity Framework Core in Action” I get asked to build, or fix, applications using Entity Framework Core (EF Core) to be “fast”. Typically, “fast” means the database queries (reads) should return quickly, which in turn improves the scalability of the database.
Modal Popup Example and Tutorial with Angular 9 Material
(Ahmed Bouchefra) In this tutorial, we’ll build by example a modal popup using Angular 9 Material.
SQL Database Project Code Branching in Git
(Haroon Ashraf) As a SQL Server database developer, I need to understand and implement the concept of database code branching particularly in the case of state based database development using SQL Server Data Tools (SSDT).
Oracle Database 19c Automatic Indexing: Index Compression (Ghosteen)
(Richard Foote) In my previous post on Automatic Indexing, I discussed how the default index column order (in absence of other factors) is column id, the order in which the columns are defined in the table. In this post, I’ll explore if this changes if index compression is also implemented.
API Platform – Developer Portal Delegated Authentication
(Phil Wilkins) The API Platform when you configure IDCS to provide the option to authenticate users against a corporate Identity Provider such as Active Directory will automatically update the Management Portal Login screen accordingly.
APEX Low code expressions
(Scott Wesley) The following where clause expression would normally return false, therefore the query would deliver no rows.
InnoDB : Tablespace Space Management
(Mayank Prasad) A user defined table and its corresponding index data, in InnoDB, is stored in files that have an extension .ibd. There are two types of tablespaces, general (or shared) tablespace and file-per-table.