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
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
4 min read
Microsoft Integration and Azure Stencils Pack for Visio: New version available (v8.0.1)
Sandro Pereira
Oct 3, 2023
In my previous update, I discussed my intention to release a new major version of my stencils However, I've opted for a gradual approach, releasing minor
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
3 min read
A fish out of water: How to check what SSIS packages are running and stop them?
Sandro Pereira
Jun 23, 2023
You may already know that I usually use the series A fish out of water when I want to write something that goes a little bit off-topic on my main blog
