Get Free Tips
MSSQLTips.com

Author: Manvendra Singh

Home » Archives for 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

TitleCategoryDate
Enable and Disable Full Text Search for SQL Server DatabasesFull Text Search2025-06-18
Renaming Physical Database File Names for a SQL Server DatabaseDatabase Administration2025-06-15
SQL Server Login and User Permissions with fn_my_permissionsSecurity2025-05-27
How to read the SQL Server Database Transaction LogDatabase Administration2025-01-20
Add Full Text Search on SQL ServerFull Text Search2025-01-14
Database Cloning in SQL Server for Troubleshooting and DiagnosticsPerformance Tuning2024-12-29
Azure SQL Database Change Primary Region for Failover GroupAzure SQL Database2023-06-05
Azure SQL Database Change Secondary Region for Failover GroupAzure SQL Database2023-05-11
Remove a SQL Database from an Azure Failover GroupAzure SQL Database2023-05-02
How to add an Azure SQL Database to an existing Auto-Failover GroupAzure SQL Database2023-04-17
How To Configure Azure SQL Auto Failover GroupsAzure SQL Database2022-12-05
Setup and Configure a Failover Database for Azure SQL DatabaseAzure SQL Database2022-11-30
SQL Server OBJECTPROPERTY Function ExamplesFunctions System2022-09-30
Add a Column in a Table in SQLDatabase Design2022-09-26
Metadata Functions in SQL Server SERVERPROPERTY, DB_NAME, OBJECT_IDFunctions System2022-08-19
Find All Securable Objects in SQL Server and PermissionsSecurity2022-08-02
SQL Server Collation Settings Instance, Database and Column LevelsDatabase Configurations2022-07-25
SQL COUNT and SQL COUNT_BIG FunctionsFunctions System2022-07-13
SQL Server Configuration FunctionsFunctions System2022-07-06
SQL Average Function to Calculate Average of a set of SQL Server RowsFunctions System2022-06-22
SQL MAX Examples and Use CasesFunctions System2022-05-05
DATEADD SQL Function to Add and Subtract Dates and TimesDates2022-04-26
SQL DATEDIFF and DATEDIFF_BIG Functions with Sample CodeDates2022-04-11
SQL Login Details with SQL LOGINPROPERTY FunctionSecurity2022-01-28
Change the host name for Linux server on Red Hat, SuSE or UbuntuSQL Server on Linux2021-12-15
SQL Server Agent for SQL Server 2019 on Redhat LinuxSQL Server on Linux2021-12-02
Install SQLCMD and BCP for SQL Server on Redhat LinuxVirtualization2021-11-23
Install SQL Server 2019 on Red Hat LinuxVirtualization2021-11-17
Install Python and Openssl on Red Hat LinuxVirtualization2021-10-29
Repositories to install SQL Server on Red Hat Linux Virtual MachineVirtualization2021-10-21
Configure Red Hat Subscription Management on VMware Virtual MachineVirtualization2021-10-14
Build Virtual Machine for Red Hat Enterprise Linux on VMwareVirtualization2021-10-07
Create a New Virtual Machine for VMware Workstation ProVirtualization2021-09-29
VMware Workstation Pro InstallationVirtualization2021-09-28
SQL Server 2019 Hybrid Buffer Pool Enable and DisableSQL Server 20192021-08-24
SQL Server 2019 Hybrid Buffer PoolSQL Server 20192021-07-26
Lock Pages in Memory for SQL Server on WindowsSQL Server Configurations2021-07-19
6 Ways to Get SQL Server VersionsSQL Server Configurations2021-07-07
AdventureWorks Database Installation StepsTesting2021-06-18
How to Upgrade SQL Server Management Studio and Azure Data StudioSQL Server Management Studio2021-06-10
Understanding SQL Server Full Text SearchFull Text Search2021-05-27
SQL Server Management Studio Template ExplorerSQL Server Management Studio2021-05-18
INDEXPROPERTY Function in SQL ServerIndexing2021-05-13
SQL Server SERVERPROPERTY() Use CasesFunctions System2021-04-30
SQL ALTER Authorization ExamplesSecurity2021-04-29
Multi-Site SQL Server Always On Availability GroupsAvailability Groups2021-03-30
Configure Always ON Availability Groups between Two SQL Server FCIsAvailability Groups2021-03-22
Fix Tracer Tokens in SQL ReplicationReplication2021-03-11
Azure Data Studio InstallationInstall and Uninstall2021-02-10
Install SQL Server Management Studio 18.6Install and Uninstall2021-02-09
Install SQL Server 2019 on Windows Server 2016 in VMwareVirtualization2021-02-04
Install Windows Server 2016 on VMware WorkstationVirtualization2021-02-03
How to Setup a Virtual Machine with VMware Workstation 14Virtualization2021-02-01
Install VMware Workstation 14 on WindowsVirtualization2021-01-19
Install SQL Server Management StudioSQL Server Management Studio2020-12-17
SQL Server Uninstallation Error Could Not Open KeyInstall and Uninstall2020-12-02
SQL Server Single User Mode TroubleshootingDatabase Administration2020-11-16
Migrate Data from Oracle to SQL Server with SSMASQL Server and Oracle Comparison2020-11-06
Oracle to SQL Server Migration Load Database ObjectsSQL Server and Oracle Comparison2020-10-23
Oracle to SQL Server Migration Convert Database ObjectsSQL Server and Oracle Comparison2020-10-13
Oracle to SQL Server Migration with SQL Server Migration AssistantSQL Server and Oracle Comparison2020-09-30
SQL Server AlwaysOn Interview Questions and Answers – Part 2Professional Development Interview Questions DBA2018-12-07
SQL Server AlwaysOn Interview Questions and Answers – Part 1Professional Development Interview Questions DBA2018-11-22
SQL Server Replication Interview Questions and AnswersProfessional Development Interview Questions DBA2018-07-09
Install SQL Server Migration Assistant for Oracle Extension PackSQL Server and Oracle Comparison2018-06-25
How to Install SQL Server Migration Assistant for Oracle – Part 1SQL Server and Oracle Comparison2018-06-13
How to Change SQL Server Instance Name Running on a Linux ServerSQL Server on Linux2018-05-25
Adding a Database to an existing SQL Server Always ON ConfigurationAvailability Groups2018-05-03
Remove SQL Tools sqlcmd and bcp from Ubuntu Linux ServerSQL Server on Linux2018-04-11
Fixing SQL Server Installation Error 1639Install and Uninstall2018-03-23
How to Uninstall SQL Server 2017 running on UbuntuSQL Server on Linux2018-03-02
Renaming a Red Hat Linux System Hostname for SQL ServerSQL Server on Linux2018-02-14
Fixing Error 19405 When Configuring SQL Server Availability GroupsAvailability Groups2018-02-05
Add a SQL Server Database to an Existing Always On Availability GroupAvailability Groups2018-01-16
Join a Secondary SQL Server Database to an AlwaysON Availability GroupAvailability Groups2017-10-24
Remove SQL Server AlwaysOn Database from Primary ReplicaAvailability Groups2017-10-11
Remove Database from SQL AlwaysON Availability Group Secondary ReplicaAvailability Groups2017-09-26
Fixing error Failed to mount cd: devices when installing SQL Server tools on SUSE Linux ServerSQL Server on Linux2017-09-11
Installing SQL Server Tools on SUSE LinuxSQL Server on Linux2017-08-09
Installing SQL Server Agent on SUSE LinuxSQL Server on Linux2017-08-02
Installing SQL Server Agent on Red Hat Linux based SQL ServersSQL Server on Linux2017-07-17
How to create SQL Server Agent Jobs on a Linux based instance using Management StudioSQL Server on Linux2017-07-12
How to change the Default Dump File location of SQL Server running on Linux ServerSQL Server on Linux2017-07-03
Error 1408 Joining database on secondary replica resulted in an errorAvailability Groups2017-06-28
Enable and Disable SQL Server Trace Flags on a Linux ServerSQL Server on Linux2017-06-19
Installing SQL Server vNext on SUSE Linux ServerSQL Server on Linux2017-06-05
How to Change SQL Server Port Number for a Linux ServerSQL Server on Linux2017-05-22
Schedule SQL Server Agent Job on a Linux based instance using T-SQLSQL Server on Linux2017-05-17
How to Uninstall SQL Server vNext from a Linux ServerSQL Server on Linux2017-05-08
Installing SQL Server Agent on Ubuntu ServerSQL Server on Linux2017-04-25
Upgrading SQL Server running on Ubuntu to latest updateSQL Server on Linux2017-04-19
Fix SQL Server AlwaysOn Error: 35250 Failed to Join the Availability GroupAvailability Groups2017-04-05
Remove SQL Server AlwaysOn Availability Group ConfigurationAvailability Groups2017-03-28
Restore SQL Server database on Linux from backup on WindowsSQL Server on Linux2017-03-24
How to Change Default Data and Log file directory for SQL Server running on LinuxSQL Server on Linux2017-03-17
Upgrading SQL Server vNext on Red Hat Linux to latest available updateSQL Server on Linux2017-03-13
Restore a SQL Server database on a Linux based instance from a backup on a Windows instanceSQL Server on Linux2017-03-01
Install SQL Server Tools to Establish a Database Connection from an Ubuntu ServerSQL Server on Linux2017-02-15
Installing SQL Server vNext on UbuntuSQL Server on Linux2017-02-10
Fixing dependency issues during installation of SQL Server Tools on Red Hat Linux ServerSQL Server on Linux2017-02-01
Installing SQL Server Tools to make a Database Connection from Redhat Linux ServerSQL Server on Linux2017-01-25
Installing SQL Server vNext CTP1 on Red Hat Linux 7.2SQL Server on Linux2017-01-16
Removing a Secondary Replica from a SQL Server AlwaysON Availability GroupAvailability Groups2017-01-05
Add secondary replica to existing SQL Server AlwaysON Availability GroupAvailability Groups2016-12-26
SQL Server Always On Availability Group on Multi-Subnet ClusterAvailability Groups2016-12-16
Wait on the Database Engine recovery handle failedInstall and Uninstall2016-11-24
Wait on the Database Engine Recovery Handle Failed SQL Server Installation ErrorInstall and Uninstall2016-11-18
SQL Server error Wait on the Database Engine Recovery Handle FailedInstall and Uninstall2016-10-31
Rename SQL Server physical database files using T-SQLDatabase Administration2016-09-26
Rename SQL Server physical database files using detach and attachDatabase Administration2016-09-12
Rename logical database file name for a SQL Server databaseDatabase Administration2016-08-16
How to remove a SQL Server Data file for a multi-data file databaseDatabase Administration2016-08-04
Move SQL Server data between data files in a single filegroupDatabase Administration2016-07-11
Understanding how SQL Server stores data in data filesDatabase 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 ConfigurationDatabase Mirroring2016-05-25
Change SQL Server Database Mirroring from Manual to Automatic FailoverDatabase Mirroring2016-05-12
How to Remove Node from a SQL Server Failover ClusterClustering2016-05-03
Change the Virtual IP Address for a SQL Server Failover ClusterClustering2016-04-14
How to rename the SQL Server Network Name of a failover clusterClustering2016-04-05
Step by Step Installation of Adding a New Node to a SQL Server 2014 Failover ClusterClustering2016-03-22
Step by Step Installation of SQL Server 2014 on a New Failover ClusterClustering2016-03-14
Validating a Windows Cluster Prior to Installing SQL Server 2014Clustering2016-03-10
Understanding the SSIS Catalog and creating the SSISDB CatalogIntegration Services Configuration Options2015-11-24
Fix invalid object name master.dbo.spt_values when viewing SQL Server database propertiesSQL Server Management Studio2015-08-12
Change operating modes for SQL Server Database MirroringDatabase Mirroring2015-07-24
Temporarily Change SQL Server Log Shipping Database to Read OnlyLog Shipping2015-07-01
Steps to Recover the system_health Extended Events Session in SQL ServerExtended Events2015-06-23
How to Modify SQL Server Database Mail AccountsDatabase Mail2015-06-17
Change Restore Mode of Secondary SQL Server Database in Log ShippingLog Shipping2015-05-05
Change SQL Server Log Shipped Database to Standby Read-OnlyLog Shipping2015-05-01
Assign Colors in SQL Server Management Studio Query Windows Based on EnvironmentSQL Server Management Studio2015-04-15
Read SQL Server Transaction Log Backups to Find When Transactions OccurredDatabase Administration2015-04-14
Grant Permissions for SQL Server Profiler for non System Admin UserProfiler and Trace2015-03-20
Fixing SQL Server fatal error 4014Error Logs2015-03-05
Recover Deleted SQL Server Data and Tables with Transaction LogDatabase Administration2014-02-10
Find user who ran DROP or DELETE statements in SQL ServerDatabase Administration2013-12-02
How to Change the SQL Server Agent Log File PathSQL Server Agent2013-11-05
How to hide SQL Server user databases in SQL Server Management StudioSQL Server Management Studio Configuration2013-08-14
How to change server level collation for a SQL Server InstanceSQL Server Configurations2013-07-08
Handling Windows Processes using Windows PowerShell for SQL ServerPowerShell2013-07-01
Controlling Windows and SQL Server Services using Windows PowerShellPowerShell2013-05-29
Using PowerShell to access event logs for SQL ServerPowerShell2013-04-30
How to allow Ad hoc updates in SQL Server system catalogsSQL Server Configurations2013-02-11
How to add a database file to a mirrored SQL Server databaseDatabase Mirroring2013-01-11
Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory IssuesPerformance Tuning2013-01-04
How to add database file to a Log Shipped database in SQL ServerLog Shipping2012-12-10
Index Create Memory Setting for SQL ServerIndexing2012-12-05
How to Add SSRS to Existing SQL Server Clustered InstanceReporting Services Installation2012-10-03
Identify blank and weak passwords for SQL Server loginsSecurity2012-09-26
Find out which SQL Server instance is consuming most of the CPUPerformance Tuning2012-09-17
How to start SQL Server Agent when Agent XPs show disabledSQL Server Agent2012-07-12
How to revert a Database Snapshot to recover a SQL Server databaseRestore2012-06-25
How to move database files of a Mirrored SQL Server DatabaseDatabase Mirroring2012-05-30
How to connect to SQL Server if you are completely locked outSecurity2012-04-26
Database Attach Failure in SQL Server 2008 R2Database Administration2012-02-24
SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade ruleUpgrades and Migrations2012-02-16
Enable PowerShell on Windows Server 2008 R2 Core EditionPowerShell2011-12-19
Enable Powershell Remoting on SQL Server InstancesPowerShell2011-12-01
Property Owner Not Available for Database Error in SQL Server Management StudioSQL Server Management Studio2011-08-17
How to find out how much CPU a SQL Server process is really usingPerformance Tuning2011-08-09
Error running the SQL Server Database Tuning Advisor for non SA usersPerformance Tuning2011-07-08
SQL Server Configuration Manager Cannot Connect to WMI ProviderInstall and Uninstall2011-06-08

Categories

Recent Articles

  • SQL Server Transaction Log

  • 10 New Features in SQL Server 2025

  • Elevate Your ETL: Seamlessly Integrate Melissa’s SSIS Data Quality Tools with Azure Data Factory

  • Database Modernization with AI-Powered Tools

  • Optimizing SQL Server Integration: Automated Data Movement for Analytics and Operations

mssqltips white logo

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
Facebook X-twitter Rss Envelope Linkedin
Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide