How to create a microservice
To create a microservice, we need access to the following tools - Visual Studio (For implementing C# based code for the service) SQL...
top of page
Search
-
- Jul 28, 2021
- 2 min
MariaDB vs MySQL : Database Management System
What is Maria DB? MariaDB is a fork of the MySQL database management system. The RDBMS offers data processing capabilities for both small...
-
- Jul 8, 2021
- 4 min
How to Use IndexedDB ā A NoSQL DB on the Browser
IndexedDB is a large-scale, NoSQL storage system. It lets you store just about anything in the userās browser. In addition to the usual...
-
- Jul 5, 2021
- 3 min
New Features In MS SQL Server 2019
In this article, we will cover all the new feature in SQL Server 2019. The previous version of SQL 2017 came with support for Linux...
-
- Apr 28, 2021
- 3 min
Second Highest Salary in MySQL and SQL Server
Write a SQL query to get the second highest salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 ...
-
- Apr 26, 2021
- 2 min
Executing Raw Sql Queries using Entity Framework Core and returns result to Generic Data Model
As it is known, in raw sql queries such as executing stored procedures with entity framework core (versions such as core 3.0, core 3.1...
-
- Apr 19, 2021
- 3 min
What is PL/SQL? Explained
Oracle PL/SQL is an extension of SQL language that combines the data manipulation power of SQL with the processing power of procedural...
-
- Apr 16, 2021
- 2 min
What are Joins in SQL? with Examples
JOINS in SQL are commands which are used to combine rows from two or more tables, based on a related column between those tables. There...
-
- Apr 15, 2021
- 4 min
How to solve Arithmetic overflow error in Microsoft SQL Server Database
How to solve Arithmetic overflow error converting IDENTITY to data type tinyint, smallint or int in Microsoft SQL Server database The...
-
- Apr 14, 2021
- 2 min
Nth Highest Salary Example in MySQL and SQL Server
Write a SQL query to get the nth highest salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 |...
-
- Apr 13, 2021
- 3 min
ALTER Command in SQL
ALTER is not part of classical CRUD operation but itās one of the important DDL commands. One of the most frequent uses of ALTER command...
-
- Apr 13, 2021
- 3 min
How to use DROP command to remove tables in Oracle, MySQL and SQL Server
DROP is one of the basic SQL commands, which is used to DROP database objects. Since it's part of ANSI SQL, the DROP command is supported...
-
- Apr 13, 2021
- 5 min
Writing SQL in C# or When You should not use ORM
I noticed that when it becomes necessary to work with SQL databases in .Net applications, developers often chose some ORM library (.Net...
-
- Mar 1, 2021
- 4 min
How To Create SQL Server Database Project With Visual Studio
In this article, we are going to learn about SQL Server Database Project (Template) available in Visual Studio. I will cover the...
-
- Mar 1, 2021
- 2 min
Configuring GEO Replication In SQL Azure Database
Geo-replication is a feature which allows you to configure a maximum of four readable copies of your database in the same or different...
-
- Mar 1, 2021
- 3 min
Azure SQL Offers Manual Failover For PaaS Resources
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a...
-
- Feb 4, 2021
- 12 min
How to build a GraphQL server
Apollo is a set of tools for building GraphQL applications, especially suited for building on top of your existing data. There are three...
-
- Feb 3, 2021
- 5 min
LAMP (Linux, Apache, MySQL, PHP)
LAMP is an open-source Web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the...
-
- Jan 26, 2021
- 3 min
DEPLOYING WORDPRESS AND MYSQL ON AWS WITH CUSTOM VPC USING TERRAFORM
What is Amazon VPC? Amazon Virtual Private Cloud is a commercial cloud computing service that provides users a virtual private cloud, by...
-
- Jan 26, 2021
- 4 min
DEPLOYING WORDPRESS AND MYSQL ON CUSTOM VPC WITH NAT USING TERRAFORM
If you check my previous story, you can see that it had a similar to this one. The only difference is that the instances in the private...
bottom of page