Learn With Sundar

Get Started

  • 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…

  • Backup Database using T-SQL Statements

    Introduction In this article, We will discuss how to backup our database in MS-SQL Server using T-SQL Statements. We need to use BACKUP DATABASE statement to create full database backup, along with the name of Database and device to store the backup file. Syntax Example Conclusion With a simple T-SQL Statement BACKUP DATABASE , we…

  • What is Power BI

    Introduction With Microsoft Power BI we can quickly connect to our data and visualize as much or as little as we like and creates stunning reports and dashboards to help get insights into the business, which helps to make decisions. To make decisions we need data, that only the business data. In this article, we…

Subscribe

Enter your email below to receive updates.