(Andrejus Baranovskis) I will talk about expert mode View Object (with hand written SQL), this View Object is created based on SQL join. So, thats my use case for today example.
Community
Flashback Database after Resetlogs in data guard
(Jagruti Jasleniya) In this Post, We will see How enabling Flashback helps us in case of Primary Database resetlogs.
Index Column Order – Impact On Index Branch Blocks Part II (The Weeping Song)
(Richard Foote) In Part I, I discussed how the order of columns in an index makes no real difference to the effectiveness of the index if all columns are referenced via equality predicates.
HTML Manipulation using .NET – Manage Dynamic Views in MVC using Html Agility Pack
(Jamil Hallal) When creating dynamic views in MVC you might need an API that helps you manipulate the html using .NET code. I usually use “HTML Agility Pack” for this mission, it is quite flexible and easy to use .NET API.
MariaDB 10.3 supports database sequences
(Vlad Mihalcea) Traditionally, both MySQL and MariaDB relied on AUTO_INCREMENT columns to generate an IDENTITY Primary Key.
UTL_FILE_DIR and 18c
(Connor McDonald) I wrote a blog post called The Death of UTL_FILE which attracted a comment from a reader:
Market Basket Analysis in R and Power BI
(Saurabh Desai) R supports a wide range of machine algorithm libraries. Using R, we can build predictive models, clustering, classification, etc. Once an R script produces output, we need a way to visualize the output and interact to explore the visualizations effectively.
Learn About Binding Event In Angular
(Manoj Kalla) In this article, you will learn about event binding in Angular 2/4.
Using MSVC in a Docker Container for Your C++ Projects
(Marc Goodner) Containers encapsulate the runtime environment of an application: the file system, environment settings, and virtualized OS are bundled into a package. Docker containers have changed the way we think about build and test environments since they were introduced five years ago.
SQL SERVER – Backup Error: 3636 – An Error Occurred While Processing BackupMetadata
(Pinal Dave) Recently one of my old clients contacted me and informed that they are having an issue with database backup on the secondary replica. In this blog we would learn about how to fix error 3636 – An error occurred while processing BackupMetadata.