SQL Server 2014 Free eBook

Microsoft is offering a Free eBook on SQL Server 2014.  Here is the link to download PDF file

Download Book: http://aka.ms/684751pdf

Happy Learning !!!

Harsh Shah

Download AdventureWorks sample database for SQL Server–Denali CTP1

 

AdventureWorks for Denali is available now and can be downloaded from the below link.

http://msftdbprodsamples.codeplex.com/releases/view/55330

Note:

1. 1. These databases cannot be installed on any version of SQL Server other than SQL Server code-named "Denali" CTP1.
2. Microsoft SQL Server "Denali" CTP1 must be installed.
3. Full-Text Search must be enabled

Download SQL Server 2008 R2 Developers Training Kit (June 2010 Update)

An update for SQL Server 2008 R2 Developers Training Kit (June 2010 Update) has been released.

The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server. The training kit is brought to you by Microsoft Developer and Platform Evangelism.

Please go through the below link as it contains lot of information about contents in this Training Kit update.

Download link : http://www.microsoft.com/downloads/details.aspx?familyid=FFFAAD6A-0153-4D41-B289-A3ED1D637C0D&displaylang=en

Happy Learning !!!

SQL Server Driver for PHP 2.0 CTP2 – June 2010

As of June 2010, the SQL Server Driver for PHP V2.0 CTP2 is available for download.

The SQL Server Driver for PHP is a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts. The extension provides a native procedural and PDO interfaces for accessing data in all editions of SQL Server 2005 and later including SQL Azure.

Please don’t forget to check the System Requirements. One thing I noticed here is, this driver is for Any edition of SQL Server 2005 or SQL Server 2008.

Click here to get more information : http://www.microsoft.com/downloads/details.aspx?FamilyID=DF4D9CC9-459C-4D75-A503-AE3FCEB85860&displaylang=en

Follow SQLPHP blog here

Happy Learning !!!

Download Free E-Book - Introducing Microsoft SQL Server 2008 R2

Dear Readers, today I came across a very good Free eBook on SQL Server 2008 R2. This a free ebook from Microsoft and you can download it from here – Introducing Microsoft SQL Server 2008 R2

The book contains following chapters

1. SQL Server 2008 R2 Editions and Enhancements
2. Multi-Server Administration
3. Data-Tier Applications
4. High Availability and Virtualization Enhancements
5. Consolidation and Monitoring
6. Scalable Data Warehousing
7. Master Data Services
8. Complex Event Processing with StreamInsight
9. Reporting Services Enhancements
10. Self-Service Analysis with PowerPivot

Happy Learning !!!

Download SQL Server 2008 R2 Guide

The SQL Server 2008 R2 Guide provides key information and resources on evaluating the product,installation instructions and a guided tour. This seems to be very useful document as it gives quick information SQL Server 2008 R2 capabilities.

Download the document here

Download SQL Server 2008 R2 Developers Training Kit (April 2010 Update)

Dear Readers,

We now have the SQL Server 2008 R2 Developers Training Kit update – April 2010 and it is available for download at :http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d

The training kit offers the following benefits:

• Learn how to build applications that exploit the unique features and capabilities of SQL Server 2008 and SQL Server 2008 R2.
• Provides a comprehensive set of videos, presentations, demos and hands-on labs
• Contains new content for developers who are new to SQL Server.
• Contains new content for SQL Server 2008 R2.
• Contains all of the existing content from the SQL Server 2008 Developer Training Kit.
• Easy to download and install.

Please visit the above mentioned link for more information on the updated Training Kit.

Happy Learning !!!

Download Free e-book on SQL Server 2008 R2 – Introducing Microsoft SQL Server 2008 R2

Dear Readers,

There is a free e-book available from Microsoft Press on – SQL Server 2008 R2. Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner.

The book contains the following chapters

PART I   Database Administration

CHAPTER 1   SQL Server 2008 R2 Editions and Enhancements 3
CHAPTER 2   Multi-Server Administration 21
CHAPTER 3   Data-Tier Applications 41
CHAPTER 4   High Availability and Virtualization Enhancements 63
CHAPTER 5   Consolidation and Monitoring 85

PART II   Business Intelligence Development

CHAPTER 6   Scalable Data Warehousing 109
CHAPTER 7   Master Data Services 125
CHAPTER 8   Complex Event Processing with StreamInsight 145
CHAPTER 9   Reporting Services Enhancements 165
CHAPTER 10   Self-Service Analysis with PowerPivot 189

Download e-Book: http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx

Happy Learning !!!

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 !!!

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 !!!