(Daniel Janik) Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines?
Other News
Spark SQL – Beware of Implicit datatype conversions (TypeCoercion)
(Manoj) While working on some data analysis I saw one Spark SQL query was not getting me expected results. The table had some good amount of data, I was filtering on a value but some records were missing.
Using Websocket with Spring Framework and Vuejs
(Mohamed Sanaulla) Websockets are full duplex (persistent) connections between client and server such that both can share information with each other without the need for repeatedly establishing a new connection.
OCI Data Science – Create a Project & Notebook, and Explore the Interface
(brendantierney) In my previous blog post I went through the steps of setting up OCI to allow you to access OCI Data Science. Those steps showed the setup and configuration for your Data Science Team.
GROUP BY might be distinctly better than DISTINCT
(Connor McDonald) One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the source table(s) from which they are derived from, in real time or near real time.
materialized WITH query
(Martin Berger) Sometimes I have to improve a SQL query where the same (or similar) subquery is used several times within the whole statement.
The Secret Code: ASP.NET MVC Conventions
(Jeremy) ASP.NET MVC is filled with hidden conventions: put a controller or view in a certain place and give it a special name, and it magically works.
Azure DevOps Search – Deep Dive
(Imran Siddique) Azure DevOps Search (Search) service is one of the microservices of Azure DevOps that powers its search functionality and makes it easy to locate information across all your projects using just a web browser. This article discusses the inner workings of DevOps Search.
Exploring The Triple Equals (===) Operator In Lucee CFML 5.3.4.77
(Ben Nadel) A few weeks ago, I created a function that proxies the dump() function, making it safe for complex objects that may include circular-references.
SQL 101: Using ILE RPG Programs and Procedures as SQL Stored Procedures, Part 1
(Rafael Victória-Pereira) PSM stands for Persistent Storage Module. In short, it’s the language used to write “SQL programs.” I’ll delve into PSM with much greater detail later in this series, but for now, let’s just focus on what forms these SQL programs, or SQL routines as they are more commonly c