Hey folks,

It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger Doherty, Prashant Choudhari, Shireesh Thota, Charlie Carson, and Omri Bahat.

You can find it here: http://technet.microsoft.com/en-us/library/ff381683(SQL.100).aspx

There has been a lot of controversy about the latest addition to SQL 2008 R2 as to how to use these new Data Tier applications or DACPACs. This white paper will help you make sense of it all. This article walks you through how this can work in your organization. Here is the summary from the white paper:

“Microsoft’s investments in application and multi-server management will help reduce the complexity around developing, deploying, and managing applications. A core concept of application and multi-server management in SQL Server is the data-tier application (DAC). A DAC, introduced in the Microsoft® SQL Server® 2008 R2 data management software and the Microsoft Visual Studio® 2010 development system, is a self-contained unit of deployment that defines and bundles database objects, SQL Server instance objects that are associated with the database, and deployment requirements of an application. Using DACs, developers and database administrators can automate and facilitate common operations and practices in the lifecycle of database systems.?

Go check this out and keep your eyes peeled for all the other great whitepaper resources we’ll be reviewing on White Paper Wednesdays

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence.

Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world!

Lastly, don’t forget to follow me on twitter for all the latest updates@Adam_Jorgensen.