4
Blockers to upgrade
ISV Application compatibility
Lack of business reason for upgrade
Time and resources required to upgrade
Risk: “When we upgrade we break stuff”
Licensing cost
Top Blockers to upgrade
Reasons to upgrade
1) End of extended support
2) Enhanced SQL Server 2014 features and
performance
3) Impact on security and compliance
4) Cloud strategy
5
¹Total Economic Impact™ Of Microsoft SQL Server, July 2014
A new standard for mission critical databases & end-to-end business intelligence with cloud-ready technologies & solutions.
“SQL Server 2012 delivers an ROI of up to 189% with a 1 year payback period“
Forrester TEI Study 2012
Solid offering for departmental IT & enhanced enterprise data platform.
“Microsoft has made considerable strides in automating SQL Servers
management tasks & improving performance tuning & uptime”
eWeek 2005
Comprehensive data platform solution with massive strides in mission critical & business intelligence capabilities
“Upgrading to Microsoft’s SQL Server 2008 delivered an anticipated ROI of between 162% & 181%.”
Forrester TEI Study 2008
Comprehensive, integrated data management & business intelligence with
award-winning analytics.
PowerPivot: Named one of eWeek’s Top 10 Technologies of 2010
eWeek
Build mission-critical apps using high-performance, in-memory technology across OLTP, data warehousing, BI and analytics workloads without having to buy expensive add-ons or high-end appliances. Up to 30x faster transactions 100x query performance gains Enhanced high availability with up to 8 readable secondaries Enhanced security and scalability
Hybrid backup and disaster recovery
According to Forrester, the payback period for SQL Server 2014 is only 9.5 months.
Forrester TEI Study 2014
*National Institute of Standards and Technology Comprehensive Vulnerability Database 4/17/2013
Mission critical
performance with
SQL Server 2014
Breakthrough performance
13x performance from 2005, 5.5x from 2008 with up to 30x additional gains from in-memory OLTP
High availability
The 9’s you need with readable secondaries using AlwaysOn
Security
Least vulnerable database six years in a row*, with encryption, key management, auditing, and separation of duties
Scalability
Scale across compute, networking and storage with Windows Server
Manageability
Improved manageability with policy-based management, distributed replay, improved performance tuning and Windows PowerShell support
Programmability
Easy access to data,
big and small
Search, access, and shape internal and external data, and combine with unstructured data
Scale and manage data across
the enterprise
Scale your BI models and enrich your data with tools like master data services, data quality services and enhanced integration services
Powerful insights with familiar tools
Virtualize and consolidate
Scale up on-premises or scale-out via private cloud with Windows Server for maximum performance and low TCO
Hybrid cloud solutions
Enable new hybrid scenarios like cloud backup and
cloud DR to reduce costs and improve business continuity
Easy on-ramp to cloud
Easy to use built-in tools to deploy to the cloud
Complete and consistent
There will be no access to critical security updates, opening
the potential for business interruptions
Maintaining legacy servers, firewalls, intrusion systems,
etc. gets expensive quickly
Achieve mission critical
performance
Get up to 30x faster
transactions and more than
100x query performance gains
with in-Memory
Experience the 9’s you need—
greater HA and DR with
AlwaysOn
Scale across compute,
networking and storage with
Windows Server 2012 R2 and
up to 640 logical processors
Maintain security
and compliance
The least vulnerable database
platform six years in a row*,
engineered for security from
the ground-up
Manage compliance audit
requirements
Keep receiving support,
security updates and hotfixes
Optimize data
infrastructure
Virtualize and consolidate
your data platform for
maximum performance at
low TCO
Choose the best of
on-premises and Azure with
hybrid cloud
Migrate web applications to
Azure SQL Database to
reduce administrative needs
There will be no access to critical security updates, opening the potential for business interruptions
• Many critical security updates were released for SQL Server 2005 while under
extended support
• No further updates will be developed or released after end of support on April 12,
2016
Maintaining legacy servers, firewalls, intrusion systems, etc. gets expensive quickly
• Retaining old software will likely cost more in the end
• Maintaining legacy servers, firewalls, guarding against potential intrusions, and
preparing for the potential liability created by out of date software can prove to
be very costly
As support ends, organizations will likely fail to meet regulatory standards compliance
• Lack of compliance with many standards and regulations can have serious
consequences.
• The cost of doing business could substantially increase due to penalties and
higher transaction fees. In worst case scenarios, a lack of compliance can also
result in lost business.
Take advantage of key
milestones
More than half of SQL Server 2005 runs on Windows Server 2003.
Windows Server 2003 reached End of Support on July 15, 2015.
By upgrading both together, customers can avoid the added cost that comes from doing so separately.
Maintain a supported
OS configuration
SQL Server 2005 is not
supported on Windows Server
2012 or Windows Server 2012 R2. Running SQL Server 2005 on a new version of Windows Server may result in errors or
performance issues.
Help customers take advantage of the breakthrough performance gains offered by SQL Server 2014 and Windows Server R2 2012.
Keep ISV software under
support
Many packaged software providers will not support their application on out-of-date operating systems or databases.
Customers who need to keep
receiving support, security updates and hotfixes from your ISV –
upgrade now.
*National Institute of Standards and Technology Comprehensive Vulnerability Database 4/2014
Azure SQL Database Version 12 capabilities enable
customers to deploy SQL Server 2005 web-based
software workloads with high compatibility while reducing database administration.
SQL Server 2014 on Azure Virtual Machines
(IaaS) enables customers to upgrade database, OS
and hardware at the same time with no CAPEX. VMs can be stopped when not in use. Use VM sizing plus Azure Premium storage to support up to tier 1 workloads.
SQL Server 2014 on Windows Server 2012 R2 with Hyper-V helps organizations minimize costs by
enabling consolidation of multiple SS 2005 Standard Edition instances into one Enterprise
Edition machine, plus business continuity through Live Migration
SQL Server 2014 on Windows Server 2012 R2 (on
iron) provides high performance for Tier 1 SQL Server 2005 workloads. Use physical hardware when extreme low latency is required on large dedicated servers with a high number of cores and RAM.
Shared Lower cost
Dedicated Higher cost
Higher administration Lower administration
Hybrid Cloud
SQL
SQL
22
•
Proof of Concept
•
Assessment
http://aka.ms/sql_server_2005_eos
Check out SQL Server EOS Partner and
Customer resources
MySQL pitch It is good enough It’s free It works on all operating systems It is now supported by Oracle It is open source It is the most used open-source
database
In reality
Not good for complex, Tier-1 Online Transaction Processing (OLTP) workloads (for example, Enterprise Resource Planning (ERP) applications)
No built-in reporting and analysis
Significant number of known bugs, not always fixed rapidly
Is Oracle really committed to the Open
Source community? Look at what happened to OpenSolaris
More companies are moving away from MySQL to MariaDB or PostgreSQL
Positioning to win
1. SQL Server has more capabilities including db engine functionality, security features, tools, data warehouse, business intelligence, in-memory, cloud, and all-around enterprise readiness.
2. We offer a growth path for applications and customers, with higher-level editions.
3. Cost of management is a differentiator with both native SQL Server management and our System Center product lines.
If customer insists on MySQL, pitch running the workload on Azure. Preconfigured virtual machine templates are available.
