1 / 17

SQL Server 2008 Overview

SQL Server 2008 Overview. Lubor Kollar, Group Program Manager. Video. McLaren. McLaren – High Level Architecture. McLaren – Facts. ATLAS – Advanced Telemetry Linked Analysis System Server side C lient side

brent
Download Presentation

SQL Server 2008 Overview

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. SQL Server 2008 Overview Lubor Kollar, Group Program Manager

  2. Video McLaren

  3. McLaren – High Level Architecture

  4. McLaren – Facts • ATLAS – Advanced Telemetry Linked Analysis System • Server side • Client side • Inputs from ECU (Engine Control Unit) but also from the environment (weather, temperature, humidity, atmospheric presure) • Collecting 500k data / second during races and practices • Client can work with the current and historical data • Race team collects 2-5 TB of data in a year • SQL Server 2008 technologies • Filestream data type • Reporting Services • Security • Analysis of live data

  5. Amazing Journey

  6. PRODUCTIVE • Manage by policies • Simplify Application Development • Store any information • TRUSTED • Protect your information • Ensure business continuity • Predictable responses • INTELLIGENT • Integrate data • Deliver relevant information • Drive actionable insights Trusted. Productive. Intelligent.

  7. Trusted • Secure Access • Protect system • Simplify compliance • Protect your informationSecure business-critical data • Ensure Availability • Minimize Downtime • Concurrent Access • Ensure Business ContinuityReliable Platform for your data • Optimize Performance • Analyze Performance • Predict Performance • Predictable ResponseScale for any size business

  8. Predictable Response Resource Governor demo

  9. Productive • Flexible Administration • Manage centrally • Monitor Health Reduce Management CostSpend less time on operations • Easy Access • Program data logic • Sync your data Simplify Development Reduce development time • Unstructured Information • Geospatial information • Structured information Store your informationInformation Lifecycle Management

  10. Intelligent • Build Faster • Manage Efficiently • Scalable Performance Integrate & Manage dataNext Generation Data Warehousing • Author reports • Manage reports • Deliver reports Deliver Relevant Reports Enterprise Reporting Platform • Build Analytical solutions • Extend Reach • Deliver Insight • Drive Actionable InsightScalable and Predictive Analysis

  11. User View of BI Technologies Intelligent demo

  12. Hviezdny Projekt Pan-STARRS

  13. Pan-STARRS • Panoramic Survey Telescope And Rapid Response System • Detect ‘killer asteroids’ • 1.4 Gigapixel camera, 30 sec/picture • Hawaii + JHU + Harvard/CfA + Edinburgh/Durham/Belfast + Max Planck Society • Data Volume • >1 Petabytes/year raw data • Over 5B celestial objectsplus 250B detections in database • 100 TB SQLServer database built at JHU,the largest astronomy DB in the world • 3 copies for redundancy • PS4 • 4 identical telescopes in 2012, generating 4PB/yr

  14. Pan-STARRS

  15. SQL Server – Announcements (new!) • Madison: integration between SQL Server and DATAllegro, release expected within 1H 2010. Look at it if you have a datawarehouse of hudreds of Tb or more • Kilimanjaro: a sort of “R2” version of SQL Server expected to be released within 1H 2010. It includes self-service analysis (project code Gemini) and self-service reporting • Gemini: a column-based in-memory storage that seems to be part of Analysis Services (not so much details by now) and that can be used locally with Excel • Excel "on stereoids": Gemini packaged as add-in for Excel. No model design required. Relationship is inferred by the engine, navigation tool is provided – evolution of PivotTable. Reports can be published on SharePoint. Excel looks like a reporting tool of the future

  16. Thank You

  17. © 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related