Authentication

Solving the Target Principal Name is Incorrect

One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context

Finding table name based on a specific value

This script is used to Find out the table name and column name where a specific string has been used

SQL Server Services

Primary and Foriegn Keys on Temp Tables

Unattended Installation

Installing SQL Server even without seeing the installation wizard.

SQL Jobs on Always On

This script will check the status of the node in Always On and enable or disable the jobs according to our requirement.