70-461 Querying Microsoft SQL Server 2012 PDF

1
Querying Microsoft SQL Server 2012

• Top reasons your customers should upgrade to SQL
  Server 2012

2
Modernize. Save. Grow.

• Modernize Your Platform
• with SQL Server 2012

3
Company Name What We Do
Expertise and Services e.g. Cloud
Services History and Experience e.g. Provided
reporting and data analysis solutions for small
businesses since 1998 Goal e.g. Commitment to
build a successful long-term relationship by
providing best-in-class support, training,
guidance, etc.
https//www.pass4sureexam.com/70-461.html
4
Goals and Agenda

• This presentation is about how you can grow your
  business with SQL Server 2012. The goal is to
  help you
• Discover how you can modernize your platform with
  SQL Server 2012
• Learn about the resources that can help you

https//www.pass4sureexam.com/70-461.html
5
Introduction
https//www.pass4sureexam.com/70-461.html
6
We need
Data Exploration
Consistent Data
Scalable Analytics
Scale On Demand
Fast Time to Market
Increased Productivity
Anywhere Access
https//www.pass4sureexam.com/70-461.html
7
The solution
AlwaysOn
In-Memory ColumnStore
Windows Server Core Support
SharePoint
Data Quality Services BI Semantic Model
24TB¹ Cubes 15K Partitions Tier 1 Scalability
PowerPivot
Windows Azure Marketplace Data Sync
Unlimited Virtualization License Mobility
Flexible Deployment
Common Management Development Tools
https//www.pass4sureexam.com/70-461.html
8
SQL Server 2012 A Modernized Platform
Breakthrough Insight
Mission-Critical Confidence
Cloud on Your Terms
https//www.pass4sureexam.com/70-461.html
9
The Journey to a Modernized Platform
https//www.pass4sureexam.com/70-461.html
10
A modernized platform for all
https//www.pass4sureexam.com/70-461.html
11
Why Upgrade?
Reduce your TCO
https//www.pass4sureexam.com/70-461.html
12
Upgrade to SQL Server 2012
Reduce your TCO
RUN

Standard Edition
13
Why Modernize?
Accelerate your business growth
9s
14
Modernize Your Application Platform
Accelerate your business growth
GROW
Windows Server 8
Modern Hardware
15
Why the Cloud?
Extend your reach
almost anywhere
Fast to Solution
Scale On Demand
16
Get Ready for the Cloud
Extend your reach
almost anywhere
TRANSFORM
Windows Server 8
17
We Can Help
https//www.pass4sureexam.com/70-461.html
18
Next Steps

• Work with us to
• Assess your current infrastructure
• Explore the benefits of upgrading to SQL Server
  2012
• Evaluate licensing models and determine the best
  option for your needs
• Discuss existing resources and offers designed to
  simplify and reduce the cost of upgrading

Learn more about SQL Server 2012 http//www.micro
soft.com/sqlserver
19
Contact Us

• Our Contact Info info_at_pass4sureexam.com
• Name
• Phone
• Email support_at_pass4sureexam.com
• Our Website pass4sureexam
• URL https//www.pass4sureexam.com/70-461.html

20
Appendix
21
Evolution of SQL ServerAre you leveraging the
best technology available?

• XML support
• Data mining and data scripting
• Failover clustering

SQL Server 2000
1Source Microsoft Sales, 2011
22
Platform ModernizationSQL Standard Edition
CHALLENGE We need effective and secure data
management with high performance, reliable
infrastructure, comprehensive development and
up-to-date, technology.
SOLUTION Modernize your platform to Microsoft
SQL Server 2012 Standard Edition.

• RESULTS
• Deliver required uptime and data protection.
• Scale on demand with flexible deployment options
  on your terms.
• Extend the reach of data most anywhere across
  server and/or cloud.

23
Platform ModernizationSQL Enterprise Edition
CHALLENGE We dont have all the IT
capabilities in house, and were investing
sparingly in new hardware and server As our
organization grows, we need to scale affordably
while making sure everyone has access to BI
functionality
SOLUTION Modernize your platform to Microsoft
SQL Server 2012 Enterprise Edition.

• RESULTS
• Make better informed decisions with
  collaborative, self-service BI
• Increase operational efficiency through database
  consolidation
• Get cloud-ready and reduce costs with unlimited
  virtualized database deployment

