New SQL Server 2008 Case Studies
The momentum for SQL Server 2008 continues. Here are some of the latest case studies published:
- Russia’s Baltika Breweries Links its ERP Databases using SQL Server 2008 Replication
Baltika Breweries, the largest producer of beer in Russia, has about 12,000 employees and 11 breweries. Its popular brands have been the market leader in Russia for more than a decade and are exported to 46 countries. The company coordinates enterprise resource planning (ERP) across its operations using an ERP solution created by Microsoft® Certified Partner Monolit-Info. To enhance management of several geographically dispersed ERP databases holding more than 2 terabytes of information, the company deployed them as a 6-node multi-server configuration. Baltika is upgrading to Microsoft SQL Server® 2008, from the earlier version, to take advantage of new features introduced in SQL Server 2008. Baltika’s lab testing demonstrated that SQL Server 2008 provides the efficient replication required for its operations, as well as reliability.
- Big Hammer – Software as a Service Provider Lets Shoppers Furnish Homes in an Online 3D World
Edgenet, and its Big Hammer Data Division, helps retailers and manufacturers serve customers by hosting a Global Data Synchronization Network (GDSN) and Marketing data pools of basic product attributes, providing a common classification for products. As the company prepared to launch its Edgenet Vision™ product that enables users to create a 3-dimensional (3D) representation of their homes and populate rooms with 3D images of appliances and furniture from the Big Hammer data pools, it needed an enterprise-grade platform. Big Hammer deployed Edgenet Vision hosted on Microsoft® SQL Server® 2008 Enterprise Edition (64-bit) database software running on Windows Server® 2008, using a Software as a Service distribution model. The application developers used Microsoft Visual Studio® 2008. The solution runs on Unisys ES7000 enterprise server computers.
- bwin – Global Online Gaming Company Deploying SQL Server 2008 to support 100 Terabytes
Sports enthusiasts around the world place up to 1 million bets per day using the online sports betting services of Gibraltar-based bwin International. Performance is paramount at bwin which hosts more than 100 terabytes of information on some 100 instances of Microsoft® SQL Server®. The company was very happy with its deployment of SQL Server 2005, but it enjoyed 3-digit annual growth in 2005 and 2006 and is eager to take advantage of new technological advancements to help it keep pace with growth. The bwin Data Management Systems group has started upgrading its database infrastructure to SQL Server 2008 to take advantage of Backup Compression, management tools, and other new features. During peak gaming periods SQL Server processes 30,000 database transactions per second, while supporting the reliability required by the bwin database group’s motto: “Failure is not an option.”
- McLaren Electronics Fuels Analysis of Formula One Racing Data with SQL Server
McLaren Electronic Systems, part of a family of companies that includes the McLaren Racing organization, is a leader in developing specialized motor racing products including the engine control unit (ECU) that manages the complex engine, transmission, and other key elements of Formula One race cars. After the Fédération Internationale de l’Automobile (FIA), motor sport’s world governing body, awarded McLaren Electronics and Microsoft the contract to provide the ECU solution that will be used in all Formula One race cars, McLaren Electronics sought a more efficient way to manage the terabytes of ECU data that a team generates in a year. After performing a proof of concept study, McLaren Electronics found that Microsoft® SQL Server® 2008 provided the solution it needed for storing data while providing Formula One type retrieval speeds.
- RSS Aggregator NewsGator Manages 2.5 Billion Articles with SQL Server 2008
NewsGator makes life easier for individuals and companies by aggregating Really Simple Syndication (RSS) data feeds from across the Web to provide users with customized content delivery, enabling everyone to essentially create their own electronic newspaper. The company, which also provides Software as a Service to more than 50 media outlets including CNN and USA Today, stores some 2.5 billion RSS articles totalling about 4 terabytes on clustered databases running Microsoft® SQL Server® database Software. NewsGator is upgrading its database infrastructure to SQL Server 2008 Enterprise Edition (64-bit) running on the Windows Server® 2008 for 64-Bit Systems operating system to take advantage of a number of new features, including enhanced Database Mirroring for high availability, Backup Compression to reduce storage needs, and Resource Governor for allocating processing resources.
- Siemens PLM Software Validated to Easily Support 5,000 Users with SQL Server 2008
Siemens PLM Software scales to 5,000 concurrent users and gains 50 percent compression for database files running on SQL Server® 2008 and Windows Server® 2008 and Intel®-based hardware.
