(Itzik Ben-Gan) This article is the second in a series about T-SQL bugs, pitfalls and best practices. This time I focus on classic bugs involving subqueries.
Other News
Java Thread Example
(Ed de Jongh) Every Java program has at least one thread, the main thread.
Creating Strings with No Allocation Overhead Using String.Create
(Steve Gordon) In this post, I’ll continue my series about writing high-performance C# and .NET code. This time, I will focus on a new(ish) method available on the String type – String.Create.
Simplified application compatibility for IBM Data Server Drivers and Db2 12 function levels
(Jim Pickel and Paul McWilliams) In Db2 12, APAR PH08482 simplifies the process of activating new function levels without impacting existing JDBC, CLI, and .net applications, and it possibly reduces the coordination effort required between Db2 administrators and application programmers, for activati
Property Injection in C#
(Tapas Pal) In a programmer’s world, Dependency Injection (DI) frameworks offer two ways to inject concrete classes into objects: constructor injection and property injection.
OData Lives! 12-Year-Old RESTful API Protocol Put to New Use in Age of Blazor and ASP.NET Core
(David Ramel) Back in 2016, I asked Microsoft about the status of OData — the RESTful API protocol it developed back in 2007 — because it seemed its initial buzz had tapered off dramatically.
MySQL Connection Handling and Scaling
(Geir Hoydalsvik) In this post we describe MySQL connections, user threads, and scaling. We hope that an increased understanding of how MySQL works will help application developers and system administrators to make good choices and trade-offs.
V$SQL_CS_HISTOGRAMS: What Are the Buckets’ Thresholds?
(Christian Antognini) The contents of the V$SQL_CS_HISTOGRAM view is used by the SQL engine to decide when a cursor is made bind aware, and therefore, when it should use adaptive cursor sharing.
Oracle Golden Gate Microservice Architecture Components
(Jagruti Jasleniya) Till date we have seen all articles on Golden Gate with classic architecture and worked on golden gate software command line interface[ggsci] prompt.
Debugging PL/SQL…in APEX
(Jeff Smith) Of course you can debug your PL/SQL from SQL Developer when you start it in SQL Developer.