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.

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

09:43 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

08:17 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

09:45 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

10:27 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

09:05 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

14:13 Database administation, SQL Server, Work with data • One Comment

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

13:05 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

Configure SQL Server Always ON Availability Groups between Two Synchronous Replicas. Part 2

11:55 Availability Groups, Database administation

We already covered some theory about configuring Always ON Availability Groups for Linux-based SQL Servers. The current article will focus...
Read More

Understanding Always ON Availability Group between Linux-Based SQL Server Instances. Part 1

11:33 Availability Groups, Database administation

SQL Server Always ON Availability Group is a solution meant to achieve high availability and disaster recovery for SQL Server databases. We...
Read More

How to Install SQL Server Tools on Ubuntu 18.04 Linux System – Step by Step

09:29 Tools & technologies

In the previous articles, we covered sequential steps necessary to build a virtual machine, install...
Read More