(Paul White) Achieving minimal logging with INSERT…SELECT can be a complicated business.
Community
STDeleteN: Delete single vertex from geometry
(Simon Greener) SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions:
Resource limit facility usability improved in Db2 12
(Tammie Dang, Euna Park, and Jennie Chang) Db2 12 for z/OS introduced the capability to specify resource limits for static SQL statements, and APAR PH07658 recently introduced the following resource limit facility (RLF) usability enhancements in Db2 12:
Java 101: Deciding and iterating with Java statements
(Jeff Friesen) Java applications evaluate expressions in the context of statements, which are used for tasks such as declaring a variable, making a decision, or iterating over statements.
C# Job Queues (part 3) with TPL Dataflow and Failure Handling
(Michael Shpilt) In Part 1 and Part 2 we went over what are Job Queues, why they are so important and how to implement them with several methods.
Azure Database for PostgreSQL
(Tapas Pal) Azure Database for PostgreSQL is very powerful, open source, object-relational database system that has the capability of handling workloads ranging from small, single-machine applications, to large Internet-facing applications.
Unified .NET 5 Unveiled: ‘Just One .NET Going Forward’
(David Ramel) Microsoft announced .NET Core 3.0 will arrive in September, after which the company is switching to one unified .NET platform, called .NET 5, which will debut in November 2020.
MariaDB and MySQL Database Consolidation
(Shinguz) We see at various customers the request for consolidating their MariaDB and MySQL infrastructure.
APEX Upgrade redux
(Connor McDonald) I posted about my APEX upgrade to 19 yesterday, and someone was quick to point out to me that they believed I hadn’t covered all of the steps.
Oracle 12c and its new things
(Jagruti Jasleniya) I wrote many posts about all new features of Oracle 12c , how multi-tenant architecture works and all.