(Connor McDonald) There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the business day.
Community
Oracle patches – a patchfiles anatomy
(Martin Berger) In my previous post I explained some basics about IDs of platforms, products and similar and where these patches can be obtained.
SQL SERVER – ColumnStore Indexes Without Aggregation
(Pinal Dave) During the recent Comprehensive Database Performance Health Check, I noticed there were lots of aggregation going on with various data in the table. I suggested that the client can experiment with the columnstore indexes and it may help the performance.
Multiple Column Sorting: from Angular NgExTable to Source Data List Management
(Shenwei Liu) My previous article, Client and Server-Side Data Filtering, Sorting, and Pagination with Angular NgExTable, describes the base structures and uses of the custom data grid tool.
Research based on the .NET Runtime
(Matt Warren) Over the last few years, I’ve come across more and more research papers based, in some way, on the ‘Common Language Runtime’ (CLR).
Hierarchical Navigation For Azure Data Lake Storage Gen2 In Power BI/Power Query
(Chris Webb) While the documentation on how to import data from Azure Data Lake Gen2 Storage into Power BI is pretty detailed, the connector (which at the time of writing is in beta) that supports this functionality in the Power Query engine has some useful functionality that isn’t so obvious.
Truncate Table Operations in SQL Server
(Dinesh Asanka) Truncating a table is removing all the records in an entire table or a table partition. TRUNCATE table is functionally similar to DELETE table with no WHERE clause.
ReactJS Infinite Scroll Example
(Siddharth Seth) In this article, we implement the Infinite scroll feature in a ReactJS application. This feature allows us to load and present additional content as the user scrolls the container.
New tutorial discuss how to enhance cloud app security
(Henrik Loeser) Recently, I wrote a new tutorial as part of the IBM Cloud solution tutorials. Have you already developed and deployed an application on IBM Cloud?
Using RegEx To Filter Keys With Redis Key Scanner In Lucee CFML 5.2.8.50 And Jedis
(Ben Nadel) Earlier this week, I wrote about Redis Key Scanner, which is a small Lucee CFML app that allows me to safely and efficiently iterate over the key-space of a Redis database such that I can get a sense of what keys exist, how long they will be persisted (ie, what is their Time To Live), an