1

Antonios ChatzipavlisSolutions Architect , Developer Evangelist, IT Consultant

MCT, MCITP, MCPD, MCSD, MCDBA, MCSA, MCTS, MCAD, MCP, OCA

2

• Database Engine Enhancements

• Integration Services Enhancements

• Reporting Services Enhancements

• Συζήτηση και ερωτήσεις σε ερωτήματα ανάπτυξης

3

Programmability Enhancements In SQL Server 2008 R2

4

• Compressed Storage of Tables and Indexes

• FILESTREAM Storage

• New Collations

• Partition Switching on Partitioned Tables and Indexes

• Sparse Columns and Column Sets

• Spatial Data Storage, Methods, and Indexing

• Wide Tables

Data Storage

5

• Date and Time Data Types

• hierarchyid Data Type

• Spatial Data Types

• User-Defined Table Type

• User Defined Types (UDT)

Data Types

6

• Full-text catalogs are integrated into the database

• SQL Server 2005 noise words have been replaced by stopwords.

• Query and indexing performance have improved dramatically

• New tools help you understand the raw content of a full-text index

• A new family of word breakers improves word-breaking accuracy and extends the set of languages available for full-text search.

Full-Text Search

7

• Compatibility Level

• Compound Operators

• CONVERT Function

• Date and Time Functionality

• GROUPING SETS

• MERGE Statement

• SQL Dependency Reporting

• Table-Valued Parameters

• Transact-SQL Row Constructors

Transact-SQL

8

Programmability Enhancements In SQL Server 2008 R2

9

• ADO NET Destination Editor (Connection Manager Page)

• Use bulk insert when available. This option enables you to use the System.Data.SqlClient.SqlBulkCopy interface to improve the performance of bulk insert operations.

10

Programmability Enhancements In SQL Server 2008 R2

11

• Support for multiple SharePoint Zones

• Support for the SharePoint Universal Logging service

• SharePoint Lists as a data source

SharePoint Integration

12

• Report Parts

• Shared Datasets

Collaboration and Reuse

13

• Microsoft SQL Azure,

• Microsoft SQL Server Parallel Data Warehouse,

• Microsoft SharePoint List.

Data Sources

14

• Maps

• Sparklines and Data Bars

• Indicators

Data Visualization

15

• Naming Excel Worksheet Tabs

• Rendering Reports to Data Feeds

• Report Pagination

• Rotating Text 270 Degrees

Report Layout and Rendering

16

• Calculating Aggregates of Aggregates

• Enhanced Support for Expressions

• OverallPageNumber and OverallTotalPages

• PageName

• RenderFormat

• Lookup Functions

Aggregates, Expressions, and Functions

17

• Creating Queries

• Previewing Reports in Report Builder 3.0

• Making It Easier to Design and Edit Reports

Report Authoring Tools

18

• Improving the workflow for viewing and managing reports and report server items by using a new drop-down menu to access various configuration options for each report or report server item in a folder.

• Eliminating the need to render a report before accessing and configuring report properties when in default view.

• Allowing more room for Report Viewer when rendering reports.

• An updated Report Viewer toolbar, which includes some updates to the toolbar controls, as well as the ability to export report data to an Atom service document and data feeds.

Report Manager Enhancements

19

• Business Intelligence Development Studio

• New Web Service Endpoint

• New Report Definition Language Schema

• Cache Refresh Plans

Other

20

21