(Itzik Ben-Gan) The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL.
Community
IBM Brings Active-Active Mirroring Into Db2 For i Database
(Timothy Prickett Morgan) As a platform that is approaching 40 years of deployment within enterprises that can’t afford downtime with their mission critical systems – that’s counting the System/38 as well as the AS/400 and its follow-ons as part of the same continuum – it is no surprise at all that
Java 12: Mapping With Switch Expressions
(Per-Åke Minborg) Learn more about mapping with the latest Java 12 switch expressions.
Hosting DI Container with .NET Core 3.0
(Christian Nagel) ASP.NET Core included the WebHost class that was used in the Main method to startup everything up – including the dependency injection container.
Using NgModel With Input Type=’File’ And A Custom ControlValueAccessor In Angular 7.2.12
(Ben Nadel) As I’ve been learning about how to upload files using the HttpClient service in Angular 7, one of the framework features that I’ve stumbled-over is the fact that, by default, the NgModel directive doesn’t play very nicely with the File-Input form control.
Pulling Objects from Web Services with ReadAsAsync
(Peter Vogel) In an earlier post, I discussed the three objects that Microsoft has provided for calling Web Services: HttpWebRequest, WebClient and HttpClient.
PHP with Vue.js & MySQL: REST API CRUD Tutorial
(Ahmed Bouchefra) In this tutorial, we’ll build a RESTful CRUD application with PHP & MySQL in the backend and Vue.js in the frontend. We’ll also be using Axios for sending Ajax request to PHP from Vue.
Oracle Database 19c Automatic Indexing: Predicted Back In 2008 (A Better Future)
(Richard Foote) I’ve recently received a number of correspondences regarding one of my most popular blog posts, dating back to February 2008: Index Rebuild vs. Coalesce vs. Shrink Space (Pigs – 3 Different Ones).
Private Temporary Tables (Oracle 18c)
(mgogala) I was very excited when I learned about the new feature in Oracle 18c, namely the private temporary tables.
SQL Developer 19.1 Connections – Thick or Thin
(Jeff Smith) Version 19.1 of SQL Developer, SQLcl, Data Modeler, and ORDS are now all available, and you can expect many posts over the next few weeks to cover all the new goodies.