SQL Server 2005 Samples and Sample Databases - Data Access Full-Text Search CLR SMO Service Broker XML

You can download over 100 samples for SQL Server 2005, demonstrating the following components:

• Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML
• Analysis Services
• Integration Services
• Notification Services
• Reporting Services
• Replication

The samples databases downloads include the AdventureWorks sample online transaction processing (OLTP) database, the AdventureWorksDW sample data warehouse, and the AdventureWorksAS sample Analysis Services database. These databases are used in the samples and in the code examples in the SQL Server 2005 Books Online.

Learn more here.

Posted by David Hayden ( Florida .NET Developer )

Other SQL Server 2005 Tutorials

• SQL Server 2005 System View Map - SQL Server 2005 Schema
• System.Transactions for Sql Server 2000 and Sql Server 2005 - TransactionScope and SqlTransaction
• Sql Server 2005 Service Manager
• Microsoft SQL Server Management Studio Express - Graphical Management Tool
• ObjectDataSource Control and Concurrency in Multiuser ASP.NET Web Applications - OverwriteChanges - CompareAllValues
• SQL Server Transaction Savepoints - Rollback Part of Transaction - SqlTransaction.Save - SqlTransaction.Rollback
• Sql Server Transactions - ADO.NET 2.0 - Commit and Rollback - Using Statement - IDisposable
• SQL Server - Optimistic Concurrency Database Updating - Pessimistic Concurrency - High Performance ASP.NET Websites

 

posted on Sunday, December 25, 2005 9:10 PM