Standing on the Shoulders of Students

Morning! I just arrived home from an interesting week up in the Pacific Northwest, and wanted to share some insights. As senior architects and consultants, my colleagues and I are often looked to to provide strategic direction, or insight, or innovative perspectives, or that other awful and overused phrase: thought leadership. We do this on…


SQL Server TDE with SAP Applications – Part #1 Enabling TDE

Introduction An organization can take several precautions to help secure a database, such as designing a secure system, encrypting confidential assets, and building a firewall around the database servers. However, in a scenario where the physical media (such as disk drives or backup tapes) are stolen, a malicious party can simply restore or attach the…


Issues with SAP tools during migration/Unicode conversion

Hi, We raised some issues with the SAP migration tools during a replatforming project including Unicode conversion from SUN/Oracle to Windows SQL Server.  Our migration went well and all the log files from the technical migration reported no error, but during the application testing the customer claimed some missing data in a couple of tables….


The Year of Hindsight: 2020

With the year 2020 now less than a decade away, my esteemed colleague Juergen Imhoff and I have put together the following “fictional roadmap” representing upcoming technology and business themes or events. Keep in mind this blog posting in no way reflects Microsoft’s official position, any special personal insight, or any overt or implied guarantees one way or…


BI: The New Pervasive Mission-Critical Application

I have been thinking about Business Intelligence and Business Analytics the last few weeks. In my earliest days designing and supporting BI, data marts, and data warehousing systems in the late 1990s, the work I did was aimed at something typically less-than-critical. Back then, my customers ran Oracle and SAP Data Warehouses with a sprinkling of…


Experiences with SQL Server Database Compression

I want to share some customer experiences with database compression we gathered in a large SAP migration project in EMEA. Most of the public available data about SAP database compression ratios only shows values for compression of an existing SQL Server database, like:  ·         Using SQL Server Database Compression with SAP NetWeaver: ·         Quanta…


Transitioning Non-Production LOB systems into the Cloud

The more I speak with executive IT leaders nowadays, the more I hear the same: help me cut costs, reduce my risks, and show quantifiable and near-immediate value to the business. What’s not being said today is more important, though – and alarming in its absence. “Where can I do this? What else should I…


JD Edwards & SQL 2008 R2 Unicode Compression

One of the most important new features introduced in SQL Server 2008 was database compression (row and page). JD Edwards Business Data databases in particular are great candidates for compression. Customers can expect anything from a 55% to 80% reduction in the size of their databases just by using row compression. Compression in SQL Server…


Trace Flag 1117 – A Safety Net You Might Not Be Aware Of

Are you running SQL 2008 for your SAP instance? If so, are you aware of trace flag 1117? There are a couple of best practices that are important to keep your SAP instance running well on SQL Server. The first is to ensure that proportional fill is working correctly. A key best practice of proportional fill is…


Mission Critical Support for SAP and LOB Applications

In the IT community, we often talk about mission critical applications with the need to achieve high availability and have proper disaster recovery to achieve business continuity.  However, it’s amazing to me how many companies running SAP or other LOB applications (that are an integral part of successfully running their business) fail to have the most…