Microsoft SQL Server 2008
The previous release of SQL Server, SQL Server 2005, was a major release. It contained a ton of new functionality, including the revision of major query-processing components within the database engine. With SQL Server 2008, the development cycle was much shorter, and the changes are not quite as dramatic. Even though the overall quantity of changes is less than those in SQL Server 2005, the improvements that were made in this new release are specific and significant, and they will absolutely be of value to your organization.
SQL Server 2008 Editions
At the time of this writing, the SQL Server 2008 editions are essentially the same as those that were available for SQL Server 2005. Five main SQL Server 2008 editions are available:
SQL Server 2008 Requirements
The minimum RAM required to run SQL Server is 512MB, with 1GB recommended if you are planning to use SQL Server to handle larger workloads. For disk space, you need 290MB. Disk space is cheap. Even if you are installing SQL Server on a desktop machine, you probably have at least a few gigabytes free.
Why Choose SQL Server 2008
SQL Server faces competition from other databases, not only from other Microsoft products such as Microsoft Access and Microsoft Visual FoxPro, but also from competitors such as Oracle, Sybase, DB2, and Informix, to name a few.
The Vision of SQL Server 2008
SQL Server 2008 is driven by a vision consisting of four key pillars: enterprise data platform, beyond relational, dynamic development, and pervasive insight.
Upgrading to SQL Server 2008
Setup supports a direct upgrade from SQL Server 2000 and 2005. Those of you still on SQL 7.0 will need to upgrade to SQL Server 2000 or 2005 first before upgrading to SQL Server 2008. Since the product development cycle was shorter than that of SQL Server 2005, the changes and issues involved with upgrading from SQL Server 2005 to SQL Server 2008 are minimal compared with the move from SQL Server 2000 to SQL Server 2008. You can upgrade to SQL Server in two ways:
SQL Server 2008 Upgrade Planning
A smooth upgrade requires a good plan. Before you upgrade, you need to prepare your environment. The pre-upgrade tasks include the following:
Using Upgrade Advisor in SQL Server 2008
The Upgrade Advisor (UA) tool is available on the SQL Server 2008 installation disks, in the Servers\Redist\Upgrade Advisor folder. It will also be available as a free download from http://microsoft.com/downloads.
SQL Server 2008 : High Availability Defined
Ask ten database administrators (DBAs) how they define high availability (HA), and you’ll probably get ten different answers. We’re going to throw our own (informal) definition into the hat as well. In its simplest form, HA is about keeping your servers and their services up and running.
SQL Server 2008 Permissions
Permissions are the individual rights, granted (or denied) to a principal, to access a securable. As in previous SQL Server versions, you can GRANT permissions, DENY permissions, or REVOKE permissions that have already been granted. What’s changed is the sheer number of permissions that you can grant—there are 181 combinations of permissions and securables!
SQL Server Encryption
High-powered computers and cheap storage have made it possible for businesses to store unprecedented amounts of personal data about their customers. As a result, there has been a big push to secure this confidential information.
The previous release of SQL Server, SQL Server 2005, was a major release. It contained a ton of new functionality, including the revision of major query-processing components within the database engine. With SQL Server 2008, the development cycle was much shorter, and the changes are not quite as dramatic. Even though the overall quantity of changes is less than those in SQL Server 2005, the improvements that were made in this new release are specific and significant, and they will absolutely be of value to your organization.
SQL Server 2008 Editions
At the time of this writing, the SQL Server 2008 editions are essentially the same as those that were available for SQL Server 2005. Five main SQL Server 2008 editions are available:
SQL Server 2008 Requirements
The minimum RAM required to run SQL Server is 512MB, with 1GB recommended if you are planning to use SQL Server to handle larger workloads. For disk space, you need 290MB. Disk space is cheap. Even if you are installing SQL Server on a desktop machine, you probably have at least a few gigabytes free.
Why Choose SQL Server 2008
SQL Server faces competition from other databases, not only from other Microsoft products such as Microsoft Access and Microsoft Visual FoxPro, but also from competitors such as Oracle, Sybase, DB2, and Informix, to name a few.
The Vision of SQL Server 2008
SQL Server 2008 is driven by a vision consisting of four key pillars: enterprise data platform, beyond relational, dynamic development, and pervasive insight.
Upgrading to SQL Server 2008
Setup supports a direct upgrade from SQL Server 2000 and 2005. Those of you still on SQL 7.0 will need to upgrade to SQL Server 2000 or 2005 first before upgrading to SQL Server 2008. Since the product development cycle was shorter than that of SQL Server 2005, the changes and issues involved with upgrading from SQL Server 2005 to SQL Server 2008 are minimal compared with the move from SQL Server 2000 to SQL Server 2008. You can upgrade to SQL Server in two ways:
SQL Server 2008 Upgrade Planning
A smooth upgrade requires a good plan. Before you upgrade, you need to prepare your environment. The pre-upgrade tasks include the following:
Using Upgrade Advisor in SQL Server 2008
The Upgrade Advisor (UA) tool is available on the SQL Server 2008 installation disks, in the Servers\Redist\Upgrade Advisor folder. It will also be available as a free download from http://microsoft.com/downloads.
SQL Server 2008 : High Availability Defined
Ask ten database administrators (DBAs) how they define high availability (HA), and you’ll probably get ten different answers. We’re going to throw our own (informal) definition into the hat as well. In its simplest form, HA is about keeping your servers and their services up and running.
SQL Server 2008 Permissions
Permissions are the individual rights, granted (or denied) to a principal, to access a securable. As in previous SQL Server versions, you can GRANT permissions, DENY permissions, or REVOKE permissions that have already been granted. What’s changed is the sheer number of permissions that you can grant—there are 181 combinations of permissions and securables!
SQL Server Encryption
High-powered computers and cheap storage have made it possible for businesses to store unprecedented amounts of personal data about their customers. As a result, there has been a big push to secure this confidential information.
|
|
0 comments
Post a Comment