(Ben Nadel) After struggling to wrap my head around Redux-inspired state management, I wanted to step back and consider simpler solutions.
Community
Understanding Dynamic Data Masking in Azure SQL DB
(Betty Gabriela Ramirez Bejarano) When dynamic data masking is applied, the main objective is to limit the exposure of confidential information to users who do not have the necessary privileges to observe confidential information.
Enable Index To Search For NULLs By Adding Constant to Index List. But Some Constants Better Than Others (Never Let Me Down)
(Richard Foote) By default, Oracle doesn’t index an entry if all columns within the index are NULL. However, (as I’ve blogged previously), it’s possible to index all possible NULL values by simply adding a constant value to the index column list.
Oracle Offline Persistence Toolkit – Submitting Client Changes
(Andrejus Baranovskis) One of the key topics related to Oracle Offline Persistence toolkit – submitting client changes to backend when data conflict exists.
Exploring Autonomous Databases – Client Credentials
(biju.thomas) You connect to the autonomous database (ATP or ADW) by downloading the Client Credentials Zip file from the Administration console.
Query VMWare vCenter VCDB database for guest power state = OFF
(Jack Vamvas) Question: I want to identify virtual machines which are powered off. What query can I run which will return the full list of virtual machines within a VMWare vCenter database where the power state = OFF.
Calling The Power BI REST API From Microsoft Flow, Part 1: Creating A Flow Custom Connector
(Chris Webb) Playing around with Microsoft Flow recently, I was reminded of the following blog post from a few months ago by Konstantinos Ioannou about using Flow to call the Power BI REST API to refresh a dataset:
Use Eager, Explicit, And Lazy Loading In Entity Framework Core
(Bipin Joshi) You might be aware that Entity Framework Core 2.1 has added support for lazy loading of navigation properties. This means now we have three ways to load data in the navigation properties – eager loading, explicit loading, and lazy loading.
The Functional Style – Part 5
(Richard Wild) In the previous article we saw several examples of functions as first-class citizens and some of the kinds of uses they can be put to. Just to recap, a function is a first-class citizen when it is a value in its own right, and can be passed around a program just like any other type of
Temporal Support of Db2 for z/OS – Part III Temporal RI
(Xiaohong Fu) Referential integrity (RI) is the state in which all values of all foreign keys are valid. Both traditional RI and temporal RI are relationships between pairs of tables, in which the business rules are represented.