1 / 30

Technology Preview: Microsoft SQL Server 2008

Technology Preview: Microsoft SQL Server 2008. By: Ian Proffer MUSE Session 358. About the Presenter & Acmeware. This is our 10 th year at MUSE! Acmeware’s founder led the development of the DR while working at MEDITECH We work exclusively with the MEDITECH DR

liam
Télécharger la présentation

Technology Preview: Microsoft SQL Server 2008

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Technology Preview: Microsoft SQL Server 2008 By: Ian Proffer MUSE Session 358

  2. About the Presenter & Acmeware • This is our 10th year at MUSE! • Acmeware’s founder led the development of the DR while working at MEDITECH • We work exclusively with the MEDITECH DR • We have a friendly (and valued) relationship with MEDITECH • Ian Proffer • 15 years in IT, specializing in relational databases • 6+ years in healthcare, including MEDITECH C/S (Jefferson Healthcare) and Harborview Medical Center in Seattle

  3. Session Agenda • SQL Server 2000 and 2005 • What’s new in SQL Server 2008 • Reporting Services 2008 • Demo • Windows Server 2008 • Discussion, questions and answers

  4. Goodbye, old friend… • Mainstream support for SQL 2000 ended April 8, 2008 • Last service pack is SP4 • Extended support will be available until April 2013 • Pay-per-incident • Security update support at no cost • Self-help available online • SQL 2000 will not run on Windows Vista

  5. Don’t worry, it’s not going anywhere • Microsoft mainstream support for SQL 2005 will be available for the foreseeable future • For our DR customers, migration from SQL 2000 to 2005 is just reaching its peak • New deployments are all on Server 2003/SQL Server 2005

  6. What’s New in SQL Server 2008 • Security • Transparent data encryption – encrypt an entire database • Backup encryption – compresses and secures the backup file • Auditing – now monitors data access and modifications • Policy-based Framework from Windows Server 2008 automates administrative tasks

  7. What’s New in SQL Server 2008 • Continuity • Hot-pluggable CPU allows you to add CPUs on the fly, if your hardware supports it • Enhanced database mirroring provides complete redundancy

  8. What’s New in SQL Server 2008 • Performance • Built-in compression now at the row and page level improves disk storage and reduces memory requirements, backups compressed too • Resource Governor monitors and limits server resources by process or user and intervenes as necessary • More performance counters and new Performance Dashboard for increased measuring ability; 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

  9. What’s New in SQL Server 2008 • Development 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

  10. What’s New in SQL Server 2008 • Data integration (“Business Intelligence”) • Integration Services (SSIS) now scales past 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

  11. What’s New in SQL Server 2008

  12. 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 and Visual Studio

  13. 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 members on both rows and columns • Optional omission of member headers

  14. SQL 2005 Reporting Services – Matrix Report

  15. SQL 2005 Reporting Services – Matrix Report

  16. SQL 2005 Reporting Services – Matrix Report

  17. SSRS 2008 Tablix demonstration

  18. Report Designer – Grouping Panes

  19. Report Designer – Right-click access to group properties

  20. Report Designer – add “Insurance” label inside or outside group

  21. Report Designer – add “Charges” label inside group

  22. Report Designer – add Count of patients to data section

  23. Report Designer – add Location child group and subtotal

  24. Report Designer – add some color and preview the results

  25. Report Designer – add a new group adjacent to Insurance

  26. Report Designer – preview the final result

  27. 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 (think Windows Vista) • Built-in server virtualization (Hyper-V)

  28. Windows Server 2008

  29. Windows Server 2008

  30. Discussion, questions & answers

More Related