Posts Tagged ‘Other’

Here’s two incredible facts: 318576 views were made to my blog last year, being that, the country that most visited was the United States, followed by India, United Kingdom and Sweden.

01-Sandro-Pereira-blog-2016-Country-Stats

(In 2016, there was 50 new posts, growing the total of this blog to 534 posts)

And I had the opportunity, as a speaker, to present 14 sessions! A new personal record…

02-Sandro-Pereira-Speaker-Engaments-2016

So once again let’s look back and reflect into what happened in 2016. In a few words, it was an interesting and challenge year both personal and professional!

My selected Highlights of 2016

Sharing my book with the community

03-BizTalk-Mapping-Patterns-Book-sharing04-BizTalk-Mapping-Patterns-Book-2016

Physical print copies of my book “BizTalk Mapping Patterns and Best Practices” was sold or give away in several Integration events last year like: Integrate 2016 London, BizTalk User Group Sweden in Stockholm and Gothenburg or TechMeet360. And I had the privilege of being present in most of them…

05-BizTalk-Mapping-Patterns-Book-106-BizTalk-Mapping-Patterns-Book-2

(Pro Integration Group PM Jim Harrer photobombing one of the pictures)

And I had – as a “well know writer” – my first book signing event experience at Integrate 2016 London – I felt a little awkward/strange to sign copies of my book, it’s not something I’m used to, strange, but a very pleasant and rich experience.

07-BizTalk-Mapping-Patterns-Book-Steej08-BizTalk-Mapping-Patterns-Book-909-BizTalk-Mapping-Patterns-Book-310-BizTalk-Mapping-Patterns-Book-5

(At Integrate 2016 London)

11-BizTalk-Mapping-Patterns-Stockholm12-BizTalk-Mapping-Patterns-Stockholm-2

(At BizTalk User Group Sweden in Stockholm)

13-BizTalk-Mapping-Patterns-Gothenburg14-BizTalk-Mapping-Patterns-Gothenburg-2

(At BizTalk User Group Sweden in Gothenburg)

15-BizTalk-Mapping-Patterns-Book-7

(At TechMeet360 in India)

Thanks Saravana and BizTalk360 for all the work you have done to push and promote my book! Let’s do another one!

First experience at Channel 9 studio

At the MVP Summit 2016 in November, I had the opportunity to record a segment in the Channel 9 studio, that was my first experience, and I have to confess, I was a little nervous to be recording in a small professional studio, so as I was expecting after seeing the record in its raw state, the end result could have been better, but, for a first experience it went pretty well. The important for me is to face new challenges, different situations, leave my comfort zone and improve to be better next time. The segment is not public yet, but I will be sure to post when it is.

16-Sandro-Pereira-Channel917-Sandro-Pereira-Channel9-2

Fortunately, I had the company of my good friend Kent Weare in this small “adventure”:

18-Kent-Weare-at-channel-919-Kent-Weare-at-channel-9-2

He is probably one of the few people that I know that I wasn’t able to convince him to buy my book. Instead, he tried to convince me that he could help him sell more books  if I gave him a free copy 🙂

20-BizTalk-Mapping-Patterns-Book-Kent

TUGA IT 2016

Being responsible to organize the Integration track and one Integration Workshop at TUGA IT event, one of the major biggest events in Portugal that targets several distinct technologic areas like SharePoint and Office 365, Azure Infrastructure, Data Platform, Programming and Integration (BizTalk, IoT and Azure) and much more.

Having that role, I was able to invite and convince some of my good friends to speak at this event: Nino Crudele, Steef-Jan Wiggers, Sam Vanhoutte and Glenn Colpaert.

21-TugaIT-Steef22-TugaIT-Nino23-TUGAIT-Glenn24-TugaIt-Sam25-TUGAIT-2016

And I was able to perform a one day deep dive workshop about Enterprise Integration with my dear friends Nino Crudele and Steef-Jan Wiggers…. what amazing experience combining three different and experienced experts in one room to share knowledge

26-TUGAIT-Wokshop27-TUGAIT-Wokshop-2

Integrate 2016 London

As always, I was really happy and proud to speak at the biggest integration (Microsoft related technologies) event worldwide: Integrate 2016 London that was amazingly well organized by Saravana Kumar and his BizTalk360 team. The statistics of this year’s INTEGRATE 2016 event stood at 380 attendees, 187 Companies from 22 different countries and the key highlight of the welcome session was the announcement of the availability of a printed version of my “BizTalk Mapping Patterns” book… Once agan,Thanks Saravana and BizTalk360 team!

This event is always an amazing and unique opportunity to learn from some of well-known experts in the field and to meet the people you have been following on Twitter and blogs and other social networks who are interested in the same things you are.

