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
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 WCF-SQL: Invalid object name while using temporary tables
Sandro Pereira
Apr 23, 2024
It is common to use temporary tables to implement internal logic in your SQL queries or scripts I have seen it used several times, for example, inside
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
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
