Tag Archives: Microsoft Sql Server

Case Study for Relacom

Today we generate our KPIs on a daily basis. Prior to deploying Analysis Services, back when we created them by cutting and pasting, we only updated our KPIs on a monthly basis.
– Ake Soderberg, Operational Project Manager, Relacom.

With more than 15,000 employees operating in 17 countries, Relacom provides managed services for wired and wireless networks. To accommodate its growth, the company needed a more robust and flexible business intelligence (BI) data warehouse, which had been hosted using Oracle and the UNIX operating system. The company migrated its BI data warehouse to Microsoft SQL Server 2005 Enterprise Edition (64-bit) database software running on Windows Server 2003 Enterprise Edition for 64-Bit Systems…

Situation: Relacom, headquartered in Stockholm, Sweden, provides a range of data and telecommunication network services—from construction services, to equipment installation, to network maintenance—serving customers through its operations in 17 countries around the world. The 15,000 employees of Relacom provide managed services to customers ranging from private sector and government network owners to businesses and consumers. Servicing both wired and wireless networks, Relacom provides preventative and corrective maintenance services…
Click here to learn more about Relacom

Register to mark your Comments


Case Study of Barnes and Noble Inc

Barnes & Noble, the world’s largest bookseller, operates 821 stores in 50 states. To help improve its business operations and respond better to customer needs, the company needed new business intelligence tools that could access information faster and provide more detailed reports to managers. The company, which runs Oracle databases for operational systems, decided to deploy a new data warehouse using Microsoft® SQL Server™ 2005 running on an HP Integrity Superdome server equipped with Intel Itanium processors…

Situation: Barnes & Noble is the largest bookseller in the United States. As of August 2005, the company owned 821 bookstores in 50 states plus the www.bn.com online store. About 80 percent of its stores operate under the Barnes & Noble Booksellers trade name, and the company also owns and operates B. Dalton Bookseller. Through these outlets, the company offers trade books, hardcover and mass-market paperback books, magazines, computer software, and music and video titles, as well as runs in-store coffee shops. Headquartered in New York City, the publicly traded company employs about 40,000 people and reported revenues of U.S.$4.87 billion in its most recent fiscal year. Click here to read further on Barnes and Noble Inc

Register to mark your Comments

Case Study of Hoya Corporation

We successfully migrated eight production systems at the same time, which might be considered risky. But VMware software is known for its stability and it is fully supported by SAP. It would have been more risky not to virtualize.”
— Yoshihiro Moriya, IT Group, Financial Department, Hoya Corp.

Cut costs. Increase flexibility and scalability. These driving goals led the global optics firm Hoya Corp. to migrate SAP ERP from a UNIX/Oracle platform to Microsoft Windows and Microsoft SQL Server virtualized on VMware® vSphere®. As a result, the company has reduced its SAP operating costs 75 percent, increased business agility for diversified growth and set the stage for more-robust disaster recovery. What’s more, migration to a pay-as-you-go IT-as-a-service (ITaaS) model in a cloud environment hosted by QUNIE eliminates capital costs in favor of usage-based flexibility…
Click here to find out more on Hoya Corporation Case Study

Register to mark your Comments

Case Study for Polizia Ferroviaria

Business Needs: Like any police force, the Italian Railway Police (Polizia Ferroviaria, or Polfer) needs to create and store a tremendous number of documents subject to government regulations, and retrieve them at need under strict security. In the past, this was done using paper documents and manual filing systems. To complicate matters, Polfer has approval processes for archiving documents, for recording charges filed, and for recording verdicts. These processes are not completely standardized, and not only vary from department to department, but change periodically…

Solution: Polfer had already invested in a very successful automated CCTV monitoring system based on Microsoft® technologies. Polfer evaluated several possible solutions for an electronic document system, but the solution that offered the most flexibility and ability to customize the approval and archiving process was one based on SharePoint® Portal Server 2003 and Windows® Workflow Foundation (WF), with workflow and Web site state persistence supplied by Microsoft SQL Server™ 2000…
Click here to learn more about Polizia Ferroviaria Case Study

