SQL Server{Say hello to} a database for all developers and for web apps

Why SQL Server?Database available in free and paid versions

for development and production of powerful apps that grow with you, optimized for scalability, reliability,

cloud and now for web

Let’s start with FreeSQL Server Express edition is a powerful database for rapidly building and deploying reliable solutions.FREE to embed in an ISV application.FREE to develop. FREE to deploy.FREE online backup and restore.FREE reporting.

New 10GB

limit!

FREE. REALLY.

No cost to use in production

No cost for ISVs to redistribute

No cost for updates, upgrades, fixes

{ “SQL Server Express is great to develop and deploy projects, using the integrated Web Platform Installer, and developing with Visual Studio Express” }

{ “No need to pay to redistribute with my app, no need to open source my code!” }

Uses all the cores in multicore CPUs

ASP.NET Web Application Framework

NO COST for leading edge toolsSQL Server Management Studio{ Graphical management tool }

Visual Studio Express{ World class development tool }

ASP.NET Web Application Framework

SQL SERVER EXPRESS. IMPROVED.

10GB database size*

Improved installation and deployment

Integrated with Web Platform Installer

10GB = 10,737,418,240 bytes

3 times Wikipedia

And its

FREE* Today limit is 4GB. New 10G limit planned for SQL Server 2008 R2

35 times the Encyclopedia Britannica

Microsoft Web Platform InstallerFREE at microsoft.com/Web

Install the latest versions of the full development and deployment stack: tools, server, database, frameworks and apps

Stay up-to-date and explore what’s new.

Runs on Windows XP, Vista, 7, and Server

USE YOUR DATA. Save time. Reduce risk.

Oracle

Sybase

FREE robust data migration tool

FREE Migration ToolsSQL

Server

Guidance and tips

Support with issues and questions

Migrate all data with no cost

FREE test migration before doing it

ACCESS

MySQL

Develop rich, powerful appsBet your business on continuously improving product roadmap.Start small, grow as fast and large as you need.Differentiate your solutions.Expand to the cloud.

All with a single database API.

Express

Standard

Enterprise

Datacenter & Parallel DW

Free & simple• Reporting• XML, Spatial, FTS

Medium apps• Clustering and mirroring• Replication• ETL• Advanced reporting• Analysis and data mining• MDX debugging

Similar to MySQL

GROW.SQL Server editions.Same programming model.Grow with no code changes.

* New with SQL Server 2008 R2

SQL Azure Cloud-based relational database service built on SQL Server technologies. Highly available, scalable, multi-tenant database hosted service.

WebLarge scale web• Unlimited DB, Memory• Log Shipping• Performance collector• Report charts & graphs

Enterprise apps• Compression• Transparent Encryption• Resource Management• Online operations• Auditing• Data warehousing• ETL scale• Reporting scale• Advanced analysis services• Advanced data mining• Master data services*

Data centers*• Up to 256 processors• Complex event processing• Manage +25 instances

Very large DW *• Appliance based• Proven with +400TB

COMPARE. Free vs Free vs PaidMySQL SQL Server Express SQL Server Enterprise

Cost Free Free PaidDB, CPU, RAM OS Max* Some limits OS MaxOS Support Many Windows WindowsCore DB operations Yes Yes YesACID compliant Depends Yes YesSecurity risk +50 vulnerabilities 10 vulnerabilitiesOnline backup No Yes YesReporting No Yes YesCloud version No Yes YesAuto tuning No Yes YesSync No Yes YesAnalysis, OLAP No No YesHigh Availability No No YesData Warehouse No No Yes

* MySQL has several limits, for example not utilizing well more than 4 cores (even the future version 5.4 would not be able to use more than 16 cores)

OUTGROW THIS!

SAP 93,000 concurrent users. And leading TPC-H and TPC-E benchmarks

Rich integrated High Availability capabilities

log shipping

online backuponline operations

snapshot isolation

failover clusteringdatabase mirroring

database snapshots

My app is different. My app is better.

My app data is safe through online backup

DIFFERENTIATE your solutions

My app offers reporting with little coding

My app can run locally and in the cloud

My app can sync data with a central database

My app is deployed with a free simple database, and also with a highly

secure 400+TB database with no app changes!

My data can be compressed with no app changes

My app…… is me

My app uses very fast indexed XML

Now for PHP and Web apps// SQL Server 2008 R2 brings new capabilities for small to large scale web applications.// NEW features and NEW applications,// NEW web management tools,// NEW migration tools.// NEW.

RUN your app on SQL ServerThe SQL Server Driver for PHP is designed to enable reliable, scalable integration with SQL Server for PHP applications deployed on the Windows platform.

// Native PHP 5 extension

// Reading and writing of SQL Server data from within PHP scripts.

// Compatible with all editions of SQL Server 2005 and SQL Server 2008 (including Express editions).

SQL Azure, scalable cloud-based database, self managed, highly available, low cost.

// No Install.// No management.// No hardware needed.// Just connect.// And pay per use.// No use? no pay.// Use existing tools

.NET and PHP with cloud database

// New PHP toolkits and guidance for beginners and advanced devs

NEW AND IMPROVED.We have been working hard to make Web and PHP development better, faster, easier, with SQL Server.

// Use MySQL & Access data via the SQL Server migration tool

// PHP driver v1.1, UTF-8, scrollable result sets & other features

// Manage SQL Server remotely via web administration tool*

// Try SQL Server Web edition for large web projects**

*Available soon ** SQL Server Web edition has been available since SQL Server 2008

ASP.NET Web Application Framework

TOP PHP APPS run on SQL Server// Wordpress

// Coppermine Gallery

// Tutos

// Typo3

// Zend Framework

// PHProjekt

// phpBB// ADOdb

You want to try it out?Demos, examples, tutorials, hands on labs, whitepapers, free products./* go to next page */

ASP.NET Web Application Framework

Download, Learn, Try.Click in the links

Download, try and deploy the database and tools

• FREE SQL Server Express• FREE Visual Studio Express• FREE Web Platform Installer

Learn, learn, learn • Short SQL Server beginner tutorials• SQL Server 2008 R2 developer training, and

“building my first web app”

Migrate my data • Compare MySQL and SQL Server• Copy data from MySQL to SQL Server (

whitepaper guidance and the tool)

Use PHP with SQL Server • Beginners guide to PHP and SQL Server• PHP training kit:

technical examples, demos,…• How to use SQL Azure and PHP• Download the PHP driver for SQL Server

Try me!!

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