|
|
 |
| Microsoft® SQL Server™
2005 |
| Data Management and
Analysis Solution for Your Enterprise |
 |
Faster
Results |
| |
A new Management Studio and integration
with Visual Studio 2005 and the Microsoft .NET common
language runtime helps you build, debug, and operate applications
faster and more efficiently. |
|
Better Decisions |
| |
A comprehensive business intelligence
platform for data integration, analysis, and reporting
that helps you turn insight into action and make better,
faster decisions. |
|
Trusted Platform |
| |
The highest performance availability
and security to run your most demanding applications with
native data encryption, secure default settings and password
policy enforcement |
| SQL Server 2005 provides
many new and enhanced business intelligence (BI) features
designed to give you a competitive advantage. These advantages
include integrating multiple data sources with Integration
Services; enriching data and building complex business
analytics with Analysis Services; and writing, managing,
and delivering rich reports with Reporting Services. Review
the following product and technical resources and other
information designed to help you improve BI in your organization. |
|
Integrate: Easily
integrate data from a wide range of operational and enterprise
data sources, and gain competitive advantage through a
holistic view of your business. |
|
Analyze: Gain an
integrated view of all your business data as the foundation
for your traditional reporting, OLAP analysis, scorecards,
and data mining. |
|
Report: Deliver
the information employees need to make better business
decisions—in virtually any business environment. |
|
Data Mining: Explore
data, discover patterns, and apply these patterns to business
operations with an easy-to-use, extensible, accessible,
and flexible platform.
The challenge and promise of business intelligence revolves
around providing employees with the right information,
at the right time to accomplish a specific goal. Making
this promise a reality demands a business intelligence
solution that is comprehensive, secure, integrated with
operational systems, and available all day, every day.
SQL Server helps companies to achieve this goal with SQL
Server 2005.
|
| |
Business intelligence
advancements include: |
|
Integrated platform.
Building on SQL Server 7.0 and SQL Server 2000, SQL Server
2005 delivers an end-to-end business intelligence platform
with integrated analytics including online analytical
processing (OLAP); data mining; extract, transformation,
and load (ETL) tools; data warehousing; and reporting
functionality. This comprehensive, integrated approach
helps enable organizations to seamlessly build and deploy
robust business intelligence applications while controlling
costs. |
|
Improved decision
making. Advancements to existing business intelligence
features, such as OLAP and data mining, and the introduction
of a new reporting server provides enterprises with the
ability to transform information into better business
decisions at all organizational levels, from the information
worker to the CEO. |
|
Security and availability.
Scalability, availability, and security enhancements help
provide users with uninterrupted access to business intelligence
applications and reports |
|
Enterprise-wide
analytical capabilities. An improved ETL tool enables
organizations to more easily integrate and analyze data
from multiple heterogeneous information sources. By analyzing
data across a wide array of operational systems, organizations
may gain a competitive edge through a holistic understanding
of their business. |
| |
Companies Switching
to Microsoft® SQL Server™ 2005 |
| |
Companies are
switching to Microsoft® SQL Server™ 2005 providing
a proof that Microsoft® SQL Server™ 2005 provides
an unsurpassed technology providing unlimited deliverables.
Companies are strategically investing in SQL Server
for critical enterprise applications after recognizing
the richness of functionality in SQL Server and its
ability to deliver a faster time-to-market at a significantly
reduced total cost of ownership. Read about customers
who have switched to or chosen SQL Server over competitive
database management solutions. |
| |
| Company |
Considered
or switched from… |
Air
Products and Chemicals, Inc.
After considering Oracle, Air Products and
Chemicals, Inc. chose SQL Server 2000 for
its human resources system and migration from
Sybase. The solution provides scalability
and performance to support the company's 17,000
employees worldwide, achieving 99.995% availability
in its first year. |
Oracle,
Sybase |
Albertson's,
Inc.
Using the Microsoft platform, including SQL
Server 2000, and its capabilities to integrate
with IBM mainframe applications, Albertson's,
Inc. developed a scalable and integrated solution
to support multiple storefronts and fulfillment
models. |
IBM |
ASB
Bank
Since migrating its data warehouse from Oracle
to SQL Server, ASB Bank has made comprehensive
customer information instantly accessible
to employees. With in-depth knowledge at their
fingertips, employees can now make intelligent
recommendations about bank services, resulting
in increased profits. |
Oracle |
Black
& Decker
Standardizing on the Microsoft platform, including
migrating from Oracle to SQL Server, Black
& Decker built a Web site in three months.
Black & Decker now cultivates deep and
long-lasting relationships with tens of millions
of consumers at a lower total cost of ownership. |
Oracle |
Brazilian
Mercantile and Futures Exchange (BM&F)
Brazilian Mercantile and Futures Exchange
(BM&F) chose SQL Server and the Microsoft
platform to build its leading-edge foreign
exchange clearinghouse. BM&F brought the
solution to market in just six months and
has achieved a mission-critical level of availability
that now processes $5 billion US per day. |
Oracle |
Ceridian
"SQL Server 2000 came out ahead
of Oracle and DB2 because it offered the best
management tools, lowest TCO [total cost of
ownership], and greatest level of interoperability
with the disparate data sources in our enterprise
environment." Using the Microsoft platform,
Ceridian built a Web-based interface for its
mainframe-base payroll processing system in
just four months and resulted in an annual
savings of $15 million US. |
IBM,
Oracle |
Clalit
Health Services
After considering IBM, Clalit Health Services
chose SQL Server 2000 to provide real-time
business intelligence (BI) to more the 1,000
managerial and medical offices supporting
more than 3.7 million insured member. Clalit's
medical BI application now provides multidimensional
world views on every aspect of HMO operation. |
IBM
Informix |
Commonwealth
Department of Education Science and Training
By migrating its mainframe applications to
Web technology using SQL Server 2000, the
Commonwealth Department of Education Science
and Training has enabled the two-way transfer
of mission-critical data between public sector
employees and overseas agents at a lower total
cost of ownership. |
IBM |
Commonwealth
Securities Limited (CommSec)
After considering Oracle, Commonwealth Securities
Limited decides that upgrading its existing
infrastructure with SQL Server 2000 and the
Microsoft platform is the best way to provide
the scalability, low total cost of ownership,
and agility that their growing business needs. |
Oracle |
Cooper
Rubber & Tire
Cooper Rubber & Tire migrates to the Microsoft
platform and SQL Server 2000 and cuts time-to-market
by 50 percent, realizes higher revenues, and
achieves lower total cost of ownership equaling
$2.9 million US over three years. The solution
requires interoperability with legacy mainframe
and Oracle databases. |
Mainframe |
Countrywide
Home Loans
After a side-by-side comparison with IBM DB2,
Countrywide decided to implement a solution
based on SQL Server 2000 for its loan origination
data system. They are now benefiting from
new replication capabilities, improved query
return times, enhanced analysis capabilities,
outstanding reliability, and an affordable
scalability strategy. |
IBM |
Danfoss
Danfoss migrated its SAP R/3 application from
Oracle to a more cost-effective solution using
SQL Server 2000. With 1,500 users, the new
solution reduced total cost of ownership by
50% and increased overall performance by 40%,
with batch processes running up to 67% faster. |
Oracle |
DPF
Data Services
With 4 terabytes of data, DPF Data Services
Group has an enormous database to manage.
The archiving company previously used Sybase
11.5 and Oracle 8.0 to handle its customer
data, but the two systems did not work well
together and could not deliver the scalable
solution that DPF needed. In addition to saving
the company U.S.$500,000 each year in hardware
and software costs, the solution gave the
company increased performance, better interoperability,
and the scalability that DPF was trying to
achieve. Additionally, they have not experienced
any downtime in the full year and a half since
making the switch from Sybase and Oracle. |
Oracle,Sybase |
Grand
Expeditions
Grand Expeditions, a consortium of luxury
travel companies, wanted to reduce its Web
development and hosting costs while making
it easier for marketing staff to post new
information and make changes. The company
also wanted to improve site reliability and
performance. Grand Expeditions accomplished
all of these objectives by moving its nine
travel Web sites from a combination of Linux-
and UNIX-based servers running the Oracle
8i database to SQL Server on Windows and saved
approximately U.S.$200,000 a year. |
Oracle |
Guinness
World Records Limited
Guinness World Records migrated from a Sun
and Oracle platform to the Microsoft platform
and SQL Server 2000 just 90 days prior to
the launch of GuinnessWorldRecords.com. By
doing so, the site launched on schedule, with
more features than originally planned, and
with lower costs. |
Oracle |
H&R
Block
Since switching from Oracle to SQL Server,
H&R Block developed a new solution in
just four months and was able to leverage
its existing professional tax calculation
engine. It now enjoys an agile and easily
scalable system, and can focus on growing
its online business by adding new features
and services. |
Oracle |
Hadeed
(Saudi Iron & Steel Company)
Hadeed migrated its SAP R/3 application from
Oracle to SQL Server 2000 to support 1,400
users more cost effectively. The result reduced
total cost of ownership by 50%, reduced process
time by 87%, and achieved a full return on
investment in 18 months. |
Oracle |
Home
Shopping Network (HSN.com)
Home Shopping Network migrated the database
tier of its Web solution from Oracle to SQL
Server 2000 and the Microsoft platform, achieving
an increase in performance, easy maintenance,
and a decrease in time to market for new functionality. |
Oracle |
Indiana
(State of) Department of Administration (IDOA)
After extensive performance and cost analysis,
IDOA migrated its PeopleSoft application from
IBM DB2 to SQL Server and increased usage
100-fold to all 40,000 state employees. This
solution achieved a 90-day ROI and dramatically
improved performance, with most transactions
running in 1/10th of the time. |
IBM,
Oracle |
iTelcoi
Telco switched from Oracle to SQL Server 2000
and developed an entire carrier-grade conferencing
system in only three months. iTelco's solution
provides a cost-effective, high-availability
platform that carriers can offer as a new
generation of high-quality Internet Protocol
(IP) audio, video, and data conferencing,
and application sharing services. |
Oracle |
Jih
Sun Financial Holding Company
After consolidating its banking and securities-trading
operations, Jih Sun Financial Holding Company
turned to the Microsoft platform and SQL Server
2000 to develop a data warehouse and an enterprise
application integration (EAI) solution for
its IBM mainframe applications. The result
was a consistent and transparent interface
for customers. |
IBM |
Launch.com
After considering IBM DB2 and Oracle, Launch.com
chose SQL Server 2000 for its music entertainment
portal that serves more than 4.3 million customers.
The result is a robust, highly scalable database
system that handles large and diverse data
sources, including streaming media files and
music videos, and streamlines database development |
IBM,
Oracle |
Minolta
Minolta migrated one of the world's largest
SAP R/3 applications (5.5 terabytes, 2,000
users, and 700 concurrent users) from Oracle
to SQL Server and consolidated twenty UNIX-based
IBM RS/6000 servers to two 32-way Unisys ES7000
servers. The company also doubled the processing
speed for many of the key SAP R/3 functions
and reduced administration costs for the system
by half. |
Oracle |
ntl
After considering Oracle, ntl, a leading broadband
company in the United Kingdom, decided to
use the Microsoft platform and SQL Server
2000 for its customer management and billing
solution. The result has been an increase
in productivity and performance and a decrease
in development costs. |
Oracle |
NuRun
"We considered IBM DB2 and Sybase,
but decided SQL Server 2000 offered the best
solution for building an effective Web site
at lower cost and risk. Additionally, we received
excellent support from Microsoft personnel." |
IBM,
Sybase |
Outtask
Inc.
"There are certain
undeniable advantages to standardizing on
the Microsoft platform. As with the entire
suite of Microsoft .NET Enterprise Servers
[now Windows Server System], SQL Server 2000
allows us to move fast with a high level of
reliability and scalability. The speed at
which we can develop in the Microsoft environment
is far beyond what we could do in the Oracle
environment." |
Oracle |
PCS
Health Systems, Inc.
PCS Health Systems, Inc. chose SQL Server
2000 when it migrated a 1.3-terabyte data
warehouse from legacy systems, including an
IBM mainframe data warehouse. The result was
rapid, more flexible reporting without compromising
availability. |
IBM |
Premera
Blue Cross
"We believed
that Microsoft, in partnership with Unisys,
would deliver and create the highly centralized,
scalable, reliable environment that we needed
for our transaction engine and be best able
to provide it in a way that creates an integrated
solution all the way out to the desktop. The
Windows and ES7000 server platform offers
a better price/performance, and this choice
reduces the number of platforms that we have
to support." |
IBM,
Oracle, Sybase |
Radioshack.com
After migrating its Web site data tier from
Oracle to SQL Server 2000, RadioShack.com
enjoys seamless integration with legacy systems,
improved business intelligence capabilities,
and extensive personalization that meets the
needs of both B2B and B2C customers. |
IBM,
Oracle |
Safeway,
Inc.
After considering Linux, Sun Solaris, and
IBM AIX platforms, Safeway migrated its 1,800
in-store server network to the Windows Server
platform and SQL Server, resulting in a more
dependable, flexible, manageable, and cost-effective
platform. |
IBM |
Sandford
Bernstein
Sandford C. Bernstein, an investment research
and management firm, migrated its customer
care solution from Sybase to SQL Server, and
utilized the replication capabilities of SQL
Server to enhance customer service with a
more reliable and powerful centralized customer
view across sites in London, New York and
Los Angeles. |
Sybase |
Sanford
Limited
Sanford Limited migrated from an Oracle and
Solaris platform to the Microsoft platform
and SQL Server 2000. The solution was implemented
and deployed by their in-house staff in just
four months and has reduced Sanford's per-transaction
cost by nearly 50 percent and realized annual
savings of AU$480,000 (US$319,000) in licensing
and maintenance fees alone. |
Oracle |
Savings
Bank of the Russian Federation
After the deployment of a mainframe-based
solution failed, the Savings Bank of the Russian
Federation chose the Microsoft platform and
SQL Server 2000 to support its 18,000 branch
offices and 200,000 employees, and to process
millions of transactions per day and more
that 15 million documents a month. |
Mainframe |
Smead
Manufacturing Company
Smead's migration from an Oracle environment
to SQL Server simplifies operations, provides
rapid failover and recovery of mission-critical
applications, supports future growth, and
enables new e-business intiatives for its
PeopleSoft applications—all with a 75
percent reduction in total cost of ownership. |
Oracle |
Stratapult
After evaluating alternative solutions like
IBM and Oracle, Stratapult built a Web-enabled
business analysis portal using the Microsoft
platform and SQL Server 2000. The result:
a large e-business data warehouse system that
integrates with legacy systems and that is
scalable, flexible, and affordable. |
IBM,
Oracle |
Suncor
Energy
Suncor migrated its SAP R/3 application from
Oracle to SQL Server, which resulted in a
400% performance increase on batch jobs and
a projected availability of 99.99%. The company
projects that the new system will reduce hardware,
software, and support costs by 42% over six
years. The migration process was designed
and tested over a three-month period and implementation
was done over a weekend. |
Oracle |
University
of South Florida
The University of South Florida chose the
Microsoft platform and SQL Server 2000 to
build a complete Web-based student information
system that extracts information from an IBM
mainframe and other database systems throughout
the 36,000-student campus, increasing scalability
while also lowering total cost of ownership
and development costs. |
IBM,
Oracle |
|
Sources:
http://www.microsoft.com/sql/prodinfo/compare/switchers.mspx
http://members.microsoft.com/CustomerEvidence/Default.aspx
http://www.microsoft.com/sql
|
|
|
|
|
| |
 |
| Request
a real time demo. Please fill the form. One
of our represetative will contact shortly.
click
here |
|
|
|
| |
|
|
