Notes From The Road: 2021 Year In Review

Notes From The Road: 2021 Year In Review

2021 wasn’t the year we all desire to be, COVID-19 pandemic is still present, but overall it was a good year for my family and me. We manage to be safe and well, which is the most important. Because we use our homes more and more, renovations at home continue to happen during 2021 to continue to build our dream house:

It was a year we all got vaccinated, and that allowed us to have more freedom, so we were able to safely visit Portugal (our country) and take a deserved vacation away from the hustle of the city or the most tourist places:

But without exaggeration! Homeworking, or working in all possible crazy situations and from literally everywhere, was still present:

And I decide not to do any in-person events. Instead, I did 21 online events and kept friends close by doing a lot of video calls!

My Blog has still solid numbers and growing every year…

The numbers of my blog kept solid in terms of visitors and new content, and 2021 was again a very productive year:

  • Publish 77 new posts on my blog;
    • One more publisher: Pedro Almeida
    • More than 375,328 visits to my blog.
    • Coming from 210 countries across the world in the past year (and more than 15,137 cities).
      • And the countries that most visited my blog are once again the United States, followed by India, the United Kingdom, and this time Australia

Not bad if we compare to previous years:

  • 2020: 392,535 visits, 214 countries, 92 new posts
  • 2019: 431,000 visits, 207countries, 43 new posts
  • 2018: 246,381 visits, 194 countries, 70 new posts
  • 2017: 210,000 visits, 167 countries, 63 new posts (migrate to a new blog)
  • 2016: 318,576 visits, 190 countries, 50 new posts
  • 2015: 350,000 visits, 184 countries, 79 new posts
  • 2014: 310,000 visits, 183 countries, 52 new posts
  • 2013: 200,000 visits, 176 countries, 79 new posts
  • 2012: 170,000 visits, 171 countries, 102 new posts
  • 2011: 91,000 visits, 61 new posts

I want to say thanks to all my readers. I appreciate all the visits to my blog, and thanks for your support. And a big thanks to my team at DevScope:

Attractions in 2021

These are the top 10 posts that got the most views in 2021:

  1. Microsoft Integration and Azure Stencils Pack for Visio: New major version available (v5.0.0) with 15,473 views
  2. Logic Apps: How to send a well-formatted HTML Email notification with Office 365 Outlook connector with 13,659 views
  3. A fish out of water: Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created with 12,762 views
  4. SQL Server detected a logical consistency-based I/O error: incorrect pageid in BizTalkMsgBoxDb database with 12,524 views
  5. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security with 8,892 views
  6. Microsoft Integration and Azure Stencils Pack for Visio: New Azure and Dataverse Logos with 8,892 views
  7. Microsoft Integration and Azure Stencils Pack for Visio: New version available (v5.1.0) with 7,828 views
  8. Note to myself: How to perform a CTRL+ALT+DEL inside an Azure Virtual Machine? with 7,276 views
  9. A fish out of water: How to Add connector points on Visio Stencils with 7,186 views
  10. A fish out of water: PowerShell – The term ‘Invoke-Sqlcmd’ is not recognized as the name of a cmdlet, function, script file, or operable program. with 7,121 views

And these are some of my 2021 favorite posts:

A new book…

2021 was also the year I finished my second book: Migrating to BizTalk Server 2020. This time with the help of good friends: Tom Canter and Lex Hegt.

The book is almost available! Unfortunately, we had some setbacks with printing books and shipping (Brexit), but I’m confident it will become available by the end of this month (January 2022).

Open Source Contributions…

Continue to improve the existing GitHub contributions and add new ones. Here are some samples:

  • Azure:
    • PowerShell Runbook: Find Broken Azure API Connections: This PowerShell Runbook will look at all of the API Connections in all resource groups present in a specific Azure Subscription and provide a list of all broken API Connections.
    • Function App: Find Broken Azure API Connections: This PowerShell Function App will look at all of the API Connections in all resource groups present in a specific Azure Subscription and provide a list of all broken API Connections.
    • API Connections Status Report: This PowerShell script will look at all of the API Connections in all resource groups present in a specific Azure Subscription and providen their currenct status.
    • Finding Azure VM Administrator Username: This PowerShell script will get this basic information for you.
    • Find Orphaned Azure API Connectors: This PowerShell script will look at all of the API Connections in all resource groups present in a specific Azure Subscription and then inspect every Logic App in your resource group to check if the API Connections are being used or not. The goal of this script, of course, is to identify orphaned API Connections in a single Resource Group quickly and effectively.

Other contributions…

And if you think I stayed and contribute only to my blog, you are very wrong I perform several other publications outside my blog:

A year of on-line speaking engagements…

However, that is not all! I still was able to deliver 21 virtual sessions in several conferences and User Groups worldwide on topics like BizTalk Server, Logic Apps, and Power Automate:

  • Azure User Group Portugal | January 13, 2021 | Logic Apps: Development experiences
  • 101 Talk Arena | January 14, 2021 | 101 Talk Arena with Sandro Pereira: What about integration now?
  • Microsoft Integrate Conference DACH 2021 | January 21, 2021 | Logic Apps: Anywhere, Everywhere
  • Azure Lowlands | January 29, 2021 | How to create robust monitor solutions with PowerShell, Azure Functions and Logic Apps
  • Global Automation Bootcamp 2021 | February 6, 2021 | Power Automation: Best practices, tips and tricks
  • Virtual Scottish Summit 2021 | February 19, 2021 | Power Automation: Best practices, tips and tricks
  • Global Power Platform Bootcamp 2021 – Münsterland | February 19, 2021 | Power Automate: Best practices, Tips and Tricks
  • Webinar: PowerTalk by Atea | February 22, 2021 | Power Automate: Best practices, Tips and Tricks
  • Global Integration Bootcamp 2021 – Virtual | February 25, 2021 | Logic App (Preview): The new kid on the block
  • Power Platform Virtual Conference | March 12, 2021 | Power Automate: Best practices, Tips and Tricks
  • Global Azure Lüdinghausen 2021 | April 16, 2021 | Logic App (Preview): The new kid on the block
  • Global Azure Portugal 2021 | April 16, 2021 | Logic App (Preview): The new kid on the block
  • DeveloperWeek Europe 2021 | April 26, 2021 | The most important Best practices you need to know to develop Azure Logic Apps
  • Microsoft 365 Virtual Marathon | April 26, 2021 | Logic Apps: Best practices, Tips and Tricks
  • Power Platform 24 | May 5, 2021 | How to create robust monitor solutions with PowerShell and Power Automate
  • Bizz Summit ES | June 4, 2021 | Power Automation: Best practices, tips and tricks
  • Dutch Microsoft Cloud Call | June 5, 2021 | Logic Apps: Best practices, Tips and Tricks
  • Code PaLOUsa 2021 | August 19, 2021 | Logic Apps: Anywhere, Everywhere
  • Azure Summit | September 20, 2021 | Logic Apps: New set of Best practices, Tips and Tricks
  • Connected Conference 2021 | November 16, 2021 | Logic Apps: New Set of Best Practices, Tips and Tricks
  • Build Stuff 2021 Lithuania | November 19, 2021 | Logic Apps: Anywhere, Everywhere

For all of you…

Once again, thanks for following me, for reading my blog, and I promise that I will continue to share my knowledge during 2022.

The post Notes From The Road: 2021 Year In Review appeared first on SANDRO PEREIRA BIZTALK BLOG.

Merry Christmas & Happy New Year 2022

Merry Christmas & Happy New Year 2022

We wish you a Merry Christmas
We wish you a Merry Christmas
We wish you a Merry Christmas and a Happy New Year!

We are entering the 3rt pandemic year. We are in a better position, the vaccination is helping minimize the impact of this pandemic, but there is still a long way to go. This makes his holiday season even more important because we never know what tomorrow will be, so on this Christmas, I hope you all can spend time with your close family and friends in the safest way you can. And if you are like me, with three young kids, then it’s all about creating happy memories that will last a lifetime, and we need it more than ever!

And once again, my sincere wishes for a Merry Christmas and a Happy New Year to all my readers, friends, customers, partners, coworkers, my amazing Integration Team at DevScope (Pedro Almeida and Diogo Formosinho – you guys rock!), to all Microsoft Integration and Azure Community (BizTalk Server, Logic Apps, API Management, Service Bus, and so on), MSFT Product Groups, all the Portuguese Communities, my MVP “family” and of course to my beautiful family.

Thanks in advance for all the support and encouragement given throughout another year – 11 years as MVP. I couldn’t make it without you guys!. It was, once again, an incredible year for me, on both a personal and professional level, and I hope that the next will be a year filled with new challenges. I promise that I will continue to share knowledge, hoping to help someone.

May this festive season sparkle and shine, may all of your wishes and dreams come true, and may the new year be made of great happiness. Merry Christmas to you and your entire family, and a happy new year!

The post Merry Christmas & Happy New Year 2022 appeared first on SANDRO PEREIRA BIZTALK BLOG.

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

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

I’m not a Dynamics 265 expert, and Dynamics 365 is not my focus area. Nevertheless, I couldn’t ignore the flood of requests to add the new Dynamics 365 logos, especially the App icons. It took a while, but they are finally here.

What’s new in this version?

These are the list of changes and additions present in this major release:

  • New shapes: There are new shapes on the following Visio Stencils files (.vssx):
    • MIS Office, Office 365 and Dynamics 365: add the new Dynamic 265 logo, Dynamics 365 App Icons, and Dynamics 365 Mixed Reality Icons.
  • MIS Azure Stencils and MIS Azure Additional or Support Stencils: there were a few new icons add to the stencils, most of them related to new preview features and integration services like the new Logic App icon.
  • SVG files: new SVG files added.

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack it’s a Visio package that contains fully resizable Visio shapes (symbols/icons) that will help you to visually represent On-premise, Cloud or Hybrid Integration and Enterprise architectures scenarios (BizTalk Server, API Management, Logic Apps, Service Bus, Event Hub…), solutions diagrams and features or systems that use Microsoft Azure and related cloud and on-premises technologies in Visio 2016/2013:

  • BizTalk Server
  • Microsoft Azure
    • Integration
      • Integration Service Environments (ISE)
      • Logic Apps and Azure App Service in general (API Apps, Web Apps, and Mobile Apps)
      • Azure API Management
      • Messaging: Event Hubs, Event Grid, Service Bus, …
    • Azure IoT and Docker
    • AI, Machine Learning, Stream Analytics, Data Factory, Data Pipelines
    • SQL Server, DocumentDB, CosmosDB, MySQL, …
    • and so on
  • Microsoft Power Platform
    • Microsoft Flow
    • PowerApps
    • Power BI
  • Office365, SharePoint,…
  • DevOps and PowerShell
  • Security and Governance
  • And much more…
  • … and now non-related Microsoft technologies like:
    • SAP Stencils
Microsoft Integration (Azure and much more) Stencils Pack

