Home » database

Tag Archives: database

Download and Install SQL Server Management Studio

In this article, we’re going to the steps to download and install the Microsoft SQL Server Management Studio (SSMS). 1. SSMS System Requirements SQL Server Management Studio (SSMS) is a powerful application maintained and distributed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server. The application was first launched with Microsoft SQL Server 2005 ...

Read More »

SQL vs NoSQL Databases

In this article, we will explain the differences between SQL vs NoSQL Databases. You can also check this tutorial in the following video: SQL vs NoSQL Databases – video 1. Introduction We will check the relational (SQL) and non-relational (NoSQL) data structures. While both are viable options, there are key differences between the two that users must keep in mind ...

Read More »

SQL Server Versions

In this article, we’re going to see several Microsoft SQL Server versions and editions and how to identify them. 1. Introduction On MSSQL Server we need to determine the version and edition to troubleshoot some issues or to know if feature support is available. To do that, MSSQL Server introduces some procedures to identify the version and edition which we’re ...

Read More »

Spring Data JPA Auditing Example

Welcome, in this tutorial, we will see how to implement a Spring data JPA auditing application. We will use the AuditorAware interface to capture the auditing information. Database auditing is a mechanism to keep track and logs of events happening on the records present in a database like who did what and when. 1. Introduction Before going further in this ...

Read More »

Spring Boot Composite Key Example

Welcome, in this tutorial, we will see how to implement a composite key in a spring boot application. We will use the @Embeddable and @EmbeddedId annotations. 1. Introduction Before going further in this tutorial, we will look at the common terminology such as introduction to Spring Boot and Lombok. 1.1 Spring Boot Spring boot is a module that provides rapid ...

Read More »

Spring Boot Database Migrations with Flyway

Welcome, in this tutorial, we will see how to implement a database migration in a spring boot application using Flyway. 1. Introduction Before going further in this tutorial, we will look at the common terminology such as introduction to Spring Boot, Lombok, and Flyway. 1.1 Spring Boot Spring boot is a module that provides rapid application development feature to the ...

Read More »

Spring Boot pagination with Thymeleaf Tutorial

Welcome, in this tutorial, we will explain the pagination in a spring boot application and for this, we will use thymeleaf. 1. Introduction Before going further in this tutorial, we will look at the common terminology such as introduction to Spring Boot, Lombok, Thymeleaf, and Pagination. 1.1 Spring Boot Spring boot is a module that provides rapid application development feature ...

Read More »

Amazon Redshift JDBC Connection Example

In this tutorial, we will learn about how to set up a JDBC connection to an Amazon Redshift cluster. We will also discuss and analyze a coding example where we connect to an Amazon Redshift Cluster via JDBC and perform CRUD operations on a table. 1. What is Amazon Redshift? Amazon Redshift is a fully managed data warehouse service in ...

Read More »

SQL Primary Key Example

Welcome readers, in this tutorial, we will understand the SQL Primary Key column that uniquely identifies a tuple in the database table. 1. Introduction SQL Primary Key is a column or multiple columns that uniquely identify a tuple in the database table. It contains unique values but cannot have null or duplicate It consists of multiple columns known as a ...

Read More »

MySQL Replication Tutorial

1. Introduction MySQL is one of the most used SQL databases in many of the world-enterprise applications due to its ability to manage transactions and the ACID-behaviour which is built into its core. One of the reasons MySQL is so popular is due to the easiness it provides for its usage and its related commands. In the open source web application ...

Read More »