Your Data Any Place, Any Time
This presentation is the property of its rightful owner.
Sponsored Links
1 / 35

Your Data Any Place, Any Time PowerPoint PPT Presentation


  • 54 Views
  • Uploaded on
  • Presentation posted in: General

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

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.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


Your data any place any time

Your Data Any Place, Any Time

Overview


Your data any place any time

SQL Server 2008Enterprise Data Management and Analyses Platform


The data explosion

The Data Explosion

GameChangers

FormFactors

Hard Drive Prices

StorageInnovation

DataTypes

IT & Regulatory Compliance


Your data any place any time

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


Your data any place any time

  • 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


Your data any place any time

  • 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


Your data any place any time

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


Database mirroring log compression benefits

Database Mirroring : Log Compression Benefits

  • Significant benefit for low-bandwidth networks

Source: SQL Server CAT Team Technical Note, 2007-09-17


Your data any place any time

  • 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


End to end system health insight data collector

End-to-End System Health InsightData Collector


Relational database performance resource governor

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


Your data any place any time

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


Your data any place any time

  • 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


Policy based management defining policies

Policy-Based ManagementDefining Policies

Targets

Categories


Intelligent monitoring

Intelligent Monitoring


Scale with policies

Scale with Policies

Automate policy enforcement across the enterprise

Define policies centrally


Your data any place any time

  • 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


Your data any place any time

  • 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


Your data any place any time

  • Spatial Data Types

  • Example : Virtual Earth Integration

  • Query: Zip codes & Restaurants

  • Results: Density by color

  • Benefit: Quickly gain insight


Your data any place any time

  • French Electionswww.lafranceelectorale.com


Your data any place any time

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


Your data any place any time

  • 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


Your data any place any time

  • 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


Flexible layout

Flexible Layout

Tabl

e + Matr

ix


Your data any place any time

  • Reporting ServicesDundas Acquired Chart Controls


Your data any place any time

  • Reporting ServicesDundas Acquired Gauge Controls


Your data any place any time

  • Reporting ServicesReport Builder 2.0


Your data any place any time

  • 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


Your data any place any time

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


How to upgrade

How to upgrade?

  • SQL Server 2008 Upgrade Advisor

  • Types:

    • Side-by-Side (same machine)

    • Side-by-Side (separate machine)

    • In-place


Sql server 2008 editions

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


Resources

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


  • Login