(Olivia Diaz) JavaScript is one of the most popular programming languages, with different components, frameworks and tools.
Author: SSWUG Research
I created a table and SQL created a schema and a user.
(Kenneth Fisher) Demo first and then I’ll explain what happened.
Interpreting execution plans of T-SQL queries
(Esat Erkec) In this article, we will analyze a simple T-SQL query execution plan with different aspects. This will help us to improve our practical skills instead of discussing theoretical knowledge.
Dynamic Page Title In Angular 9
(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.
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
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.
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.