PowerShell –SQL Automate Tutorial-4

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 this series of tutorial, we will only walk through some … Continue reading PowerShell –SQL Automate Tutorial-4

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. In this series of tutorial, we will only walk through some … Continue reading PowerShell –SQL Automate Tutorial-3

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: 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:- Please click here to get 1st part of PowerShell –SQL … Continue reading PowerShell –SQL Automate Tutorial-2

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 take a look inside the database server. On checking from … 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 server. Being a DBA, it is one of the recommended … Continue reading Data Migration Assistant (DMA) to check SQL server compatibility issues for migrating one version to higher version

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:- 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 for secure communications, this must be disabled on SQL server, … Continue reading TLS 1.0 & MSSQL Server Dependencies

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 of SQL server to explore its features that come along … Continue reading SQL Server evaluation period has expired:Unable to start SQL services

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:- 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 the features which have been marked deprecated and discontinued in … Continue reading Download SQL server 2014/2016/2017/2019 setup file

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 (Enterprise edition). Obviously one must start upgrading from Non-prod first … 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 working on importing SSIS package for my client and tried … Continue reading Connecting to SQL server integration service through SSMS failed with error- Class Not Registered