(Grant Fritchey) The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first operator.
Author: SSWUG Research
Ad Hoc Queries Disabled
(Jason Brimhall) DBAs and ad hoc queries sometimes go together like oil and water. While we may prefer to avoid the ad hoc queries, sometimes it is the best method to achieve a task.
Hide/Show Form Fields Using Angular Forms
(Vidyadharran G) In this article, I will explain about hiding and showing form fields using Angular forms. Forms are used in web applications that enable the users to enter data and process the data from it.
SQL SERVER – SET NOCOUNT – Impact on Stored Procedure Performance
(Pinal Dave) Sometimes it is critical to get back to basics when working on solving a complex problem at Comprehensive Database Performance Health Check. Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the stored procedure.
Monitoring Table Change in Oracle
(David Fitzjarrell) Database replication is no longer restricted to Oracle-to-Oracle configurations; Oracle-to-cloud and Oracle-to-BigQuery are just two of the various options that can now be selected for replication configurations.
Merge Always Updates Sequence Number
(Bobby Durrett) This is nothing new, but I wanted to throw out a quick post to document it. If you have a sequence.nextval in the insert part of a merge statement the merge calls nextval for all the updated rows as well.
Provision Oracle Cloud Infrastructure Home Region IAM resources in a multi-region Terraform configuration
(Stephen Cross) This article covers a common configuration pattern that I’ve been meaning to post for a while. When provisioning resources in Oracle Cloud Infrastructure (OCI), some resources, specifically IAM resources, can only be created in the Home Region.
Documentum – Cast trouble with D2-REST 16.5.x on WebLogic
(Morgan Patou) In the scope of an upgrade project, with some colleagues, we have been deploying some D2-REST applications on Kubernetes pods using WebLogic Server.
Hash join in MySQL 8
(Erik Frøseth) For a long time, the only algorithm for executing a join in MySQL has been variations of the nested loop algorithm. With the release of MySQL 8.0.18, the server can now execute joins using hash join.
How to Do Machine Learning Perceptron Classification Using C#
(James McCaffrey) Perceptron classification is arguably the most rudimentary machine learning (ML) technique. The perceptron technique can be used for binary classification, for example predicting if a person is male or female based on numeric predictors such as age, height, weight, and so on.