E-Books: Microsoft SQL Server 2005 for Dummies By Andrew Watt
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.
Click Here
