May 29

Fixing “Target Principal Name is Incorrect” SQL connection error while trying to vali...

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

By Luis Rigueira

Jan 25

BizTalk Server error: BizTalk Server cannot access SQL Server

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,

By Sandro Pereira

Oct 17

Note to myself: How to easily count the number of Jobs in SQL Server Agent Jobs?

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

By Sandro Pereira

Sep 25

Note to myself: How to reset the Azure SQL Server admin account password

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

By Sandro Pereira

Sep 21

SQL Script to monitor BizTalk Server SQL Jobs

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

By Sandro Pereira

Jun 23

A fish out of water: How to check what SSIS packages are running and stop them?

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

By Sandro Pereira

Apr 27

BizTalk Backup BizTalk Server Job Error: Could not find server ‘server name’ in sys.s...

Yesterday while troubleshooting a BizTalk Server developer environment at a client, I encountered an unusual error while trying to configure the BizTalk

By Sandro Pereira

Jan 26

Microsoft Integration and Azure Stencils Pack for Visio: New version available (v7.3.1)

The full 73 version is complete with the release of v731 This was a massive work of adding new shapes of new services that appear on Azure and changing the

By Sandro Pereira

Jan 24

Microsoft Integration and Azure Stencils Pack for Visio: New version available (v7.3.0)

The full 730 version is not yet complete, but I decided to release it in small pieces instead of taking a long time to make all the planned changes and being

By Sandro Pereira

Jan 8

BizTalk Server BAM SQL Queries: Checking who has permission

While organizing my vast resources in my hard drive, I recently found out, polished, and improved two SQL Server queries that allow us to check the users and

By Sandro Pereira
turbo360

Back to Top