PostgreSQL in action with Opensearch
Learn about using Opensearch with PostgreSQL to improve performance and quickly return results to your users.
2026-10-23
1,531 reads
sabyda
- Skills: Java, Spring boot, React, Azure, AWS, Postgres, Oracle, Websphere, Angular, Blockchain, Corda
Understanding Temp Tables and Table Variables in SQL Server
Introduction When building application backends or processing complex data sets in a SQL Server, we frequently need a temporary storage to hold the intermediate query results. For example: Store filtered rows before joining them to another table Hold calculation results inside a stored procedure Break a complex query into smaller readable steps Process a small […]
2026-08-28
3,909 reads
The memory toll of VARCHAR(MAX) in SQL Server
Introduction When designing the tables or writing the stored procedures in SQL Server, we get easily tempted to choose the path of least resistance. When deciding how much space to allocate for a text column in a database table which may contain the description of a product, a product name, or an additional comment/remarks, it […]
2026-08-24
8,073 reads
The Hidden Danger of Wildcard Operators In Join Operations
This article looks at one of the killers of performance at scale, SELECT *.
2026-08-14
2,348 reads
Advanced T-SQL: Replacing Slow Cursors with Window Functions
This article looks at replacing a cursor with a window function to improve performance.
2026-08-03
7,098 reads
Implicit Conversions Cripple SQL Server
Learn about implicit conversions, which can dramatically affect the performance of your workload.
2026-07-17
3,599 reads
Using PostgreSQL as a NoSQL Store and a Search Engine
Introduction We mostly get inclined to use/introduce MongoDB for JSON storing/processing in our database system and Elasticsearch for searching operations in JSON data. However, what we often tend to overlook is that in reality, PostgreSQL can actually act as both NoSQL store and a powerful search engine too. It also comes with ACID guarantees, transactions, […]
2026-03-27
2,213 reads
Automating Database Cleanup for PostgreSQL Using Python
This article shows a technique for cleaning out older data from PostgreSQL tables using Python to follow a set of rules you create.
2026-01-30
1,045 reads
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
We have a script that can be used to help tune ind...
2026-01-21
1,798 reads
Working with JSON/JSONB Data in PostgreSQL using Python
This article discusses how to work with JSON data in PostgreSQL using Python.
2025-12-12
840 reads
Blogs
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Forums
Layanan Resmi BCA KCU A. YANI Telp:0821°8200°203
Telp/Wa 628218200203 Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282
Layanan Resmi BCA KCU BANDUNG Telp:0817°82°5533
Telp:Wa 62817825533 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers