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: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. In …

Continue reading PowerShell –SQL Automate Tutorial-3

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: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. Note:- …

Continue reading PowerShell –SQL Automate Tutorial-2

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

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

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:- As we all know that TLS 1.0 is outdated protocol, it was released somewhere in 1999 which is now no secure and most vulnerable hence …

Continue reading TLS 1.0 & MSSQL Server Dependencies

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

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:- Okay, so before upgrading SQL server version to higher, we need to have setup files in place first. Please see this link for list of …

Continue reading Download SQL server 2014/2016/2017/2019 setup file

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

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