Here is a different perspective of the event… The speaker’s vision:

28-Integrate2016-speaker-view

And here I am with the Microsoft Pro Integration Team and some of the MVPs present at the event:

29-Integrate2016-speakers

MVP Summit 2016, meet the all Microsoft BizTalk team and the reunion of BizTalkCrew

The greatest thing about attending the MVP Summit is the networking part… reconnect with some friends, meet the product group, have great technical discussions and enjoy… and that was exactly what happened this year. I cannot discuss the technical part (NDA) but here is the fun part:

  • I was able to record a session at Channel9 (which I mentioned earlier)
  • Attending my first Seahawks game

31-Me-At-SeaHawks-game31-SeaHawks-2

  • First experience at a Shooting range with most of all BizTalk MVPs… just to confirm that I am not a fun of guns… but it was a really fun experience

32-Me-At-Shooting-range

  • Engagements with the product teams during the event and outside the event… here visiting the Museum of Flight with Mikael Håkansson, Johan Hedberg and Clemens Vasters

33-Me-At-Museam-of-flight

  • Meet the all Microsoft BizTalk team (or Pro Integration Team), here is a picture of some MVPs in meeting room were the Logic App team records their Logic Apps Live webcast

35-Me-At-BizTalk-Product-Group-home

  • And the BizTalk Crew was reunited once again

36-BizTalkCrew-2016

A year of speaking engagements…

Another year full of speaking engagements… I had the opportunity to delivery 14 sessions! Speaking about different topics like: BizTalk Server, Logic Apps, API Management, App Service, Azure Functions, Microsoft Flow or PowerApps, in multiple events across Europe (UK, Sweden and Portugal) and some of them through live meetings. New personal record!

Some of them I already mentioned above but here is the complete list of speaking engagements that I did in 2016:

  • XV Porto.Data Event: Build your first LogicApp from scratch (No slides)

37-XV-EVENTO-PORTO.DATA-Build-your-first-LogicApp

  • Global Azure Bootcamp 2016 Lisbon: The "Apps" World: Logic, API & PowerApps

38-Global-Azure-Bootcamp-2016-Lisbon-Logic-API-PowerApp

  • 2 online talks at the Integration User Group: Creating reusable pieces in Logic Apps and BizTalk Mapping Patterns and Best Practices
  • Integrate2016 London: A new set of BizTalk Server Tips and Tricks

39-Sandro-Pereira-Speaker-Integrate2016-240-Sandro-Pereira-Speaker-Integrate2016

Where I also gave away BizTalk T-Rex stickers to the attendees:

41-Sandro-Pereira-Speaker-Integrate2016-stickers

  • Tuga IT 2016: One session: BizTalk Server Deep Dive Tips & Tricks for Developers and Admins; and one workshop: Enterprise Integration Workshop

42-TUGAIT-Sandro-Pereira43-TUGAIT-Sandro-Pereira-2

  • BizTalk User Group Sweden in Stockholm: BizTalk Mapping Patterns and Best Practices

44-BizTalk-User-Group-Sweden-Stockholm-Sandro

  • BizTalk User Group Sweden in Gothenburg: BizTalk Mapping Patterns and Best Practices

45-BizTalk-User-Group-Sweden-Gothenburg-Sandro

  • 12ª NetPonto Porto Meeting: API Management: Rise of the Planet of the Apps

46-Sandro-Pereira-Speaker-NetPonto-201647-Sandro-Pereira-Speaker-NetPonto-2016-2

  • XXIII Porto.Data Event: API Management: Rise of the Planet of the Apps

48-Sandro-Pereira-Speaker-XXIII-PortoData-2

(I had this event two weeks after my surgery, was still in recovery and that why my sporty look on stage)

  • DevScope CSI: SharePoint integration: How can PowerApps and Microsoft Flow give power to your SharePoint users
  • SPS Lisbon 2016: SharePoint integration: How can PowerApps and Microsoft Flow give power to your SharePoint users

49-SPSLisbon-Sandro-Pereira-450-SPSLisbon-Sandro-Pereira

  • Instituto Superior de Engenharia do Porto (ISEP): API Management: Rise of the Planet of the Apps

For me is always a great honor and joy to be participating in these type of events, either as speaker or attendee, be with old friends, meet new people and share knowledge!

And yet I had the opportunity once again to attend some events like:

  • MVP Global Summit 2016
  • MVP Open-Day 2016 (Rome)
  • A few SQLPort and Porto.Data Community events;
  • An incalculable number of internal training events at DevScope;
  • And more
My Blog is growing every year…

Very special thanks to all my reader. I really appreciate the 318,576 visits to my blog (in a total of 1456497 views since I’ve migrated to WordPress), from 187 countries in the past year. And even with all the speaking events that I had, I still was able to write 50 new posts.

