Manvendra Singh

Manvendra is a passionate database lover currently working as a Technical Architect at one of the top MNCs. He has extensive experience on all versions of SQL Server since 2000 and has built Big Data skills.  He has lead projects on the following database features: Database Mirroring, Always ON, Replication, Log Shipping, Geo-Clustering and Performance Tuning and delivered many SQL Server projects on consolidation, upgrades, heterogeneous replication, HA / DR solutions, automation and major performance tuning projects.  You can also follow Manvendra on his blog, Twitter, LinkedIn and Facebook.
  • MSSQLTips Awards: Champion (100+ tips) - 2018 | Author Contender - 2015-2018, 2021-2022
Title Category Date
Enable and Disable Full Text Search for SQL Server Databases Full Text Search2025-06-18
Renaming Physical Database File Names for a SQL Server Database Database Administration2025-06-15
SQL Server Login and User Permissions with fn_my_permissions Security2025-05-27
How to read the SQL Server Database Transaction Log Database Administration2025-01-20
Add Full Text Search on SQL Server Full Text Search2025-01-14
Database Cloning in SQL Server for Troubleshooting and Diagnostics Performance Tuning2024-12-29
Azure SQL Database Change Primary Region for Failover Group Azure SQL Database2023-06-05
Azure SQL Database Change Secondary Region for Failover Group Azure SQL Database2023-05-11
Remove a SQL Database from an Azure Failover Group Azure SQL Database2023-05-02
How to add an Azure SQL Database to an existing Auto-Failover Group Azure SQL Database2023-04-17
How To Configure Azure SQL Auto Failover Groups Azure SQL Database2022-12-05
Setup and Configure a Failover Database for Azure SQL Database Azure SQL Database2022-11-30
SQL Server OBJECTPROPERTY Function Examples Functions System2022-09-30
Add a Column in a Table in SQL Database Design2022-09-26
Metadata Functions in SQL Server SERVERPROPERTY, DB_NAME, OBJECT_ID Functions System2022-08-19
Find All Securable Objects in SQL Server and Permissions Security2022-08-02
SQL Server Collation Settings Instance, Database and Column Levels Database Configurations2022-07-25
SQL COUNT and SQL COUNT_BIG Functions Functions System2022-07-13
SQL Server Configuration Functions Functions System2022-07-06
SQL Average Function to Calculate Average of a set of SQL Server Rows Functions System2022-06-22
SQL MAX Examples and Use Cases Functions System2022-05-05
DATEADD SQL Function to Add and Subtract Dates and Times Dates2022-04-26
SQL DATEDIFF and DATEDIFF_BIG Functions with Sample Code Dates2022-04-11
SQL Login Details with SQL LOGINPROPERTY Function Security2022-01-28
Change the host name for Linux server on Red Hat, SuSE or Ubuntu SQL Server on Linux2021-12-15
SQL Server Agent for SQL Server 2019 on Redhat Linux SQL Server on Linux2021-12-02
Install SQLCMD and BCP for SQL Server on Redhat Linux Virtualization2021-11-23
Install SQL Server 2019 on Red Hat Linux Virtualization2021-11-17
Install Python and Openssl on Red Hat Linux Virtualization2021-10-29
Repositories to install SQL Server on Red Hat Linux Virtual Machine Virtualization2021-10-21
Configure Red Hat Subscription Management on VMware Virtual Machine Virtualization2021-10-14
Build Virtual Machine for Red Hat Enterprise Linux on VMware Virtualization2021-10-07
Create a New Virtual Machine for VMware Workstation Pro Virtualization2021-09-29
VMware Workstation Pro Installation Virtualization2021-09-28
SQL Server 2019 Hybrid Buffer Pool Enable and Disable SQL Server 20192021-08-24
SQL Server 2019 Hybrid Buffer Pool SQL Server 20192021-07-26
Lock Pages in Memory for SQL Server on Windows SQL Server Configurations2021-07-19
6 Ways to Get SQL Server Versions SQL Server Configurations2021-07-07
AdventureWorks Database Installation Steps Testing2021-06-18
How to Upgrade SQL Server Management Studio and Azure Data Studio SQL Server Management Studio2021-06-10
Understanding SQL Server Full Text Search Full Text Search2021-05-27
SQL Server Management Studio Template Explorer SQL Server Management Studio2021-05-18
INDEXPROPERTY Function in SQL Server Indexing2021-05-13
SQL Server SERVERPROPERTY() Use Cases Functions System2021-04-30
SQL ALTER Authorization Examples Security2021-04-29
Multi-Site SQL Server Always On Availability Groups Availability Groups2021-03-30
Configure Always ON Availability Groups between Two SQL Server FCIs Availability Groups2021-03-22
Fix Tracer Tokens in SQL Replication Replication2021-03-11
Azure Data Studio Installation Install and Uninstall2021-02-10
Install SQL Server Management Studio 18.6 Install and Uninstall2021-02-09
Install SQL Server 2019 on Windows Server 2016 in VMware Virtualization2021-02-04
Install Windows Server 2016 on VMware Workstation Virtualization2021-02-03
How to Setup a Virtual Machine with VMware Workstation 14 Virtualization2021-02-01
Install VMware Workstation 14 on Windows Virtualization2021-01-19
Install SQL Server Management Studio SQL Server Management Studio2020-12-17
SQL Server Uninstallation Error Could Not Open Key Install and Uninstall2020-12-02
SQL Server Single User Mode Troubleshooting Database Administration2020-11-16
Migrate Data from Oracle to SQL Server with SSMA SQL Server and Oracle Comparison2020-11-06
Oracle to SQL Server Migration Load Database Objects SQL Server and Oracle Comparison2020-10-23
Oracle to SQL Server Migration Convert Database Objects SQL Server and Oracle Comparison2020-10-13
Oracle to SQL Server Migration with SQL Server Migration Assistant SQL Server and Oracle Comparison2020-09-30
SQL Server AlwaysOn Interview Questions and Answers – Part 2 DBA Interview Questions2018-12-07
SQL Server AlwaysOn Interview Questions and Answers – Part 1 DBA Interview Questions2018-11-22
SQL Server Replication Interview Questions and Answers DBA Interview Questions2018-07-09
Install SQL Server Migration Assistant for Oracle Extension Pack SQL Server and Oracle Comparison2018-06-25
How to Install SQL Server Migration Assistant for Oracle – Part 1 SQL Server and Oracle Comparison2018-06-13
How to Change SQL Server Instance Name Running on a Linux Server SQL Server on Linux2018-05-25
Adding a Database to an existing SQL Server Always ON Configuration Availability Groups2018-05-03
Remove SQL Tools sqlcmd and bcp from Ubuntu Linux Server SQL Server on Linux2018-04-11
Fixing SQL Server Installation Error 1639 Install and Uninstall2018-03-23
How to Uninstall SQL Server 2017 running on Ubuntu SQL Server on Linux2018-03-02
Renaming a Red Hat Linux System Hostname for SQL Server SQL Server on Linux2018-02-14
Fixing Error 19405 When Configuring SQL Server Availability Groups Availability Groups2018-02-05
Add a SQL Server Database to an Existing Always On Availability Group Availability Groups2018-01-16
Join a Secondary SQL Server Database to an AlwaysON Availability Group Availability Groups2017-10-24
Remove SQL Server AlwaysOn Database from Primary Replica Availability Groups2017-10-11
Remove Database from SQL AlwaysON Availability Group Secondary Replica Availability Groups2017-09-26
Fixing error Failed to mount cd: devices when installing SQL Server tools on SUSE Linux Server SQL Server on Linux2017-09-11
Installing SQL Server Tools on SUSE Linux SQL Server on Linux2017-08-09
Installing SQL Server Agent on SUSE Linux SQL Server on Linux2017-08-02
Installing SQL Server Agent on Red Hat Linux based SQL Servers SQL Server on Linux2017-07-17
How to create SQL Server Agent Jobs on a Linux based instance using Management Studio SQL Server on Linux2017-07-12
How to change the Default Dump File location of SQL Server running on Linux Server SQL Server on Linux2017-07-03
Error 1408 Joining database on secondary replica resulted in an error Availability Groups2017-06-28
Enable and Disable SQL Server Trace Flags on a Linux Server SQL Server on Linux2017-06-19
Installing SQL Server vNext on SUSE Linux Server SQL Server on Linux2017-06-05
How to Change SQL Server Port Number for a Linux Server SQL Server on Linux2017-05-22
Schedule SQL Server Agent Job on a Linux based instance using T-SQL SQL Server on Linux2017-05-17
How to Uninstall SQL Server vNext from a Linux Server SQL Server on Linux2017-05-08
Installing SQL Server Agent on Ubuntu Server SQL Server on Linux2017-04-25
Upgrading SQL Server running on Ubuntu to latest update SQL Server on Linux2017-04-19
Fix SQL Server AlwaysOn Error: 35250 Failed to Join the Availability Group Availability Groups2017-04-05
Remove SQL Server AlwaysOn Availability Group Configuration Availability Groups2017-03-28
Restore SQL Server database on Linux from backup on Windows SQL Server on Linux2017-03-24
How to Change Default Data and Log file directory for SQL Server running on Linux SQL Server on Linux2017-03-17
Upgrading SQL Server vNext on Red Hat Linux to latest available update SQL Server on Linux2017-03-13
Restore a SQL Server database on a Linux based instance from a backup on a Windows instance SQL Server on Linux2017-03-01
Install SQL Server Tools to Establish a Database Connection from an Ubuntu Server SQL Server on Linux2017-02-15
Installing SQL Server vNext on Ubuntu SQL Server on Linux2017-02-10
Fixing dependency issues during installation of SQL Server Tools on Red Hat Linux Server SQL Server on Linux2017-02-01
Installing SQL Server Tools to make a Database Connection from Redhat Linux Server SQL Server on Linux2017-01-25
Installing SQL Server vNext CTP1 on Red Hat Linux 7.2 SQL Server on Linux2017-01-16
Removing a Secondary Replica from a SQL Server AlwaysON Availability Group Availability Groups2017-01-05
Add secondary replica to existing SQL Server AlwaysON Availability Group Availability Groups2016-12-26
SQL Server Always On Availability Group on Multi-Subnet Cluster Availability Groups2016-12-16
Wait on the Database Engine recovery handle failed Install and Uninstall2016-11-24
Wait on the Database Engine Recovery Handle Failed SQL Server Installation Error Install and Uninstall2016-11-18
SQL Server error Wait on the Database Engine Recovery Handle Failed Install and Uninstall2016-10-31
Rename SQL Server physical database files using T-SQL Database Administration2016-09-26
Rename SQL Server physical database files using detach and attach Database Administration2016-09-12
Rename logical database file name for a SQL Server database Database Administration2016-08-16
How to remove a SQL Server Data file for a multi-data file database Database Administration2016-08-04
Move SQL Server data between data files in a single filegroup Database Administration2016-07-11
Understanding how SQL Server stores data in data files Database Administration2016-07-06
SQL Server Setup Error – There was an error generating the XML document. Error code 0x84B10001. Install and Uninstall2016-05-31
How to Remove SQL Server witness server from an existing Database Mirroring Configuration Database Mirroring2016-05-25
Change SQL Server Database Mirroring from Manual to Automatic Failover Database Mirroring2016-05-12
How to Remove Node from a SQL Server Failover Cluster Clustering2016-05-03
Change the Virtual IP Address for a SQL Server Failover Cluster Clustering2016-04-14
How to rename the SQL Server Network Name of a failover cluster Clustering2016-04-05
Step by Step Installation of Adding a New Node to a SQL Server 2014 Failover Cluster Clustering2016-03-22
Step by Step Installation of SQL Server 2014 on a New Failover Cluster Clustering2016-03-14
Validating a Windows Cluster Prior to Installing SQL Server 2014 Clustering2016-03-10
Understanding the SSIS Catalog and creating the SSISDB Catalog Integration Services Configuration Options2015-11-24
Fix invalid object name master.dbo.spt_values when viewing SQL Server database properties SQL Server Management Studio2015-08-12
Change operating modes for SQL Server Database Mirroring Database Mirroring2015-07-24
Temporarily Change SQL Server Log Shipping Database to Read Only Log Shipping2015-07-01
Steps to Recover the system_health Extended Events Session in SQL Server Extended Events2015-06-23
How to Modify SQL Server Database Mail Accounts Database Mail2015-06-17
Change Restore Mode of Secondary SQL Server Database in Log Shipping Log Shipping2015-05-05
Change SQL Server Log Shipped Database to Standby Read-Only Log Shipping2015-05-01
Assign Colors in SQL Server Management Studio Query Windows Based on Environment SQL Server Management Studio2015-04-15
Read SQL Server Transaction Log Backups to Find When Transactions Occurred Database Administration2015-04-14
Grant Permissions for SQL Server Profiler for non System Admin User Profiler and Trace2015-03-20
Fixing SQL Server fatal error 4014 Error Logs2015-03-05
Recover Deleted SQL Server Data and Tables with Transaction Log Database Administration2014-02-10
Find user who ran DROP or DELETE statements in SQL Server Database Administration2013-12-02
How to Change the SQL Server Agent Log File Path SQL Server Agent2013-11-05
How to hide SQL Server user databases in SQL Server Management Studio SQL Server Management Studio Configuration2013-08-14
How to change server level collation for a SQL Server Instance SQL Server Configurations2013-07-08
Handling Windows Processes using Windows PowerShell for SQL Server PowerShell2013-07-01
Controlling Windows and SQL Server Services using Windows PowerShell PowerShell2013-05-29
Using PowerShell to access event logs for SQL Server PowerShell2013-04-30
How to allow Ad hoc updates in SQL Server system catalogs SQL Server Configurations2013-02-11
How to add a database file to a mirrored SQL Server database Database Mirroring2013-01-11
Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues Performance Tuning2013-01-04
How to add database file to a Log Shipped database in SQL Server Log Shipping2012-12-10
Index Create Memory Setting for SQL Server Indexing2012-12-05
How to Add SSRS to Existing SQL Server Clustered Instance Reporting Services Installation2012-10-03
Identify blank and weak passwords for SQL Server logins Security2012-09-26
Find out which SQL Server instance is consuming most of the CPU Performance Tuning2012-09-17
How to start SQL Server Agent when Agent XPs show disabled SQL Server Agent2012-07-12
How to revert a Database Snapshot to recover a SQL Server database Restore2012-06-25
How to move database files of a Mirrored SQL Server Database Database Mirroring2012-05-30
How to connect to SQL Server if you are completely locked out Security2012-04-26
Database Attach Failure in SQL Server 2008 R2 Database Administration2012-02-24
SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule Upgrades and Migrations2012-02-16
Enable PowerShell on Windows Server 2008 R2 Core Edition PowerShell2011-12-19
Enable Powershell Remoting on SQL Server Instances PowerShell2011-12-01
Property Owner Not Available for Database Error in SQL Server Management Studio SQL Server Management Studio2011-08-17
How to find out how much CPU a SQL Server process is really using Performance Tuning2011-08-09
Error running the SQL Server Database Tuning Advisor for non SA users Performance Tuning2011-07-08
SQL Server Configuration Manager Cannot Connect to WMI Provider Install and Uninstall2011-06-08