Malaysian Mobile Technology Enabler Delivers Faster, More Reliable Data Access With Move to SQL Server

Data management features help MACROKIOSK improve database performance and query execution speeds, enabling employees and customers to get more done.

KUALA LUMPUR, Malaysia — April 24, 2012 — MACROKIOSK, a mobile technology enabler for enterprises, today announced its deployment of Microsoft SQL Server 2008 R2. The Malaysia-based company made the upgrade to improve performance of its relational database system and to position itself for continued business growth through enabling mobile technologies for enterprises.

Since opening its doors in 2000, MACROKIOSK has established relationships with global mobile operators and grown its etracker (Global Mobile Messaging Network) connectivity coverage to more than 2 billion mobile subscribers worldwide. With the move to SQL Server 2008 R2, MACROKIOSK will benefit from more effective tools for managing large amounts of data and providing customers with the most optimal services.

MACROKIOSK currently serves more than 2,000 clients in more than 37 countries and in 18 industries, including aviation, automotive, medical, hospitality, entertainment, banking and finance, telecommunications, and transportation and logistics. Through etracker, MACROKIOSK offers premium and bidirectional bulk messaging services that serve as the platform for end-user experiences, such as mobile banking transaction alerts, mobile airline flight booking and many other comprehensive mobile services.

“MACROKIOSK is a multicountry mobile technology enabler, and we constantly look for new opportunities for growth — whether through greater internal efficiency or expanded services for our customers,” said Joanna Hew, chief technology officer at MACROKIOSK. “We’ve been very pleased to see the breadth of features and tools in SQL Server 2008 R2, which have enabled our customers to get more done and positioned us to be more responsive to changes in the market.”

Employees and Customers Reap the Benefits

MACROKIOSK worked with Microsoft Premier Support to devise a migration plan and identify any known issues. Consequently, MACROKIOSK was able to complete the migration from SQL Server 2005 in just four hours. Since that time, MACROKIOSK has seen an increase in productivity and operational efficiency:

·           Improved performance and availability. The Table Partitioning feature in SQL Server 2008 R2 has enabled MACROKIOSK to split each database table across multiple physical devices, increasing query execution speeds by up to 100 percent. And with a combination of Data Mirroring and a failover configuration, MACROKIOSK improved the availability of its databases.

·           Reduced hardware requirements. SQL Server 2008 R2 performed fast backups, while producing compressed backup files that were smaller. MACROKIOSK currently manages about 3.8 terabytes of data and has up to 200 users querying this data simultaneously. The size of uncompressed in-production data remains the same, but the company has seen a 50 percent reduction in the size of compressed backup database files.

·           Easier administration. The combination of an improved user interface, enhanced management tools and simpler maintenance procedures help database administrators increase productivity and efficiency. For example, IntelliSense is an auto-suggest/auto-complete feature that assists administrators when entering commands. And Data Collector identifies tables that are sluggish and offers configuration recommendations to improve their performance.

The enhanced database management features in SQL Server 2008 R2 have also improved the user experience for MACROKIOSK customers, many of whom must download data from the company’s servers to create a report. Features such as Table Partitioning have led to a noticeable reduction in how long it takes for customers to generate these reports.