The posts that got the most views in 2016 were:

  1. BizTalk Server 2013 R2: Installation and Configuration – Install and Configure BizTalk Server 2013 R2 (Part 9) posted in January 2015
  2. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security. posted in February 2012
  3. BizTalk 2013 Installation and Configuration – Install and Configure BizTalk Server 2013 (Part 9) posted in May 2013
  4. BizTalk Server 2013 R2: Installation and Configuration – Important considerations before set up the server (Part 1) posted in January 2015
  5. BizTalk 2013 Installation and Configuration – Important considerations before set up the server (Part 1) posted in May 2013

However, my 3 favorite’s posts that I enjoyed writing last year was:

Still contributing in TechNet Wiki and provide several BizTalk Open Source Contributions

And as has been the case in recent years, I’m BizTalk Technet Contributor, were I write articles in Microsoft TechNet Wiki and BizTalk TechNet moderator. I’m also member of the TechNet Wiki Community Council and TechNet Wiki Ninja Blogger.

And many other contributions….

And as always Besides community work…

… of course, friendship, family, travelling and running were also important things as always!

51-Me-with-Tommaso-Mikael58-Dinner-at-Summit

  • 2016 I had the pleasure to have a mini vacation (3 days) with my greatest friend: Nino Crudele and is family… thanks for having us in your home

52-vacations-2016-Nino-253-vacations-2016-Nino

  • Travelling (for work and pleasure) … I was able to visit two new countries: Sweden and The Netherlands (Where I enjoyed a nice dinner with Steef-Jan Wiggers and his family, I also visited their home … thank you!)

54-2016-Travelling-Netherlands55-2016-Travelling-Sweden

  • And finally… Portugal won their first European Championship

56-Portugal-Won-Euro2016

And this means that these two guys will were Pepe jersey in the upcoming Integrate 2017 in London during their presentation: Steef-Jan Wiggers and Mikael Håkansson

57-Steef-Jan-and-Mikael

(Kent Weare in the picture was the only one supporting Portugal, so he will be there with me enjoying this moment)

Thanks for following me, for reading my blog and I promise that I will continue to share my knowledge during 2017.

So what happened in 2015? Many things! But, shortly, it was a good year both personal and professional, the end of last year was crazy in terms of projects, so crazy that I didn’t had any free time to write new posts on my blog (a thing that I enjoy doing)… I even thought I had published a few posts this year (at least considerably less than last year)… SURPRISE! Despite all that I still was able to publish 27 more post than last year, in a total of 97 post!

In 2015, there were 79 new posts, growing the total archive of this blog to 482 posts.

Microsoft-WebCamp-Lisbon-December-2-2015-2

BizTalk Mapping Patterns and Best Practices is now a physical book…

Thanks to BizTalk360 (the publisher), my first book is now able as a physical print copy!! This is a book completely free for the community. A book that was announced in Oslo, Norway during the BizTalk Innovation day of 2014.

BizTalk Mapping Patterns and Best Practices” book is a 400-page recipe that offers insights on how maps work, the most common patterns in real time scenarios, and best practices for BizTalk Developers to develop effective, robust, and organized maps. The book has as technical reviewers Steef-Jan Wiggers, Nino Crudele, Michael Stephenson and José António Silva and is available for you to download at BizTalk360 website here.

printed-version-book

A year of speaking engagements…

Wow I had the opportunity to be present 13 sessions!!, has a speaker, some of them with completely different topics (TechNet Wiki, several topics about BizTalk Server and of course Logic Apps), in multiple events across Europe (UK, Belgium and Portugal) and some of them through live meetings. That indeed is my personal record so far!

Here is the complete list of speaking engagements that I had in 2015:

  • III Evento da Comunidade Porto.Data | January 22, 2015

III-Evento-Comunidade-Porto.Data-January-22-2015

  • 2 talks in TechNet Wiki Summit 2015 | March 17-18-19, 2015
  • BizTalk Summit London 2015 | April 13-14, 2015

BizTalk-Summit-London-April-13-14-2015BizTalk-Summit-London-April-13-14-2015-2

  • Microsoft MVP Showcase | April 25, 2015

Microsoft-MVP-Showcase-April-25-2015Microsoft-MVP-Showcase-April-25-2015-2

  • Global Azure Bootcamp 2015 | April 25, 2015

Global-Azure-Bootcamp-2015-April-25Global-Azure-Bootcamp-2015-April-25-2

  • BTUG.be – Integration Day 2015 | June 4th, 2015

