(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.
Community
APEX Low code expressions
(Scott Wesley) The following where clause expression would normally return false, therefore the query would deliver no rows.
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.
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.
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).
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.
Different methods to identify the SQL Server version number
(Nisarg Upadhyay) In this article, I am going to show different methods to identify the SQL Server version number and its edition. Also, I have included the list of known SQL Server version numbers, Service Packs (SP), and Cumulative Updates (CU of MS SQL Server 2019, 2017). I have not included the
Overview of Azure SQL Database Serverless
(Marcin Policht) Public cloud offers a wide range of benefits, including scalability, agility, and on-demand resource provisioning. While these benefits apply to majority of cloud services, they are most apparent in the context of serverless computing.
Getting to Know Deep Java Library (DJL)
(Kesha Williams) Amazon’s DJL is a deep learning toolkit used to develop machine learning (ML) and deep learning (DL) models natively in Java while simplifying the use of deep learning frameworks. A toolkit open-sourced just in time for re:Invent 2019, DJL provides a set of high-level APIs to train,
Practical RPG: Encapsulating Your Data with Extension Files, Part 1
(Joe Pluta) As business programmers, we spend most of our time working with the database, one way or another. Unless we’re lucky enough to be in on the ground floor of a new installation of a modern package, chances are that database will require modifications to support changing business requiremen