RajKishore

Rajkishore Sahoo is a Microsoft Azure consultant with more than 14 years of hands-on experience building cloud-native data solutions across Azure and AWS, focused on Azure SQL Database, Azure SQL Managed Instance, and the pipelines that connect them to production apps. Day to day, he provisions Azure SQL instances, configures firewalls and connection strings, tunes queries for cloud workloads, and wires databases into Azure Functions and Logic Apps. Read more

MariaDB Alter Table Add Index

by
MariaDB Alter Table Add Index

In this MariaDB tutorial, we will understand how to add the indexes to the existing table to speed up the search of the records in the database. While I was searching for the detail of the customers in my database, it was very time-consuming because the table of the database wasn’t indexed properly or the … Read more >>

SQL Server LEFT OUTER JOIN with WHERE clause

by
Sql server left outer join with where clause example

In this SQL Server tutorial, we will learn and understand how to use the SQL Server LEFT OUTER JOIN with the WHERE clause on tables by the query. Recently, I got a requirement to join multiple tables and even filter records based on the condition for the resultset in the SQL Server. So, I came … Read more >>

MariaDB Set Auto Increment Value

by
MariaDB Set Auto Increment Value

In this MariaDB tutorial, we will know how to set the auto-increment value in MariaDB. Sometimes database developer needs to design a database that should keep each record in a unique way or the record can be found easily, for that auto-increment is used. The auto-increment assigns a unique identity to each record or information … Read more >>

MariaDB Str_To_Date [10 Amazing Examples]

by
MariaDB Str_To_Date

If you are working with date and time data in MariaDB, you may need to convert strings to date/time values in order to perform various operations on the data. MariaDB provides several functions and techniques that you can use to perform this conversion. In this MariaDB tutorial, we will explore some of the most common … Read more >>

SQL Server Inner Join With Where Clause

by
Example of Sql server inner join with where clause

In this SQL Server tutorial, we will learn and understand how to use the SQL Server INNER JOIN with WHERE clause on tables by the query. Recently I got a requirement where I need to join multiple tables and even filter some data in SQL Server. So, I came across the use of SQL Server … Read more >>

SQL Server Inner Join Distinct

by
Sql server inner join distinct example

In this SQL Server tutorial, we will learn and comprehend how to use the SQL Server DISTINCT clause with the INNER JOIN clause on tables via the query. So, I got an update from the client of their Book Management System project for using the DISTINCT clause with the INNER JOIN clause on tables in … Read more >>

SQL Server FULL OUTER JOIN with WHERE clause

by
Sql server full outer join with where clause example

In this SQL Server tutorial, we will learn and understand how to use the SQL Server FULL OUTER JOIN with WHERE clause on tables by the query. Recently, I got a requirement to join multiple tables and even filter records based on the condition for the resultset in the SQL Server. So, I came across … Read more >>

SQL Server Trigger On View

by
SQL Server Trigger on View Example

In this SQL Server tutorial, we will discuss how to create a SQL Server Trigger on View with the help of multiple examples. In one of our tutorials on SQL Server Trigger, we understood how to create a trigger on a table in SQL Server. However, Triggers in SQL Server are not restricted to just … Read more >>

MariaDB Show Column Data Type

by
MariaDB show column data type from database

This MariaDB tutorial will go through how to Show Column Data Type. To assist you in better understanding the topic, we will explore and draw conclusions from a number of examples in this section by following the below topics. MariaDB Show Column Data Type or Data Type From Table To view details about the column … Read more >>

SQL Server Group by Join Strings

by
Sql server group by join strings

In this SQL Server tutorial, we will learn and understand how to use the SQL Server STRING_AGG function and aggregate_functions with JOIN and GROUP BY clauses on tables by the query. Recently I got a requirement where I need to join strings by concatenation on multiple tables and even group some data in SQL Server. … Read more >>