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.

2022 Awards   

2021 Awards   

2018 Awards      

2017 Awards      

2016 Awards      

2015 Awards   

2013 Awards   

Category	Tip Title
Availability Groups	Add a SQL Server Database to an Existing Always On Availability Group
Availability Groups	Add secondary replica to existing SQL Server AlwaysON Availability Group
Availability Groups	Adding a Database to an existing SQL Server Always ON Configuration
Availability Groups	Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster
Availability Groups	Fix SQL Server AlwaysOn Availability Group Error: 1408 Joining database on secondary replica resulted in an error
Availability Groups	Fix SQL Server AlwaysOn Error: 35250 Failed to Join the Availability Group
Availability Groups	Fixing Error 19405 When Configuring SQL Server Availability Groups
Availability Groups	How to Configure Always ON Availability Groups between Two SQL Server Failover Cluster Instances - Part 1
Availability Groups	How to Join a Secondary SQL Server Database to an AlwaysON Availability Group
Availability Groups	Multi-Site Multi-Cluster SQL Server Installation with Clustering and Availability Groups
Availability Groups	Remove Database from SQL Server AlwaysON Availability Group Secondary Replica
Availability Groups	Remove SQL Server AlwaysOn Availability Group Configuration
Availability Groups	Remove SQL Server AlwaysOn Database from Primary Replica
Availability Groups	Removing a Secondary Replica from a SQL Server AlwaysON Availability Group
Azure SQL Database	Add Azure SQL databases to existing auto-failover group
Azure SQL Database	Change Primary Region for Azure SQL Database Failover Group
Azure SQL Database	Change Secondary Region of a Failover Group for Azure SQL Database
Azure SQL Database	Configure Active Geo Replication for Azure SQL Database
Azure SQL Database	Configure Auto-Failover Group for Azure SQL Database and Azure SQL Managed Instances for SQL Server
Azure SQL Database	Remove Azure SQL Databases from a Failover Group and Remove Geo-Replication
Clustering	Change the Virtual IP Address for a SQL Server Failover Cluster
Clustering	How to Remove Node from a SQL Server Failover Cluster
Clustering	How to rename the SQL Server Network Name of a failover cluster
Clustering	Step by Step Installation of Adding a New Node to a SQL Server 2014 Failover Cluster
Clustering	Step by Step Installation of SQL Server 2014 on a New Failover Cluster
Clustering	Validating a Windows Cluster Prior to Installing SQL Server 2014
Database Administration	Database Attach Failure in SQL Server 2008 R2
Database Administration	How to find user who ran DROP or DELETE statements on your SQL Server Objects
Database Administration	How to read the SQL Server Database Transaction Log
Database Administration	How to remove a SQL Server Data file for a multi-data file database
Database Administration	Move SQL Server data between data files in a single filegroup
Database Administration	Read SQL Server Transaction Log Backups to Find When Transactions Occurred
Database Administration	Recover deleted SQL Server data and tables with the help of Transaction Log and LSNs
Database Administration	Rename logical database file name for a SQL Server database
Database Administration	Rename SQL Server physical database file names using detach and attach method
Database Administration	Rename SQL Server physical database files using T-SQL
Database Administration	Renaming Physical Database File Names for a SQL Server Database
Database Administration	Troubleshooting SQL Server Starting in Single User Mode
Database Administration	Understanding how SQL Server stores data in data files
Database Configurations	SQL Server Collation Properties using the COLLATIONPROPERTY Function
Database Design	How to Add a Column to a SQL Server Table
Database Mail	How to Modify SQL Server Database Mail Accounts
Database Mirroring	Change operating modes for SQL Server Database Mirroring
Database Mirroring	Change SQL Server Database Mirroring from Manual to Automatic Failover
Database Mirroring	How to add a database file to a mirrored SQL Server database
Database Mirroring	How to move database files of a Mirrored SQL Server Database
Database Mirroring	How to Remove SQL Server witness server from an existing Database Mirroring Configuration
Dates	Getting Started with SQL DATEDIFF and DATEDIFF_BIG Functions with Use Cases
Dates	Understanding the DATEADD SQL Function and its use cases
Error Logs	Fixing SQL Server fatal error 4014
Extended Events	Steps to Recover the system_health Extended Events Session in SQL Server
Full Text Search	How to Enable and Disable Full Text Search for SQL Server Databases
Full Text Search	Step by Step Process to Add Full Text Search on SQL Server 2019
Full Text Search	Understanding SQL Server Full Text Search
Functions System	5 use cases of SQL Average
Functions System	Getting started with SQL MAX Function with Use Cases
Functions System	Getting Starting with SQL COUNT() and COUNT_BIG() Functions
Functions System	Metadata Functions in SQL Server and Their Use Cases
Functions System	SQL Server Database Object Properties using OBJECTPROPERTY Function
Functions System	SQL Server SERVERPROPERTY() Use Cases
Functions System	Understanding SQL Server T-SQL Configuration Functions
Indexing	Index Create Memory Setting for SQL Server
Indexing	INDEXPROPERTY Function in SQL Server
Install and Uninstall	Fix SQL Server Installation issue Wait on the Database Engine recovery handle failed with Single User Mode Login Option
Install and Uninstall	Fixing SQL Server Installation Error 1639
Install and Uninstall	How to Fix SQL Server Uninstallation Error Could Not Open Key
Install and Uninstall	SQL Server Configuration Manager Cannot Connect to WMI Provider
Install and Uninstall	SQL Server install error Wait on the Database Engine Recovery Handle Failed
Install and Uninstall	SQL Server Setup Error - There was an error generating the XML document. Error code 0x84B10001.
Install and Uninstall	Step by Step Installation of Microsoft Azure Data Studio on Windows Machine
Install and Uninstall	Step by Step Installation of SQL Server Management Studio 18.6
Install and Uninstall	Wait on the Database Engine Recovery Handle Failed SQL Server Installation Error
Integration Services Configuration Options	Understanding the SQL Server Integration Services Catalog and creating the SSISDB Catalog
Log Shipping	Change SQL Server log shipped database from Restoring to Standby Read-Only
Log Shipping	Change the restore mode of a secondary SQL Server database in Log shipping with SSMS
Log Shipping	How to add database file to a Log Shipped database in SQL Server
Log Shipping	Temporarily Change SQL Server Log Shipping Database to Read Only
Performance Tuning	Database Cloning in SQL Server for Troubleshooting and Diagnostics
Performance Tuning	Error running the SQL Server Database Tuning Advisor for non SA users
Performance Tuning	Find out which SQL Server instance is consuming most of the CPU
Performance Tuning	How to find out how much CPU a SQL Server process is really using
Performance Tuning	Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues
PowerShell	Controlling Windows and SQL Server Services using Windows PowerShell
PowerShell	Enable PowerShell on Windows Server 2008 R2 Core Edition
PowerShell	Enable Powershell Remoting on SQL Server Instances
PowerShell	Handling Windows Processes using Windows PowerShell for SQL Server
PowerShell	Using PowerShell to access event logs for SQL Server
Professional Development Interview Questions DBA	SQL Server AlwaysOn Interview Questions and Answers - Part 1
Professional Development Interview Questions DBA	SQL Server AlwaysOn Interview Questions and Answers – Part 2
Professional Development Interview Questions DBA	SQL Server Replication Interview Questions and Answers
Profiler and Trace	How to Grant Permissions to run SQL Server Profiler for a non System Admin User
Replication	How to Fix Tracer Token warnings in SQL Server Replication Monitor
Reporting Services Installation	How to add Reporting Services to an existing SQL Server Clustered Instance
Restore	How to revert a Database Snapshot to recover a SQL Server database
Security	An Overview of System Function LOGINPROPERTY for SQL Login Details
Security	How to Assign Ownership to Various Database Objects using ALTER Authorization T-SQL Statement
Security	How to connect to SQL Server if you are completely locked out
Security	How to use fn_builtin_permissions SQL Server Security Function
Security	Identify blank and weak passwords for SQL Server logins
Security	List SQL Server Login and User Permissions with fn_my_permissions
SQL Server 2019	How to Enable and Disable Hybrid Buffer Pool for SQL Server Databases
SQL Server 2019	Understanding Hybrid Buffer Pool in SQL Server 2019
SQL Server Agent	How to Change the SQL Server Agent Log File Path
SQL Server Agent	How to start SQL Server Agent when Agent XPs show disabled
SQL Server and Oracle Comparison	How to Convert Database Objects from Oracle to SQL Server using SQL Server Migration Assistant for Oracle – Part 2
SQL Server and Oracle Comparison	How to Install SQL Server Migration Assistant for Oracle – Part 1
SQL Server and Oracle Comparison	How to Install SQL Server Migration Assistant for Oracle Extension Pack – Part 2
SQL Server and Oracle Comparison	How to Migrate an Oracle Database to SQL Server using SQL Server Migration Assistant for Oracle - Part 1
SQL Server and Oracle Comparison	Load Database Objects for Conversion from Oracle to SQL Server using SQL Server Migration Assistant - Part 3
SQL Server and Oracle Comparison	Migrate Data from Oracle to SQL Server with SQL Server Migration Assistant - Part 4
SQL Server Configurations	6 Ways to Get SQL Server Versions
SQL Server Configurations	How to allow Ad hoc updates in SQL Server system catalogs
SQL Server Configurations	How to change server level collation for a SQL Server Instance
SQL Server Configurations	Lock Pages in Memory for SQL Server on Windows
SQL Server Management Studio	Assign Colors in SQL Server Management Studio Query Windows Based on Environment
SQL Server Management Studio	Fix invalid object name master.dbo.spt_values when viewing SQL Server database properties
SQL Server Management Studio	How to Install SQL Server Management Studio to Access SQL Server Databases
SQL Server Management Studio	How to Upgrade SQL Server Management Studio and Azure Data Studio
SQL Server Management Studio	Property Owner is not available for Database SSMS error
SQL Server Management Studio	SQL Server Management Studio Template Explorer
SQL Server Management Studio Configuration	How to hide SQL Server user databases in SQL Server Management Studio
SQL Server on Linux	Enable and Disable SQL Server Trace Flags on a Linux Server
SQL Server on Linux	Fixing dependency issues during installation of SQL Server Tools on Red Hat Linux Server
SQL Server on Linux	Fixing error Failed to mount cd: devices when installing SQL Server tools on SUSE Linux Server
SQL Server on Linux	How to Change Default Data and Log file directory for SQL Server running on Linux
SQL Server on Linux	How to Change Hostname of Various Linux Systems
SQL Server on Linux	How to Change SQL Server Instance Name Running on a Linux Server
SQL Server on Linux	How to Change SQL Server Port Number for a Linux Server
SQL Server on Linux	How to change the Default Dump File location of SQL Server running on Linux Server
SQL Server on Linux	How to create SQL Server Agent Jobs on a Linux based instance using Management Studio
SQL Server on Linux	How to Enable and Configure SQL Server Agent for SQL Server 2019 on RHEL 8.1
SQL Server on Linux	How to schedule a SQL Server Agent Job on a Linux based instance using T-SQL
SQL Server on Linux	How to Uninstall SQL Server 2017 running on Ubuntu
SQL Server on Linux	How to Uninstall SQL Server vNext from a Linux Server
SQL Server on Linux	Install SQL Server Tools to Establish a Database Connection from an Ubuntu Server
SQL Server on Linux	Installing SQL Server Agent on Red Hat Linux based SQL Servers
SQL Server on Linux	Installing SQL Server Agent on SUSE Linux
SQL Server on Linux	Installing SQL Server Agent on Ubuntu Server
SQL Server on Linux	Installing SQL Server Tools on SUSE Linux
SQL Server on Linux	Installing SQL Server Tools to make a Database Connection from Redhat Linux Server
SQL Server on Linux	Installing SQL Server vNext CTP1 on Red Hat Linux 7.2
SQL Server on Linux	Installing SQL Server vNext on SUSE Linux Server
SQL Server on Linux	Installing SQL Server vNext on Ubuntu
SQL Server on Linux	Remove SQL Tools sqlcmd and bcp from Ubuntu Linux Server
SQL Server on Linux	Renaming a Red Hat Linux System Hostname for SQL Server
SQL Server on Linux	Restore a SQL Server database on a Linux based instance from a backup on a Windows instance
SQL Server on Linux	Upgrading SQL Server running on Ubuntu to latest update
SQL Server on Linux	Upgrading SQL Server vNext on Red Hat Linux to latest available update
SQL Server on Linux	Use SSMS to Restore a SQL Server database on a Linux based instance from a backup on a Windows instance
Testing	AdventureWorks Database Installation Steps
Upgrades and Migrations	SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule
Virtualization	Build Virtual Machine using VMware Workstation Pro
Virtualization	Create VMware Virtual Machine for Red Hat Enterprise Linux
Virtualization	How to Configure Repositories for Installing and Upgrading SQL Server on RHEL Virtual Machine
Virtualization	How to Install Python2 and Openssl1.0 on RHEL 8.1
Virtualization	How to Install SQL Server Command Line Tools SQLCMD and BCP on RHEL 8.1
Virtualization	How to Register a Virtual Machine to RedHat Subscription Management
Virtualization	How to Setup a Virtual Machine with VMware Workstation 14
Virtualization	Install VMware Workstation 14 on Windows
Virtualization	Install VMware Workstation Pro for SQL Server
Virtualization	Step by Step Installation of SQL Server 2019 on Windows Server 2016 in VMware
Virtualization	Step by Step Installation of Windows Server 2016 on a Virtual Machine
Virtualization	Step by Step Process to Install SQL Server 2019 on RHEL 8.1

