(Ben Nadel) Now that InVision is migrating from the New Relic APM to the FusionReactor APM (Application Performance Management) for our Lucee CFML servers, I wanted to take some time to familiarize myself with the API exposed by the FusionReactor Java Agent.
Author: SSWUG Research
Guru: SQL Functions Can Do Non-function Things
(Ted Holt) We all know that the SQL SELECT statement only retrieves data, right? If you want to modify data, you have to use INSERT, UPDATE, DELETE, or MERGE, correct? Well, to quote the great George Gershwin, It Ain’t Necessarily So. You can modify data from a SELECT statement, and maybe sometimes
What is the JVM? Introducing the Java Virtual Machine
(Matthew Tyson) The Java Virtual Machine is a program whose purpose is to execute other programs. It’s a simple idea that also stands as one of our greatest examples of coding kung fu.
What Tables Are Being Written To The Most?
(Michael J. Swart) You have excessive WRITELOG waits (or HADR_SYNC_COMMIT waits) and among other things, you want to understand where.
Why Wait Stats Alone Are Not Enough
(Greg Gonzalez) Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.
Mocking Dependencies In Angular Unit Tests
(Neeraj Shende) There could be 3 different scenarios when it comes to mocking the dependencies in order to optimize the performance of unit tests cases and to reduce the development time of unit test cases.
Maximizing Database Query Efficiency for MySQL – Part One
(Paul Namuag) Slow queries, inefficient queries, or long running queries are problems that regularly plague DBA’s. They are always ubiquitous, yet are an inevitable part of life for anyone responsible for managing a database.
5 ways to get an Oracle Database
(Gerald) Do you want to get your hands on an Oracle Database but don’t know how? Here are 5 ways to get you going.
Getting the most out of in-memory – part 2
(Connor McDonald) In the previous post, I described the importance of checking V$IM_SEGMENTS to ensure that the in-memory store is populated to have confidence that you are indeed getting the benefit of the feature.
Using OCI Monitoring Healthchecks to Schedule execution of Serverless Functions on Oracle Cloud Infrastructure
(Lucas Jellema) Execution of scheduled jobs based on a time schedule is a frequent requirement. Jobs on Oracle Cloud Infrastructure are often implemented using cloud native, serverless Functions – that can be exposed through (public) HTTP endpoints on an API Gateway.