SAP on SQL Server on Azure – How to Bypass Proxy Server During Backup to URL

This short blog discusses how to avoid overloading an on-premises or Azure Proxy server with Backup to URL. Creating a typical .Net configuration file to disable a proxy server will allow BackupToURL.exe to communicate via https directly to Azure blog storage. 1. SQL Server Backup to URL Modern releases of SQL Server support backups to… Read more

Flat Cube became default in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Flat-Cube-became-default-in-SAP-BW/ba-p/368151 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 Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP… Read more

Columnstore became default in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Columnstore-became-default-in-SAP-BW/ba-p/368149 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 Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP… Read more

Very Large Database Migration to Azure – Recommendations & Guidance to Partners

SAP systems moved onto Azure cloud now commonly include large multinational “single global instance” systems and are many times larger than the first customer systems deployed when the Azure platform was first certified for SAP workloads some years ago Very Large Databases (VLDB) are now commonly moved to Azure. Database sizes over 20TB require some… Read more

SAP on SQL Server: General Update – January 2018

SAP and Microsoft are continuously adding new features and functionalities to the SAP on SQL Server platform. The key objective of the SAP on Windows SQL port is to deliver the best performance and availability at the lowest TCO and simplest operation. This blog includes updates, fixes, enhancements and best practice recommendations collated over recent… Read more

Improve SAP BW Performance by Applying the Flat Cube

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Improve-SAP-BW-Performance-by-Applying-the-Flat-Cube/ba-p/368125 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 Overview SAP released the Columnstore Optimized Flat Cube over two years ago. We want to give a brief explanation of the benefits and advantages of using the Flat… Read more

Customer Experience with Columnstore on ERP

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Customer-Experience-with-Columnstore-on-ERP/ba-p/368118 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 SAP released the report MSS_CS_CREATE a few months ago. Using this report, customers can create an additional Nonclustered Columnstore Index (NCCI) on any SAP ERP table. This… Read more

Distributed Availability Groups extended

SQL Server 2016 supports distributed availability groups (AG) as additional HA feature of the engine. Today we want to show how this feature can be used to transfer near-real-time productive data around the globe. Based on Jürgens Blog about SQL Server 2016 Distributed Availability Groups we set up a Primary AG with the SAP Database (e.g…. Read more

New SQL Server 2016 functionality helps SAP supportability

Due to the combined effort of the SAP – Microsoft Porting group the SQL Server Development team added a new functionality to the SQL Server UPDATE STATISTICS command and to the way SQL Server automatically updates statistics. This new functionality enables the SAP customers on SQL Server to persist a sample rate of the manual… Read more

Customer experience with SAP BW FEMS-Pushdown

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Customer-experience-with-SAP-BW-FEMS-Pushdown/ba-p/368084 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 A few months ago we released a new SAP BW statement generator, which increases BW query performance for complex queries containing FEMS filters, see https://blogs.msdn.microsoft.com/saponsqlserver/2017/03/06/bw-queries-by-factors-faster-using-fems-pushdown. In the… Read more