Microsoft SQL Server 2008 R2 Free E-Book

Microsoft recenltly released SQL Server 2008 R2 with new features that i’m really eager to try, also Microsoft Press published a new free e-book which is really a good starting point to get the most out of the new release

 

 

Table of Contents

 

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 it from here

Microsoft SQL Server 2005 Upgrade Advisor

Download details: Microsoft SQL Server 2005 Upgrade Advisor: "This tool helps Database developers and administrators analyze SQL Server 7.0 and SQL Server 2000 database servers in preparation for upgrading to SQL Server 2005."

download it here

SQL 2005 Service Broker

Stumbled today with this a very nice article "An Introduction to the Service Broker"  on SQLServerCentral explaining the Service Broker feature in MSSQL 2005, The idea of Service Broker is really useful in the scenarios where you need to execute your processes in asynchronously fashion.

 

Read it here

SQL 2005 Web Casts

here is a list of web casts for MS SQL 2005, so let’s prepare our selves and get ready with the assistance of these web casts.