BTUG.be-Integration-Day-2015-June-4-2015

  • 2 Talks at Integration Monday | August 31 and June 22, 2015
  • XI Porto.Data Community Meeting | September 30, 2015

XI-Porto.Data-Community-Meeting-September-30-2015

  • 2 talks in SQLSaturday#429 Porto | October 3, 2015

SQLSaturday-429-PortoSQLSaturday-429-Porto-2SQLSaturday-429-Porto-3

  • Microsoft WebCamp Lisbon | December 2, 2015

Microsoft-WebCamp-Lisbon-December-2-2015Microsoft-WebCamp-Lisbon-December-2-2015-3Microsoft-WebCamp-Lisbon-December-2-2015-4

For me is always a great honor and joy to be participating in events, either as speaker or attendee, be with old friends, meet new people and share knowledge!

And yet had the opportunity once again to attend some events like:

  • MVP Global Summit 2015

MVP-Global-Summit-2015MVP-Global-Summit-2015-2

  • A few SQLPort and Porto.Data Community events;
  • An incalculable number of internal training events at DevScope;
  • And more
My Blog is growing every year…

Very special thanks to all my reader I really appreciate the 350,000 visits to my blog, from 184 countries in the past year. That’s 40,000 more visits than last year and 150,000 more than 2013!

  • 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

Most visitors came from The United States. India & United Kingdom were not far behind.

And even with all the speaking events that I had I still was able to write 79 new posts.

The posts that got the most views in 2015 were:

  1. BizTalk 2013 Installation and Configuration – Install and Configure BizTalk Server 2013 (Part 9) posted in May 2013
  2. BizTalk 2013 Installation and Configuration – Important considerations before set up the server (Part 1) posted in May 2013
  3. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security. posted in February 2012
  4. BizTalk 2013 Installation and Configuration – Install SQL Server 2012 (Part 7) posted in May 2013
  5. BizTalk 2013 Installation and Configuration – Installing BizTalk Adapter Pack (Part 12) posted in May 2013

However my favorite’s posts that I enjoyed writing last year was:

TechNet Wiki, BizTalk Open Source Contributions

And as has been the case in recent years, I’m BizTalk Technet Contributor were I write articles in Microsoft TechNet Wiki and BizTalk TechNet moderator. I’m also member of the TechNet Wiki Community Council and TechNet Wiki Ninja Blogger.

And many other contributions….

Besides community work…

… of course friendship, family, travelling and running were also important things as always!

  • 2015 I had the pleasure to have 3 great friends in my house/country: Steef-Jan Wiggers, Kent Weare and his wife, and Nino Crudele and is family!

Kent Weare and wifeNino-and-familyNino-and-family-2

  • Besides travelling for speaking events I was able to visit several places in Portugal (a personal choice this year) for pleasure
  • And several MVP Meetings

me-2015

Thanks for following me, for reading my blog and I promise that I will continue to share my knowledge during 2016.

Notes From The Road: 2014 in review

Posted: January 2, 2015 in Other
Tags: , ,

So many things happen in 2014, for me it was a year of radical changes in my life, most of them extremely good others less so but in the end it was once again a professional and personal remarkable year for me.

Released my first book…

In partnership with BizTalk360 (the publisher) and my company DevScope, I was able to produce and publish my first book completely free for the community. A book that was announce in Oslo, Norway during the last BizTalk Innovation day of 2014.

BizTalk Mapping Patterns and Best Practices” book is a 400-page recipe that offers insights on how maps work, the most common patterns in real time scenarios, and best practices for BizTalk Developers to develop effective, robust, and organized maps. The book has as technical reviewers Steef-Jan Wiggers, Nino Crudele, Michael Stephenson and José António Silva and is available for you to download at BizTalk360 website here.
BizTalk-Mapping-Patterns-And-Best-Practices

Multiple speaking engagements…

I had the opportunity to be present, has a speaker, in multiple events across Europe (UK, Norway and Portugal). But the most relevant, due to its main objective, was in April of 2014, where DevScope and I participated on the second Global Windows Azure Bootcamp, an event held in 138 locations around the globe. This allowed all participants to have a one day deep dive class and get up to speed on developing Cloud Computing Applications for Windows Azure. In addition to this great learning opportunity, the hands on labs featured launching a huge global compute farm to perform diabetes research using the contributions (processing time) from all participants all over the globe.

During the event our team (DevScope Team) dedicated a total of 159 of our virtual machines, spread over 5 Azure Datacenters worldwide. The final statistics were recently published and, although not all processing was leveraged, our overall effort is still 38% of all Portuguese contribution.

Overall Statistics for DevScope, Portugal

  • Total worker role instances: 140
  • Total targets processed: 1441
  • Total processing time: 5 days 14 hours 8 minutes.

Here is the complete list of speaking engagements that I had in 2014:

  • BizTalk Summit 2014 London (March 3rd & 4th)

  • Global Windows Azure Bootcamp – Lisboa (March 29)

IMG_7698IMG_7840

  • XLIX Encontro da Comunidade SQLPort – Porto (April 23)

XLIX-Encontro-Comunidade-SQLPort-Sandro-Pereira

  • BizTalk Innovation Day Oslo (September 25)

  • LIX Encontro da Comunidade SQLPort (October 15)

Sandro-Pereira-speaking-at-LIX-SQLPort

  • SQLSaturday #341 – Porto (October 18)

SQLSaturday-341– Porto-Sandro-PereiraSQLSaturday-341-Porto-Speakers

For me is always a great honor and joy to be participating in events, either as speaker or attendee, be with old friends, meet new people and share knowledge!

And yet had the opportunity to attend some events like:

  • MVP Global Summit 2014

MVP-Summit-2014-Saravana-ninno-meMVP-Summit-2014-Steej-Jan-me

  • XLVII Encontro da Comunidade SQLPort Porto
  • And incalculable number of internal training events in DevScope were we address all kind of topics like: VisualStudio Data Tools, Upgrade to SharePoint 2013, Azure ML (Machine Learning), SharePoint Apps, Tools for x-platform development, Twitter Bootstrap, SQL 2014 Power Tools, productivity tips and so on.

WP_20141027_13_31_23_Panorama

  • And more
My Blog is still growing…

Very special thanks to all my reader I really appreciate the 310,000 visits to my blog, from 183 countries in the past year. That’s 110,000 more visits than last year!

  • 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

2014-blog-post-calendar

And this last year was the weakest year in terms of post publication with only 52 Smile, less 27 than the last year.

The posts that got the most views in 2014 were:

  1. “Cannot open database ‘…’ requested by the login. The login failed” or “The EXECUTE permission was denied on the object ‘…’, database ‘…’, schema ‘dbo’” posted in February 2012 (for the third year on the top Smile)
  2.  BizTalk 2013 Installation and Configuration – Important considerations before set up the server (Part 1) posted in May 2013
  3. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security. posted in February 2012
  4. BizTalk 2013 Installation and Configuration – Install and Configure BizTalk Server 2013 (Part 9) posted in May 2013
  5. How To import Add Reference from WSDL file posted in June 2009

However my favorite’s posts that I enjoyed writing last year was:

TechNet Wiki, BizTalk Open Source Contributions

And as has been the case in recent years, I’m BizTalk Technet Contributor were I write articles in Microsoft TechNet Wiki and BizTalk TechNet moderator. I’m also member of the TechNet Wiki Community Council and TechNet Wiki Ninja Blogger.

And many other contributions….

Besides community work…

Friendship, family, travelling and running were also important things besides community work hehe…

  • 2014 was the year I start to run (who knows maybe one day I will join Steef-Jan and Kent Weare to a half marathon)

RunningRunning-devscopeS-Silvestre-Porto

  • Besides travelling for speaking events I was able to visit London (UK), Piacenza (Italy) Saint-Nazaire (France) and Salvador (Brazil) for pleasure

Italy-pizzalondressalvador-brasil-2salvador-brasilSaint-Nazaire

  • Portuguese MVP Meetings

MVP-norte-2MVP-portugalMVP-portugal-2

  • Family and friends!

10312815_743691672348406_6559472926156173085_n10436355_748113701906203_8788749183436210957_n10801611_846753638708875_1524857362980079387_nNatal-Crianças

Thanks for following me, for reading my blog and I promise that I will continue to share my knowledge during 2015.

2014-Thanks-for-following-me

2013 was a remarkable year for me where many things happened, I had the pleasure to meet and become friends with excellent people and great professionals.

BizTalk Innovation Days more active…

One of the best things is that BizTalkCrew (me, Nino Crudele, Tord Glad Nordahl, Saravana Kumar and Steef-Jan Wiggers) became even closer and more active and the result was 4 major BizTalk Event in Europe:

  • BizTalk Summit 2013, London (Jan 2013)
  • Oporto BizTalk Innovation Day, Portugal (Mar 2013)
  • Bouvet BizTalk Innovation Days 2013, Norway (Sep 2013)
  • BizTalk Innovation Day Italy 2013, Italy (Oct 2013)

And for me it was a great honor to the first time realize this event in Portugal.

Oporto-BizTalk-Innovation-Day-BooksOporto-BizTalk-Innovation-Day-attendes

Oporto-BizTalk-Innovation-Day-speakersOporto-BizTalk-Innovation-Day-welcome

Also this year we have the opportunity and the pleasure to invite Microsoft Integration MVP’s, strongest specialist and Microsoft Product Team to join us in this type of events like: Kent Weare, Salvatore Pellitteri, Charles Young, Jon Fancey, Michael Stephenson, Guru Venkataraman, Kent Brown, Paolo Salvatori, Akshat Sharma and Sam Vanhoutte.

My Blog is growing…

Very special thanks to all my reader I really appreciate the 200,000 visits to my blog, from 176 countries in the past year. After in 2012 the visits to my blog having grown 87% (from 91,000 to 170,000), this year the upward trend continued… this time by 17% so once again thank you for following my blog.

In 2013, there were 79 new posts (less 20 than the last year) with a total of 855 pictures uploaded, growing the total archive of this blog to 350 posts. The busiest day of the year was October 24th with 1,148 views. The most popular post that day was BizTalk 2013 Installation and Configuration – Installing BizTalk Adapter Pack (Part 12).

The posts that got the most views in 2013 were:

  1. “Cannot open database ‘…’ requested by the login. The login failed” or “The EXECUTE permission was denied on the object ‘…’, database ‘…’, schema ‘dbo’” posted in February 2012 (for the second year on the top J)
  2.  How To import Add Reference from WSDL file posted in June 2009
  3. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security. posted in February 2012
  4. BizTalk 2013 Installation and Configuration – Important considerations before set up the server (Part 1) posted in May 2013
  5. BizTalk 2010 Installation and Configuration – Installing and Configuring BizTalk Server (Part 8) posted in October 2010

However my favorite’s posts that I enjoyed writing last year was:

My most commented on post in 2013 was BizTalk Scheduled Task Adapter 4.0 is fully compatible with BizTalk Server 2013.

TechNet Wiki

Last year I wrote a total of 20 wiki articles for Microsoft TechNet Wiki and edit an enormous amount of existing articles, these are my favorites:

You can see all of my articles here.

MSDN-Contributions-2013

BizTalk Open Source Contributions

Last year I continue to contribute with open source projects/scripts/How to tutorials or demos in several platforms available:

You can see all of my contributions here.

Portugal Technical Articles (Minitel) and TechNet Wiki Blog

Last year I began to contribute to the Minitel project with technical articles written in Portuguese, where I already have 3 published articles:

And I was invited to become part of the TechNet Wiki Blog contributes and start to write there about the TechNet Wiki:

 

And many other contributions…. Thanks for following me, for reading my blog and I promise that I will continue to share my knowledge during 2014.

Merry Christmas and a Happy 2014

Posted: December 22, 2013 in Other
Tags:

As has become usual in this time of the year, is like a tradition now, I will sincere like to wishes for a Merry Christmas and a Happy New Year to all of my family, friends, Microsoft BizTalk Community, Microsoft BizTalk Server Product Group and special for all my readers. I sincerely wish everyone a new year filled with good things and prosperity.

I also cannot forget my BizTalk family! To the BizTalkCrew my wishes for Happy Holidays, a new year fill of new events and success and a big hug and kisses for your families who welcomed me when I was there and thanks for your friendship!

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

merryxmas

I will also like to thanks Sonia Gomes for this wonderful Christmas post.

And in my native language (Portuguese):

Como já se tornou habitual nesta época do ano, é como uma espécie de tradição agora, os meus sinceros votos de um Bom Natal e um Próspero Ano Novo para toda a minha família, amigos, para toda a comunidade de BizTalk e em especial para todos os meus leitores.

Desde já obrigado por todo o apoio e incentivo dado ao longo destes anos e que o próximo seja um ano recheado de novos artigos, da minha parte fica a promessa que irei continuar a partilhar conhecimento na esperança de poder sempre ajudar alguém.

PS: Obrigado Sónia Gomes por este belíssimo postal de natal.

2012 in review

Posted: January 4, 2013 in Other
Tags:

2012 was an excellent professional and personal year for me, thankfully with lots of work but also extremely funny. I had the chance to meet and become good friend with a few outstanding BizTalk community members and MVP’s, some I had the opportunity to meet during MVP Summit, like Nino Crudele, others I met during the BizTalk Innovation Event “tour”, like Tord G. Nordahl and Lex Hegt, among many others, would be impossible to describe them all!

In addition to write regularly in my blog and in BizTalk Brazil community (in my native language), I’m also:

MSDN-contributions-2012

My blog statics

Very special thanks to all my reader I really appreciate the 170,000 visits to my blog in the past year. The WordPress made ​​in its annual report, which he create for me, made ​​a comparison that I found extremely funny:

“About 55,000 tourists visit Liechtenstein every year. This blog was viewed about 170,000 times in 2012. If it were Liechtenstein, it would take about 3 years for that many people to see it. Your blog had more visits than a small country in Europe!”

In 2012, there were 99 new posts, growing the total archive of this blog to 268 posts. The busiest day of the year was November 7th with 912 views. The most popular post that day was BizTalk Server 2013 Beta Released, but the posts that got most views last year was:

  1. “Cannot open database ‘…’ requested by the login. The login failed” or “The EXECUTE permission was denied on the object ‘…’, database ‘…’, schema ‘dbo’” posted in February 2012
  2. The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security. posted in February 2012
  3. BizTalk 2010 Installation and Configuration – Installing and Configuring BizTalk Server (Part 8) posted in October 2010
  4. Visio 2010 Stencil for BizTalk Server Updated posted in June 2011
  5. How To import Add Reference from WSDL file posted in June 2009

I’m always curious to see these statistics because they never match with my favorite’s posts that I enjoyed writing:

TechNet Wiki

Last year I wrote a total of 21 wiki articles for Microsoft TechNet Wiki and edit an enormous amount of existing articles, these was my favorites:

  • BizTalk: List of Errors and Warnings, Causes and Solutions: This article is intended to be a knowledge base of all Errors and Warnings, Causes and Solutions documented in all stages/components of BizTalk: different stages of development, deployment, adapters, runtime, setup and configuration…
  • BizTalk Server: Basics principles of Maps: In this article, as we explore the BizTalk Mapper Designer, we try to explain its main concepts, covering slightly themes such as product architecture, BizTalk Schemas and some of the most widely used standards in the translation of messages.
  • Installing BizTalk Server 2010 in a Basic Multi-Computer Environment: This guide describes some of the considerations that apply to the various parts of a BizTalk Server installation in a basic multi-computer environment.
  • BizTalk Server: Transform text files (Flat Files) into XML: Transformations are one of the most common components in the integration processes. They act as essential translators in the decoupling between the different systems to connect. This article aims to help you understand the process of transforming a text file (also called Flat Files) in an XML document using BizTalk Server Flat File Schemas. This article intends to be an introductory note for whom is taking the first steps in this technology.

And in the last weeks of the year, during my vacations I managed to be in TechNet Wiki Top contributors for three consecutive weeks!

TechNet-Wiki-Top-contributors

Speaking engagements

I never considered myself as a speaker, perhaps because there aren’t many people in BizTalk Portuguese community or simply by lack of opportunities, however 2012 was the year it all changed and I started making presentations more often:

  • Windows Azure One Day Lab – Oporto, Portugal
  • OVERNET BizTalk Innovation Event – Milan, Italy
  • 5th Meeting of NetPonto Community – Coimbra, Portugal
  • Windows Azure [R]Evolution- Lisbon, Portugal
  • Bouvet BizTalk Innovation Event – Stavanger, Norway

As I said earlier, I have the privilege to be part of a remarkable group, the “BizTalkCrew” (unofficially named of this group) composed by 5 Microsoft Integration MVPs: myself, Tord G. Nordahl, Saravana Kumar, Nino Crudele and Steef-Jan Wiggers, that have been making events and speaking about integration a bit throughout Europe and the good news is that we will continue to do BizTalk Innovation Events throughout this year! (UK, Portugal, Holland, Italy, Norway, …)

BizTalk Open Source Contributions

Last year I really began to contribute in:

And many other contributions…. Thanks for following me, for reading my blog and I promise that I will continue to share my knowledge during 2013.

Merry Christmas & Happy 2013

Posted: December 21, 2012 in Other
Tags:

To all my readers, friends, family and Microsoft BizTalk Community my sincere wishes for a Merry Christmas, a Happy New Year and a 2013 full of good business, a lot of happiness, health and of course many integrations.

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

merry-christmas-2013-metro

And in my native language (Portuguese):

A todos os meus leitores, amigos, família e comunidade de BizTalk os meus sinceros votos de um Bom Natal, um Feliz Ano Novo e um 2013 cheio de bons negócios, muita saúde, felicidade e claro muitas integrações.

Desde já obrigado por todo o apoio e incentivo dado ao longo deste ano e que o próximo seja um ano recheado de novos artigos, da minha parte fica a promessa que irei continuar a partilhar conhecimento na esperança de poder sempre ajudar alguém.

This post is not really about BizTalk… but since I’ve been configuring several environments in my client I decided to take this notes. Basically we have some BizTalk processes that communicate with database in SQL Server that we are moving to SQL Server 2008 R2.

Consideration 1: Change Edit Top 200 Rows and Select Top 1000 Rows

SQL Server Management Studio is configured by default, for performance reasons, with the following options:

  • Select Top 1000 Rows
  • Edit Top 200 Rows

default-options-select-edit-sql

In my opinion I think these quantities a bit exaggerated and I suggest you to always reduce them. In my LAB environment I set the following values:

  • Select Top 100 Rows
  • Edit Top 100 Rows

my-options-select-edit-sql

However in production environment you should reduce more this numbers, maybe 20/10.

To modify these options you should:

  • Run the SQL Management Studio
  • Click in the menu Tools -> Options
  • Select the option “SQL Server Object Explorer” and edit the following properties:
    • “Value for Edit Top Rows Command”
    • “Value for Select Top Rows Command”

edit-options-select-edit-sql

Note: If we set these properties: ““Value for Edit Top Rows Command”, “Value for Select Top Rows Command” with the value 0 (zero) it will return all records from the table.

 

Consideration 2: Set a valid owner to database

As I said earlier, we did some database migration and when attempting to create a diagram (New Database Diagram) in one of these databases on SQL Server 2008 R2 I obtained the following error:

TITLE: Microsoft SQL Server Management Studio
——————————

Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

——————————

This error occurred in two situations:

  • After I performed a database restore from another server
  • Or after making a detached, move the files to a new directory and attached again

CAUSE

This error is being originated because the database does not have a valid owner.

The "no valid owner" issue usually comes up when databases are owned by SQL-authentication logins and are upgraded, detached/attached to another server, or restored from backup to another server.  The SID (a large number) doesn’t match any existing login on the new server, so the owner name remains whatever it was on the old server, but it is marked invalid.  Explicitly setting the owner to a valid principal on the server solves the problem.

SOLUTION

In order to solve this problem we have to:

  • Access database properties (select database, right-click and choose Properties)
  • Select “Files” tab
  • And give a valid user to database owner

valid-owner-sql-database

Note: A good best practice is to change the database owner immediately after creating, restoring or attaching a database. Unless you have a reason to do otherwise, I suggest you to specify “sa” or one SQL service user as the database owner.

Tags: SQL

2011 in review

Posted: January 2, 2012 in Other
Tags:

Very special thanks to all my reader I really appreciate the 91,013 visits to the blog. 2011 was a very interesting year, for the first time:

  • I began writing in my native language for Portuguese and Brazilian community.
  • I began to write articles for Portuguese Community Magazines
  • I began to make public presentations for Portuguese Communities
  • And I began to contribute in MSDN Code Gallery
  • I had the opportunity to give to my readers 7 e-copies of two BizTalk books

And of course, not forgetting my blog: 57 new posts in 2011.

Crunchy numbers

In 2011, there were 57 new posts, growing the total archive of this blog to 165 posts. That’s about 1 post per week.

The busiest day of the year was October 19th with 736 views. The most popular post that day was BizTalk 2010 Installation and Configuration – Installing and Configuring BizTalk Server (Part 8).

Where did you come from?

Most visitors came from The United States. India & The United Kingdom were not far behind.

2012-Where-did-they-come-from

The top referring sites in 2011 were biztalkgurus.com, social.msdn.microsoft.com, LinkedIn, WordPress.com, biztalkblogs.com, Google and Google Reader.

Some visitors came searching, mostly for biztalk bam, biztalk 2010 installation, how to install biztalk 2010, biztalk logo, biztalk 2010 books, biztalk macros and biztalk blog.

Attractions in 2010

These are the posts and pages that got the most views in 2011.

  1. BizTalk 2010 Installation and Configuration – Installing and Configuring BizTalk Server (Part 8) posted in October 2010
  2. BizTalk 2010 Installation and Configuration – Install and Configure Windows SharePoint Services (Part 6) posted in October 2010
  3. BizTalk 2010 Installation and Configuration – Install SQL Server 2008 R2 (Part 4) posted in October 2010
  4. BizTalk 2010 Installation and Configuration – Enable Internet Information Services (Part 1) posted in October 2010
  5. Visio 2010 Stencil for BizTalk Server Updated posted in June 2011

These are some of my favorite post that I enjoyed writing in 2011:

Merry Christmas & Happy 2012

Posted: December 23, 2011 in Other
Tags:

To all my readers, friends and Microsoft BizTalk Community 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 and hope that the next will be a year filled with new articles, I promise that I will continue to share knowledge hoping that they can help someone.

merry-christmas

And in my native language (Portuguese):

A todos os meus leitores, amigos e comunidade de BizTalk os meus sinceros votos de um Bom Natal e um Próspero Ano Novo.

Desde já obrigado por todo o apoio e incentivo dado ao longo deste ano e que o próximo seja um ano recheado de novos artigos, da minha parte fica a promessa que irei continuar a partilhar conhecimento na esperança de poder sempre ajudar alguém.

PS: Obrigado Sónia Gomes por este belíssimo postal de natal.