(Gunnar Peipman) I have never seen a real-life project where object-relational mapper generates 100% of needed SQL. There have always been those special cases when raw SQL commands are needed.
Other News
An Introduction to Container Adapters in C++
(Manoj Debnath) The C++ Standard Library offers a host of implementations on common data structures and algorithms. The collection of container classes provides a set of data structure to store a list of objects as its element.
NDB Parallel Query, part 5
(Mikael Ronstrom) In this part we are going to analyze a bit more complex query than before.
Using Build Options
(Salim Hlayel) In many cases, you would like as a developer to be able to enable or disable certain related functionalities in your APEX applications.
Oracle Clusterware (19c) and SLES 12 certification
(Marco Mischke) Recently we stumbled upon an issue with Oracle Clusterware on SLES 12 SP5.
Oracle Database 19c Automatic Indexing – Need Another Index (Another Brick in The Wall Part 2)
(Richard Foote) I previously discussed how Automatic Indexing can effectively cleverly reorder an existing index if it means it can now use the new index to satisfy new SQL predicates. In this post, we’ll explore this example further with some new workloads.
SQL SERVER 2019 – New Values in Sys.Configurations
(Pinal Dave) Since the release of SQL Server 2019, I have written quite a few blogs about this release. In this blog, we would see the new options available in sys.configurations catalog view.
Command Design Pattern Using Java Sample
(Nagaraj M) Command Design pattern is a behavioral design pattern in which a request can be turned to action.
Permissions required for row counts to show up on Object Explorer Details
(Kenneth Fisher) I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on my own I posted for help. This wasn’t something I felt could be easily translated into #sqlhelp so I went ahead and posted it on Stack Exchange then tweeted the link, with a brief
Learn SQL: Foreign Key
(Emil Drkusic) In the previous article, we talked about the primary key (PK). In this one, we’ll check what is the foreign key (FK) and how it’s related to the primary key. This is the final step, after creating tables, inserting data, and defining primary keys, to cover all basics related to the da