(hercules7sakthi) MySQL InnoDB Cluster has introduced by the MySQL team for the High Availability ( HA ) purpose . It provides a complete high availability solution for MySQL.
Author: SSWUG Research
SQL SERVER – Temp Table vs Table Variable – Cardinality Estimation
(Pinal Dave) It has been a while since I have been working with SQL Server 2019 with my clients to help them with performance-related issues while working on Comprehensive Database Performance Health Check. Recently, I had a very interesting conversation with one of my clients about Cardinality Esti
Git Autocorrect
(Steve Smith) I don’t know how I didn’t know about this before now, but apparently you can turn on autocorrect for your git command line, and it will accept (after a short delay in which you can cancel) commands that are close to but not exactly correct.
Unpivoting Oracle APEX meta-data
(Scott Wesley) There are APEX dictionary views for most of the data that represents the ‘source’ that is your APEX application meta-data.
SQL Server Dynamic PIVOT Query
(Eli Leiba) The PIVOT operator (or “cross-tab” operation) is a very handy tool in SQL Server, but its main limitation is that you often don’t know the values that you need to pivot on.
Using Referential Constraints with Partitioned Tables in InnoDB
(Carlos Tutte) One of our support customers approached us with the following problem the other day:
StructCopy() Does Not Necessarily Return A Native Struct In Lucee CFML 5.3.3.62
(Ben Nadel) Over the weekend, while working on a version of dump() that gracefully handles cyclic references in Lucee CFML, I happened upon a quirk of the language when dealing with reflection-style coding.
What’s new with Oracle database 19.6 versus 19.5
(Frits Hoogland) As expected, there aren’t any really drastic differences between Oracle database version 19.5 and 19.6. Now that I am doing these series on differences for all the versions every quarter the new release updates are coming out, there is a certain line, and this release does follow th
Patching Null++
(Ashley Frieze) Here’s a curiosity.
How To Get Localized Number Format Based On Country Using Angular 8
(Siddharth Gajbhiye) To explain the concept of localization and number format based on their locale I am taking my previous article as reference to display the price based on different countries and their currencies.