Recent SAP BW improvements for SQL Server

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Recent-SAP-BW-improvements-for-SQL-Server/ba-p/368010 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Over the course of the last few months we implemented several improvements in SAP BW. We already blogged about two improvements separately: https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/14/simplified-and-faster-sap-bw-process-chains https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/25/improved-sap-compression-tool-msscompress In this blog…


Understanding different GC modes with Concurrency Visualizer

In this post I’m going to visualize what exactly happens during Garbage Collection (GC) and how different GC modes can significantly affect application performance. I assume that the reader is familiar with garbage collection basics. If this isn’t the case I encourage you to spend 15 minutes to fill this gap, for instance from the…


Enable System.Net tracing on Azure App Service

This article has been moved to its new home here:  https://benperk.github.io/msdn/2017/2017-01-enable-system-net-tracing-on-azure-app-service-unable-to-connect-to-remote-server.html It is becoming a common scenario that customers of Azure App Services Web Apps are making requests to services hosted on other Azure IaaS or PaaS platforms, services not hosted on the Azure platform (on premises) and which use the System.Net class.  For example, making…


Using Postman to call Azure REST APIs

This article has been moved to its new home here:  https://benperk.github.io/msdn/2017/2017-01-using-postman-to-call-azure-rest-apis.html I had a need to call an Azure REST API and thought I would document that here.  Here are the steps required: Get the Postman app Get your Bearer Token for authentication Configure Postman for calling the Azure Rest API Get the Postman app In…


Create and deploy an ASP.NET Core Web API to Azure Windows

This article has been moved to its new home here:  https://benperk.github.io/msdn/2017/2017-01-create-and-deploy-an-asp-net-core-web-api-to-azure-windows.html There are a number of things I want to accomplish with this and a few future articles: How to deploy an ASP.NET Core Web API to an Azure App Services Web App How to deploy an ASP.NET Core Web API to an Azure VM Check…