Note:Â Â Download SQL Server 2008 Developer Training Kit by Microsoft
SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2005. The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008. The training kit is brought to you by Microsoft Developer and Platform Evangelism.
The training kit includes the following content:
- Presentations (6)
- Filestream
- Spatial
- T-SQL
- Date and Time Types
- SQLCLR
- Reporting Services
- Demos (12)
- AdventureWorks Racing All-Up SQL Server 2008 Demo
- SQL Server 2008 All-Up Spatial Demo
- Spatial Types Demo
- Intro to Filestream Demo
- SQL CLR Nullable Types Demo
- Programming with Filestream Demo
- Reporting Services Web Application Integration Demo
- Date and Time Support in SQL Server 2008 Demo
- T-SQL Table-Valued Parameters Demo
- T-SQL Row Constructors Demo
- T-SQL Grouping Sets Demo
- T-SQL Merge Demo
- Hands-on Labs (3)
- Using Spatial Data in TSQL
- Using Spatial Data in Managed Code
- Using SQL CLR in SQL Server 2008
Download SQL Server 2008 Developer Training Kit
If you are using SQL Server 2008 or later version this training kit can be very helpful.
Reference : Pinal Dave (https://blog.sqlauthority.com)
3 Comments. Leave new
Iam vist your blog and learn lot of things , iam new in database . Have you any DBA Training KIET SQL SERVER 2008.
I have downloaded both sql 2008 developer training kit, and
2008 AdventureWorks Sample Database , but I have no idea how to create the AW db correctly. I got the syntax error after I made data loc change and uncommentd the 2nd setvar statement as shown below…
Here are some of the statements in the instawdb.sql
–:setvar SqlSamplesDatabasePath “C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\”
–:setvar SqlSamplesSourceDataPath “C:\Program Files\Microsoft SQL Server\100\Tools\Samples\”
IF ‘$(SqlSamplesSourceDataPath)’ IS NULL OR ‘$(SqlSamplesSourceDataPath)’ = ”
BEGIN
RAISERROR(N’The variable SqlSamplesSourceDataPath must be defined.’, 16, 127) WITH NOWAIT
RETURN
END
Would you please help? I’ll appreciate it.
@Mei,
The correct and recommended way of installing the Sample Databases in SQL Server 2008 are given below
Download the samples from
or x64)
And installation proc @
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms161556(v=sql.105)
Thanks