Explore BI Features of SQL Server 2008 R2

SQL Server 2008 R2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence, improve IT and developer efficiency, and enable highly scalable and well managed Business Intelligence on a self-service basis for your users.

You can download the latest SQL Server 2008 R2 preview as well as Microsoft's complete Business Intelligence platform, including the new PowerPivot for Excel 2010 add-in now.

SQL Server 2008 R2 Content from PDC09

You can find out more about SQL Server 2008 R2 at these sessions from Professional Developers Conference (PDC09):

Reporting Services

https://microsoftpdc.com/Sessions/SVR09

SQL Server Reporting Services (SSRS) provides a comprehensive platform for developing and delivering rich enterprise reporting functionality over the Web. SSRS reports support rich data visualization and navigation features, and can be rendered in most popular formats. Come get a quick review of SSRS report development, and explore some of the key improvements in SQL Server 2008 R2, including new map visualizations, a new component library, using existing reports as a data source for the new PowerPivot functionality in Microsoft Excel 2010, and an improved AJAX enabled Report Viewer control for building Web-based reporting solutions.

Intro to StreamInsight

https://microsoftpdc.com/Sessions/SVR07

Microsoft SQL Server 2008 R2 includes an exciting new platform called StreamInsight for building rich data processing over real-time event streams. This technology is ideal for applications that need to process high volumes of event stream data with no latency. Learn the basics of how to build a StreamInsight input adapter for monitoring an event stream, how to construct real-time queries in LINQ and install them in the highly scalable StreamInsight engine, and how to build a StreamInsight output adapter to visualize the results from your queries

Advanced StreamInsight

https://microsoftpdc.com/Sessions/SVR08

This is the second session in a series focusing on Microsoft SQL Server 2008 R2 StreamInsight, a new platform for building rich data processing over real-time event streams. Come get a detailed architectural walkthrough of the three major components of StreamInsight: input and output adapters SDK, the StreamInsight engine runtime, and the semantics of the continuous standing queries hosted in the StreamInsight engine. Learn how the engine deals with out-of-order data arrival and how to achieve close to real-time latency for queries. Examine best practices for performance and scalability, and hear a few case studies of real-world StreamInsight implementations and the lessons learned from them.

DataTier Applications in Visual Studio 2008

https://microsoftpdc.com/Sessions/P09-15

Come explore the new enhancements in SQL Server 2008 R2, known as Application and Multi-Server Management, which enable a more efficient way to develop, deploy, and manage data-tier applications and instances. See how a new single unit of deployment for database applications is integrated with Microsoft Visual Studio and helps enable developers to more quickly write higher quality database applications, author deployment policies based on the needs of their applications, and hand off a single package to database administrators. Also learn how improvements combine a first-class Transact-SQL IDE with a new Visual Studio 2010 project template known as .DACPAC (Database Application Component) to produce a comprehensive model of the objects, policies and runtime resources required by a data-tier application.

Bruce D. KyleISV Architect Evangelist | Microsoft Corporation