[youtube http://www.youtube.com/watch?v=Rn-Yrox-hus&w=420&h=315]

Register to mark your Comments

Case Study for Arabian United Float Glass Company

Situation: Arabian United Float Glass Company (AUFGC), which was founded in 2006 by leading corporate investors in Saudi Arabia, was the first independent float glass production line in the Middle East and Africa. Since 2009, the factory has manufactured 600 tons of high-quality float glass a day. Using state-of-the-art technology helps the Yanbu-based firm on the Red Sea coast manufacture glass to architectural or automotive quality. The company uses technology from the world’s leading suppliers to the float glass industry, and its output supplies both the domestic Saudi and export markets…

Solution: Working with Microsoft Partner Networks Connection, AUFGC migrated its existing Windows Small Business Server 2003 operating system to Windows Server 2008 R2 Enterprise with Hyper-V virtualization technology. On this infrastructure, the company implemented the Microsoft System Center suite of products together with Microsoft Exchange Server 2010 and Microsoft SQL Server 2008 R2. The latter two products replaced earlier versions of Microsoft software. Exchange Server 2010 gives AUFGC its database availability group feature, which ensures automatic recovery for mailbox databases…
Read further on Arabian United Float Glass Company

Register to mark your Comments

Case Study for Winsight

Winsight, a subsidiary of Winwise, designs software and offers services, technology training, and consulting on projects. Specialists in implementing business intelligence (BI) decision support systems in IT systems based on Microsoft® technologies, Winsight has its own line of tools called OLAP Webhouse. A notable member of this lineup is ReportSmith.net, a decision support interface that unites both the power of analysis and flexibility in reporting in a single Web application. ReportSmith.net complements Microsoft SQL Server™ Reporting Services, and had only a Web browser as its client—until recently. Read further..

Register to mark your Comments

Case Study on Investec Ltd

Investec Bank (Channel Islands)—a specialist provider of offshore private banking services—wanted to improve its core banking technology and manage its growing intermediary business more effectively. Vega Solutions replaced the bank’s previous banking system with a customised banking solution called Vision Online, based on Microsoft SQL Server and Microsoft BizTalk Server. Investec has doubled its revenue since 2004 without needing any extra back-office staff since the software went live. In the meantime, Vega Solutions has provided further enhancements. This has included integration with the Society for Worldwide Interbank Financial Telecommunication (SWIFT) network using Microsoft BizTalk Accelerator for SWIFT, and online banking giving customers straight-through processing for payments. Read more..

[youtube http://www.youtube.com/watch?v=ZERj_p7p1-w&w=480&h=360]

Register to mark your Comments

Case Study on Capital & Coast District Health Board

Capital & Coast District Health Board (C&C DHB) wanted more affordable and detailed business intelligence (BI). To achieve this goal, C&C DHB replaced its previous BI solution with a new one based on the Microsoft SQL Server Fast Track Data Warehouse and the HP Business Decision Appliance. In just 12 months, C&C DHB transformed its BI capabilities, cut software costs by about 50 percent, and improved insight, efficiency, and agility. Click here to read more…

Register to mark your Comments

Case Study on Touchstone Behavioral Health

Case Study about Touchstone Behavioral Health

Situation: Touchstone Behavioral Health is a nonprofit organization that provides a range of youth behavioral health services, including anger management, crisis intervention, psychiatric evaluations, support groups, and parenting classes. The Glendale, Arizona–based organization has six sites throughout Arizona and employs 180 people.

Technology is critical in helping Touchstone meet ever-increasing healthcare regulations, empower its staff to be productive, and keep operating costs low. When Steven Porter arrived in mid-2006 to lead Touchstone’s IT department, the organization had already upgraded the company’s seven servers to the Windows Server 2003 operating system, installed Microsoft® Exchange Server 2003 as its messaging system, and standardized on Microsoft SQL Server 2000 data management software. The company’s desktop computers ran the Windows® 2000 and Windows XP operating systems. Keep Reading..

A Case Study on Large Retail Bank

The Challenges: As a standard regulatory requirement, the bank needed to send frequent reports to the Financial Services Authority and to Jersey Financial Services Commission within an allocated timeframe. The process of liquidity monitoring and reporting was managed within an internal MS Access database and required half a day of employee time to complete, on a daily basis. Reporting to regulatory bodies was conducted when necessary by email.While the system provided adequate results, it was a stand-alone solution and so did not reconcile with other systems.

Our Solution: C5 designed and developed a Microsoft SQL Server based solution, to automate all of the bank’s Offshore liquidity monitoring and reporting requirements.The project was delivered in two phases, the first phase to address the issue in relation to London’s regulatory environment and the second phase to apply to Jersey’s. Each phase was completed successfully, well within the allocated timeframe and budget and provided internally consistent reporting for the first time…
Click here to read more on Large Retail Bank