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,512 reads
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
2024-07-29
1,216 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,488 reads
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
2023-12-01
1,329 reads
2023-08-25
574 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,989 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,958 reads
2023-03-17
4,877 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers