Manvendra Singh

Manvendra Singh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc.

Manvendra is a passionate database lover currently working as a Technical Architect at one of the top MNCs. He has extensive experience onall versions of SQL Server since 2000 andhas 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.
2021 Awards

2018 Awards

2017 Awards

2016 Awards

2015 Awards

2013 Awards

CategoryTitle
Availability GroupsAdd a SQL Server Database to an Existing Always On Availability Group
Availability GroupsAdd secondary replica to existing SQL Server AlwaysON Availability Group
Availability GroupsAdding a Database to an existing SQL Server Always ON Configuration
Availability GroupsConfigure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster
Availability GroupsFix SQL Server AlwaysOn Availability Group Error: 1408 Joining database on secondary replica resulted in an error
Availability GroupsFix SQL Server AlwaysOn Error: 35250 Failed to Join the Availability Group
Availability GroupsFixing Error 19405 When Configuring SQL Server Availability Groups
Availability GroupsHow to Configure Always ON Availability Groups between Two SQL Server Failover Cluster Instances - Part 1
Availability GroupsHow to Join a Secondary SQL Server Database to an AlwaysON Availability Group
Availability GroupsMulti-Site Multi-Cluster SQL Server Installation with Clustering and Availability Groups
Availability GroupsRemove Database from SQL Server AlwaysON Availability Group Secondary Replica
Availability GroupsRemove SQL Server AlwaysOn Availability Group Configuration
Availability GroupsRemove SQL Server AlwaysOn Database from Primary Replica
Availability GroupsRemoving a Secondary Replica from a SQL Server AlwaysON Availability Group
ClusteringChange the Virtual IP Address for a SQL Server Failover Cluster
ClusteringHow to Remove Node from a SQL Server Failover Cluster
ClusteringHow to rename the SQL Server Network Name of a failover cluster
ClusteringStep by Step Installation of Adding a New Node to a SQL Server 2014 Failover Cluster
ClusteringStep by Step Installation of SQL Server 2014 on a New Failover Cluster
ClusteringValidating a Windows Cluster Prior to Installing SQL Server 2014
Database AdministrationDatabase Attach Failure in SQL Server 2008 R2
Database AdministrationHow to find user who ran DROP or DELETE statements on your SQL Server Objects
Database AdministrationHow to read the SQL Server Database Transaction Log
Database AdministrationHow to remove a SQL Server Data file for a multi-data file database
Database AdministrationMove SQL Server data between data files in a single filegroup
Database AdministrationRead SQL Server Transaction Log Backups to Find When Transactions Occurred
Database AdministrationRecover deleted SQL Server data and tables with the help of Transaction Log and LSNs
Database AdministrationRename logical database file name for a SQL Server database
Database AdministrationRename SQL Server physical database file names using detach and attach method
Database AdministrationRename SQL Server physical database files using T-SQL
Database AdministrationRenaming Physical Database File Names for a SQL Server Database
Database AdministrationTroubleshooting SQL Server Starting in Single User Mode
Database AdministrationUnderstanding how SQL Server stores data in data files
Database MailHow to Modify SQL Server Database Mail Accounts
Database MirroringChange operating modes for SQL Server Database Mirroring
Database MirroringChange SQL Server Database Mirroring from Manual to Automatic Failover
Database MirroringHow to add a database file to a mirrored SQL Server database
Database MirroringHow to move database files of a Mirrored SQL Server Database
Database MirroringHow to Remove SQL Server witness server from an existing Database Mirroring Configuration
DatesGetting Started with SQL DATEDIFF and DATEDIFF_BIG Functions with Use Cases
DatesUnderstanding the DATEADD SQL Function and its use cases
Error LogsFixing SQL Server fatal error 4014
Extended EventsSteps to Recover the system_health Extended Events Session in SQL Server
Full Text SearchHow to Enable and Disable Full Text Search for SQL Server Databases
Full Text SearchStep by Step Process to Add Full Text Search on SQL Server 2019
Full Text SearchUnderstanding SQL Server Full Text Search
Functions SystemGetting started with SQL MAX Function with Use Cases
Functions SystemSQL Server SERVERPROPERTY() Use Cases
IndexingIndex Create Memory Setting for SQL Server
IndexingINDEXPROPERTY Function in SQL Server
Install and UninstallFix SQL Server Installation issue Wait on the Database Engine recovery handle failed with Single User Mode Login Option
Install and UninstallFixing SQL Server Installation Error 1639
Install and UninstallHow to Fix SQL Server Uninstallation Error Could Not Open Key
Install and UninstallSQL Server Configuration Manager Cannot Connect to WMI Provider
Install and UninstallSQL Server install error Wait on the Database Engine Recovery Handle Failed
Install and UninstallSQL Server Setup Error - There was an error generating the XML document. Error code 0x84B10001.
Install and UninstallStep by Step Installation of Microsoft Azure Data Studio on Windows Machine
Install and UninstallStep by Step Installation of SQL Server Management Studio 18.6
Install and UninstallWait on the Database Engine Recovery Handle Failed SQL Server Installation Error
Integration Services Configuration OptionsUnderstanding the SQL Server Integration Services Catalog and creating the SSISDB Catalog
Log ShippingChange SQL Server log shipped database from Restoring to Standby Read-Only
Log ShippingChange the restore mode of a secondary SQL Server database in Log shipping with SSMS
Log ShippingHow to add database file to a Log Shipped database in SQL Server
Log ShippingTemporarily Change SQL Server Log Shipping Database to Read Only
Other Database PlatformsHow to Convert Database Objects from Oracle to SQL Server using SQL Server Migration Assistant for Oracle Part 2
Other Database PlatformsHow to Install SQL Server Migration Assistant for Oracle Part 1
Other Database PlatformsHow to Install SQL Server Migration Assistant for Oracle Extension Pack Part 2
Other Database PlatformsHow to Migrate an Oracle Database to SQL Server using SQL Server Migration Assistant for Oracle - Part 1
Other Database PlatformsLoad Database Objects for Conversion from Oracle to SQL Server using SQL Server Migration Assistant - Part 3
Other Database PlatformsMigrate Data from Oracle to SQL Server with SQL Server Migration Assistant - Part 4
Performance TuningDatabase Cloning in SQL Server for Troubleshooting and Diagnostics
Performance TuningError running the SQL Server Database Tuning Advisor for non SA users
Performance TuningFind out which SQL Server instance is consuming most of the CPU
Performance TuningHow to find out how much CPU a SQL Server process is really using
Performance TuningTroubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues
PowerShellControlling Windows and SQL Server Services using Windows PowerShell
PowerShellEnable PowerShell on Windows Server 2008 R2 Core Edition
PowerShellEnable Powershell Remoting on SQL Server Instances
PowerShellHandling Windows Processes using Windows PowerShell for SQL Server
PowerShellUsing PowerShell to access event logs for SQL Server
Professional Development Interview Questions DBASQL Server AlwaysOn Interview Questions and Answers - Part 1
Professional Development Interview Questions DBASQL Server AlwaysOn Interview Questions and Answers Part 2
Professional Development Interview Questions DBASQL Server Replication Interview Questions and Answers
Profiler and TraceHow to Grant Permissions to run SQL Server Profiler for a non System Admin User
ReplicationHow to Fix Tracer Token warnings in SQL Server Replication Monitor
Reporting Services InstallationHow to add Reporting Services to an existing SQL Server Clustered Instance
RestoreHow to revert a Database Snapshot to recover a SQL Server database
SecurityAn Overview of System Function LOGINPROPERTY for SQL Login Details
SecurityHow to Assign Ownership to Various Database Objects using ALTER Authorization T-SQL Statement
SecurityHow to connect to SQL Server if you are completely locked out
SecurityIdentify blank and weak passwords for SQL Server logins
SecurityList SQL Server Login and User Permissions with fn_my_permissions
SQL Server 2019How to Enable and Disable Hybrid Buffer Pool for SQL Server Databases
SQL Server 2019Understanding Hybrid Buffer Pool in SQL Server 2019
SQL Server AgentHow to Change the SQL Server Agent Log File Path
SQL Server AgentHow to start SQL Server Agent when Agent XPs show disabled
SQL Server Configurations6 Ways to Get SQL Server Versions
SQL Server ConfigurationsHow to allow Ad hoc updates in SQL Server system catalogs
SQL Server ConfigurationsHow to change server level collation for a SQL Server Instance
SQL Server ConfigurationsLock Pages in Memory for SQL Server on Windows
SQL Server Management StudioAssign Colors in SQL Server Management Studio Query Windows Based on Environment
SQL Server Management StudioFix invalid object name master.dbo.spt_values when viewing SQL Server database properties
SQL Server Management StudioHow to Install SQL Server Management Studio to Access SQL Server Databases
SQL Server Management StudioHow to Upgrade SQL Server Management Studio and Azure Data Studio
SQL Server Management StudioProperty Owner is not available for Database SSMS error
SQL Server Management StudioSQL Server Management Studio Template Explorer
SQL Server Management Studio ConfigurationHow to hide SQL Server user databases in SQL Server Management Studio
SQL Server on LinuxEnable and Disable SQL Server Trace Flags on a Linux Server
SQL Server on LinuxFixing dependency issues during installation of SQL Server Tools on Red Hat Linux Server
SQL Server on LinuxFixing error Failed to mount cd: devices when installing SQL Server tools on SUSE Linux Server
SQL Server on LinuxHow to Change Default Data and Log file directory for SQL Server running on Linux
SQL Server on LinuxHow to Change Hostname of Various Linux Systems
SQL Server on LinuxHow to Change SQL Server Instance Name Running on a Linux Server
SQL Server on LinuxHow to Change SQL Server Port Number for a Linux Server
SQL Server on LinuxHow to change the Default Dump File location of SQL Server running on Linux Server
SQL Server on LinuxHow to create SQL Server Agent Jobs on a Linux based instance using Management Studio
SQL Server on LinuxHow to Enable and Configure SQL Server Agent for SQL Server 2019 on RHEL 8.1
SQL Server on LinuxHow to schedule a SQL Server Agent Job on a Linux based instance using T-SQL
SQL Server on LinuxHow to Uninstall SQL Server 2017 running on Ubuntu
SQL Server on LinuxHow to Uninstall SQL Server vNext from a Linux Server
SQL Server on LinuxInstall SQL Server Tools to Establish a Database Connection from an Ubuntu Server
SQL Server on LinuxInstalling SQL Server Agent on Red Hat Linux based SQL Servers
SQL Server on LinuxInstalling SQL Server Agent on SUSE Linux
SQL Server on LinuxInstalling SQL Server Agent on Ubuntu Server
SQL Server on LinuxInstalling SQL Server Tools on SUSE Linux
SQL Server on LinuxInstalling SQL Server Tools to make a Database Connection from Redhat Linux Server
SQL Server on LinuxInstalling SQL Server vNext CTP1 on Red Hat Linux 7.2
SQL Server on LinuxInstalling SQL Server vNext on SUSE Linux Server
SQL Server on LinuxInstalling SQL Server vNext on Ubuntu
SQL Server on LinuxRemove SQL Tools sqlcmd and bcp from Ubuntu Linux Server
SQL Server on LinuxRenaming a Red Hat Linux System Hostname for SQL Server
SQL Server on LinuxRestore a SQL Server database on a Linux based instance from a backup on a Windows instance
SQL Server on LinuxUpgrading SQL Server running on Ubuntu to latest update
SQL Server on LinuxUpgrading SQL Server vNext on Red Hat Linux to latest available update
SQL Server on LinuxUse SSMS to Restore a SQL Server database on a Linux based instance from a backup on a Windows instance
TestingAdventureWorks Database Installation Steps
Upgrades and MigrationsSQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule
VirtualizationBuild Virtual Machine using VMware Workstation Pro
VirtualizationCreate VMware Virtual Machine for Red Hat Enterprise Linux
VirtualizationHow to Configure Repositories for Installing and Upgrading SQL Server on RHEL Virtual Machine
VirtualizationHow to Install Python2 and Openssl1.0 on RHEL 8.1
VirtualizationHow to Install SQL Server Command Line Tools SQLCMD and BCP on RHEL 8.1
VirtualizationHow to Register a Virtual Machine to RedHat Subscription Management
VirtualizationHow to Setup a Virtual Machine with VMware Workstation 14
VirtualizationInstall VMware Workstation 14 on Windows
VirtualizationInstall VMware Workstation Pro for SQL Server
VirtualizationStep by Step Installation of SQL Server 2019 on Windows Server 2016 in VMware
VirtualizationStep by Step Installation of Windows Server 2016 on a Virtual Machine
VirtualizationStep by Step Process to Install SQL Server 2019 on RHEL 8.1
No Records Found
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (23)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (45)
CloudApache Spark (3)
CloudAzure (187)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (11)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (33)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (72)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (21)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (188)
Database AdministrationDatabase Configurations (17)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (10)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (66)
Database AdministrationPartitioning (14)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (121)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (126)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (40)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (2)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (14)
Database DevelopmentCommon Runtime Language (12)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (68)
Database DevelopmentDates (47)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (20)
Database DevelopmentFunctions System (64)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (73)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (39)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (36)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (27)
Database DevelopmentSynonyms (4)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (8)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (294)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (10)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (106)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (128)
Power PlatformPower BI Charts (44)
Power PlatformPower BI Formatting (12)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (22)
Professional DevelopmentProfessional Development Interview Questions Developer (6)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (28)
SecuritySecurity (194)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (10)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (92)
ToolsSQL Server Management Studio (74)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (31)