SQL_Server_.ppt

1、Technology Preview: Microsoft SQL Server 2008,By: Ian Proffer MUSE Session 358,About the Presenter new Performance Studio puts all performance tools in one console NULL storage sparse columns allow NULL values to be stored without using any physical disk space,Whats New in SQL Server 2008,Developmen

2、t enhancements DATE and TIME data types New MERGE T-SQL syntax allows different operations (UPDATE, INSERT or DELETE) on a table based on user-defined conditions all in a single statement,Whats New in SQL Server 2008,Data integration (“Business Intelligence”) Integration Services (SSIS) now scales p

3、ast 2 processors and adds better performance for large datasets Analysis Services (SSAS) scales and performs better for large datasets Report Services (SSRS) integrates nicely with Office 2007 export directly to Word, use Word and Excel for report templates in Report Designer,Whats New in SQL Server

4、 2008,Reporting Services,SQL 2005 added: Interactive sorting Direct client printing (print report without exporting it first) Use of multi-valued parameters Better expression editor in Report Designer (list of functions, auto-complete, syntax checking) Integration with SQL Server Management Studio a

5、nd Visual Studio,Reporting Services,SQL 2008 adds: Integration with Office 2007 Better report rendering performance, especially for large datasets New “Tablix” data region, which allows you to build reports that include: Multiple parallel row/column members at each level A mix of dynamic or static m

6、embers on both rows and columns Optional omission of member headers,SQL 2005 Reporting Services Matrix Report,SQL 2005 Reporting Services Matrix Report,SQL 2005 Reporting Services Matrix Report,SSRS 2008 Tablix demonstration,Report Designer Grouping Panes,Report Designer Right-click access to group

7、properties,Report Designer add “Insurance” label inside or outside group,Report Designer add “Charges” label inside group,Report Designer add Count of patients to data section,Report Designer add Location child group and subtotal,Report Designer add some color and preview the results,Report Designer

8、 add a new group adjacent to Insurance,Report Designer preview the final result,Windows Server 2008,New user authentication and data encryption architecture Logging improvements to capture SQL auditing events Server clustering and database mirroring improvements Policy-based Framework Administration through Windows PowerShell (automated scripting environment) Reliability and Performance Monitoring (thi