4 min read
SQL Server Management Studio 22: Why Can’t I Create a Maintenance Plan?
Sandro Pereira
Oct 20, 2026
Sometimes I’m genuinely mesmerized by how Microsoft manages to complicate something that has been simple for ages! For years, installing SQL Server
3 min read
BizTalk Server monitoring: View Count of BizTalk Instances Suspended (Non-Resumable)
Sandro Pereira
Nov 7, 2022
As service instances (receive ports, orchestrations, send ports) process messages moving through BizTalk Server, these service instances can be in one of
3 min read
BizTalk Server monitoring: View Count of BizTalk Instances Suspended (Resumable)
Sandro Pereira
Nov 6, 2022
As service instances (receive ports, orchestrations, send ports) process messages moving through BizTalk Server, these service instances can be in one of
3 min read
BizTalk Server monitoring: View Count of Dehydrated BizTalk Instances
Sandro Pereira
Nov 4, 2022
As service instances (receive ports, orchestrations, send ports) process messages moving through BizTalk Server, these service instances can be in one of
3 min read
BizTalk Server monitoring: View Count of Active (running) BizTalk Instances
Sandro Pereira
Nov 3, 2022
As service instances (receive ports, orchestrations, send ports) process messages moving through BizTalk Server, these service instances can be in one of
7 min read
BizTalk Server Maintenance: Repair Refcounts issues for All Messages
Sandro Pereira
Oct 27, 2022
In my last two blog posts — BizTalk Server monitoring: View Count of Messages Without Reference Counts (RefCounts) and BizTalk Server monitoring: View Count
2 min read
The job failed. Unable to determine if the owner (domain\username) of job job-name has server ac...
Sandro Pereira
Aug 17, 2021
I recently received a request for help from a customer about a problem that has started to occur with SQL Server jobs in BizTalk Server Everything was working
3 min read
SQL Queries to Enable or Disable All BizTalk SQL Server Agent jobs
Sandro Pereira
Nov 18, 2014
BizTalk Server installs a total of 13 SQL Server Agent jobsExperienced BizTalk administrators know that almost all of these jobs must remain enabled and run
5 min read
New release: Managing and cleaning BizTalk Server MarkLog database tables: sp_DeleteBackupHistory...
Sandro Pereira
May 26, 2014
Almost three weeks ago, in my last post I release a SQL script to manage and delete the unnecessary records in the BizTalk “MarkLog” tables according to
