(mdinh) This is a multi-part series for 18c Upgrade and suggest read the above 2 posts first.
Community
Standardize SQL Server data with text lookup and replace function
(Greg Robidoux) Have you ever had the need to replace multiple words in a data column with a new word or a new phrase for an entire table? A good example would be to update a product catalog with new words either for standardization or just to reflect a new name for the product.
React.js: implement the drag and drop feature without using external libraries
(Rajesh Pillai) Get into the details of implementing drag and drop features in React from scratch.
SQL TRIM Function
(Rajendra Gupta) In this article, we will review the new SQL TRIM function in SQL Server 2017 onwards as well as providing some information on strings functions that pre-date it like LTRIM AND RTRIM.
How to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache
(Greg Larsen) Have you ever heard of the identity cache? If not, it is just a cache that stores the next 1000 available identity cached values for a table.
Java 101: Inheritance in Java, Part 1: The extends keyword
(Jeff Friesen) Use Java’s extends keyword to derive a child class from a parent class, invoke parent class constructors and methods, override methods, and more.
The History of ASP.NET – Part II (Covers ASP.NET MVC)
(Daniel Jimenez Garcia) Part 1 took an overview of the initial design of ASP.NET and how Microsoft reacted to the various changes in webdev. In Part II, we will now look at how those changes influenced the development of ASP.NET MVC and ended up transforming ASP.NET into a much more flexible framewo
IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery
(Ute Baumbach and Frank Neumann) IBM Db2 Analytics Accelerator is a workload optimized appliance add-on to IBM DB2 for IBM z/OS that enables the integration of analytic insights into operational processes to drive business critical analytics and exceptional business value.
Xamarin, Part 4: Shared Projects
(Hannes DuPreez) Part 4 in my Xamarin series of articles explains Shared Projects and the benefits of sharing code. You have come a long way so far within the Xamarin series.
How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster on Docker
(Ashraf Sharif) ProxySQL is an intelligent and high-performance SQL proxy which supports MySQL, MariaDB and ClickHouse.