Transcript For environments inside the firewall.

SQL Server &
Business Intelligence
Christine Bishop
Product Marketing
Manager
SQL Server & Business
Intelligence
Enterprise Ready!
“Microsoft’s ambition
has been to grow SQL
Server into the
upper echelons of major
enterprises, and with
SQL Server 2005, this
seems to
be happening.”
SQL Server 2005
Ongoing Enhancements
Service Pack 1
Service Pack 2
Delivery of Database Mirroring
SQL Server Express with Advanced
Functions
Management Tools
Full Text Search
Reporting Services
Reporting Services support for
Netweaver BI
Performance updates: data
compression
Enhanced BI capabilities
SSRS Integration with SharePoint
Server 2007
Data Mining Plug-ins for Office
2007
Manageability enhancements
Optimized for Windows Vista & Office
2007
Common Criteria Certification
Designed for
Portable enterprise applications
Occasionally-connected & offline use
Embedded in applications & devices
The Data Explosion
Game
Changers
Delivering On Our Vision
Enterprise Data Platform
• Secure, trusted platform for your data
• Optimized and predictable system performance
• Productive policy-based management of your infrastructure
Enterprise Data Platform
Beyond Relational
• Store and consume any type of data
• DeliverRelational
Location Intelligence within your applications
Beyond
Dynamic Development
Dynamic
Development
• Accelerate your development with entities
• Synchronize your data from anywhere
Pervasive Insight
Pervasive Insight
• Integrate all your data in the Enterprise Data Warehouse
• Reach all your users with scalable BI platform
• Empower every user with actionable insights
SQL 2005
•
•
•
•
•
•
•
•
•
•
•
Enterprise Edition
Meets the high demands of enterprise online transaction
processing and data warehousing applications
OLTP
Data Warehousing
Data Mining
Standard Edition
Data management and analysis platform for small and mediumsized organizations
E-commerce
Data Warehousing
Line-of-Business Solutions
Workgroup Edition
Designed for small organizations that need a database with no
limits on size or number of users
Front-end Web server
Departmental or branch office operations
SQL 2005 models
Which should I choose?
- the server plus device CAL, the server plus user CAL, or
the processor license
•
•
•
For externally focused server applications. Processor licensing is a
better choice for externally focused server applications, such as Internet
and extranet scenarios. It is often difficult to count devices or users in
these scenarios, so hardware-based pricing is more straightforward.
For mixed-use servers. For mixed-use servers that will be accessed
from both inside and outside the organization's firewall, processor
licensing is generally favorable. Because the processor licenses are
probably needed for external users, there would be no need to purchase
access separately for internal users through CALs.
•For environments inside the firewall. For environments inside the
firewall where client-to-server processor ratios are relatively low, the
server plus device CAL licensing model will likely be the more costeffective choice if there are multiple users per device (for example, in a
call center), while the server plus user CAL licensing model will likely be
more cost-effective if there are multiple devices per user. For
environments inside the firewall where client-to-server processor ratios
are high, the processor licensing model will likely be more cost-effective.
SQL 2008 licensing
•
•
•
•
Waiting for final clarification as to pricing and licensing
Price to increase by 1% at most
Licensing changes are minimal
Competitive migration sku available
Many customers want to migrate from costly platforms such as Oracle, DB2, Informix, and
Sybase. To help customers migrate, Microsoft is offering a limited-time promotion for
customers1 interested in migrating from eligible database vendors to SQL Server 2005.
Offer
50% discount on SQL Server Enterprise Edition license, provided the
customer buys regularly priced Software Assurance
50% discount on SQL Server CAL license, provided the customer buys
regularly priced Software Assurance
•
25% discount on SQL Server Standard Edition license, provided the
customer buys regularly priced Software Assurance
http://www.microsoft.com/sql/solutions/migration/limitedoffer.mspx
Opportunity/ Call To Action
• Look at existing your customer base
– SQL 2000 begins End of Life April 2008
– More than 50% of customer base still on SQL2000 or
below
• From now until June 30
Sell SQL 2005 (L plus SA)
• Sell Enterprise Edition not standard
• Per Processor vs Server and CAL (approx 70 ent
/30 std)
• Sell through hosting channel
Business Intelligence
• #1 Priority for CIO’s for last 2 years - Gartner
• Market is growing substantially and demand is
high
• Recent Market Consolidation is opportunity for
Microsoft
– SAP/ Cognos
– IBM Business Objects
– Oracle / Hyperion
• Is a Business Decision Makers conversation not
Technical conversation
BI Customer Concerns
• BI solutions involve many different products
• Tools can be difficult to learn and use
• Lack of product integration can be costly and
make ease of use impossible
• Scalability and reliability become more
important as the amount of users grow
• End-users want BI as part of their daily
process
Microsoft advantage
customer familiarity with Excel
Microsoft’s Business
Intelligence Solution
•
Microsoft Products
– SQL Data Warehouse
– SQL reporting & Analysis Services
– MOSS
– Office 2007
– Performance Point Server
– Customers can use any or all of these products
– Great integrations with Dynamics Product range
Business Intelligence Offers
Get a competitive edge with better Business Intelligence
SQL Server 2005
SQL Server 2005 Business Intelligence (BI) includes Analysis Services for online
analytical processing (OLAP) and data mining, Reporting Services and other robust
features. Unlike Oracle’s solution, these powerful capabilities are included in the
basic license and price with SQL Server 2005 – allowing your organization to widely
deploy BI solutions without additional purchase costs.
SharePoint Server and PerformancePoint Server 2007 Promotion
•
Better Together Performance Management – Receive a 25% discount on
Microsoft Office SharePoint Server ECAL licenses through June 30, 2008
•
Now through June 30, 2008 eligible customers can receive a 25% discount for every
Microsoft Office SharePoint Server Enterprise Client Access Licenses (CAL)
purchased when licensing an equal number of Microsoft Office PerformancePoint
Server 2007 CALs. Together, these two products become important elements of a
complete performance management solution.
•
The PerformancePoint Server 2007 CAL provides business users with access to
PerformancePoint Server 2007, an integrated performance management application
that supports an organization's need to monitor performance, analyze key trends and
plan for the business' future success.
The SharePoint Server 2007 Enterprise CAL provides end user access to SharePoint
Server 2007, which facilitates collaboration, content management and document
sharing, and delivers portal-based access to information essential to attaining
organizational goals and streamlining key processes.
Opportunities/ Call to Action
Identify the BDM’s in your accounts
• Ask "Is there any data that, if assembled, would help your
employees make better decisions?“
• Ask “Can we help you add value to your existing MS
investments”
•
Use BI discussion to add value to every decision
• Use Office & SharePoint for delivery
• Use scorecards as an entry-point
• Scale from self-service (individual) to corporate BI
• Embed in everyday applications - mobility
• Deliver lowest TCO, highest affordability
•
Encourage standardization
– Deliver a complete and integrated offering including
Performance Management
– Optimise existing investments in MS technology
© 2007 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.
Microsoft Confidential – NDA Only