Learn With Sundar

SQL Server

Mastering ETL with Microsoft: Extract, Transform, Load Process Explained

ETL, which stands for Extract, Transform, Load, is a fundamental process in data engineering. It is…
Key Concepts in Data Engineering: ETL, Data Pipeline, Data Warehouse

Data engineering is a critical field that underpins the modern data-driven world. It involves the design,…
NoSQL vs. SQL Databases

Introduction In today’s data-driven world, the choice of database technology plays a crucial role in shaping…
The Role of a Data Engineer: Powering Data-Driven Decision Making

Introduction In today’s data-driven world, organizations are inundated with vast amounts of data generated from various…
Quick Reference Guide for SQL Server DBA Daily Tasks

Introduction As a SQL Server Database Administrator (DBA), daily operations can be time-consuming and require a…
Azure Data Studio vs SSMS – Overview

Introduction When it comes to working with SQL Server, Microsoft offers two powerful tools: Azure Data…
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…
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…
Find Database Owner In SQL Server

Introduction In this simple article, let’s explore different ways to find a Database owner. When a…
How to Identify Unused Tables In SQL Server

Introduction When working on large-scale projects, we might have created many tables, or later some point…
Find All Tables Containing Column With Specified Column Name – MS SQL Server

Introduction In this article, we will discuss how to get the list of table names that…
Where are the SQL Jobs are Stored in SQL Server

Introduction In this article, We will discuss where the SQL Jobs are stored in SQL Server.…
How to Check SQL Server Database Size

Introduction In this simple article, I would like to share how to check DB size. Sometimes…
Find When was a SQL Server View Last Modified

Introduction In this simple tips and tricks article, I would like to share how to when…
Find Table Creation Date In SQL Server

Introduction In this article, we will discuss how to get the created date of a table.…
List All Available Time Zone – SQL Server

Introduction In this simple tips and tricks article, I would like to share how many time…
To Get Total Number of Columns In a Table In SQL Server

Introduction In this simple article, lets explore to get total number of columns in a table…
sp_rename – Rename a column or table in MS SQL Server

Introduction In this article, I would like to share how to rename a column name or…
Altering Column – From NULL to NOT NULL in SQL Server

Introduction When working in SQL Server tables, sometimes we may need to change a column that…
Execution Time of Stored Procedures In SQL Server

Introduction When working in SQL Server Stored Procedures, we are keen about the execution time of…
Different Ways To Get Table Column Names In SQL Server

Introduction In this simple article, we will discuss different ways to find the particular table’s column…
Python Packages in SQL Server – Get Started with SQL Server Machine Learning Services – Part 5

Introduction When installing Machine Learning Services in SQL Server by default few Python Packages are installed.…
Find Columns That Allows NULL In SQL Server

Introduction The columns in a table, that allows NULL in a database sometimes can lead to…
SQL Server Rank Functions

Introduction As like an Aggregate functions, the Ranking functions will rank the values of specified field…
T-SQL Query For Finding The Longest And Shortest names In A Table

Introduction In SQL Server, we can find the Longest String Value and Shortest String Value from…
MERGE Statement in SQL Server to Insert, Update, Delete Records

Introduction In a single transaction (MERGE Statement) we can perform Insert, Update and Delete records on…
Function to Calculate Simple Interest In SQL Server

Introduction Whenever working in Financial Applications like Banking applications or financial modules in any ERP application…
Creating T-SQL Query Shortcuts in SQL Server Management Studio(SSMS)

Introduction Using keyboard shortcuts, it saves time, isn’t it?. SQL Server Management Studio is also not…
Efficient Way Of Copying Database In SQL Server

Introduction Sometimes when working in Database, we may need to create another working copy of the…
One Drop Statement For Multiple Tables In SQL Server

Introduction When as a developer working in a database, which is in Development state, we may…
List of Available Database for Current User In SQL Server

Introduction When working in the SQL Server, we may have to check some other databases other…
Find Recently Modified Tables In SQL Server Database

Introduction SQL Server maintains a table to keep information about each tables that are created in…
Import Dataset In Python From SQL Server – Get Started with SQL Server Machine Learning Services – Part 4

Introduction In our previous article, we discuss about how to run Python in SQL Server that…
SQL Server sp_execute_external_script Stored Procedure – Get Started with SQL Server Machine Learning Services – Part 3

Introduction When we want to execute any external language script in SQL Server, then we have…
SQL Query To Increase Salary By Percentage For All Employees In A Table

Introduction Sometimes we may need to increase the current column value by Percentage. The very good…
T-SQL Query To Order By The Last Three Characters Of A Column

Introduction In this article, we will discuss how to Order By the Column Result By Last…
Azure Data Studio Tips And Tricks

Introduction Who will say NO to when they want to improve the speed and efficiency of…
Select Names NOT Starting with Vowels in MS SQL Server

Introduction Sometime we may need to select the column results that the string not starting with…
Select Names NOT Starting And NOT Ending With Vowels in MS SQL Server

Introduction Sometime we may need to select the column results that the string not starting and…
Select Names NOT Ending With Vowels in MS SQL Server

Introduction In this article, We will have a look, How to select the columns results NOT…
Select Names Ending With Vowels in MS SQL Server

Introduction Sometime we may need to select the column results that the string ends with Vowels.…
Install Machine Learning Services for Python-Get Started with SQL Server Machine Learning Services – Part 2

