Blogs

Microsoft’s Artificial Intelligence – An Overview

Introduction In this article, we will have a detailed listing at AI Services supported and provided by Microsoft. What of Artificial Intelligence Artificial Intelligence is a branch of computer science that aims to create intelligent machines, in simple terms, Human Intelligence processed by Machines, specifically computers. AI Categories AI can be categorized as either weak…
Selecting Only EVEN or ODD Records from Tables – MS SQL SERVER

Introduction In this article, we will learn to Select only EVEN or ODD records from the MS SQL Server database table🤔. The efficient way to find the record belongs to even or odd is determining by the table’s ID column. Select EVEN Records By applying the modulo operator by 2 for the ID column, we…
Stored Procedure Performance Tuning

Introduction In the Database, we may be using Stored Procedures. Most of the time we are concerned about the performance of the Stored Procedures. In this article, I would like to share a few techniques to improve the stored procedure’s performance to get better results in less time. Optimization Techniques SET NOCOUNT ON/OFF – When…
Optimize your SQL Query – Replace Star (*) in Select Statement – MS SQL Server

Introduction Sometime we may need almost all the columns from a table result. In this scenario we use Star(*) in our select statement i.e. as SELECT * FROM TableName. Using Star(*) in the select statement is BAD. The best approach is selecting the table with column names. In this article we will learn how quickly…
How to Store non-English Characters in SQL Server

Introduction Sometime, we may need to store non-English characters or multiple languages in our database. In this article, we will have a look at how to store non-English characters in SQL Server. VARCHAR vs NVARCHAR We can store non-English Characters in our database table using the data type NVARCHAR(). The N stands for Unicode. It…
Monolithic vs Microservice Architecture

Introduction Most of web application developer might discussed about Monolithic vs Microservice. Now a days we can develop better web application with either these options. Its all important that which one is right our needs. In this article, we will discusses both of these architecture and you can decide which architecture is needed for application…