nalinb80
01-10-2009, 05:07 PM
SQL Server 2008 Enterprise edition in both x86 and x64 versions:
SQL Server 2008
Experience a trusted, productive, and intelligent relational database management system that provides an enterprise-ready data platform for organizations to manage any data, any place, any time.
OverviewYour Data, Any Place, Any Time
SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. Store data from structured, semi-structured, and unstructured documents, such as images and rich media, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze.
SQL Server 2008 provides the highest levels of security, reliability, and scalability for your business-critical applications. To take advantage of new opportunities in today's fast-moving business world, companies need the ability to create and deploy data-driven solutions quickly. SQL Server 2008 reduces time and cost of management and development of applications.
Access data from across your enterprise and provide control over your data no matter where it’s stored—from the largest servers within the data center to desktops to mobile devices. SQL Server 2008 provides a comprehensive platform that delivers intelligence where your users want it. Information workers can access data directly using the tools they use every day, such as the 2007 Microsoft Office system.
SQL Server 2008 enables data to be consumed from custom applications developed using Microsoft .NET and Visual Studio and from within service-oriented architectures (SOA) and business processes through Microsoft BizTalk Server.
Microsoft Data Platform Vision
http://i44.tinypic.com/2q09a8g.gif
Solutions
Business Intelligence
Learn how SQL Server 2008 provides a scalable business intelligence platform optimized for data integration, reporting, and analysis, enabling organizations to deliver intelligence where users want it.
Virtualization and Server Consolidation
Server virtualization, also known as hardware virtualization, is a hot topic in the IT world because it can provide dramatic cost savings while enhancing a company’s agility.
Server Consolidation
Read about how SQL Server 2008 reduces hardware and maintenance costs by providing a flexible server consolidation solution with enterprise-class manageability and performance.
OLTP
Find out how SQL Server 2008 provides a scalable, high performance database engine for mission-critical applications that require the highest levels of availability and security, while reducing the total cost of ownership through enhanced enterprise-class manageability.
Data Warehousing
Discover how SQL Server 2008 provides a comprehensive and scalable data warehouse platform that enables organizations to integrate data into the data warehouse faster, scale and manage growing volumes of data and users, while delivering insights to all users.
Application Development
See how SQL Server 2008 is at the heart of a comprehensive data programmability platform that enables you to access and manipulate business-critical data from a variety of diverse devices, platforms, and data.
Learn More
10 reasons why SQL Server 2008 is going to rock
Just like its predecessor, SQL Server 2008 is taking its sweet time to actually ship. However, unlike its predecessor, it won't just be a "worthwhile upgrade". It will kick ass.
Here are the top 10 reasons why.
10. Plug-in model for SSMS. SSMS 2005 also had a plug-in model, but it was not published, so the few developers that braved that environment were flying blind. Apparently for 2008, the plug-in model will be published and a thousand add-ins will bloom.
9. Inline variable assignment. I often wondered why, as a language, SQL languishes behind the times. I mean, it has barely any modern syntactic sugar. Well, in this version, they are at least scratching the the tip of the iceberg.
Instead of:
DECLARE @myVar int
SET @myVar = 5
you can do it in one line:
DECLARE @myVar int = 5
Sweet.
8. C like math syntax. SET @i += 5. Enough said. They finally let a C# developer on the SQL team.
7. Auditing. It's a 10 dollar word for storing changes to your data for later review, debugging or in response to regulatory laws. It's a thankless and a mundane task and no one is ever excited by the prospect of writing triggers to handle it. SQL Server 2008 introduces automatic auditing, so we can now check one thing off our to do list.
6. Compression. You may think that this feature is a waste of time, but it's not what it sounds like. The release will offer row-level and page-level compression. The compression mostly takes place on the metadata. For instance, page compression will store common data for affected rows in a single place.
The metadata storage for variable length fields is going to be completely crazy: they are pushing things into bits (instead of bytes). For instance, length of the varchar will be stored in 3 bits.
Anyway, I don't really care about space savings - storage is cheap. What I do care about is that the feature promised (key word here "promises") to reduce I/O and RAM utilization, while increasing CPU utilization. Every single performance problem I ever dealt with had to do with I/O overloading. Will see how this plays out. I am skeptical until I see some real world production benchmarks.
5. Filtered Indexes. This is another feature that sounds great - will have to see how it plays out. Anyway, it allows you to create an index while specifying what rows are not to be in the index. For example, index all rows where Status != null. Theoretically, it'll get rid of all the dead weight in the index, allowing for faster queries.
4. Resource governor. All I can say is FINALLY. Sybase has had it since version 12 (that's last millennium, people). Basically it allows the DBA to specify how much resources (e.g. CPU/RAM) each user is entitled to. At the very least, it'll prevent people, with sparse SQL knowledge from shooting off a query with a Cartesian product and bringing down the box.
Actually Sybase is still ahead of MS on this feature. Its ASE server allows you to prioritize one user over another - a feature that I found immensely useful.
3. Plan freezing. This is a solution to my personal pet peeve. Sometimes SQL Server decides to change its plan on you (in response to data changes, etc...). If you've achieved your optimal query plan, now you can stick with it. Yeah, I know, hints are evil, but there are situations when you want to take a hammer to SQL Server - well, this is the chill pill.
2. Processing of delimited strings. This is awesome and I could have used this feature...well, always. Currently, we pass in delimited strings in the following manner:
exec sp_MySproc 'murphy,35;galen,31;samuels,27;colton,42'
Then the stored proc needs to parse the string into a usable form - a mindless task.
In 2008, Microsoft introduced Table Value Parameters (TVP).
CREATE TYPE PeepsType AS TABLE (Name varchar(20), Age int)
DECLARE @myPeeps PeepsType
INSERT @myPeeps SELECT 'murphy', 35
INSERT @myPeeps SELECT 'galen', 31
INSERT @myPeeps SELECT 'samuels', 27
INSERT @myPeeps SELECT 'colton', 42
exec sp_MySproc2 @myPeeps
And the sproc would look like this:
CREATE PROCEDURE sp_MySproc2(@myPeeps PeepsType READONLY) ...
The advantage here is that you can treat the Table Type as a regular table, use it in joins, etc. Say goodbye to all those string parsing routines.
1. Intellisense in the SQL Server Management Studio (SSMS). This has been previously possible in SQL Server 2000 and 2005 with use of 3rd party add-ins like SQL Prompt ($195). But these tools are a horrible hack at best (e.g. they hook into the editor window and try to interpret what the application is doing).
Built-in intellisense is huge - it means new people can easily learn the database schema as they go.
There are a ton of other great features - most of them small, but hugely useful. There is a lot of polishing all over the place, like server resource monitoring right in SSMS, a la Vista.
I'd love to finish this entry on a happy note, but I can't, because I just finished perusing Editions of SQL Server 2008 page. In addition to the Standard, Enterprise, Developer and Express editions, there are now Workgroup, Web, Compact (which has nothing to do with SQL Server) and Express Advanced editions. Here is the comparison matrix. And you thought picking a version of Vista was complicated.
[quote]SQL Server 2008 Top New Features
Enterprise Data Platform
Policy-Based Management
Policy-Based Management enables the efficient management of multiple SQL Server instances from a single location. Easily create policies that control security, database options, object naming conventions, and other settings at a highly granular level. Policies can evaluate servers for compliance with a set of predefined conditions and prevent undesirable changes being made to servers.
Additional Resources
Administering Servers by Using Policy-Based Management
SQL Server Policy-Based Management Blog
Management is centralized, thereby reducing the need to configure each server separately
Administration is simplified, reducing the effort required to maintain standardization and compliance, even in complex environments
Configuration is straightforward and can be done entirely within SQL Server Management Studio
Out-of-the-box predefined policies make it easy to get started
Backwards compatibility supports managing instances of SQL Server 2008, SQL Server 2005, and SQL Server 2000
Performance Data Collection (Data Collector)
The Data Collector provides a convenient way to collect, store, and view performance data automatically. It collects disk usage, server activity, and query statistics data, which it loads in a management data warehouse and performance data can be reviewed in SQL Server Management Studio or by using third-party tools.
Additional Resources
Performance Data Collector for SQL Server 2008-Revealed
Data Collector in DQL Server 2008
Troubleshooting the Data Collector
Introducing the Data Collector
Setup wizard makes configuration simple
Data collection is automated by using set of SQL Server Agent jobs and SQL Server Integration Services packages
Management is centralized so data collection can be easily configured and results can be viewed in one place
Performance impact is minimal because the data collected can be cached and uploaded to the data warehouse later
Data Compression
Data compression reduces the amount of storage space needed to store tables and indexes, which enables more efficient storage of data. Data Compression does not require changes be made to applications in order to be enabled.
Additional Resources
Backup Compression (SQL Server)
SQL Server Storage Engine
Save disk storage
Enable compression option for individual tables or indexes
Configuration is easy using the Data Compression wizard
Applications do not instanceu
Download Links:-
[/code]http://rapidshare.com/users/5DJG22
http://rapidshare.com/files/171089143/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part13.rar
http://rapidshare.com/files/171089183/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part12.rar
http://rapidshare.com/files/171066344/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part11.rar
http://rapidshare.com/files/171074114/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part10.rar
http://rapidshare.com/files/171088067/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part09.rar
http://rapidshare.com/files/171065853/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part08.rar
http://rapidshare.com/files/171058004/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part07.rar
http://rapidshare.com/files/171057728/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part06.rar
http://rapidshare.com/files/171056259/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part05.rar
http://rapidshare.com/files/171048365/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part04.rar
http://rapidshare.com/files/170772961/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part03.rar
http://rapidshare.com/files/170771174/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part02.rar
http://rapidshare.com/files/171047366/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part01.rar
All links 13
Size /link 200 MB
ISO Size 3.9 GB
Password: " Code:
www.microsoftadmin.in
" all in small caps
Recovery Record : Yes 20 %
License : Volume Licensed . No need to do anything except install .
Checked : 100 % Installed on 10 Live servers . [/code]
SQL Server 2008
Experience a trusted, productive, and intelligent relational database management system that provides an enterprise-ready data platform for organizations to manage any data, any place, any time.
OverviewYour Data, Any Place, Any Time
SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. Store data from structured, semi-structured, and unstructured documents, such as images and rich media, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze.
SQL Server 2008 provides the highest levels of security, reliability, and scalability for your business-critical applications. To take advantage of new opportunities in today's fast-moving business world, companies need the ability to create and deploy data-driven solutions quickly. SQL Server 2008 reduces time and cost of management and development of applications.
Access data from across your enterprise and provide control over your data no matter where it’s stored—from the largest servers within the data center to desktops to mobile devices. SQL Server 2008 provides a comprehensive platform that delivers intelligence where your users want it. Information workers can access data directly using the tools they use every day, such as the 2007 Microsoft Office system.
SQL Server 2008 enables data to be consumed from custom applications developed using Microsoft .NET and Visual Studio and from within service-oriented architectures (SOA) and business processes through Microsoft BizTalk Server.
Microsoft Data Platform Vision
http://i44.tinypic.com/2q09a8g.gif
Solutions
Business Intelligence
Learn how SQL Server 2008 provides a scalable business intelligence platform optimized for data integration, reporting, and analysis, enabling organizations to deliver intelligence where users want it.
Virtualization and Server Consolidation
Server virtualization, also known as hardware virtualization, is a hot topic in the IT world because it can provide dramatic cost savings while enhancing a company’s agility.
Server Consolidation
Read about how SQL Server 2008 reduces hardware and maintenance costs by providing a flexible server consolidation solution with enterprise-class manageability and performance.
OLTP
Find out how SQL Server 2008 provides a scalable, high performance database engine for mission-critical applications that require the highest levels of availability and security, while reducing the total cost of ownership through enhanced enterprise-class manageability.
Data Warehousing
Discover how SQL Server 2008 provides a comprehensive and scalable data warehouse platform that enables organizations to integrate data into the data warehouse faster, scale and manage growing volumes of data and users, while delivering insights to all users.
Application Development
See how SQL Server 2008 is at the heart of a comprehensive data programmability platform that enables you to access and manipulate business-critical data from a variety of diverse devices, platforms, and data.
Learn More
10 reasons why SQL Server 2008 is going to rock
Just like its predecessor, SQL Server 2008 is taking its sweet time to actually ship. However, unlike its predecessor, it won't just be a "worthwhile upgrade". It will kick ass.
Here are the top 10 reasons why.
10. Plug-in model for SSMS. SSMS 2005 also had a plug-in model, but it was not published, so the few developers that braved that environment were flying blind. Apparently for 2008, the plug-in model will be published and a thousand add-ins will bloom.
9. Inline variable assignment. I often wondered why, as a language, SQL languishes behind the times. I mean, it has barely any modern syntactic sugar. Well, in this version, they are at least scratching the the tip of the iceberg.
Instead of:
DECLARE @myVar int
SET @myVar = 5
you can do it in one line:
DECLARE @myVar int = 5
Sweet.
8. C like math syntax. SET @i += 5. Enough said. They finally let a C# developer on the SQL team.
7. Auditing. It's a 10 dollar word for storing changes to your data for later review, debugging or in response to regulatory laws. It's a thankless and a mundane task and no one is ever excited by the prospect of writing triggers to handle it. SQL Server 2008 introduces automatic auditing, so we can now check one thing off our to do list.
6. Compression. You may think that this feature is a waste of time, but it's not what it sounds like. The release will offer row-level and page-level compression. The compression mostly takes place on the metadata. For instance, page compression will store common data for affected rows in a single place.
The metadata storage for variable length fields is going to be completely crazy: they are pushing things into bits (instead of bytes). For instance, length of the varchar will be stored in 3 bits.
Anyway, I don't really care about space savings - storage is cheap. What I do care about is that the feature promised (key word here "promises") to reduce I/O and RAM utilization, while increasing CPU utilization. Every single performance problem I ever dealt with had to do with I/O overloading. Will see how this plays out. I am skeptical until I see some real world production benchmarks.
5. Filtered Indexes. This is another feature that sounds great - will have to see how it plays out. Anyway, it allows you to create an index while specifying what rows are not to be in the index. For example, index all rows where Status != null. Theoretically, it'll get rid of all the dead weight in the index, allowing for faster queries.
4. Resource governor. All I can say is FINALLY. Sybase has had it since version 12 (that's last millennium, people). Basically it allows the DBA to specify how much resources (e.g. CPU/RAM) each user is entitled to. At the very least, it'll prevent people, with sparse SQL knowledge from shooting off a query with a Cartesian product and bringing down the box.
Actually Sybase is still ahead of MS on this feature. Its ASE server allows you to prioritize one user over another - a feature that I found immensely useful.
3. Plan freezing. This is a solution to my personal pet peeve. Sometimes SQL Server decides to change its plan on you (in response to data changes, etc...). If you've achieved your optimal query plan, now you can stick with it. Yeah, I know, hints are evil, but there are situations when you want to take a hammer to SQL Server - well, this is the chill pill.
2. Processing of delimited strings. This is awesome and I could have used this feature...well, always. Currently, we pass in delimited strings in the following manner:
exec sp_MySproc 'murphy,35;galen,31;samuels,27;colton,42'
Then the stored proc needs to parse the string into a usable form - a mindless task.
In 2008, Microsoft introduced Table Value Parameters (TVP).
CREATE TYPE PeepsType AS TABLE (Name varchar(20), Age int)
DECLARE @myPeeps PeepsType
INSERT @myPeeps SELECT 'murphy', 35
INSERT @myPeeps SELECT 'galen', 31
INSERT @myPeeps SELECT 'samuels', 27
INSERT @myPeeps SELECT 'colton', 42
exec sp_MySproc2 @myPeeps
And the sproc would look like this:
CREATE PROCEDURE sp_MySproc2(@myPeeps PeepsType READONLY) ...
The advantage here is that you can treat the Table Type as a regular table, use it in joins, etc. Say goodbye to all those string parsing routines.
1. Intellisense in the SQL Server Management Studio (SSMS). This has been previously possible in SQL Server 2000 and 2005 with use of 3rd party add-ins like SQL Prompt ($195). But these tools are a horrible hack at best (e.g. they hook into the editor window and try to interpret what the application is doing).
Built-in intellisense is huge - it means new people can easily learn the database schema as they go.
There are a ton of other great features - most of them small, but hugely useful. There is a lot of polishing all over the place, like server resource monitoring right in SSMS, a la Vista.
I'd love to finish this entry on a happy note, but I can't, because I just finished perusing Editions of SQL Server 2008 page. In addition to the Standard, Enterprise, Developer and Express editions, there are now Workgroup, Web, Compact (which has nothing to do with SQL Server) and Express Advanced editions. Here is the comparison matrix. And you thought picking a version of Vista was complicated.
[quote]SQL Server 2008 Top New Features
Enterprise Data Platform
Policy-Based Management
Policy-Based Management enables the efficient management of multiple SQL Server instances from a single location. Easily create policies that control security, database options, object naming conventions, and other settings at a highly granular level. Policies can evaluate servers for compliance with a set of predefined conditions and prevent undesirable changes being made to servers.
Additional Resources
Administering Servers by Using Policy-Based Management
SQL Server Policy-Based Management Blog
Management is centralized, thereby reducing the need to configure each server separately
Administration is simplified, reducing the effort required to maintain standardization and compliance, even in complex environments
Configuration is straightforward and can be done entirely within SQL Server Management Studio
Out-of-the-box predefined policies make it easy to get started
Backwards compatibility supports managing instances of SQL Server 2008, SQL Server 2005, and SQL Server 2000
Performance Data Collection (Data Collector)
The Data Collector provides a convenient way to collect, store, and view performance data automatically. It collects disk usage, server activity, and query statistics data, which it loads in a management data warehouse and performance data can be reviewed in SQL Server Management Studio or by using third-party tools.
Additional Resources
Performance Data Collector for SQL Server 2008-Revealed
Data Collector in DQL Server 2008
Troubleshooting the Data Collector
Introducing the Data Collector
Setup wizard makes configuration simple
Data collection is automated by using set of SQL Server Agent jobs and SQL Server Integration Services packages
Management is centralized so data collection can be easily configured and results can be viewed in one place
Performance impact is minimal because the data collected can be cached and uploaded to the data warehouse later
Data Compression
Data compression reduces the amount of storage space needed to store tables and indexes, which enables more efficient storage of data. Data Compression does not require changes be made to applications in order to be enabled.
Additional Resources
Backup Compression (SQL Server)
SQL Server Storage Engine
Save disk storage
Enable compression option for individual tables or indexes
Configuration is easy using the Data Compression wizard
Applications do not instanceu
Download Links:-
[/code]http://rapidshare.com/users/5DJG22
http://rapidshare.com/files/171089143/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part13.rar
http://rapidshare.com/files/171089183/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part12.rar
http://rapidshare.com/files/171066344/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part11.rar
http://rapidshare.com/files/171074114/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part10.rar
http://rapidshare.com/files/171088067/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part09.rar
http://rapidshare.com/files/171065853/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part08.rar
http://rapidshare.com/files/171058004/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part07.rar
http://rapidshare.com/files/171057728/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part06.rar
http://rapidshare.com/files/171056259/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part05.rar
http://rapidshare.com/files/171048365/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part04.rar
http://rapidshare.com/files/170772961/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part03.rar
http://rapidshare.com/files/170771174/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part02.rar
http://rapidshare.com/files/171047366/SW_DVD5_SQL_Svr_Enterprise_Edtn_2008_English_MLF_X14-89207_2_.part01.rar
All links 13
Size /link 200 MB
ISO Size 3.9 GB
Password: " Code:
www.microsoftadmin.in
" all in small caps
Recovery Record : Yes 20 %
License : Volume Licensed . No need to do anything except install .
Checked : 100 % Installed on 10 Live servers . [/code]