Service broker is a technology available in all versions of SQL Server since SQL 2005 that provides a message based communication framework from within the database. This allows you to easily design distributed applications and to use asynchronous programming techniques for a scalable solution. The presentation is an introduction to this exciting technology and assumes no previous knowledge of service broker.

Anthony has been a sql server DBA since 1998 and have worked with all versions of SQL server since 6.5. Since 2001 he has worked at John Lewis on their website designing a highly scalable and resilient architecture for it. He has experience in many areas of sql server including service broker, replication and visual studio database projects.

This session will focus on the new features and walk through the authoring, management and delivery of reports, focusing on the new features of Reporting Services 2008 R2, creating a report in the new report designer and raising the awareness of report management options and the delivery mechanisms to deliver reports.

This session will focus on...

Report Designer Controls

An exploration of the report designer controls that are available that provides greater flexibility for creating reports from within SQL Server 2008 R2.

·         New Data Source support

·         Pagination

·         Data Synchronisation

Data Visualisation

An increased range of data visualisation will enable you to compelling reports that enables business users to interpret reports in an easier manner. Data visualisation improvements will cover...

·         Spark lines

·         Data bars

·         Indicators

·         Maps

Report Builder 3

Improve end users experience of creating as hoc reports with Report Builder 3, exploring new data regions and ways to browse and connect to data including...

·         Data Visualisation

·         Report Galleries

Extended Expression Support

Explore the extended expression support that provides greater flexibility adding custom components to the reports that you build including

·         Aggregation changes

·         Multiple data source

·         Conditional rendering

·         Group page numbering

Report Management

Explore the new features that provides expanded browser support and management functionality that makes it easier to administer and manage reports, including...

·         Report Manager changes

·         Report Viewer improvements

·         Improved security changes