Download SQL Server 2008 Samples

Now we have a new location for SQL Server 2008 Samples. The new location is on the codePlex web site. Please find the below link to download the SQL Server 2008 Samples
http://sqlserversamples.codeplex.com/Wikipage

Quickly :
Download AdventureWorks Family Database:
http://msftdbprodsamples.codeplex.com/releases/view/37109
Download All the samples together without AdventureWorks
http://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=SqlServerSamples

Happy Learning !!!

Advertisements

Download BI Architecture and Design Guide – Microsoft Business Intelligence

Today, I came across very useful design guide for Microsoft BI and thought to share with the readers.
This guide is available for download on CodePlex.com. It contains following chapters.

  1. BI Framework
  2. Data Extraction
  3. Data Staging
  4. Data Transformations and Data Quality
  5. Data Loading
  6. Dimensional Modeling
  7. Data Partitions
  8. Online Analytical Processing (OLAP)
  9. Data Mining

Please visit : http://biarchanddesignguide.codeplex.com/ for more information on the design guide and to download the material.

Happy Learning !!!

SSIS Webcast Watch : Tuning Your SSIS Package Data Flow in the Enterprise

Tuning Your SSIS Package Data Flow in the Enterprise video gives you a very good understanding on the SSIS tuning part.

Download Video from here:

http://msdn.microsoft.com/en-us/library/dd795224.aspx

There are couple of other video links are available for download on SSIS. So don’t forget to check that. Those are really good videos and gives lot of knowledge on the performance tuning of SSIS packages.

Happy Learning !!!

Download SQL Server 2008 R2 Developers Training Kit

Hello Readers,

SQL Server 2008 R2 Developers Training Kit is available now for the download. You can download it from the  below MSDN link.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d

The training kit is brought to you by Microsoft Developer and Platform Evangelism.

Following are the contents of the Developer Training Kit. For more details please visit the link mentioned above.

Contents
The training kit includes the following content:

  • Videos (8)
    • SQL Server 2008 R2 Update for Developers Overview Part I – SQL Server 2008 Review
    • SQL Server 2008 R2 Update for Developers Overview Part II – Introducing SQL Server 2008 R2
    • Introducing SQL Server 2008 R2 StreamInsight
    • Demo: Real Time Analytics with SQL Server 2008 R2 StreamInsight
    • Introducing SQL Server 2008 R2 Application and Multi-Server Management
    • Introducing SQL Server 2008 R2 Reporting Services
    • Introduction To SQL Server 2008 R2 StreamInsight and Complex Event Processing
    • Introducing PowerPivot for Excel 2010 and SharePoint 2010
  • Presentations (8)
    • SQL Server 2008 R2 Update for Developers Overview Part I – SQL Server 2008 Review
    • SQL Server 2008 R2 Update for Developers Overview Part II – Introducing SQL Server 2008 R2
    • SQL Server 2008 Filestream
    • SQL Server 2008 Spatial
    • SQL Server 2008 T-SQL
    • SQL Server 2008 Date and Time Types
    • SQL SErver 2008 SQLCLR
    • SQL Server 2008 Reporting Services
  • Demos (13)
    • AdventureWorks Racing All-Up SQL Server 2008 Demo
    • SQL Server 2008 All-Up Spatial Demo
    • SQL Server 2008 Spatial Types Demo
    • Intro to SQL Server 2008 Filestream Demo
    • SQL Server 2008 SQL CLR Nullable Types Demo
    • Programming with SQL Server 2008 Filestream Demo
    • SQL Server 2008 Reporting Services Web Application Integration Demo
    • Date and Time Support in SQL Server 2008 Demo
    • SQL Server 2008 T-SQL Table-Valued Parameters Demo
    • SQL Server 2008 T-SQL Row Constructors Demo
    • SQL Server 2008 T-SQL Grouping Sets Demo
    • SQL Server 2008 T-SQL Merge Demo
  • Hands-on Labs (8)
    • How to build your first Web Application with SQL Server and ASP.NET
    • Using SQL Server 2008 Spatial Data in TSQL
    • Using SQL Server 2008 Spatial Data in Managed Code
    • Using SQL CLR in SQL Server 2008
    • PowerPivot in SQL Server 2008 R2
    • Using the New Features of Reporting Services 2008 R2
    • Introduction To SQL Server 2008 R2 StreamInsight and Complex Event Processing
    • Data-tier Applications in SQL Server 2008 R2 and Visual Studio 2010

Happy Learning !!!