technology preview microsoft sql server 2008 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Technology Preview: Microsoft SQL Server 2008 PowerPoint Presentation
Download Presentation
Technology Preview: Microsoft SQL Server 2008

Loading in 2 Seconds...

play fullscreen
1 / 30

Technology Preview: Microsoft SQL Server 2008 - PowerPoint PPT Presentation


  • 166 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Technology Preview: Microsoft SQL Server 2008' - liam


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
technology preview microsoft sql server 2008

Technology Preview: Microsoft SQL Server 2008

By: Ian Proffer

MUSE Session 358

about the presenter acmeware
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
session agenda
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
goodbye old friend
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
don t worry it s not going anywhere
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
what s new in sql server 2008
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
what s new in sql server 20087
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
what s new in sql server 20088
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
what s new in sql server 20089
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
what s new in sql server 200810
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
reporting services
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
reporting services13
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
windows server 2008
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)