His main focus is on Integration Technologies where he has been using .NET, BizTalk and SOAP/XML/XSLT since 2002 and Windows Azure. Sandro is very active in the BizTalk community as a blogger (http://sandroaspbiztalkblog.wordpress.com/), member and moderator on the MSDN BizTalk Server Forums, TechNet Wiki author, Code Gallery and CodePlex contributor, member of BizTalk Brazil community (http://www.biztalkbrasil.com.br/), NetPonto community (http://netponto.org/), BiztalkAdminsBlogging community (http://www.biztalkadminsblogging.com), editor of the magazine “Programar” (http://www.revista-programar.info), public speaker and technical reviewer of "BizTalk 2010 Cookbook", Packt Publishing book.
He has been awarded the Microsoft Most Valuable Professional (MVP) since January 2011 for his contributions to the world-wide BizTalk Server community and is a certified MCTS: BizTalk Server BizTalk Server 2006 and BizTalk Server 2010.
Table of Contents
Note: This is a "User Page" (click for a list of all user pages on TechNet Wiki). User pages on TechNet Wiki exist for the following reasons: (1) To link to these pages from various online profiles, blog posts, etc. (2) To allow collaboration on filling out such information. (3) To allow easy editing for filling out such information. (4) To act as an aggregation or collection of links that help define what a person does.
Profiles
Sandro's MVP Profile:Sandro's MSDN Profile:
Blogs
Sandro shares his knowledge around BizTalk Server and the value of contributing in the community through:- His personal blog: http://sandroaspbiztalkblog.wordpress.com
- BizTalk Administrators: http://www.biztalkadminsblogging.com
Community Member
Besides publishing in blogs, Sandro is also member of the following communities where he shares his knowledge through speaking engagements or articles on BizTalk Server:- NetPonto community: http://netponto.org/membro/sandro-pereira/
- Magazine “Programar”: http://revista-programar.info/?action=members&type=viewMember&n=115
BizTalk Innovation Day
BizTalk Innovation Day is a one-day event focused purely on Microsoft BizTalk Server related topics that has been conducted in several major European cities since Feb 2011: Amsterdam (Netherland), Milan (Italy), Stavanger (Norway), London (UK) and Porto
(Portugal).
Sandro is member of BizTalk Crew that are responsible to organize this events along with MVP's: Steef-Jan Wiggers, Tord Glad Nordahl, Saravana Kumar and Nino Crudele.
You can follow BizTalk Innovation Day
through its Facebook page:
https://www.facebook.com/BizTalkInnovationDay
TechNet Wiki
Sandro is the author of the following English contributions on the TechNet Wiki:BizTalk Server:
- Installing BizTalk Server 2010 in a Basic Multi-Computer Environment
- BizTalk: List of Errors and Warnings, Causes and Solutions
- BizTalk Server: List of Macros
- BizTalk Server: Basics principles of Maps
- BizTalk: Blogroll
- BizTalk Server: How Maps Work
- BizTalk Server: List of Custom Adapters
- BizTalk Server: List of Third-Party Adapters
- BizTalk Server: Transform text files (Flat Files) into XML
- Microsoft BizTalk Server seen by the programmer’s eyes
- BizTalk Server: BizTalk Mapper Patterns
- Installing and configuring BizTalk Server 2010 in a Standalone machine
- Training Resources for BizTalk Developer
- Training Resources for BizTalk Administrators
- BizTalk Server: Redistributable CAB Files
- BizTalk Server: Presentations Gallery
- List of Service Packs and Cumulative Updates available for BizTalk Server
- BizTalk Server: Webcasts and Videos
- BizTalk Server: Glossary
- BizTalk Server Best Practices: Create and Configure BizTalk Server Host and Host Instances
- BizTalk Server: Backup BizTalk Server job failed Troubleshooting
- BizTalk Server: How to map values from a repeating node into a single node using conditions
- BizTalk Server: Grouping and Sorting Operations Inside BizTalk Maps Using the Muenchian Method
- BizTalk Server: Summary of SQL Server versions supported
- BizTalk Server 2010: Step-by-Step to implement Unit Testing in Schemas and Maps
- BizTalk Server 2013: Step-by-Step to implement Unit Testing in Schemas and Maps
- BizTalk Server: Installing the new BizTalk Health Monitor snap-in on BizTalk Server 2010 or BizTalk Server 2013
- BizTalk Server 2013 R2: WCF-SAP Adapter Step-by-Step Installation Guide
- BizTalk Server: How to upgrade BizTalk Health Monitor from a previous version to the latest one
Microsoft Azure BizTalk Services:
- Azure BizTalk Services resources on the TechNet Wiki
- Azure BizTalk Services: Webcasts and Videos
- Azure BizTalk Services: Code Gallery Samples
- Azure BizTalk Services: List of Errors and Warnings, Causes and Solutions
- Migrating BizTalk Server maps to Azure BizTalk Services maps
Wiki Life:
- Wiki: Templates For Converting a Forum Thread Into a New Wiki Article
- Wiki: Best Practices For Converting a Forum Thread Into a New Wiki Article
- Wiki: Errors or Troubleshooting Template Format
- Wiki: Questions and Solutions Template Format
- Guia de Sobrevivência: BizTalk Server 2010
- Exemplos de BizTalk Server disponíveis no Code Gallery
- BizTalk Server - Como funcionam os mapas
- BizTalk Server - Princípios básicos dos Mapas
- Microsoft BizTalk Server aos olhos dos programadores
- BizTalk Server: Livros
- BizTalk Server - Transformar arquivos de texto (Flat Files) em XML
- BizTalk Server: Lista de Versões
- Recursos BizTalk Server no TechNet Wiki
- Recursos Windows Phone no TechNet Wiki
WikiNinjas - Official Blog of TechNet Wiki
Sandro has written the following blog posts:- Interview with a SharePoint MVP – André Lage
- Defining the Role of an TechNet Wiki Editor
- Interview with a Wiki Ninja: Lex Hegt
- BizTalk TechNet Wiki Articles: Can I? or Should I?
- TechNet Wiki Magazine First Edition | PowerShell, SQL, SharePoint, Windows Server 2012, Windows Phone 8, BizTalk Server and TechNet Wiki Blog
- TechNet Wiki Magazine Second Edition | MVC5, SQL, BizTalk Server, SharePoint, C#, Visual C#, Small Basic, Windows Store and Windows Phone Apps, eBooks and TechNet Wiki Blog
- TechNet Wiki Magazine Third Edition | TechNet Wiki, Reporting Services, Power Pivot, Windows Server 2012 R2, SharePoint, BizTalk Server, WPF, LINQ, Active Directory, Windows 8.1 and XAML
- Interview with a Wiki Ninja: João Eduardo Sousa
- TechNet Wiki Magazine Fourth Edition | TechNet Wiki Ninjas, TFS, Office365, Windows Phone, SharePoint, BizTalk Server and Services, CRM, SQL Server and Windows Azure
- Interview with a BizTalk Wiki Ninja: Tomasso Groenendijk
- TechNet Wiki Magazine Fifth Edition | Microsoft Azure, Transact-SQL, Lync, Power Pivot, System Center, BizTalk Server and Services, Office 365, Windows Phone, SharePoint, SQL Server and many more
- TechNet Wiki Magazine Sixth Edition | Wiki Ninjas, Business Intelligence, Microsoft Azure, SharePoint, Windows Phone, AD, BizTalk Server, SQL Server and many more
- The most unseen and unspoken TechNet Wiki roles: The mentor Role
- Interview with a Visual C# MVP Wiki Ninja - Sara Silva
- TechNet Wiki Magazine Seventh Edition | Wiki Ninjas, Lync, Yammer, Windows Phone, Apps, System Center and many more…
- TechNet Wiki Magazine Eighth Edition | Calling for new TechNet Wiki Ninja Heroes, Mobile Services, Azure, C# and many more…
- TechNet Wiki Magazine Ninth Edition | Merry Christmas and a very creative Happy New Year...
- TechNet Wiki Magazine Tenth Edition | TechNet Wiki Summit... all about sharing knowledge.
Code Gallery
Sandro has made the following contributions to code gallery:- BizTalk Mapper Extensions UtilityPack for BizTalk Server 2010
- How to Call Orchestrations developed in a different Visual Studio Solution
- BizTalk Server – Transform text files (Flat Files) into XML
- Calling an external assembly from Custom XSLT in BizTalk Server 2010 Maps
- BizTalk MapperExtensions Functoid Wizard
- Using EDI Bridge to exchange B2B messages in Windows Azure Service Bus
- EAI Bridge Message Sender and Queue Message Receive
- Handling Exceptions inside BizTalk Orchestrations
- Call Orchestration from another project or from another BizTalk Application
- BizTalk Mapper Patterns: How to Map Hierarchical Schema to a Name Value Pair
- Understanding Content Based Routing in EAI Bridges
- BizTalk: Accessing and change message values inside orchestration
- BizTalk Mapping - Selecting distinct nodes (grouping)
- Using EAI Bridges and LOB Target to connect to on-premises SQL Server
- BizTalk Mapper Patterns: How to Map Name Value Pair to a Hierarchical Schema
- Multi-Part Message Attachments Zipper Pipeline Component for BizTalk 2006/2009
- BizTalk Server – Basics principles of Maps
- How to implement multi-level Muenchian grouping in BizTalk Maps
- How to map values from a repeating node into a single node using conditions
- Grouping elements from different messages in BizTalk Maps
- Muenchian Grouping and Sorting in BizTalk Maps without losing Map functionalities
- BizTalk Multi-part Message Attachments Zipper Pipeline Component
- BizTalk Mapper Extensions UtilityPack for BizTalk Server 2006
- Customize filename dynamically inside BizTalk Orchestration
- BizTalk Mapper Patterns: How to Send Orchestration Variables Into Maps
- BizTalk Mapper Patterns: Working with Constant Values inside maps
- BizTalk Mapper Patterns: Working With Multiple Output Messages (Spliting Msgs)
- BizTalk Mapper Patterns: Working with Multiple input messages or joining message
- BizTalk Mapper Extensions UtilityPack for BizTalk Server 2006/2009
- BizTalk Mapper Extensions UtilityPack for BizTalk Server 2013
- BizTalk Mapper Patterns: How to Send Orchestration Variables Into Maps
- Automatically Link The Record Elements By Structure, Name or Using Mass Copy
- BizTalk Mapper: External Custom XSLT file vs BizTalk Mapper (Best Practices)
- Migrating BizTalk Server maps to Azure BizTalk Services maps
- BizTalk Mapper Patterns: Content Filter Pattern (Data Cleaning Pattern)
- BizTalk Mapper Patterns: Sorting Pattern
- BizTalk Mapper Patterns: Conditional Pattern
- BizTalk Mapper Patterns: Looping Pattern
- BizTalk Mapper Patterns: Canonical Data Model Pattern
- BizTalk Mapper: Working With Nillable Values (xsi:nil="true")
- BizTalk Mapper: When to use the Ignore Namespaces for Links property
- BizTalk Mapper: OptimizeValueMapping attribute of the mapsource element
- BizTalk Mapper: GenerateDefaultFixedNodes attribute of the mapsource element
- BizTalk Mapper: PreserveSequenceOrder attribute of the mapsource element
- BizTalk Mapper: Method (Grid Property) explained
- BizTalk Mapper: Copy Processing Instructions (PIs) (Grid Property) explained
- BizTalk Mapper: TreatElementsAsRecords attribute of the mapsource element
- BizTalk Server 2013: Using the Unit Testing Feature with Schemas and Maps
- BizTalk Server 2010: Using the Unit Testing Feature with Schemas and Maps
- BizTalk Mapper: Built-in Functoids, Scripting Functoid and Custom Functoids
- BizTalk Mapper: Omit XML Declaration (Grid Property) explained
- BizTalk Server: Moving Event Source To Different Event Log (Administration)
- BizTalk Mapper: How to use Database Lookup Functoid
TechNet Gallery
Sandro has made the following contributions to TechNet gallery:- Collection of Visio 2010 Stencil for BizTalk Server
- Collection of Visio 2013 Stencil for BizTalk Server
- Monitoring disk spaces in your BizTalk environment with PowerShell
- How to set SQL Server Network Protocols in the SQL Server for BTS Databases
- Monitoring SQL Agent Jobs in your BizTalk environment with PowerShell
- BizTalk Mapper: Custom Extension XML property fix with PowerShell (BizTalk 2010)
- Determining the process ID of BizTalk Host Instances
- Pre-allocate space and define auto-growth settings for BizTalk Server databases
- XML-RPC Schema
- Obtain a list of “BizTalk Software Inventory�� installed with PowerShell
- BizTalk Server 2013 logo in vector format
- BizTalk Server 2010 logo in vector format
- Item Template for Visual Studio 2010: Custom BizTalk Functoid
- Configure BizTalk Services to start automatically after a system restart
- Query for list all users with access to BAM Primary Import database
- Query for list all users with access to specify BAM View
- PowerShell to Configure BizTalk Server Host and Host Instances
- Enable all the requires IIS features for BizTalk Server with PowerShell
- Monitoring Windows Updates and Pending Restarts on the servers using PowerShell
- BizTalk Infrastructure and Solution Overview Samples
- Force Full Backup BizTalk Server (BizTalkMgmtDb) Job
- BizTalk Server: Cleaning MarkLog Tables According to Some of the Best Practices
- BizTalk 2006: Cleaning MarkLog Tables According to Some of the Best Practices
- BizTalk Server 2013 R2 logo in vector format
- BizTalk Server 2013: Wrapper classes to perform Unit Testing in Maps
- BizTalk Magazine - September 2014 Edition
- BizTalk DevOps: How to Disable Tracking Settings in BizTalk Server Environment
- SQL Query to Enable All BizTalk SQL Server Agent jobs
- SQL Query to Disable All BizTalk SQL Server Agent jobs
- BizTalk Server 2013 R2: Fix for SSO Configuration Application MMC Snap-In
- PowerShell to Configure BizTalk Server 2013/2013 R2 Host and Host Instances
- BizTalk Server 2013: Fix for SSO Configuration Application MMC Snap-In
- TNWiki Summit 2015 Presentation: From Forums to Wiki: Templates
- BizTalk DevOps: Moving an Event Source To a Different/Custom Windows Event Log
- Another way to monitor BizTalk SQL Agent Jobs with PowerShell
- Monitoring Event Viewer Errors in your BizTalk environment with PowerShell
- Collection of Microsoft Integration Stencils for Visio 2013
Books and White Papers
Sandro wrote the following Books:- BizTalk Mapping Patterns & Best Practices: A 400-page recipe for BizTalk Developers to develop effective, robust, and organized maps
- How to install and configure BizTalk360 on BizTalk Server 2013 standalone machine running on Windows Server 2012
- Installing and Configuring BizTalk360 on Windows Server 2012 / BizTalk Server 2013 (user guide)
Sandro was technical reviewer of the following white papers:
- Proactively keep an eye on health of your Microsoft BizTalk Server Environments
- How to Properly Administer and Operate a BizTalk Server Infrastructure
- Supportability and operations of Microsoft BizTalk Server
- WCF-BasicHttpRelay Adapter Deep Dive (White Paper)
Events
You can see the following Sandro online video session:- BizTalk Server tips and tricks for developers and admins at BizTalk Summit 2015 London
- BizTalk Mapping Patterns and an Introduction to WABS Maps at BizTalk Summit 2014 London
- Windows Azure BizTalk Services at BizTalk Summit 2013 London
Other Contributions
Sandro also contributed to the following projects:
- BizTalk Maturity Assessment
- BizTalk Scheduled Task Adapter
- BizTalk Mapper Extensions UtilityPack
- BizTalk Multi-part Message Attachments Zipper Pipeline Component
Certifications
Sandro has the following certifications:- MCTS: Microsoft BizTalk Server 2006
- MCTS: Microsoft BizTalk Server 2010