(Corrado Pandiani) This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), a new feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0.
Other News
SQL SERVER – Disable Parameter Sniffing with DISABLE_PARAMETER_SNIFFING Query Hint
(Pinal Dave) The journey of consulting is always a fun one with lots of learning. Recently during the Comprehensive Database Performance Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.
Run Umbraco Rest with Docker and Angular
(Daniele Florean) Nowadays, we all see and hear tons of PoC and software solutions based on front-end frameworks, .NET backend, and containerization; with the spreading of .net core and its multi-platform nature, we have now opened a whole world of solutions that we couldn’t see before and that will
Concept of Relational Database Model – Part 2
Join Operation A join operation combines linked tuples of different relationships if and only if a particular join condition is met. It is noted ?. For example, if there are two tables: EMPLOYEE and SALARY; Evaluation: ∏EMP_NAME, SALARY (EMPLOYEES ?. For example, if there are two tables EMPLOYEE and SALARY; Evaluation: (EMPLOYEE ?. For example, if there is two tables...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Extended Events: Histogram Output
(Grant Fritchey) The single most important thing to remember about Extended Events is that this functionality is not simply a replacement for Profiler/Trace, but a whole new tool with new functionality.
Static classes and inner classes in Java
(Jeff Friesen) Nested classes are classes that are declared as members of other classes or scopes. Nesting classes is one way to better organize your code.
How to customize your OpenAPI Doc for Oracle REST Data Services
(Jeff Smith) You can easily generate {Swagger} documentation sets for your RESTful Services in ORDS. Each /metadata-catalog endpoint includes a link to get the OpenAPI 2.0 JSON as well.
Merge vs. Insert-Exception-Update
(Marco Mischke) Recently I had a discussion with one of our developer about how to bring new rows in a table or, if the row already exists, update it.
Cleanup Oracle Fusion Middleware 12c Repository manually
(Dirk Nachbar) Currently I was cleaning up some of my Oracle Fusion Middleware Forms & Reports test and demo environments manually and wanted to setup them freshly.
How to install Visual Studio Code on a Raspberry Pi 4 in minutes
(Scott Hanselman) Four years ago I wrote how to BUILD (literally compile) Visual Studio Code for a Raspberry Pi ARM machine. Just a few months later in November, community member Jay Rodgers released his labor of love – nightly builds of VS Code for Chromebooks and Raspberry Pi.