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

LLBLGen Pro v3.0 RTM has been released!

After two years of very hard work, version 3.0 has been released! 
LLBLGen Pro now is the most advanced O/RM Designer for .NET and offers, among other things, Entity Framework (v1 & v4) support, NHibernate support (hbm & FluentNH), Linq to SQL support, Model-first and Database-first development, .NET 4.0 support, Model views and much much more.

Click here for the full feature list or download the trial to experience the power of v3.0 yourself. Congratulations team for another nice effort.

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