(Vishal Gilbile) Recently while working on Angular 9 project with SharePoint rest API, I came across this requirement where I needed to set the SharePoint List name as page title in Angular 9.
Other News
Modern approaches to replacing accumulation user-defined variable hacks, via MySQL 8.0 Window functions and CTEs
(Saverio Miroddi) A common MySQL strategy to perform updates with accumulating functions is to employ user-defined variables, using the UPDATE […] SET mycol = (@myvar := EXPRESSION(@myvar, mycol)) pattern.
Azure Data Studio- Export Any SQL SERVER Query As JSON
(Pinal Dave) In the industry, I see that Azure Data Studio (ADS) is getting adopted along with SQL Server Management Studio (SSMS). I will still say that ADS is not the replacement of SSMS and for the near future it seems that they will co-exist. Recently, one of my clients’ Comprehensive Database P
AWS Cloud Helps Users Port .NET Framework Apps to .NET Core
(David Ramel) Amazon Web Services (AWS) introduced a tool to help its cloud computing users port their .NET Framework apps to .NET Core, the open source, cross-platform successor to the 18-year-old, Windows-only legacy framework.
Returning CFQuery / Query Results As Structs In Lucee 5.3.6.61
(Ben Nadel) A few months ago, I looked at returning CFQuery results as an Array in Lucee CFML; and, in the comments of that post, Gert Franz pointed out that Lucee could also return CFQuery results as a Struct in which a given column would be used as the look-up key in said Struct.
Run WPF in .NET Core on Nano Server in Docker
(Tony Sneed) Every now and then you’re presented with a scenario that should in theory work as advertised, but you’re not convinced until you actually see it with your own eyes.
AWR on ADG
(Pieter Van Puymbroeck) Active Data Guard is a lot more than the read-only standby database. Let’s focus on this part a bit. Read-only workloads are select workloads and are just queries.
Reading Query Parameters in GET requests to Project Fn Functions (and Oracle Functions as a Service)
(Lucas Jellema) TLDR: query parameters can be retrieved from the Fn-Http-Request-Url header in the ctx parameter passed by Fn to the Node function handling the request; using url.parse() on that header retrieves the url query parameters
Oracle Spatial, dynamic SQL, a view and the strange problem of a SDO_GEOMETRY bind variable
(Flavio Casetta) The title sound like an old italian joke and indeed I wasted 4 hours on this joke before having the epiphany.
Machine Learning with IBM Db2: Building and Deploying a Linear Regression Model
(Les King) In this demonstration, we’ll use a Jupyter Notebook from IBM Watson Studio to show how you can build a Linear Regression model inside Db2.