The Microsoft Integration Stencils Pack is composed of 27 files:

  • Microsoft Integration Stencils
  • MIS Additional or Support Stencils
  • MIS AI and Machine Learning Stencils
  • MIS Apps and Systems Logo Stencils
  • MIS Azure Additional or Support Stencils
  • MIS Azure Black and Gray
  • MIS Azure Old Versions
  • MIS Azure Stencils
  • MIS Black and Cyan
  • MIS Buildings Stencils
  • MIS Databases and Analytics Stencils
  • MIS Deprecated Stencils
  • MIS Developer Stencils
  • MIS Devices Stencils
  • MIS Files and Message Types Stencils
  • MIS Generic Stencils
  • MIS Infrastructure and Networking Stencils
  • MIS Integration Fun
  • MIS Integration Patterns Stencils
  • MIS IoT Stencils
  • MIS Office, Office 365 and Dynamics 365
  • MIS Power BI Stencils
  • MIS Power Platform Stencils
  • MIS SAP Stencils
  • MIS Security and Governance
  • MIS Servers (Hexagonal) Stencils
  • MIS Users and Roles Stencils
  • Organisational Stencils

That you can use and resize without losing quality, in particular, the new shapes.

Download

You can download Microsoft Integration, Azure, BAPI, Office 365 and much more Stencils Pack for Visio from GitHub Here:

The post Microsoft Integration and Azure Stencils Pack for Visio: New version available (v7.2.0) appeared first on SANDRO PEREIRA BIZTALK BLOG.

Notes From The Road: 2020 Year In Review

Notes From The Road: 2020 Year In Review

I sincerely believe that humankind has faced worse years than in 2020. Nevertheless, this was probably the most challenging, exhausting, and difficult year of our generation. When the pandemic hit, and we were forced to be locked down at home, everything change, and we have to struggle between: 

  • Both parents working from home. We were not prepared, i.e., we did not have the necessary conditions at home, but that was the least of concerns, and it was relatively easier to fix. I ready had my office at home, so it was a matter to extend it to fit my wife’s needs and improve the network capabilities.
  • 3 Kids with younger ages being 24 hours at home and more critical having virtual school at home, and this was truly a challenge. Once again, luckily, I have several devices, that unfortunately, many people do not have, so in terms of equipment, that was easy, the oldest get a Mac, and the youngest was entitled to a Surface Pro. the little one, fortunately, didn’t have virtual school. But to conciliate both kids having virtual school and both parents having to work, and taking care of the kids and the house… wow, that was something huge that we luckily succeeded in without causing to much stress on our family and marriage.

Briefly and in the face of adversity, I would say that this turned out to be a good year. Family until now is safe and healthy, and that is the essential thing in life. We didn’t travel this year, that is something that I miss, but we arrange other things to pass the time in family, mainly at home safely. And for that reason, renovations at home continue to happen during 2020 in order to continue to build our dream house.

But that it’s not all:

  • We increased the family by adopting a new member: a 4-year-old puppy who suffered from mistreatment and that is now is a little princess here at home and cause for great joy and children’s play
  • We started a pep project during this pandemic to reduce stress, but it ended up improving our food: a biological garden that was initially small and got bigger and bigger!
  • And my team at DevScope grew even more and we hope it will continue to grow during this year in terms of business but full of challenging and great projects worldwide. We are doing a fantastic job;

My Blog is growing every year…

With all these constraints caused by the pandemic, both in personal and professional terms, It was to imagine that I had little time to do something I like: sharing knowledge. But when you do something that you enjoy, you always find the time. It was also a way to escape from all the problems and worries that have happened and relax. So it actually was a very productive year:

  • Publish 92 new posts on my blog; This goes directly to the podium, being the second most productive year since I start my personal blog.
    • More than 392,535 visits to my blog – that’s an average of 1,075 visits per day!
    • Coming from 214 countries across the world in the past year.
      • 7 new countries compare to the previous year
    • And the countries that most visited my blog are once again the United States, followed by India, the United Kingdom, and Canada

Not bad if we compare to previous years:

  • 2019: 431,000 visits, 207countries, 43 new posts
  • 2018: 246,381 visits, 194 countries, 70 new posts
  • 2017: 210,000 visits, 167 countries, 63 new posts (migrate to a new blog)
  • 2016: 318,576 visits, 190 countries, 50 new posts
  • 2015: 350,000 visits, 184 countries, 79 new posts
  • 2014: 310,000 visits, 183 countries, 52 new posts
  • 2013: 200,000 visits, 176 countries, 79 new posts
  • 2012: 170,000 visits, 171 countries, 102 new posts
  • 2011: 91,000 visits, 61 new posts

I want to say thanks to all my readers. I appreciate all the visits to my blog, and thanks for your support.

Attractions in 2020

These are the top 10 posts that got the most views in 2020:

  1. A fish out of water: Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created with 40,532 views
  2. Microsoft Integration and Azure Stencils Pack for Visio: New major version available (v5.0.0) with 21,948 views
  3. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security with 17,420 views
  4. SQL Server Management Studio (SSMS): The Visual Studio component cache is out of date. Please restart Visual Studio with 14,256 views
  5. SQL Server detected a logical consistency-based I/O error: incorrect pageid in BizTalkMsgBoxDb database with 13,450 views
  6. Logic Apps: How to send a well-formatted HTML Email notification with Office 365 Outlook connector with 10,070 views
  7. Microsoft Flow: How to pass the SQL data table results in a Markdown-formatted table into an Email notification or Approval Requests with 8,271 views
  8. Microsoft Integration and Azure Stencils Pack for Visio: New version available (v5.1.0) with 6,964 views
  9. TypeLoadException: Could not load type ‘type name’ from assembly ‘assembly name, Version=1.0.0.0, Culture=neutral, PublicKeyToken=…’ with 6,596 views
  10. Microsoft Integration (Azure and much more) Stencils Pack v3.0.0 for Visio with 5,122 views

And these are some of my favorite post that I enjoyed writing in 2020:

Open Source Contributions…

With all of this activity on my blog and to support my posts, I end up reorganizing and add several repositories and contributions to my GitHub account and organizations. Here are some samples:

  • Migrate all the BizTalk Server tools and Open Source Community projects to BizTalk Server 2020:
    • BizTalk Port Multiplier Tool: a tool that aims to simplify this process by allowing you to easily “clone or duplicate” an existing port (Receive Port or Send Port).
    • BizTalk Filter Finder Tool: a tool that aims to simplify the process for better understand and maintain solutions based on content-based routing. By allowing you to have a quick overview of all the artifacts, send ports, or orchestrations that have filters associated.
    • BizTalk Bindings Exporter tool: a tool that you can use to easily export a binding file from BizTalk Applications.
    • BizTalk Server SSO Application Configuration Tool: a tool that provides the ability to add and manage applications, add and manage key-value pairs in the SSO database, as well as import and export configuration applications so that they can be deployed to different environments.
    • BizTalk MapperExtensions Functoid Wizard: a Custom Functoid Project Wizard for Visual Studio 2010. It allows you to create a new Functoids project for BizTalk Server without having to create manually the project.
    • BizTalk MapperExtensions Functoid Project Template:  a Custom Functoid Project Template for Visual Studio 2019. It allows you to create a new Functoids project for BizTalk Server 2020 without having to create manually the project.
    • BizTalk Pipeline Components Extensions Utility Pack: a set of custom pipeline components (libraries) with several custom pipeline components that can be used in received and sent pipelines, which will provide an extension of BizTalk out-of-the-box pipeline capabilities.
    • BizTalk Mapper Extensions UtilityPack: a set of libraries with several useful functoids to include and use in a map, which will provide an extension of BizTalk Mapper capabilities.
  • Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack continues to be updated with new releases and getting some contributions from the community.
  • And I add brand new Repositories on my account:

Other contributions…

And if you think I stayed and contribute only on my blog, you are very wrong I perform several other publications outside my blog:

A year of on-line speaking engagements…

However, that not all! I still was able to deliver 10 virtual sessions in several conferences and User Groups worldwide on topics like BizTalk Server, Logic Apps and Power Automate:

  • Virtual Global Azure Lisbon | April 25, 2020 | Logic Apps: Best practices, Tips, and Tricks
  • Integration Use Group | May 4, 2020 |Microsoft Power Platform: Learn what Power BI + PowerApps + Power Automate + Office 365 can do for your organization
  • Integration Use Group | May 25, 2020 |Logic App: Best Practices, Tips & Tricks
  • INTEGRATE 2020 Remote | June 1-3, 2020 | BizTalk Server 2020: Migration Path
  • On-Demand | July 16, 2020 | Current Vision Enterprise Integration & Automation
  • Collabdays Lisbon | October 10, 2020 | Power Automates: Best Practices, Tips & Tricks
  • Global Microsoft 365 Bootcamp Lisbon 2020 | November 21, 2020 | Power Automates: Best Practices, Tips & Tricks
  • Global Integration Bootcamp Madrid 2020 | November 28, 2020 | BizTalk Server 2020 In Action
  • Integration Use Group | December 07, 2020 | Logic Apps: Development Experiences
  • Developer! Developer! Developer! (DDD2020) | December 12, 2020 | Logic App: Best Practices, Tips & Tricks

For all of you…

Once again, thanks for following me, for reading my blog, and I promise that I will continue to share my knowledge during 2021.

The post Notes From The Road: 2020 Year In Review appeared first on SANDRO PEREIRA BIZTALK BLOG.

Merry Christmas & Happy New Year 2021

Merry Christmas & Happy New Year 2021

HO HO HO, yes, it is that magical time of the year again!… More than other years, this year Christmas is about spending time with close family, the small number possible and family members that you are in contact with every day to due this COVID 19 pandemic. It’s about creating happy memories that will last a lifetime, and we need it more than ever!

This was without a doubt a challenging year for everyone, a year not to forget but to learn and remember, and hoping to start 2021 with a blank page for us to write a better story.

To all my readers, friends, coworkers, customer, partners, to all Microsoft Integration and Azure Community (BizTalk Server, Logic Apps, API Management, Service Bus, and so on), MSFT Product Groups, all the Portuguese Communities, my MVP “family” and of course to my family, my sincere wishes for a Merry Christmas and a Happy New Year!

Thanks in advance for all the support and encouragement given throughout this year. I hope that the next will be a year filled with new distinct contributions. I promise that I will continue to share knowledge, hoping that they can help someone.

This year I had the privilege of receiving a surprise Christmas gift from good friends that intentionally or unintentionally (I believe it was intentional) combine two of my passions/hobbies:

  • Wine enthusiasm and the passion for exploring and taste new wines (you can find more in my Instagram account)
  • And my blog.

So I got this fantastic Blog (Black Label) 2016 Red Wine. Thanks for this amazing gift! No need to mention names. You know who you are 🙂

All the best for the coming year, and most importantly, stay safe!

The post Merry Christmas & Happy New Year 2021 appeared first on SANDRO PEREIRA BIZTALK BLOG.

Deploying local queues (MSMQ) with PowerShell

When migrating your BizTalk Server environment or deploy to a new or different environment, there are many different resources or configurations that you need to take into considerations like:

  • local queue creations
  • cloud queue creations
  • folder creations
  • and so on.

In this blog post, I will address how we can easily “export” a list of existing local private Message Queues (MSMQ) and recreate them, and set proper permissions in a different environment/server.

PowerShell script to extract a list of all private Message Queues (MSMQ) names

With this PowerShell sample, we will be able to extract a list of all private Message Queues (MSMQ) names to a CSV file to be used on a different script to deployed these resources on a different BizTalk Server environment.

set or update the URI (address) or part of the URI on a list of BizTalk Server Receive Locations deployed in your BizTalk Server environment.

Get-MsmqQueue -QueueType Private | 
Select-Object QueueName, Transactional, UseJournalQueue | 
Export-Csv -Path c:tempqueues.csv -Encoding ascii -NoTypeInformation

THIS POWERSHELL SCRIPT IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

You can download this script here: Extract a list of all Private Message Queuing (MSMQ) names to a CSV file with PowerShell

PowerShell script to create private Message Queues (MSMQ)

With this PowerShell sample, we will be able to create local Private Message Queues (MSMQ) and set proper permissions on a different BizTalk Server environment.

New-MsmqQueue -Name $queueName -Label $queueName -QueueType $queueType -Transactional | 
                Set-MsmqQueueAcl -UserName "Everyone" -Allow FullControl

THIS POWERSHELL SCRIPT IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

You can download this script here: Create local Private Message Queuing (MSMQ) and set proper permissions with PowerShell

The post Deploying local queues (MSMQ) with PowerShell appeared first on SANDRO PEREIRA BIZTALK BLOG.

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

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

Well, the thing is, you cannot say to me, “…these stencils look fantastic, but are currently unusable or worthless because…” my brain enters in a crazy mode, and I can only free myself when all the work is finished successfully and that these resources are handy :).

Jokes apart, I use these resources for a long time, I create these for myself, but I knew that they were not perfects. The major problem was that fixing that amount of icons was a time-consuming task. However, with the number of people using these stencils increasing and reporting those problems, I decided to resolve them once and for all.

Today I can announce that I close all the open issues reported on the git repository of this package.

What’s new in this version?

These are the list of changes and additions present in this major release:

  • Restructure of Visio Stencils files (.vssx) names: the package is now composed of 26 Visio Stencils files.
    • Some of them were renamed: PowerApps and Flow is now Power Platform; Files is now Files and Message Types Stencils, …
    • Some were merged: Power BI was merged in the new Power Platform Visio Stencil file; Azure Others was merged in the Azure Additional or Support Stencils, Office365 is now Office, Office 365 and Dynamics 365…
    • New Visio Stencils files: MIS Black and Cyan and MIS Azure Black and Gray;
      • New Organisational Stencils file add by Jacob Mansfield;
  • New shapes: New shapes were added on the majority of the Visio Stencils files (.vssx). Probably the one that was most affected was Azure Stencils and Office, Office 365 and Dynamics 365;
  • Text annotations and connector points: The issues regarding text annotations (legend appear in the center of the icon instead of bellow) and connector points (lack of proper connect points) are now solved in all the Visio Stencils files (.vssx). This was a massive work!
  • Order of the icons: all the icons appear in alphabetic order inside the Visio Stencil file, with the exception in some cases of the first ones that in some case contains the main shape of the context, like in Microsoft Integration Stencils, the first icon is BizTalk Server Logo.
  • Automation: add 3 PowerShell script to this package for you to:
    • Standardize all SVG filenames available in all subfolders by:
      • Not using spaces. Some software will not recognize file names with spaces, and file names with spaces must be enclosed in quotes when using the command line. Having spaces in URL’s are also not a good experience and should be avoided. For all these reasons I decided to remove all spaces and replace it will ‘-‘ (dash);
      • Names are in Camel case, where the first letter of each section of text is capitalized (of course respecting the line above), e.g., File-Name.svg
      • Having extension in lowercase, e.g., *.svg
      • List all the detected duplicate files.
    • Automatically install (configure) all the Visio files (*.vssx), so that next time you open Visio, they will be there available;
    • And also the possibility to download the most recent version from GitHub and install it locally;
  • Standardize shape sizes: standardize the shapes sizes in all to be more or less all of the same sizes Visio Stencils files.
  • Fixed some minor stencils layouts;
  • SVG files: new SVG files added.

These changes were a massive job that stole all my free time apart from my work and family time, from the past three weeks! So I hope you appreciate it!

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack it’s a Visio package that contains fully resizable Visio shapes (symbols/icons) that will help you to visually represent On-premise, Cloud or Hybrid Integration and Enterprise architectures scenarios (BizTalk Server, API Management, Logic Apps, Service Bus, Event Hub…), solutions diagrams and features or systems that use Microsoft Azure and related cloud and on-premises technologies in Visio 2016/2013:

  • BizTalk Server
  • Microsoft Azure
    • Integration
      • Integration Service Environments (ISE)
      • Logic Apps and Azure App Service in general (API Apps, Web Apps, and Mobile Apps)
      • Azure API Management
      • Messaging: Event Hubs, Event Grid, Service Bus, …
    • Azure IoT and Docker
    • AI, Machine Learning, Stream Analytics, Data Factory, Data Pipelines
    • SQL Server, DocumentDB, CosmosDB, MySQL, …
    • and so on
  • Microsoft Power Platform
    • Microsoft Flow
    • PowerApps
    • Power BI
  • Office365, SharePoint,…
  • DevOps and PowerShell
  • Security and Governance
  • And much more…
  • … and now non-related Microsoft technologies like:
    • SAP Stencils
Microsoft Integration (Azure and much more) Stencils Pack

The Microsoft Integration Stencils Pack is composed of 27 files:

  • Microsoft Integration Stencils
  • MIS Additional or Support Stencils
  • MIS AI and Machine Learning Stencils
  • MIS Apps and Systems Logo Stencils
  • MIS Azure Additional or Support Stencils
  • MIS Azure Black and Gray
  • MIS Azure Old Versions
  • MIS Azure Stencils
  • MIS Black and Cyan
  • MIS Buildings Stencils
  • MIS Databases and Analytics Stencils
  • MIS Deprecated Stencils
  • MIS Developer Stencils
  • MIS Devices Stencils
  • MIS Files and Message Types Stencils
  • MIS Generic Stencils
  • MIS Infrastructure and Networking Stencils
  • MIS Integration Fun
  • MIS Integration Patterns Stencils
  • MIS IoT Stencils
  • MIS Office, Office 365 and Dynamics 365
  • MIS Power BI Stencils
  • MIS Power Platform Stencils
  • MIS SAP Stencils
  • MIS Security and Governance
  • MIS Servers (Hexagonal) Stencils
  • MIS Users and Roles Stencils
  • Organisational Stencils

That you can use and resize without losing quality, in particular, the new shapes.

Download

You can download Microsoft Integration, Azure, BAPI, Office 365 and much more Stencils Pack for Visio from:
Microsoft Integration Azure Stencils Pack VisioMicrosoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack for Visio
GitHub

The post Microsoft Integration and Azure Stencils Pack for Visio: New major version available (v7.0.0) appeared first on SANDRO PEREIRA BIZTALK BLOG.

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

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

I am always paying attention to requests from members of the community, and whenever I can, I update this stencil pack with requested shapes or functionalities. And this is one of these cases. One of the most common complaints about this stencil pack was/is text annotations. When you try to add a legend on the stencil, the text is in the middle of the icon, instead of underneath. And sometimes the text is white, which doesn’t help also.

Microsoft Integration and Azure Stencils Pack for Visio: text annotation issue

Another recent aspect that came to my attention was the fact that was missing proper connector points, which make it hard to properly connect shapes in a diagram.

Microsoft Integration and Azure Stencils Pack for Visio: connector points issue

Of course, all of these you can manually fix by move the text to the bottom of each shape, change the color of the text and add connector points. But some of these tasks required a more deep knowledge of working with Visio and they are time-consuming. Luckily this work is being made, it may take a while since this package has more than 2000 shapes!

What’s new in this version?

Today I can announce that the first phase is done and the first file, and probably the most important, of this package is fixed:

  • Microsoft Azure (MIS Azure Stencils.vssx): This package contains stencils of Azure Services (original icons) that are available thru the Azure Portal.

The main goal of this release was to solve or improve the user experience regarding text annotations and connector points. In this version, the changes and additions are:

  • Text annotations issue solved: This issue was solved on the stencils present on the Microsoft Azure (MIS Azure Stencils.vssx) file;
  • Proper connector points added: This improved feature was added on stencils present on the Microsoft Azure (MIS Azure Stencils.vssx) file;
Microsoft Integration and Azure Stencils Pack for Visio
  • Fixed some minor stencils layouts;
  • New shapes: New shapes added on Microsoft Azure (MIS Azure Stencils.vssx) and Microsoft Azure: Others (MIS Azure Others Stencils.vssx);

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack it’s a Visio package that contains fully resizable Visio shapes (symbols/icons) that will help you to visually represent On-premise, Cloud or Hybrid Integration and Enterprise architectures scenarios (BizTalk Server, API Management, Logic Apps, Service Bus, Event Hub…), solutions diagrams and features or systems that use Microsoft Azure and related cloud and on-premises technologies in Visio 2016/2013:

  • BizTalk Server
  • Microsoft Azure
    • Integration
      • Integration Service Environments (ISE)
      • Logic Apps and Azure App Service in general (API Apps, Web Apps, and Mobile Apps)
      • Azure API Management
      • Messaging: Event Hubs, Event Grid, Service Bus, …
    • Azure IoT and Docker
    • AI, Machine Learning, Stream Analytics, Data Factory, Data Pipelines
    • SQL Server, DocumentDB, CosmosDB, MySQL, …
    • and so on
  • Microsoft Power Platform
    • Microsoft Flow
    • PowerApps
    • Power BI
  • Office365, SharePoint,…
  • DevOps and PowerShell
  • Security and Governance
  • And much more…
  • … and now non-related Microsoft technologies like:
    • SAP Stencils
Microsoft Integration (Azure and much more) Stencils Pack

The Microsoft Integration Stencils Pack is composed of 27 files:

  • Microsoft Integration Stencils
  • MIS Additional or Support Stencils
  • MIS AI and Machine Learning Stencils
  • MIS Apps and Systems Logo Stencils  
  • MIS Azure Additional or Support Stencils
  • MIS Azure Mono Color
  • MIS Azure Old Versions
  • MIS Azure Others Stencils
  • MIS Azure Stencils
  • MIS Buildings Stencils
  • MIS Databases and Analytics Stencils
  • MIS Deprecated Stencils
  • MIS Developer Stencils
  • MIS Devices Stencils
  • MIS Files Stencils
  • MIS Generic Stencils
  • MIS Infrastructure Stencils
  • MIS Integration Fun
  • MIS Integration Patterns Stencils
  • MIS IoT Devices Stencils
  • MIS Office365
  • MIS Power BI Stencils
  • MIS PowerApps and Flows Stencils
  • MIS SAP Stencils
  • MIS Security and Governance
  • MIS Servers (HEX) Stencils
  • MIS Users and Roles Stencils

That you can use and resize without losing quality, in particular, the new shapes.

Download

You can download Microsoft Integration, Azure, BAPI, Office 365 and much more Stencils Pack for Visio from:
Microsoft Integration Azure Stencils Pack VisioMicrosoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack for Visio
GitHub

The post Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.3.0) appeared first on SANDRO PEREIRA BIZTALK BLOG.

Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.2.0)

Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.2.0)

Once again, I update this stencil pack with requested shapes from community members: Azure HL7 FHIR (Fast Healthcare Interoperability Resource) and Azure Synapse Analytics. The result was the addition of 16 new shapes. I hope you enjoy it.

What’s new in this version?

The main goal of this release was to provide the new icons present in the Azure Portal and update existing ones. In this version, the changes and additions are:

  • New shapes: New shapes added on MIS Apps and Systems Logo Stencils, Microsoft Integration Stencils, MIS Users and Roles Stencils, MIS Files Stencils, MIS Azure Others Stencils, and MIS Azure Stencils;
  • SVG Files: Add new SVG files, and uniform all the filenames;

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack it’s a Visio package that contains fully resizable Visio shapes (symbols/icons) that will help you to visually represent On-premise, Cloud or Hybrid Integration and Enterprise architectures scenarios (BizTalk Server, API Management, Logic Apps, Service Bus, Event Hub…), solutions diagrams and features or systems that use Microsoft Azure and related cloud and on-premises technologies in Visio 2016/2013:

  • BizTalk Server
  • Microsoft Azure
    • Integration
      • Integration Service Environments (ISE)
      • Logic Apps and Azure App Service in general (API Apps, Web Apps, and Mobile Apps)
      • Azure API Management
      • Messaging: Event Hubs, Event Grid, Service Bus, …
    • Azure IoT and Docker
    • AI, Machine Learning, Stream Analytics, Data Factory, Data Pipelines
    • SQL Server, DocumentDB, CosmosDB, MySQL, …
    • and so on
  • Microsoft Power Platform
    • Microsoft Flow
    • PowerApps
    • Power BI
  • Office365, SharePoint,…
  • DevOps and PowerShell
  • Security and Governance
  • And much more…
  • … and now non-related Microsoft technologies like:
    • SAP Stencils
Microsoft Integration (Azure and much more) Stencils Pack

The Microsoft Integration Stencils Pack is composed of 27 files:

  • Microsoft Integration Stencils
  • MIS Additional or Support Stencils
  • MIS AI and Machine Learning Stencils
  • MIS Apps and Systems Logo Stencils  
  • MIS Azure Additional or Support Stencils
  • MIS Azure Mono Color
  • MIS Azure Old Versions
  • MIS Azure Others Stencils
  • MIS Azure Stencils
  • MIS Buildings Stencils
  • MIS Databases and Analytics Stencils
  • MIS Deprecated Stencils
  • MIS Developer Stencils
  • MIS Devices Stencils
  • MIS Files Stencils
  • MIS Generic Stencils
  • MIS Infrastructure Stencils
  • MIS Integration Fun
  • MIS Integration Patterns Stencils
  • MIS IoT Devices Stencils
  • MIS Office365
  • MIS Power BI Stencils
  • MIS PowerApps and Flows Stencils
  • MIS SAP Stencils
  • MIS Security and Governance
  • MIS Servers (HEX) Stencils
  • MIS Users and Roles Stencils

That you can use and resize without losing quality, in particular, the new shapes.

Download

You can download Microsoft Integration, Azure, BAPI, Office 365 and much more Stencils Pack for Visio from:
Microsoft Integration Azure Stencils Pack VisioMicrosoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack for Visio
GitHub

or from :

You can download Microsoft Integration, Azure, Power Platform, Office 365 Stencils Pack for Visio 2019 from:

Microsoft Integration, Azure, Power Platform, Office 365 Stencils Pack for Visio 2019 (21,1 MB)
Microsoft | TechNet Gallery

The post Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.2.0) appeared first on SANDRO PEREIRA BIZTALK BLOG.

Notes From The Road: 2019 Year In Review

Notes From The Road: 2019 Year In Review

2019 was a very challenging year. Nevertheless, it was another great year both on a personal and professional level, if last year I described as a family year this one it was a consolidation year.

  • If last year I moved my family to a bigger house, this year we made all the necessary modifications to the home of our dreams;
  • If my team at DevScope grew at the end of 2018, 2019 was a year of consolidation, and we hope it will continue to grow during this year in terms of business but full of challenging and great projects worldwide. We are doing a fantastic job;
  • My Porto Airbnb host house is running smoothly, with good reviews from our guests. Nevertheless, there is always space for improvement.
  • And who knows me knows that one of my passions is to enjoy a glass of good wine, so I’m delighted to have my first wine cellar draft (it will be improved in the future)
  • But with all of these renovations, it was also a year
    that I had to dedicated more time to the family – something that was delightful!
  • And I got married…

My Blog is growing every year…

So, once again, I struggle to have free time, but when you love what you do, you will always find a way to do it. So, in the end, I was able to:

  • Publish 43 new posts on my blog; it was indeed the year I publish fewer blog posts since I started my blog, but to be honest, I compensate in other aspects!
    • More than 431,000 visits to my blog – that’s an average of 1,181 visits per day!
      • That is almost double of last year. And the best year ever.
    • Coming from 207 countries across the world in the past year.
      • 13 new locations compare to the previous year
    • And the countries that most visited my blog still are the United States, followed by India, the United Kingdom, and Canada

Not bad if we compare to previous years:

  • 2018: 246,381 visits, 194 countries, 70 new posts
  • 2017: 210,000 visits, 167 countries, 63 new posts (migrate to a new blog)
  • 2016: 318,576 visits, 190 countries, 50
    new posts
  • 2015: 350,000 visits, 184 countries, 79 new
    posts
  • 2014: 310,000 visits, 183 countries, 52
    new posts
  • 2013: 200,000 visits, 176 countries, 79
    new posts
  • 2012: 170,000 visits, 171 countries, 102
    new posts
  • 2011: 91,000 visits, 61 new posts

