Microsoft® SQL ServerTM 2005 For Dummies®

Welcome to the world of SQL Server 2005. I am excited by the many new
capabilities of SQL Server 2005 and I hope that you are too.
SQL Server 2005 is the new edition of Microsoft’s SQL Server client-server
relational database. It’s a major release; the first in five years. SQL Server
2005 has many new features that help you manage a relational database and,
in many editions, adds important new business intelligence functionality.

SQL Server 2005, quite simply, is bigger and better than SQL Server 2000. It
offers functionality and pricing to help businesses of many sizes handle their
crucial business data more effectively and more efficiently. No, I am not a
Microsoft marketing person. It’s quite simply true that a lot of new features
and tools in SQL Server 2005 can help you look after your data.

SQL Server 2005 comes in several different editions:

Enterprise: Has the full functionality to support scalability and availability
needed by large enterprises. It supports an unlimited number of CPUs.
In addition, it has the full suite of Business Intelligence functionality.

Standard: Supports up to 4 CPUs. Has only some Business Intelligence
functionality; for example, it includes only basic Integration Services
transforms.

Workgroup: It has limited Business Intelligence support. No Analysis
Services or Integration Services support. No Web services support.

Developer: Has all the functionality included in Enterprise Edition, but it
is not licensed for production use.

Mobile: Microsoft’s mobile database solution. The successor to SQL
Server CE.

Express: A low-end free database with maximum 4GB database size. The
successor to MSDE. No full-text search. This edition is not covered in
this book, but another book — Microsoft SQL Server 2005 Express For
Dummies, by Robert Schneider (Wiley) — is dedicated to it.
At the time of writing a full feature comparison of the editions of SQL Server
2005 is at www.microsoft.com/sql/prodinfo/features/
compare-features.mspx.

SQL Server 2005 is huge. No book of this size can hope to cover it all. I have
had to make choices about the topics to include in this book to help you
understand how SQL Server works and how to use a range of its functionality.

Here are some of the things you can do with this book:

Find out how to use SQL Server Management Studio, the new management
tool in SQL Server 2005 that replaces Enterprise Manager and
Query Analyzer.

Create databases and tables.

Retrieve data from a SQL Server database.

Create maintenance plans.

Create an Integration Services project.

Create a simple Analysis Services project.

Use Reporting Services.

Download Ebook:
http://rapidshare.com/files/76331907/Microsoft_SQL_Server_2005_For_Dummies__2006_.pdf