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)
54 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
413 reads
2024-12-06
1,496 reads
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
2024-07-29
1,115 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,439 reads
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
2023-12-01
1,311 reads
2023-08-25
549 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,837 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,802 reads
2023-03-17
4,794 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Dear Folks, Restore jobs in my SQL2022 Standard edition replication were failing on a...
hi, just to get this part out of the way, if my intended target...
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers