(Peter Vogel) ExpandoObjects let you dynamically add members to your object at runtime — a great way to handle scenarios where you need a lot of flexibility. But how do you work with an object when you don’t know the names of its properties?
Other News
MySQL Replication Setup
(Lalit) Replication used to replicate data from the Master node to a slave node[Replica].
Invoke an Oracle Function on Oracle Cloud Infrastructure from a Node application
(Lucas Jellema) Oracle Functions is currently in limited preview and is expected to soon reach wider availability. Rolando Carrasco did this write up on Medium about his first experiences with Oracle Functions.
Manual upgrading Oracle database 11gR2 to 19c
(Skant Gupta) If you want to know how we upgrade an 11.2.0.4 database to 19.0.0.0.0 using DBUA, click here.
Linking Excel to AUTO REST Enabled Tables…with the Oracle Visual Builder Plugin
(Jeff Smith) We’ve talked about the AUTO REST feature of ORDS for TABLES quite a few times here. What I want to talk about today is how you can take advantage of that TABLE REST API in your favorite Excel spreadsheets.
SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution
(Pinal Dave) Every time we talk about deadlock, you will see DBA frowning on this topic. DBA believes that Developers are creating the deadlocks and developers believe that DBA’s should be taking care of the deadlocks.
Toastr Like Notification Component In Angular 7
(Abhishek Mishra) This article shows how to create custom component for notification in Angular 7.
Troubleshooting xml problems in SQL Server 2017
Troubleshooting xml problems in SQL Server 2017 If you have problems with SQL Server 2017 XML, review this troubleshooting checklist to find potential solutions. 1. The error 432 occurs when you try to use the Xml data type methods in check constraints. This error indicates that Xml data type methods are not supported in check constraints anymore. You should drop...
Measuring Latency in Complex PowerApps
(Steve Endow) I have created a PowerApp that has several dependencies, and I am concerned about latency, and how that will affect the delay that a user experiences when they use the PowerApp.
Database Fundamentals #21: Using the JOIN Operator, OUTER JOIN
(Grant Fritchey) The OUTER JOIN returns one complete set of data and then the matching values from the other set. The syntax is basically the same as INNER JOIN but you have to include whether or not you’re dealing with a RIGHT or a LEFT JOIN.
