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

Restoring Sample DW Database AdventureWorksDW2019

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

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...
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 nature of data and transaction workload....
Read More

Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases

Database administation, Security

There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what...
Read More

Understanding SQL Server Lockdown to Secure Database Environment

Database administation, Security

Security is the main concern these days in every sector. Database Security is also a major worry...
Read More

How to Change Server Level Collation of Running SQL Server Instance

Database administation, Work with data

In my previous article I have explained the basics of SQL Server Collation. I would suggest you first read that article (if you haven’t...
Read More

Understanding the Database Level Collation and Impact of Changing it for a Database

Database administation, SQL Server, Work with data

When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and...
Read More

How to Get SQL Server Statistics Information Using System Statistical Functions

Database administation, Database development, Database Optimization & Structure, Stored Procedures

Often, we need to gather system statistics regarding running SQL Server Instances, such as the...
Read More
Close