2026-04-17
1,461 reads
Shivayan Mukherjee
- Interests: coding, travelling, outdoor games
Cassandra Springboot Integration With Redis
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)
84 reads
PostgreSQL Aggregate Functions
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
488 reads
2024-12-06
1,555 reads
Getting Started With Azure Cosmos DB for PostgreSQL
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
2024-07-29
1,291 reads
PostgreSQL UNION, INTERCEPT & EXCEPT Operator
Another article on how the SQL language works in PostgreSQL. This time we examine the UNION, INTERSECT, and EXCEPT operators.
2024-05-31
1,557 reads
Getting Started with DDL statements of Cassandra Query Language
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
2023-12-01
1,384 reads
2023-08-25
639 reads
PostgreSQL Copy
In this article you will learn how to use the COPY command in PostgreSQL to copy a database or a table.
2023-06-09
5,160 reads
PostgreSQL Table Import/Export from and to CSV File
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
2,138 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers