Introduction Azure Data Factory does not really handle complex data types very well. This applies to both V1 and V2. In this blog post, I will explain the problem and a solution for one sample complex type, which is ST_GEOMETRY. The scenario is copying data from an Oracle database to any Azure cloud-service, for instance … More Complex Data Types in Azure Data Factory
Working with the Azure Data Lake Store can sometimes be difficult, especially when performing actions on several items. As there is currently no GUI tool for handling this, PowerShell can be used to perform various tasks. The toolkit described in this post contains several scripts, which makes automation in the Data Lake a little easier. … More Azure Data Lake Store PowerShell Toolkit
When establishing an enterprise class Data Platform based on Microsoft Azure, several tools are handy and beneficial. This article will list and explain some of the recommended tools, which will make the daily operation efficient. The article lists and explains the following tools: Azure Portal PowerShell Storage Explorer Azure Cosmos DB Data Migration Tool Visual … More Data Platform – Tools of the Trade
BizTalk Server 2016 Feature Pack 1 is now available for download: http://biztalkfp1.azurewebsites.net/ This release extends functionality in key areas such as Deployment, Analytics, and Runtime. BizTalk Server 2016 Feature Pack 1 is available for Software Assurance customers running the BizTalk Server 2016 Developer and Enterprise editions or are running BizTalk Server in Azure under an … More BizTalk Server 2016 Feature Pack 1
The Spool table is a table in BizTalkMsgBoxDb. Having a large record count indicates a lot of active, dehydrated or suspended messages. It is important to avoid large and growing Spool size, as this can cause all kinds of problems in your BizTalk environment. This simple script checks the BizTalk Message Type and count of … More Check Contents of the BizTalk MessageBox Spool Table
Global Integration Bootcamp is a free event driven by user groups and communities around the world, backed by Microsoft, for anyone who wants to learn more about Microsoft’s integration story. In this full-day bootcamp we will deep-dive into Microsoft’s integration stack with hands-on sessions and labs, delivered to you by experts and community leaders. In this … More Global Integration Bootcamp 2017
I recently passed the 3rd and final exam in the Microsoft Azure Solutions Architect certification program. Here are some thoughts and tips, which may make the road easier for anyone who wishes to follow the same path. Introduction When completing this certification program, you will earn an MCSD – Azure Cloud Architect title. Note that … More Road to Azure Solutions Architect Certification
Cortana Intelligence Suite (formerly known as Cortana Analytics Suite) is a fully managed Big Data and Advanced Analytics suite to transform data into intelligent action. It is a collection of technologies, all part of the Microsoft Azure cloud offering. The suite consists of numerous components, divided into the following areas: Information Management Big Data Stores … More Cortana Intelligence Suite
Dear Reader, With Christmas around the corner, I would like to thank you for visiting my blog. Thank you for your support, and I hope you have learned something from my articles. I will keep up the community sharing in 2017. This blog started July 2016, and now has visitors from 40 countries. I appreciate … More Merry Christmas and Happy New Year!
Installing and configuring BizTalk Server is not straightforward. It is error prone and can take a lot of time. BizTalk MVPs and experts have created their own installation guides, which are very helpful. The toolkit described in this article consists of several PowerShell scripts, which are meant to automate installation and configuration steps. The toolkit … More BizTalk Server Installation PowerShell Toolkit