No Records Found

No Records Found

CategoryGroup	Category (articles)
Analysis Services	Analysis Services Administration (33)
Analysis Services	Analysis Services Development (95)
Analysis Services	Analysis Services Dimensions (16)
Analysis Services	Analysis Services Measure Groups (7)
Analysis Services	Analysis Services Performance (14)
Analysis Services	Analysis Services Security (7)
Analysis Services	Analysis Services Tutorials (6)
Business Intelligence	Artificial Intelligence (23)
Business Intelligence	Big Data (25)
Business Intelligence	Data Science (3)
Business Intelligence	Data Warehousing (7)
Business Intelligence	Import and Export (81)
Business Intelligence	R Language (11)
Business Intelligence	Snowflake (29)
Cloud	Amazon AWS (38)
Cloud	Amazon AWS RDS (21)
Cloud	Azure (149)
Cloud	Azure Backup and Restore (25)
Cloud	Azure Cosmos DB (15)
Cloud	Azure Functions (7)
Cloud	Azure SQL Database (51)
Cloud	Azure SQL Managed Instance (5)
Cloud	Cloud Strategy (25)
Cloud	Google Cloud (10)
Cloud Analytics	Apache Spark (13)
Cloud Analytics	Azure Data Factory (73)
Cloud Analytics	Azure Databricks (39)
Cloud Analytics	Azure Integration Services (14)
Cloud Analytics	Azure Synapse Analytics (42)
Cloud Analytics	Microsoft Fabric (18)
Data Quality	Data Cleansing for Validation (4)
Data Quality	Data Quality Services (10)
Data Quality	Master Data Services (41)
Database Administration	Central Management Servers (10)
Database Administration	Comparison Data and Objects (14)
Database Administration	Database Administration (208)
Database Administration	DBA Best Practices (39)
Database Administration	Dedicated Administrator Connection (4)
Database Administration	Scripts (35)
Database Administration	System Databases (31)
Database Configuration	Compression (22)
Database Configuration	Database Configurations (19)
Database Configuration	Database Mail (18)
Database Configuration	FILESTREAM (9)
Database Configuration	Full Text Search (21)
Database Configuration	In Memory OLTP (32)
Database Configuration	Linked Servers (18)
Database Configuration	Policy Based Management (29)
Database Configuration	Recovery Models (4)
Database Configuration	Resource Governor (5)
Database Configuration	SQL Server Configurations (75)
Database Design	Constraints (20)
Database Design	Data Types (22)
Database Design	Database Design (92)
Database Design	Identities (17)
Database Design	JOIN Tables (23)
Database Design	Synonyms (5)
Database Design	Table Valued Parameters (4)
Database Design	Temp Tables (15)
Database Design	Temporal Tables (13)
Database Design	User Defined Type UDT (3)
Database Design	Views (17)
Database Development	Application Development (46)
Database Development	Common Runtime Language (13)
Database Development	Debugging (4)
Database Development	DevOps (36)
Database Development	Entity Framework (13)
Database Development	Language Integrated Query LINQ (7)
Database Development	Paging (5)
Database Development	Referential Integrity (5)
Database Development	Service Broker (11)
Database Development	Testing (32)
Database Development	XML (14)
Database Maintenance	Database Console Commands DBCCs (25)
Database Maintenance	Fragmentation and Index Maintenance (28)
Database Maintenance	Maintenance (34)
Disaster Recovery / High Availability	Availability Groups (80)
Disaster Recovery / High Availability	Backup (81)
Disaster Recovery / High Availability	Clustering (77)
Disaster Recovery / High Availability	Database Mirroring (33)
Disaster Recovery / High Availability	Disaster Recovery (23)
Disaster Recovery / High Availability	High Availability (3)
Disaster Recovery / High Availability	Log Shipping (18)
Disaster Recovery / High Availability	Replication (78)
Disaster Recovery / High Availability	Restore (42)
Functions	Dates (56)
Functions	Functions System (99)
Functions	Functions User Defined UDF (41)
Infrastructure	Contained Databases (4)
Infrastructure	Containers (12)
Infrastructure	Hardware (14)
Infrastructure	Spatial Data Storage (9)
Infrastructure	Virtualization (25)
Integration Services Admin	Integration Services Administration (10)
Integration Services Admin	Integration Services Best Practices (12)
Integration Services Admin	Integration Services Configuration Options (22)
Integration Services Admin	Integration Services Performance (12)
Integration Services Admin	Integration Services Security (7)
Integration Services Admin	Integration Services Upgrade (4)
Integration Services Development	Data Transformation Services (6)
Integration Services Development	Integration Services Analysis Services Tasks (5)
Integration Services Development	Integration Services Connection Managers (5)
Integration Services Development	Integration Services Control Flow Transformations (14)
Integration Services Development	Integration Services Data Flow Transformations (19)
Integration Services Development	Integration Services Development (116)
Integration Services Development	Integration Services Error Handling (8)
Integration Services Development	Integration Services Excel (14)
Integration Services Development	Integration Services Execute Package Options (8)
Integration Services Development	Integration Services Oracle (4)
Microsoft Office	Microsoft Access Integration (8)
Microsoft Office	Microsoft Excel Integration (45)
Microsoft Office	Microsoft Flow (1)
Other RDBMS	Other Database Platforms (16)
Other RDBMS	PostgreSQL (11)
Other RDBMS	SQL Server and Oracle Comparison (29)
Other RDBMS	SQL Server on Linux (78)
Other RDBMS	SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance	Dynamic Management Views and Functions (34)
Performance	Error Logs (11)
Performance	Extended Events (22)
Performance	Indexing (94)
Performance	Locking and Blocking (43)
Performance	Monitoring (110)
Performance	Partitioning (17)
Performance	Performance Data Warehouse (4)
Performance	Performance Tuning (124)
Performance	Profiler and Trace (20)
Performance	Query Optimization (15)
Performance	Query Plans (20)
Performance	Query Store (7)
Power Platform	Power Apps (20)
Power Platform	Power BI (172)
Power Platform	Power BI Charts (57)
Power Platform	Power BI Formatting (17)
Professional Development	Professional Development Branding (16)
Professional Development	Professional Development Career (18)
Professional Development	Professional Development Career Planning (20)
Professional Development	Professional Development Certifications (62)
Professional Development	Professional Development Community (16)
Professional Development	Professional Development Interview Questions BI (18)
Professional Development	Professional Development Interview Questions DBA (23)
Professional Development	Professional Development Interview Questions Developer (9)
Professional Development	Professional Development Interviewing (39)
Professional Development	Professional Development Job Search (24)
Professional Development	Professional Development Management (14)
Professional Development	Professional Development Resume (13)
Professional Development	Professional Development Skills Development (18)
Python	Python (89)
Reporting Services Admin	Reporting Services Administration (21)
Reporting Services Admin	Reporting Services Best Practices (6)
Reporting Services Admin	Reporting Services Configuration (10)
Reporting Services Admin	Reporting Services Installation (10)
Reporting Services Admin	Reporting Services Migration (5)
Reporting Services Admin	Reporting Services Monitoring (5)
Reporting Services Admin	Reporting Services Network Load Balancing (4)
Reporting Services Admin	Reporting Services Performance (6)
Reporting Services Admin	Reporting Services Security (8)
Reporting Services Development	Reporting Services Analysis Services (4)
Reporting Services Development	Reporting Services Charts (25)
Reporting Services Development	Reporting Services Data Sources (10)
Reporting Services Development	Reporting Services Development (67)
Reporting Services Development	Reporting Services Dynamic Reports (11)
Reporting Services Development	Reporting Services Formatting (26)
Reporting Services Development	Reporting Services KPI (5)
Reporting Services Development	Reporting Services Overview (5)
Reporting Services Development	Reporting Services Parameters (15)
Reporting Services Development	Reporting Services Report Builder (9)
Security	Auditing and Compliance (47)
Security	Encryption (35)
Security	Security (199)
Security	SQL Injection (5)
Security	Surface Area Configuration Manager (4)
SharePoint	SharePoint (131)
SharePoint	SharePoint Administration (46)
SharePoint	SharePoint Configuration (27)
SharePoint	Sharepoint Design (46)
SharePoint	SharePoint Document Management (20)
SQL Coding	Change Data Capture (16)
SQL Coding	Common Table Expressions (4)
SQL Coding	Dynamic SQL (7)
SQL Coding	Error Handling (11)
SQL Coding	Stored Procedures (30)
SQL Coding	Transactions (9)
SQL Coding	Triggers (44)
SQL Coding	TSQL (342)
Tools	Azure Data Studio (18)
Tools	PowerShell (131)
Tools	SQL Operations Studio (11)
Tools	SQL Server Agent (95)
Tools	SQL Server Management Objects SMO (3)
Tools	SQL Server Management Studio (78)
Tools	SQL Server Management Studio Configuration (22)
Tools	SQL Server Management Studio Shortcuts (9)
Tools	Tools (35)
Versions	Deprecated Features (6)
Versions	Express Edition (16)
Versions	Install and Uninstall (33)
Versions	Licensing (4)
Versions	SQL Server 2016 (96)
Versions	SQL Server 2017 (44)
Versions	SQL Server 2019 (20)
Versions	SQL Server 2022 (21)
Versions	Upgrades and Migrations (55)