Migrate to SQL Server 2008 R2 and Manage

So if you have decided to migrate your SQL Server database to SQL Server 2008 R2, Microsoft TechNet has collected resources for you to easily accomplish the job.

There are many scenarios during an upgrade where you’ll want to migrate a SQL Server installation. We've collected a series of articles and resources that describe the processes and tools to make the task easier.

This set of topics includes information on how to migrate a reporting services installation, how to migrate integration services packages, and how to migrate data transformation services packages.

Read more

Defensive Database Programming (Free eBook)

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected.
To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings.

Read more

Free ebook: Introducing Microsoft SQL Server 2008 R2

I am really thrilled to let you know about another free ebook: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner!
The book contains 10 chapters and 216 pages, like so:

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

Here’s more info about the book:

Introduction

Our purpose in Introducing Microsoft SQL Server 2008 R2 is to point out both
the new and the improved in the latest version of SQL Server. Because this
version is Release 2 (R2) of SQL Server 2008, you might think the changes are
relatively minor—more than a service pack, but not enough to justify an entirely
new version. However, as you read this book, we think you will find that there are a
lot of exciting enhancements and new capabilities engineered into SQL Server 2008 R2
that will have a positive impact on your applications, ranging from improvements
in operation to those in management. It is definitely not a minor release!

You can download the ebook in XPS format here and in PDF format here.

Read more