The error “Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause” appears when a query uses ...
MigrationPilot is a static analysis tool for PostgreSQL schema migrations. It parses your SQL with the actual PostgreSQL parser (libpg-query), classifies every lock acquired, flags dangerous patterns ...
APEX Signature allows you to draw smooth signatures into a HTML5 canvas and enables you to save the resulting image into database. It is based on JS Framework ...
I read something recently on LinkedIn about Deadlocks in SQL Server and how to monitor them. This reminded me of a script I wrote at the last place I worked that used the system_health Extended Event ...
Secure coding refers to the practice of writing source code for software applications in a manner that actively prevents the introduction of security vulnerabilities. It is a proactive approach ...
Astro.js is a well-thought-out and capable full-stack JavaScript platform that provides flexible technology choices on both the front and back end. It’s no surprise it currently has 50,000 stars on ...
This week we will discuss one of the most common error messages we get while we install the SQL version of Windows. This is the third article of the SQL ...
One of the most common use cases for the Visualforce, Aura, and LWC is to represent data in a tabular form using Data Tables. We know we can do this by creating an APEX class and providing necessary ...