Article Overview In this article we will learn how to integrate a Spring boot application with Apache Cassandra database and Redis cache. This is an extension to one of our previous articles which demonstrates the steps to set up Apache Cassandra and how to integrate is with Springboot, link shared below. https://www.sqlservercentral.com/articles/cassandra-springboot-integration In this tutorial […]
2025-07-14 (first published: 2024-07-18)
63 reads
Overview In this article we will go through the various in built aggregate functions available in PostgreSQL. Aggregate functions perform a calculation on a set of rows and return a single value. COUNT Function The COUNT function is a simple and very useful function in counting the number of records, which are expected to be […]
2025-07-09
435 reads
2024-12-06
1,511 reads
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
2024-07-29
1,213 reads
Another article on how the SQL language works in PostgreSQL. This time we examine the UNION, INTERSECT, and EXCEPT operators.
2024-05-31
1,486 reads
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
2023-12-01
1,328 reads
2023-08-25
571 reads
In this article you will learn how to use the COPY command in PostgreSQL to copy a database or a table.
2023-06-09
4,988 reads
This article will cover exporting data from a PostgreSQL table to a CSV file, both from the command line and pgAdmin. We will also look at importing data from a CSV file.
2023-05-05
1,951 reads
2023-03-17
4,873 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers