2 min read
A fish out of water: How to delete a credential in SQL Server (sys.credentials table)
Sandro Pereira
Jul 31, 2025
You may already know that I typically use the series A Fish Out of Water when I want to write something that slightly deviates from my main blog topic:
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 prerequirements This
2 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 and after the first attempt to configure BizTalk Server failed, I encountered this error while
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
3 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
3 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 just another post for the sake of my mental sanity because I’m always tired of looking up for this over and over again While working on BizTalk
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
