Microsoft SQL Server
2005
|
Organizations
today face
numerous
data
challenges,
such as the
need to make
faster and
more
data-driven
decisions,
the need to
increase the
productivity
and
flexibility
of
development
staff, and
pressure to
reduce
overall
information
technology
(IT) budgets
while also
scaling the
infrastructure
to meet
ever-increasing
demands.
SQL Server
2005 is
designed to
help
enterprises
address
these
challenges.
This
next-generation
data
management
and analysis
solution
delivers
increased
security,
scalability,
and
availability
to
enterprise
data and
analytical
applications,
while making
them easier
to build,
deploy, and
manage.
Extending
the
strengths of
SQL Server
2000, SQL
Server 2005
provides an
integrated
data
management
and analysis
solution
that can
help
organizations
of any size
to do the
following:
|
• |
Build,
deploy,
and
manage
enterprise
applications
that
are
more
secure,
scalable,
and
reliable. |
|
• |
Maximize
IT
productivity
by
reducing
the
complexity
of
developing
and
supporting
database
applications. |
|
• |
Share
data
across
multiple
platforms,
applications,
and
devices
to
make
it
easier
to
connect
internal
and
external
systems. |
|
• |
Control
costs
without
sacrificing
performance,
availability,
scalability,
or
security. |
SQL Server
2005
advances
your data
infrastructure
in three key
areas:
enterprise
data
management,
developer
productivity,
and business
intelligence
(BI). It
also breaks
new ground
in
affordable
pricing and
licensing,
upgrade
paths to SQL
Server 2005,
and the
Microsoft
Windows
Server
System.
SQL
Server Data
Platform
SQL Server
is a
comprehensive,
integrated,
end-to-end
data
solution
that
empowers
users across
your
organization
by providing
a more
secure,
reliable,
and
productive
platform for
enterprise
data and BI
applications.
SQL Server
2005
delivers
powerful,
familiar
tools to IT
professionals
as well as
to
information
workers,
reducing the
complexity
of creating,
deploying,
managing,
and using
enterprise
data and
analytical
applications
on platforms
ranging from
mobile
devices to
enterprise
data
systems.
Through a
comprehensive
feature set,
interoperability
with
existing
systems, and
automation
of routine
tasks, SQL
Server 2005
provides a
complete
data
solution for
enterprises
of all
sizes.
Figure 1
shows the
layout of
the SQL
Server 2005
data
platform.
The SQL Server data platform includes the following tools:
| • |
Relational Database. A more secure, reliable, scalable, highly available relational database engine with improved performance and support for structured and unstructured (XML) data. |
| • |
Replication Services. Data replication for distributed or mobile data processing applications, high systems availability, scalable concurrency with secondary data stores for enterprise reporting solutions, and integration with heterogeneous systems, including existing Oracle databases. |
| • |
Notification Services. Advanced notification capabilities for the development and deployment of scalable applications that can deliver personalized, timely information updates to a variety of connected and mobile devices. |
| • |
Integration Services.Data extraction, transformation, and loading (ETL) capabilities for data warehousing and enterprise-wide data integration. |
| • |
Analysis Services. Online analytical processing (OLAP) capabilities for the rapid and sophisticated analysis of large and complex datasets using multidimensional storage. |
| • |
Reporting Services. A comprehensive solution for creating, managing, and delivering both traditional, paper-oriented reports and interactive, Web-based reports. |
| • |
Management Tools. SQL Server includes integrated management tools for advanced database management and tuning as well as tight integration with tools such as Microsoft Operations Manager (MOM) and Microsoft Systems Management Server (SMS). Standard data access protocols drastically reduce the time it takes to integrate data in SQL Server with existing systems. In addition, native Web service support is built into SQL Server to ensure interoperability with other applications and platforms. |
| • |
Development Tools. SQL Server offers integrated development tools for the database engine, data extraction, transformation, and loading, data mining, OLAP, and reporting that are tightly integrated with Microsoft Visual Studio to provide end-to-end application development capabilities. Every major subsystem in SQL Server ships with its own object model and set of application program interfaces (APIs) to extend the data system in any direction that is unique to your business. |
The SQL Server 2005 data platform provides organizations of all sizes with the following benefits:
| • |
Capitalize on Data Assets. In addition to delivering a secure, reliable database for line-of-business and analytical applications, SQL Server 2005 enables customers to get more value from their data by including embedded functionality such as reporting, analysis, and data mining. You can take advantage of this power and flexibility to deliver data to every corner of your organization at a fraction of the cost of some other systems. |
| • |
Increase Productivity. Through comprehensive BI capabilities and integration with familiar tools such as Microsoft Office System, SQL Server 2005 provides information workers across your organization with critical and timely business information that is tailored to their specific needs. The goal is to extend BI to all users within an organization and ultimately to help users at all levels of the organization make better business decisions based on one of their most valuable assets—their data. |
| • |
Reduce IT Complexity. SQL Server 2005 simplifies the development, deployment, and management of line-of-business and analytical applications by providing a flexible development environment for developers and integrated, automated management tools for database administrators. |
| • |
Lower Total Cost of Ownership (TCO). The integrated approach and focus on ease of use and deployment in SQL Server 2005 provides the industry's lowest upfront, implementation, and maintenance costs for rapid return on your database investment. |
SQL Server 2005 provides the technology and capabilities that your organization can count on. With significant advancements in the key areas of enterprise data management, developer productivity, and BI, the benefits of upgrading or migrating to SQL Server 2005 are substantial.
SQL Server 2005 has the potential to take your business to the next level—we encourage you to try it for yourself.
|
|
|
|
|
|
|
|
Massey
Consulting