Introduction This is Part 2 of “Get Started with SQL Server Machine Learning Services “. In…
Difference Between Drop Table, Truncate Table & Delete Table in MS SQL Server – Zero to Hero Query Master – Part 6

Introduction In this article, we will discuss the difference between Drop Table, Truncate Table, Delete Table.…
Tables in Database- MS SQL Server – Zero to Hero Query Master – Part 5

Introduction All the data in a database is stored in a Table, which is a data…
How is Data Stored in SQL Database

Introduction Being Software Developer / DBA / Database Developer, its important to know or understand the…
Get Started with SQL Server Machine Learning Services – Part 1

Introduction We know Humans learn from their past experiences. Mean while Machines follow Instructions given by…
SQL Server Date Functions

Introduction Date and Time plays major role in many projects. SQL Server has several date and…
SQL Server String Functions

Introduction In this article, we will discuss about the SQL Server String Functions (built in functions)…
Aggregate Functions in SQL Server

Introduction Aggregate Functions are used to return a single value, which is calculated from multiple values…
Retrieve Unsaved SQL Query Scripts

Introduction In this article, we will have a look how to retrieve the Unsaved SQL Query…
Select Statement Execution Order In SQL Server

Introduction We all can write the SELECT Statement in SQL Server. But how many of us…
System Databases in SQL Server

Introduction In SSMS, we many of may noticed System Databases under the Database Folder. But how…
What is Database Normalization in SQL Server – MS SQL Server – Zero to Hero Query Master – Part 4

What is Database Normalization Database normalization is the step by step process of organizing data to…
Schema Comparisons using Visual Studio SQL Data Tools

Introduction There are many occasions where we may need to compare the schema between two databases.…
Link a SQL Server Database Project to a Git Repository

Introduction Continuous Integration has become practice to many development project. Did you know, we can achieve…
Create and Publish SQL Server Database Project With Visual Studio

Introduction Databases plays an important role in any project these days. It becomes too difficult to…
Customize Azure Data Studio with Dashboard Widgets

Introduction Azure Data Studio is a free multi-platform database tool with built-in support for both SQL…
Cycle Clipboard Ring In SSMS – Reuse Copied Items

Introduction As a developer, the most used shortcut keys are CTRL+C and CTRL+V i.e., copy and…
Set custom colors to differentiate between environments in SSMS

Introduction Generally we have to shift between different environments within SQL Server Management Studio, as Dev…
Recover unsaved SQL queries in SSMS

Introduction During our productive hours, sometimes due to SSMS crashes or sudden machine reboots due to…
Multiple Backup Files of the SQL Server database with SSMS and T-SQL

Introduction In this article, we will learn a simple tip to take multiple backup files of…
Difference between CURRENT_TIMESTAMP vs GETDATE() vs SYSDATETIME() vs GETUTCDATE() in SQL Server

Introduction In this article, we will discuss the difference between CURRENT_TIMESTAMP , GETDATE() , SYSDATETIME() GETUTCDATE()…
Change Schema Name Of Table In MS SQL Server

Introduction In this article we will learn the trick to Move a Table from One Schema…
5 Tips to Improve SQL Query Performance

Introduction In this article, I will share few SQL Tips for Boosting our SQL Query Performance.…
Identifying object dependencies in SQL Server using SP_DEPENDS

Introduction When developing components for SQL Server one change may affect another database object. Finding these…
Select Names Starting With Vowels in MS SQL Server

Introduction Sometime we may need to select the column results that the string starts with Vowels.…
Display Line Numbers in a SQL Server Management Studio Query Window (SSMS)

Introduction Sometimes when we encounter an error message for a T-SQL query while debugging. The SQL…
Get list of Tables & Views in MS SQL Server- sp_tables

Introduction Sometimes we may need to get all the tables and views from a database in…
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…
Stored Procedure Performance Tuning

Introduction In the Database, we may be using Stored Procedures. Most of the time we are…
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…
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…
Backup Database using T-SQL Statements

Introduction In this article, We will discuss how to backup our database in MS-SQL Server using…
Pinned tabs in SQL Server Management Studio (SSMS)

Introduction While working in SQL Server Management Studio (SSMS), we may need to open many query…
SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master – Part 3

Introduction This is part 3 of “MS SQL Server- Zero to Hero” and in this article,…
Split Query Window in SQL Server Management Studio(SSMS)

Introduction Sometime we may write a long query in our query window and we may need…
Last Execution of Stored Procedure in SQL Server

Introduction In an ERP project or any other big applications, there may be many Stored Procedures…
List Databases Available for Current User -SQL Server

Introduction Sometimes, we may be curious to know to which databases do we have access or…
Format JSON Output in SQL Server

Introduction From SQL Server 2016 JSON functions are introduced, since many modern Web and Mobile applications…
Find user who ran DROP statements – SQL Server

Introduction Sometimes we need to track or find which user has DROPPED the table(s) from the…
SQL Server Management Studio Shortcut Keys Cheat sheet

Introduction In this article, I would like to share few shortcut keys which is really useful…
MS SQL Server – Zero to Hero Query Master – Part 2

Introduction In this article, you will learn how to create a database, access the created database,…
MS SQL Server – Zero to Hero Query Master – Part 1

Introduction This is part one of the Zero To Hero Series in MS SQL Server. This…