(Syed Jaffar Hussain) In my perspective, any performance & tuning discussions or debates are just incomplete without Oracle index topic.
Other News
Partitioning — 15 : Online Modification of Partitioning Type (Strategy)
(Hemant K Chitale) Oracle 18c introduces the ability to convert a Partitioned Table from one Type to another — e.g. from Hash Partitioning to Range Partitioning.
Reverse Engineer SQL Server Databases with Visual Studio
(John Miner) Many companies are switching over from the waterfall model to the agile software development process with the hopes of bringing quality software quicker to market. Under this process, requirements and solutions evolve through the collaborative effort of cross-functional teams and their
Displaying XML Files with CSS/XSLT
(Matias Lopez) In this post, I display XML files with CSS/XSLT.
Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 1
What is SQL (Structured Query Language)? SQL is a structured query language, a computer language in which the data stored in a relational database is stored, manipulated and retrieved. The structured query language (SQL) is the default language of the relationship database system. All relational database management systems, such as MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server,...
Versioning C# projects in Azure DevOps build pipeline
(Rory Primrose) I’m a big fan of using GitVersion to calculate an application version based on git history. I’m also a big fan of the new csproj format because of its simplicity.
MySQL 8.0: New Storage Format for Compressed BLOBs
(Annamalai Gurusami) In this article, let us look at the new storage format of compressed large objects (compressed LOB or ZLOB).
Creating Object Store Credentials in Autonomous Transaction Processing (ATP)
(Skant Gupta) In this post, you use the ADMIN user schema. You store the Auth Token created in the previous post along with the username, as a credential under an ADMIN schema.
How to Track Data Platform Service Level and Performance Before and After Consolidation?
(Pinal Dave) When you are planning data platform consolidation, it is very important to track down the changes in the overall system performance after the actual migration is done. You should understand the differences in the configurations and performance of the instances and databases.
Localization In Angular With i18n
(Ankit Sharma) We will learn how to make our Angular app available in different languages using i18n and localization.