24
Platform ModernizationSQL Server Lineup
https//www.pass4sureexam.com/70-461.html
25
Mission Critical ConfidenceReal world examples
Greater High Availability NEW SQL Server AlwaysOn
Mediterranean Shipping Company runs their
business critical global shipping logistics
application on SQL Server. Getting the required
9s is absolutely critical for the business.
Our business has to be on-line all the time.we
were able to install SQL Server 2012 and enable
AlwaysOn in a matter of minutes.
Worlds largest container shipping company
Reduced Downtime NEW SQL Server AlwaysOn
Online company reduces downtime and helps its
customers to improve service
The SQL Server 2012 online indexing capabilities
alone save us up to 20 minutes a year in
downtime, or 38.5 of allowable downtime. That
might not sound like much, but its huge for us
and our customers.
26
Breakthrough InsightReal world example
Interactive data visualizations NEW Power View
EdgeNet connects Manufacturers, Retailers, and
Shopping Engines to create world-class-product
data feeds where quickly slicing and visualizing
data is critical to providing the highest quality
products and services.
Power View has allowed spur of the moment
questions to be answered by users who previously
did not have the expertise to find the answers.
https//www.pass4sureexam.com/70-461.html
27
Breakthrough Insight Real world examples
Higher Quality Data NEW Data Quality Services
RealtyTrac helps customers make real estate
decisions with property data and mortgage
information. With a SQL Server 2012 solution,
information workers have tools to improve data
quality and analysis for higher accuracy results
that mean better decisions.
With SQL Server 2012 Data Quality Services, we
will help our customers clearly see all lenders
involves in a foreclosure. This will help our
customers make better, more informed buying and
selling decisions.
Fast Innovative BI NEW Reporting Services
SharePoint360 provides IT services and BI
solutions to global customers. With a SQL Server
2012 solution, the firm can enhance its
competitiveness, increase revenue, accelerate the
time-to-market of BI offerings, and greatly
reduce yearly costs.
We need to be nimble, offer innovative services,
and ensure customer satisfaction. With SQL Server
2012 thats what we can do deliver better
solutions up to 50 percent faster, for less
money.
28
Cloud on Your TermsReal world example
New Hybrid IT scenarios Common Architecture and
Tools
Miamis 911 system ran on a mainframe. Today when
someone dials 911 in Miami, emergency personnel
are dispatched from the systems Windows Server.
Data from the system is stored in a SQL Server
database.

• The cloud is absolutely the future, and
  Microsoft has made it easy to migrate mainframe
  applications.

https//www.pass4sureexam.com/70-461.html
29
New Pricing Benefits

Leading TCO

• Continued high-value leader among major vendors

• Investments protected for customers with SA
  including migrations to new licensing

Cloud-Optimized

• Flexible virtualization licensing
• License mobility enables hybrid scenarios that
  span on-premises and cloud

Pay As You Grow

• Simplified edition lineup
• Streamlined editions aligned to database and
  business intelligence needs

30
Simplified Licensing Models
Editions Licensing Models ServerCAL Core-based Licensing Models ServerCAL Core-based Changes to Licensing
Business critical OLTP BI EE Processor licenses are changing to cores EE ServerCAL model discontinued for new purchases
Premium BI BI Server available only through ServerCAL model Same CAL as Standard Edition
Basic DB BI Standard Processor licenses are changing to cores Standard also available through ServerCAL model
NEW!
31
License Hardware Capacity by Cores
Pay for the power you need Cores are a precise
and flexible measure of capacity for hybrid
environments
Physical Server Licensing
Virtual Machine Licensing

• License all physical cores on hardware
• Minimum of 4 cores per Processor
• EE w/SA provides unlimited virtualization

• License virtual cores
• Minimum of 4 virtual cores per VM
• License mobility with Software Assurance

Pay only for what you use
OR
32
License by User or Device
Pay for the users or devices you need A single
SQL Server 2012 CAL provides access to any SQL
Server Alignment to SharePoint and Office
Licensing
License The Server
License Users or Devices
Physical Server Licensing
Virtual Machine Licensing
Users or Devices

• License each individual Server

• License single virtual machines
• License mobility with Software Assurance

• License each user/device
• SQL Server CALs access any SQL Server

OR
33
https//www.pass4sureexam.com/70-461.html