Tag Archives: Sql Server 2005

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

v

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 on InvestLink

We now get development done faster and at less cost. I’d estimate that I saved 20% in staff increases developing with the .NET Framework, compared to what we’d have needed using previous technologies.”
Stephen Tague, CTO, InvestLink.



Situation: The need for systems to manage Defined Contribution pension plans and health savings accounts has been growing rapidly, and InvestLink, a prominent player in this field, has been feeling growth pains. Founded in 1997, InvestLink has grown to be roughly the third largest technology provider to the Defined Contribution industry, with over 500,000 participants and over $30 billion being administered…






Solution: One major programming services organization proposed an Oracle-based solution; a local Microsoft partner, twentysix New York, proposed a solution built around SQL Server 2005, Visual Studio® 2005, and .NET Framework 2.0. The Oracle-based quote was roughly 2.5 times higher than the SQL Server-based quote, and the decision was obvious to InvestLink: the company chose the Microsoft Application Platform. The new software took roughly 18 months from inception to “rollout”, using a team of 10 consultants and 8 in-house developers…
View further for InvestLink



Register to mark your Comments


Case Study about Powell Electronics

With BizTalk Server 2006, we can perform as if we were a number one, two, or three company in our industry. That puts us on a level playing field.
Bob Oldrati, Controller and IT Director, Powell Electronics.



Situation: Powell Electronics assembles and distributes electronic components for use in equipment that is manufactured by other companies. Founded in 1946, the company is still owned by the Powell family. Including its New Jersey headquarters, Powell has 12 offices in North America, South America, and Europe, as well as Israel and China. Although the firm is relatively small (with 240 employees in 2007), its value-added services and precisely customized solutions have won Powell ongoing business relationships with major players in the aerospace and defense industries, including Caterpillar, Lockheed Martin, and Boeing…






Solution: Powell Electronics selected Activ Technologies—a Microsoft® Gold Certified Partner specializing in supply-chain infrastructure development—to help design a business process management (BPM) solution that would include the following components:



>Microsoft BizTalk® Server 2006 R2 to serve as the solution’s foundation,
>Microsoft SQL Server® 2005 database software to provide the BPM message storage,
>The Microsoft Visual Studio® 2005 development system to support custom programming,
>Microsoft Office SharePoint® Server 2007 to provide the user interface…
Click here discover more about Powell Electronics



Register to mark your Comments


Case Study of LendingTree LLC

Business Challenge: LendingTree is a relatively young and profitable company progressing at a rapid pace in a highly competitive, very dynamic economic environment. As the company matures, the need for tracking and measuring results becomes increasingly important in order to maintain the company’s competitive advantage. Lei Fu , Vice President of Business Applications summarizes by saying, “we are striving for quicker access to information that the business can act upon.” The Information Services team targeted two fundamental segments of the business, Operations and Sales, for their phase I implementation of the Microsoft and Decision Support Panel (DSP) Business Intelligence (BI) Solution…






Solution: Business Applications and Information Services looked at possible solutions considering both cost and effectiveness. LendingTree implemented a Microsoft solution that included Decision Support Panel’s DSP Portal Edition BI Portal Solution. The products included are as follows: Microsoft SQL Server 2005, SQL Server 2005 Analysis Services, SQL Server 2005 Integration Services, Microsoft SharePoint Portal Server 2003, Microsoft Office PerformancePoint Server 2007 and DSP Portal Edition 4.3, as well as, Microsoft Windows Server 2003 and Microsoft Office Professional Edition 2003. The Microsoft/DSP solution provides LendingTree with a secure, reliable BI platform. The DSP Portal and customizable Web Parts compliment Microsoft SharePoint Portal Server and enable LendingTree to leverage its existing Intranet portal…
Click here to view further information about LendingTree LLC


Register to mark your Comments


Case Study on Visuales Caribe

Situation: Puerto Rico’s credit unions play a significant role in the lives of their customers. Members of these credit unions are considered part owners, and ownership brings with it considerable security and a sense of belonging. The country’s credit unions range in size and have diverse clientele—urban credit unions typically have many offices to serve professionals in the country’s major cities, while rural credit unions have fewer branches but count tens of thousands of farmers and small business owners as clients. The majority of credit union members in Puerto Rico are over the age of 50…






Solution: Involvement in Microsoft early adoption programs helped Visuales Caribe to see the potential of new tools available in Windows Vista, such as the Windows Presentation Foundation, and innovative development tools like the Microsoft® .NET 3.0 Framework. Confident that these tools would help to create a more intelligent and user-friendly solution in less time, Visuales Caribe quickly made the decision to build its application on the Windows Vista platform.The development team at Visuales Caribe built its credit union operations software for use on Windows Vista, and based the solution on Microsoft technologies including Windows Server® 2003, Microsoft SQL Server™ 2005, Microsoft Office SharePoint® Server 2007, Microsoft Exchange Server 2007, and the 2007 Microsoft Office system…
Click here to view further for Visuales Caribe


Register to mark your Comments


Case Study on Autodrome

Situation: Vehicle dealerships operate in a low-margin market, requiring them to optimise business processes and maximise operational efficiency. With ever-diminishing loyalty among consumers, dealerships compete on price and on the quality of their customer service. In the face of these challenges, leading Dutch dealership Autodrome is using the latest technologies to streamline its operations. The company, which sells 12 brands of cars and commercial vehicles from six locations in the north of the Netherlands, also offers vehicle repairs and fleet rental services…






Solution: To address its operational challenges, Autodrome decided to deploy RPMcar BackOffice, a reporting, analytics, and dashboard tool that optimises the car sales and delivery process and gives insight into what is happening in the dealership. The RPMcar BackOffice solution is based on a Microsoft® infrastructure, including Windows Server® 2003 operating system, Microsoft SQL Server® 2005 database software, and the 2007 Microsoft Office system. Sandra van Leeuwen, Strategic Alliance Manager at RPMcar, says:…
Continue reading..






Register to mark your Comments


Case Study on MAXIMUS

Life is easier for everyone if the information from these different systems can be united in a single repository, and that’s what we’ve done with SQL Server.”
Nora Paape, Vice President of the Educational Services Division, MAXIMUS.



Situation: For more than 30 years, MAXIMUS has been committed to its mission of “Helping Government Serve the People.” The company’s 5,500 employees located in more than 280 offices in the United States, Canada, and Australia, provide services to a spectrum of government organizations including some 2,000 school districts, 300 courts, 100 colleges and universities, and 80 airports. The MAXIMUS Web-based TIENET application suite is valued by school districts because it provides a direct connection between curriculum and assessment for individual and groups of students in both regular and special education…






Solution: Building upon Microsoft® SQL Server™ 2005 database software, and other elements of the Microsoft Application Platform, MAXIMUS has created a BI data mart integration solution for its TIENET users. Data mart information is aggregated into multidimensional cubes for faster online transaction processing (OLAP) queries, using SQL Server 2005 Analysis Services, the OLAP component in SQL Server. The solution runs on the Windows Server® 2003 Enterprise Edition operating system. The company chose to create an OLAP data mart, rather than expand upon reporting already offered in the TIENET OLTP solution, for a number of reasons, including the need to not slow the OLTP production database by running OLAP queries against it…
Click here to view more about MAXIMUS






Register to mark your Comments


Case Study for Halliburton Energy Services Group

The eRedBook™ is an unbeatable way to ensure that everyone on the team is aligned on the same job objectives.”
Anthony Badalamenti, Strategic Business Manager, Halliburton Energy Services Group.



Executives at Halliburton Energy Services Group wanted to boost the bottom line by enhancing collaboration among engineers, operators, service coordinators, and customers, and by improving resource utilization and other operational efficiencies. To accomplish these objectives, the executives decided to give employees and customers more-powerful software solutions for making calculations in the field, sharing information, and scheduling jobs. They also decided to base the applications on a service-oriented architecture provided by the Microsoft® .NET Framework 2.0, and to develop and deploy the applications using the Microsoft Visual Studio® 2005 development system and a SQL Server™ 2005 database. Consequently, the group has enjoyed a higher level of communications and collaboration among internal staff and customers, and a vastly more efficient approach to job scheduling. Read more on Halliburton Energy Services Group










Register to mark your Comments


Case Study of Gomez

In short, our revenue is growing substantially faster than our costs, thanks in large part to the efficiency of using an architecture based on SQL Server 2005.
Imad Mouline, Chief Technology Officer, Gomez.



Situation: Based in Lexington, Massachusetts, and founded in 1997, Gomez provides a complete solution for managing Web application experience from development through deployment and the entire application life cycle, featuring active monitoring, competitive benchmarking, and more than 14,000 data sources worldwide. Gomez was honored with Network Computing magazine’s “Editor’s Choice” award for best Internet performance monitoring service…






Solution: omez upgraded its central database infrastructure to SQL Server 2005 Enterprise Edition to take advantage of the new Table Partitioning feature. Table Partitioning enables fast data loads and simplified maintenance for very large tables by giving database administrators the ability to treat a single large table as a collection of multiple smaller pieces. Gomez used Table Partitioning to divide data into daily units so that an entire partition can be deleted each time a day has aged out of the 40-day window of captured data. Gomez runs SQL Server 2005 on the Windows Server® 2003 Enterprise Edition operating system… Find out more for Gomez


Register to mark your Comments