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

Protecting SAP Solutions with Azure Site Recovery

Protect SAP Applications Most large and medium sized SAP solutions have some form of Disaster Recovery solution. The importance of robust and testable Disaster Recovery solutions has increased as more core business processes are moved to applications such as SAP. Azure Site Recovery has been tested and integrated with SAP applications and exceeds the capabilities… Read more

Customer experience with SAP BW FEMS-Pushdown

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 meanwhile, a few customers who tested the new feature, provided feedback to the “SAP on SQL Server development”. Based on this feedback, we further improved the performance of… Read more

SAP OS/DB Migration to SQL Server–FAQ v6.2 April 2017

The FAQ document attached to this blog is the cumulative knowledge gained from hundreds of customers that have moved off UNIX/Oracle and DB2 to Windows and SQL Server in recent years. In this document a large number of recommendations, tools, tips and common errors are documented.  It is recommended to read this document before performing… Read more

Transparent Data Encryption (TDE) acceleration for SQL 2016 in Windows Azure

Today we want to show you the speed improvements we get by supporting the Intel AES-NI instruction set for transparent data encryption (TDE) on Windows Azure. This instruction set reduces the CPU overhead of turning on Transparent Data Encryption for SQL Server databases. For the testing scenario we used an Azure DS15 virtual machine with… Read more

More Questions From Customers About SQL Server Transparent Data Encryption – TDE + Azure Key Vault

Recently many customers have been moving from AIX and HPUX to Windows 2016 & SQL Server 2016 running on Azure as these UNIX platforms are no longer mainstream, developed or invested by their vendors Most of these customers are deploying TDE to protect the Database files and backups. Encrypting databases with strong ciphers like AES-256… Read more

SAP on SQL: General Update for Customers & Partners March 2017

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

Large Australian Energy Company Modernizes SAP Applications & Moves to Azure Public Cloud

This blog is a technical overview of a project recently completed by a large Australian Energy Company (the Company) over the past 12 months to transform the Company’s SAP Solution from an End of Life HPUX/Oracle platform to a modern SQL Server 2016 solution running on the Azure Public Cloud. This blog focuses on the… Read more

How to install or upgrade SAP Systems to SQL Server 2016 *updated*

On 4/10/2016, SAP released support for SQL Server 2016 for some SAP NetWeaver based systems. In this blog we will talk about how you can update your existing installations on SQL Server to SQL Server 2016, what you need to do when installing a new SAP NetWeaver based system on SQL Server 2016 and what… Read more