2018-06-18
856 reads
Raghavender Chavva
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
2018-05-31
28,233 reads
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
2018-04-17 (first published: 2018-04-13)
1,400 reads
2018-04-16
899 reads
2016-08-16
1,328 reads
2016-04-19
4,747 reads
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.
2015-12-02 (first published: 2015-11-18)
1,608 reads
Blogs
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Build a Serverless Todo App With AWS, Pulumi, and Python
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Forums
Temp table security
So, I have an interesting situation that I need a double-check on. One of...
Searching a Form (using "Find") after an Access to SQL Migration
I have completed a successful migration of an access database to SQL Express. Most...
Question of the Day
Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers