Notes From The Road: 2021 Year In Review

Posted: January 3, 2022  |  Categories: Other

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.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Leave a Reply

Your email address will not be published. Required fields are marked *

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top