Clustered role ‘Cluster Resource Group’ has exceeded its fail-over threshold. It has exhausted the configured number of fail-over attempts within the fail-over period of time

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- One of our UAT database environment which was setup with Active-Active fail-over cluster approach ran into inaccessible for the application and DBA was asked to … Continue reading Clustered role ‘Cluster Resource Group’ has exceeded its fail-over threshold. It has exhausted the configured number of fail-over attempts within the fail-over period of time

Data Migration Assistant (DMA) to check SQL server compatibility issues for migrating one version to higher version

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- Well, it is always a good practice to use DMA tool by Microsoft to check any compatibility issues before upgrading to higher version of SQL … Continue reading Data Migration Assistant (DMA) to check SQL server compatibility issues for migrating one version to higher version

SQL Server evaluation period has expired:Unable to start SQL services

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- It doesn't happen so often as company always use the licensed SQL server but sometime on Development or Lab environment people use the evaluation edition … Continue reading SQL Server evaluation period has expired:Unable to start SQL services

Microsoft SQL Server 2017 Deprecated & Discontinued Features- Go Through

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- One of my UK based client , wanted to upgrade its production database to SQL server 2017 version (Enterprise edition) from existing SQL server 2014 … Continue reading Microsoft SQL Server 2017 Deprecated & Discontinued Features- Go Through

Connecting to SQL server integration service through SSMS failed with error- Class Not Registered

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- Have you ever tried connecting SQL server integration service through management studio and failed to connect and receive error like Class not registered? I recently … Continue reading Connecting to SQL server integration service through SSMS failed with error- Class Not Registered

Change or customize “from” portion/header of the email when calling sp_send_dbmail in SQL server

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- Recently, I had received a request from one of the customer to send some report from SQL to his management and it looks pretty simple … Continue reading Change or customize “from” portion/header of the email when calling sp_send_dbmail in SQL server