Author: Manvendra Singh

Manvendra has 15 years of experience in the database domain where he has worked on various critical deliveries like heterogeneous migration of SAP databases from AIXOracle platform to WindowsSQL Server, On Prem to Cloud migrations, Database consolidation projects and various HA & DR implementations.

Getting Started with the SQL Not Equal To Operator and Its Use Cases

Uncategorized

This article will give an overview of the SQL Not Equal To operator and demonstrate how to use it...
Read More

SQL Server DBA Interview Questions and Answers – Part 2

SQL Server

This article is in sequence with my last article where I have covered SQL Server interview questions and answers on SQL Server...
Read More

SQL Server DBA Interview Questions and Answers – Part 1

SQL Server

This article will help you to prepare for SQL Server interviews. I have explained various popular SQL Server interview questions and...
Read More

An Overview of SQL LIKE Statement and Its Use Cases

Uncategorized

SQL LIKE statement is used to search a similar phrase or pattern in a column. It supports ASCII and...
Read More

SQL IN operator

Uncategorized

The SQL IN statement matches a specified value from a list or subquery. It reduces our efforts to write various OR statements with equal to...
Read More

How to Download, Install and Restore AdventureWorks Database in SQL Server

Database administation

Sometimes, we need a sample database that has all the required objects along with a large set of data inside the database for our various...
Read More

Getting Started with the SQL Server T-SQL CASE Expression Statement

T-SQL

SQL Server CASE expression is very useful in returning an output based on some conditional matching...
Read More

Restoring SQL Server Data Warehouse Sample Database AdventureWorksDW2019 Using Azure Data Studio

Azure, Cloud

I explained a step-by-step process to restore the data warehouse sample database AdventureWorks DW in my last article. AdventureWorks DW...
Read More

How to Use SQL Server T-SQL Function SUM: 5 Use Cases

Database development, Statements

The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column –...
Read More

Azure SQL Elastic Pool – Understanding and Creating

Azure, Cloud

Microsoft Azure offers many PAAS services for addressing the database requirements based on the...
Read More
Close