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)
62 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
426 reads
2024-12-06
1,506 reads
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
2024-07-29
1,167 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,483 reads
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
2023-12-01
1,327 reads
2023-08-25
557 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,943 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,892 reads
2023-03-17
4,844 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a couple of SQL Agent job steps which run PowerShell commands of...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers