1 / 35

Your Data Any Place, Any Time

Your Data Any Place, Any Time. Overview. SQL Server 2008 Enterprise Data Management and Analyses Platform. The Data Explosion. Game Changers. Form Factors. Hard Drive Prices. Storage Innovation. Data Types. IT & Regulatory Compliance. Intelligent. Integrate data

taini
Download Presentation

Your Data Any Place, Any Time

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. Your Data Any Place, Any Time Overview

  2. SQL Server 2008Enterprise Data Management and Analyses Platform

  3. The Data Explosion GameChangers FormFactors Hard Drive Prices StorageInnovation DataTypes IT & Regulatory Compliance

  4. Intelligent • Integrate data • Deliver relevant information • Drive actionable insights Productive • Manage by policies • Simplify Application Development • Store any information Trusted • Protect your information • Ensure business continuity • Predictable response Trusted. Productive. Intelligent

  5. Protect your information • Secure business-critical data • Secure Access • Strong Authentication • Granular Authorization • Transparent Data Encryption • External Key Management • Protect system • Secure deployment • Secure by default • Simplify compliance • Enhanced Data Auditing • Enterprise Wide Security Policies

  6. Ensure Business Continuity • Reliable Platform for your data • Ensure Availability • Mirror your data • Failover clustering • Replicate your data • Minimize Downtime • Online Operations • Add system resources • Reduce recovery time • Concurrent Access • Database Snapshots • Snapshot Isolations

  7. 5. Transfer page 6. Write Page Log Log Data Data 8. Acknowledgement 1. Commit 4. Transfer to mirror 2. Request page 7. Acknowledgement 5. Write to Log 2. Write to Log 6. Log written 3. Log written 3. Find page X 4. Retrieve page 1. Bad Page Detected • Database Mirroring Client Witness Principal Mirror

  8. Database Mirroring : Log Compression Benefits • Significant benefit for low-bandwidth networks Source: SQL Server CAT Team Technical Note, 2007-09-17

  9. Predictable Response • Scale for any size business • Optimize Performance • Efficient Data Storage • Prescriptive Guidance • Analyze Performance • Data Collection • Performance Insights • Predict Performance • Plan Freezing • Resource Governor

  10. End-to-End System Health InsightData Collector

  11. Relational Database PerformanceResource Governor SQL Server • Ability to differentiate workloads • e.g. app_name, login, etc. • Per-request limits • Max memory % • Max CPU time • Grant timeout • Max Requests • Resource monitoring Backup OLTP Activity Executive Reports Admin Tasks Ad-hoc Reports High Admin Workload OLTP Workload Report Workload Min Memory 10% Max Memory 20% Max CPU 20% Max CPU 90% Admin Pool Application Pool

  12. Intelligent • Integrate data • Deliver relevant information • Drive actionable insights Productive • Manage by policies • Simplify Application Development • Store any information Trusted • Protect your information • Ensure business continuity • Predictable response Trusted. Productive. Intelligent

  13. Reduce Management Cost • Spend less time on operations • Flexible Administration • Visual Management • Automate Operations • Monitor Health • Management Reports • Performance Tuning Tools • Manage centrally • Enterprise Policies • Monitor Compliance

  14. Policy-Based ManagementDefining Policies Targets Categories

  15. Intelligent Monitoring

  16. Scale with Policies Automate policy enforcement across the enterprise Define policies centrally

  17. Simplify Development • Reduce development time • Easy Access • Model Entities • Integrated Query • Comprehensive connectivity • Program data logic • Time aware applications • Pass data results • Sync your data • Local data storage • Offline Synchronization

  18. Store your information • Information Lifecycle Management • Unstructured Information • File Storage • Search text • Extensible Types • Geospatial information • Spatial Standards • Visualize Location • Structured information • Model complex hierarchies • Sparsely populated data

  19. Spatial Data Types • Example : Virtual Earth Integration • Query: Zip codes & Restaurants • Results: Density by color • Benefit: Quickly gain insight

  20. French Electionswww.lafranceelectorale.com

  21. Intelligent • Integrate data • Deliver relevant information • Drive actionable insights Productive • Manage by policies • Simplify Application Development • Store any information Trusted • Protect your information • Ensure business continuity • Predictable response Trusted. Productive. Intelligent

  22. Integrate & Manage data • Next Generation Data Warehousing • Build Faster • Connect to data • Cleanse data • Integrate data • Manage Efficiently • Efficient Data Storage • Manage mixed workloads • Streamline Aggregates • Scalable Performance • DW Query Optimizations • Enhanced Partitioning

  23. Deliver Relevant Reports • Enterprise Reporting Platform • Author reports • Enhanced Designers • Flexible Layout • Manage reports • Enterprise Platform • Server-based Deployment • Deliver reports • Rich Visualizations • Render in Office • Share reports

  24. Flexible Layout Tabl e + Matr ix

  25. Reporting ServicesDundas Acquired Chart Controls

  26. Reporting ServicesDundas Acquired Gauge Controls

  27. Reporting ServicesReport Builder 2.0

  28. Drive Actionable Insight • Scalable and Predictive Analysis • Build Analytical solutions • Scalable Platform • Prescriptive Guidance • Extend Reach • Business view of data • Manage KPIs • Predictive Analysis • Deliver Insight • Work in Office • Rich partner Ecosystem

  29. Your Data Any Place, Any Time Intelligent • Integrate any data • Deliver relevant information • Drive actionable insights Productive • Reduce management cost • Simplify Application Development • Store any information Trusted • Protect your information • Ensure business continuity • Predictable response Trusted. Productive. Intelligent

  30. How to upgrade? • SQL Server 2008 Upgrade Advisor • Types: • Side-by-Side (same machine) • Side-by-Side (separate machine) • In-place

  31. SQL Server 2008 Editions • SQL Server Compact Edition • SQL Server Express Edition • SQL Server WorkgroupEdition • SQL Server Web Edition • SQL Server Standard Edition • SQL Server Enterprise Edition • SQL Server Developer Edition • www.microsoft.com/sqlserver/2008/en/us/editions.aspx

  32. Resources • SQL Server 2008 • http://www.microsoft.com/sql/2008 • SQL Server 2008 Benchmarks • http://www.microsoft.com/sqlserver/2008/en/us/benchmarks.aspx • SQL Server 2008 Case Studies • http://www.microsoft.com/sqlserver/2008/en/us/case-studies.aspx • SQL Server 2008 Service Pack 1 • http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19

More Related