I want to say thanks to all my readers. I appreciate all the visits to my
blog, and thanks for your support.

Attractions in 2019

These are the top 10 posts that got the most views in 2019:

  1. A fish out of water: Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created with 82,876 views
  2. BizTalk Assessment: .NET Runtime Optimization Service causing high CPU usage with 36,387 views
  3. SQL Server Management Studio (SSMS): The Visual Studio component cache is out of date. Please restart Visual Studio with 18,915 views
  4. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security with 15,125 views
  5. Microsoft Integration (Azure and much more) Stencils Pack v3.0.0 for Visio with 14,048 views
  6. SQL Server detected a logical consistency-based I/O error: incorrect pageid in BizTalkMsgBoxDb database with 12,965 views
  7. New Office365 icons are now included in Microsoft Integration (Azure and much more) Stencils Pack v3.1.1 for Visio with 8,255 views
  8. Microsoft Flow: How to pass the SQL data table results in a Markdown-formatted table into an Email notification or Approval Requests with 6,852 views
  9. TypeLoadException: Could not load type ‘type name’ from assembly ‘assembly name, Version=1.0.0.0, Culture=neutral, PublicKeyToken=…’ with 6,078 views
  10. BizTalk Server 2020… is coming at the end of CY 2019 with 5,905 views

And these are some of my favorite post
that I enjoyed writing in 2019:

Open Source Contributions…

I told earlier that this was the year I wrote fewer
blog posts in my blog. On the other hand, this was the year I published more
open source contributions like code samples, tools, and resources. Here is the
current list of all my contributions:

  • Migrate all the code samples that existed in Microsoft Code Gallery that shut down to a GitHub repository: BizTalk Server Learning Path that includes nothing less than 46 code samples that will help you understand and improve different skill in BizTalk Server.
  • Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack continues to be updated with new releases. The last time I counted already includes nearly 2150 shapes that will help you visually represent Integration architectures (On-premise, Cloud or Hybrid scenarios) and Cloud solutions diagrams.
  • BizTalk Scheduled Task Adapter repo includes an in-process receive adapter that executes a prescribed task on a daily, weekly or monthly schedule.
  • And the creation of a public repository for Microsoft BizTalk Server open source community extensions: code samples, BizTalk Artifacts (components), adapters, tools and so on: BizTalk Server Open Source Community that at the moment already includes 5 tools and 3 resources:
    • BizTalk Port Multiplier Tool is a simple tool that aims to simplify this process by allowing you to easily “clone or duplicate” an existing port (Receive Port or Send Port).
    • BizTalk Filter Finder Tool is a simple tool that aims to simplify the process for better understand and maintain solutions based on content-based routing and context-based routing with or without orchestrations involved.
    • BizTalk Pipeline Components Extensions Utility Pack is a set of custom pipeline components (libraries) with several custom pipeline components that can be used in received and sent pipelines, which will provide an extension of BizTalk out-of-the-box pipeline capabilities.
    • BizTalk Mapper Extensions UtilityPack is a set of libraries with several useful functoids to include and use it in a map, which will provide an extension of BizTalk Mapper capabilities.
    • BizTalk MapperExtensions Functoid Wizard is a Custom Functoid Project Wizard for Visual Studio. It allows you to create a new Functoids project for BizTalk Server without having to create manually the project.
    • SSO Application Configuration tool that provides the ability to add and manage applications, add and manage key-value pairs in the SSO database, as well as import and export configuration applications so that they can be deployed to different environments.

Other contributions…

And of course, several other publications outside my
blog.

A year of speaking engagements…

However, that not all! I still was
able to deliver 9 sessions:

  • XLVIII Porto.Data Community Meeting | January 30, 2019
    | How we use Microsoft Flow and PowerApps: Real cases scenarios
  • Integration Use Group | February 4, 2019 | The
    NoS-addin – your (free) BizTalk Dev buddy!
  • Integration Down Under | February 14, 2019 | How we
    are using Microsoft Integration features and related Azure technologies to
    improve our processes
  • Global Integration Bootcamp 2019 Madrid | May 30, 2019
    | Real case implementations using Azure Logic Apps and/or Microsoft Flows
  • Global Azure Bootcamp 2019 Lisbon | April 27, 2019 |
    How we are using Logic Apps (and/or Microsoft Flow): Real cases scenarios
  • INTEGRATE 2019 UK London | June 3-5, 2019 | BizTalk
    Server Fast & Loud Part II
  • INTEGRATE 2019 USA – Redmond | June 24-26, 2019 |
    BizTalk Server Fast & Loud Part II
  • PBIPT #7 | July 2, 2019 | Power BI Service, Flow,
    PowerApps and all together!
  • DevScope CSI | October 4, 2019 | Diagnosis – How are
    your Flow’s: Best Practices, Tips and Tricks

And several workshops and
training course during 2019:

  • Developing Business Process and Integration Solutions
    Using Microsoft BizTalk Server 2016 training  course
  • BizTalk Server 2016: Developer and Administration
    (OAM) training course
  • Get started with Microsoft PowerApps and Flow training
    course
  • Microsoft Integration Workshop London | October 28-29

For all of you…

Once again, thanks for following me, for reading my blog, and I promise that I will continue to share my knowledge during 2020.

The post Notes From The Road: 2019 Year In Review appeared first on SANDRO PEREIRA BIZTALK BLOG.