(K. Scott Allen) I thought enable would be the star of the C# 8 show by now, but in day to day work I’m finding that switch expressions are stealing the show.
Author: SSWUG Research
(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.
(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.
(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.
(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.
(Valerii Kravchuk) I’ve seen questions like this: “Is there a way to know when (date and time) the last statement captured in … was actually ran?”
(Dimitri Gielis) If you are reading this blog post you are probably searching for an alternative for the deprecated multimedia (or intermedia) feature of the Oracle Database… and you are in the right post as APEX Media Extension is that replacement!
(Ben Nadel) The fun thing about maintaining a legacy code base is that you’re constantly turning over stones to find new and exciting areas of code-rot and technical debt. Just yesterday, I discovered that one of my ColdFusion servers was deadlocked on some Date/Time code that was not thread-safe.
(Rafael Winterhalter) While Java beginners quickly learn typing public static void main to run their applications, even seasoned developers often do not know about the JVM’s support of two additional entry points to a Java process: the premain and the agentmain methods.
(Rick Dobson) SQL Server offers three types of user defined functions (udf) and in this tip we will cover examples for each of the three major types of user-defined function types: scalar-valued, table-valued and multi-statement table-valued.