(Paul Namuag) This is the second part of a two-part series blog for Maximizing Database Query Efficiency In MySQL. You can read part one here.
Community
Angular – Typescript Fundamentals
(Veerendra Annigere) In order to build an application in Angular, we need to know the fundamentals of Typescript. In this article, I’m going to explain the fundamentals of Typescript and object-oriented programing principles.
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.
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.
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.
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
Using The FusionReactor API (FRAPI) To Add Custom Instrumentation In Lucee CFML 5.2.9.40
(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.
Logging MVC properties with Serilog.AspNetCore
(Andrew Lock) In my previous post I described how to configure Serilog’s RequestLogging middleware to add additional properties (such as the request hostname or the selected endpoint name) to Serilog’s request log summary.
Didact Project Walks Through Tutorials in Visual Studio Code
(David Ramel) A Red Hat developer has created the Didact project, a Visual Studio Code extension that puts the code editor to work as a tutorial guide and also showcases other things it can do via a combination of technologies.
Single Value Column Frequency Histogram Oracle 12c and later
(Randolf Geist) It is hopefully in the meantime well known that Oracle has introduced in version 11g a new algorithm to gather statistics on a table that no longer requires sorting for determining the critical Number Of Distinct Values (NDV) figure – it instead uses a clever “approximate NDV” algori