Learn With Sundar

Get Started

  • Azure Data Studio vs SSMS – Overview

    Introduction When it comes to working with SQL Server, Microsoft offers two powerful tools: Azure Data Studio and SQL Server Management Studio (SSMS). While both tools are designed for managing SQL Server, they differ in several key areas. In this article, we will explore the features and benefits of each tool, and discuss which scenarios…

  • T-SQL Query To Find Deadlocks In MS SQL Server

    Introduction As a Backend Developer, I have frequently encountered performance issues, particularly those stemming from poorly written code or lack of indexes, which can lead to blocking conditions called “deadlocks.” These situations can directly impact user experience and become more severe with frequent occurrences. This article addresses deadlock issues and reporting. Upon completion, readers will…

  • Introduction To Python – Part One

    Introduction Python is a ‘high-level, interpreted, general-purpose programming language’ that is utilized for various purposes such as ‘web development, scientific computing, data analysis, artificial intelligence, and more.’ It is recognized for its ‘simple and easy-to-read syntax,’ making it a desirable language for novice programmers. Furthermore, Python has a thriving and dynamic community, offering an abundance…

  • What is Entity Framework

    Introduction Entity Framework (EF) is an object-relational mapping (ORM) framework for the Microsoft .NET Framework. It allows developers to work with a database using objects, eliminating the need to write SQL commands. EF provides a set of APIs for creating, querying, and updating data in a database, and it can work with a variety of…

  • What is ChatGPT?

    Introduction ChatGPT, developed by OpenAI, is a large language model trained on a dataset of conversational text. It generates human-like responses to text-based prompts and is useful for various natural language processing tasks including language translation, question answering, and text completion Who can use ChatGPT ChatGPT, a publicly accessible model, is widely used by researchers…

  • How To Remove Duplicate Values Without Using DISTINCT In SQL Server

    Introduction Whenever we work with data, sometimes there are some possibilities of getting duplicate data, not only because of the duplicate entries but also because of the T-SQL statement. We may need to remove it as well. In this instance, most of us follow to implement the DISTINCT keyword in our T-SQL Statement. Applying DISTINCT…

Subscribe

Enter your email below to receive updates.