2 min read
A fish out of water: How to delete a credential in SQL Server (sys.credentials table)
Sandro Pereira
Jul 31, 2025
As you may already know, I use the A Fish Out of Water series when I want to write about topics that slightly deviate from my main focus: Enterprise
3 min read
SQL Server Integration Services Error: Connecting to the Integration Services service on the comp...
Sandro Pereira
Oct 30, 2024
Sometimes, it is fun to install new BizTalk Server environments, especially if you are not in the process/responsible for installing its prerequisites This
3 min read
SQL Server Error while trying to delete Job: Cannot perform this operation while SQLServerAgent i...
Sandro Pereira
Oct 29, 2024
Today, while installing a brand‑new BizTalk Server environment, the initial configuration attempt failed As a result, I tried to clean up the artifacts
2 min read
SQL Server Management Studio: The certificate chain was issued by an authority that is not trusted.
Sandro Pereira
Oct 28, 2024
Some time ago, I wrote a similar blog post describing this exact same error message while using the WCF-SQL Adapter of the BizTalk Server Today, I encountered
4 min read
Fixing “Target Principal Name is Incorrect” SQL connection error while trying to vali...
Luis Rigueira
May 29, 2024
I'm going to start quoting Sandro: "Sometimes the life of a developer is a nightmare, hehe" But it is also fun once you find the solution So, on one of
4 min read
BizTalk Server error: BizTalk Server cannot access SQL Server
Sandro Pereira
Jan 25, 2024
A client called me this week to help with their BizTalk Server production environment BizTalk was not running, and they needed to know the reason why Quickly,
2 min read
Note to myself: How to easily count the number of Jobs in SQL Server Agent Jobs?
Sandro Pereira
Oct 17, 2023
This is another post for the sake of my mental sanity I keep looking up this information again and again Therefore, I decided to write it down once and for
2 min read
Note to myself: How to reset the Azure SQL Server admin account password
Sandro Pereira
Sep 25, 2023
Welcome back to yet another post, driven by my desire to maintain my mental well-being, as I've become exhausted from the constant need to look this up I
2 min read
SQL Script to monitor BizTalk Server SQL Jobs
Sandro Pereira
Sep 21, 2023
For those who've been following my work, you might recall that I shared a set of PowerShell scripts a while back for monitoring BizTalk Server One of these
