(Ben Nadel) Just now, as I was looking at iterating over Structs using CFLoop in Lucee CFML, I ran into a fun little behavior of the ColdFusion language: Scope traversal will skip-over undefined function arguments and access like-named values in higher-up scopes.
Other News
GitHub Integration with Azure DevOps
(Subodh Sohoni) This tutorial demonstrates how to use Azure DevOps and GitHub collaboratively. You will learn to connect and integrate Github with Azure Boards, integrate Github in Visual Studio, and use Azure Pipelines to build and deploy code under Github.
Adding host filtering to Kestrel in ASP.NET Core
(Andrew Lock) Host filtering, restricting the hostnames that your app responds to, is recommended whenever you’re running in production for security reasons. In this post, I describe how to add host filtering to an ASP.NET Core application.
Read only partitions
(Connor McDonald) The ability for part of a table to be read-only and other parts of the same table to allow full DML is a cool feature in the Oracle Partitioning option.
Installing Virtualbox Guest Additions for Oracle Linux 8.2
(Martin Bach) Since I can never remember how to install Virtualbox Guest Additions I thought I’d write it down. Maybe it’ll save you a few minutes; I know it will save me a lot of time 😉
Deploying Oracle Database XE 18c as container on Play With Docker (PWD)
(Matthias Hoys) Play with Docker (PWD) is a free Docker environment that you can use for up to 4 hours – you only need a web browser and a Docker account! It uses the “Docker-in-Docker” technology.
Guru: SUBSET on EXECUTE and OPEN
(Paul Tuohy) The DB2 for i Enhancements in IBM i 7.3 Technology Refresh 8 / IBM i 7.4 Technology Refresh 2 just made dynamic SQL, embedded in RPG, a lot easier to use. It includes an enhancement entitled USING SUBSET on EXECUTE and OPEN with Extended indicators.
JavaScript in SVGs
(David Walsh) SVGs are such an amazing tool for creating custom fonts, animations, size-reduced graphics, and more. They’re part HTML, part image, and all awesome.
Database Fundamentals #26: The Primary Key War
(Grant Fritchey) There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful information.
Optimising The Performance Of Power Query Merges In Power BI, Part 4: Table.Join And Other Join Algorithms
(Chris Webb) In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better performance for merge operations in Power Query – but only if your data is sorted.