Querying Microsoft SQL Server 2012 (Exam 70-461) Course

June 26, 2017 | Autor: W. Pharmacy | Categoria: Windows, Microsoft Technologies, SQL SERVER
Share Embed


Descrição do Produto

Querying Microsoft SQL Server 2012 Top reasons your customers should upgrade to SQL Server 2012

1

Modernize. Save. Grow. Modernize Your Platform with SQL Server 2012

[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

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

Introduction

https://www.pass4sureexam.com/70-461.html

We need…

Availability

Speed

Compliance

?

Data Exploration

Self-Service BI

Consistent Data

Scalable Analytics

Scale On Demand

Fast Time to Market

Increased Productivity

Anywhere Access

9s

https://www.pass4sureexam.com/70-461.html

The solution… AlwaysOn

In-Memory ColumnStore

Windows Server Core Support

Availability

Speed

Compliance

?

PowerPivot

SharePoint

Data Quality Services & BI Semantic Model

24+TB¹ Cubes 15K Partitions Tier 1 Scalability

Data Exploration

Self-Service BI

Consistent Data

Scalable Analytics

Flexible Deployment Fast Time to Market

Common Management & Development Increased Tools Productivity

9s

Unlimited Virtualization & License Mobility Scale On Demand

Windows Azure Marketplace & Data Sync Anywhere Access

https://www.pass4sureexam.com/70-461.html

SQL Server 2012 A Modernized Platform

https://www.pass4sureexam.com/70-461.html

The Journey to a Modernized Platform

https://www.pass4sureexam.com/70-461.html

A modernized platform for all

Lower Mid-Market (25-49 PCs)

Core Mid-Market (50-250 PCs)

Upper Mid-Market (>250 PCs)

REDUCE OWNERSHIP COSTS ACCELERATE BUSINESS GROWTH EXTEND YOUR DATA ANYWHERE

https://www.pass4sureexam.com/70-461.html

Why Upgrade? Reduce your TCO



We want to improve the performance and reliability of our data management so we can increase productivity…but we also need better control our IT maintenance costs.

https://www.pass4sureexam.com/70-461.html



Upgrade to SQL Server 2012 Reduce your TCO



We want to improve the performance and reliability of our data management so we can increase productivity…but we also need better control our IT maintenance costs.



Why Modernize? Accelerate your business growth

9s “

Our current database can no longer meet the scalability and performance requirements of our most demanding applications.



Modernize Your Application Platform Accelerate your business growth

Modern Hardware



Our current database can no longer meet the scalability and performance requirements of our most demanding applications.



Why the Cloud? Extend your reach…almost anywhere



Managing multiple databases and servers is getting more and more expensive, but we still need to cut down time costs and focus on our core business while protecting data with improved availability.



Get Ready for the Cloud Extend your reach…almost anywhere



Managing multiple databases and servers is getting more and more expensive, but we still need to cut down time costs and focus on our core business while protecting data with improved availability.



We Can Help

https://www.pass4sureexam.com/70-461.html

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

Contact Us Our Contact Info: [email protected] [Name] [Phone] [Email] [email protected] Our Website: pass4sureexam [URL] https://www.pass4sureexam.com/70-461.html

Appendix

Evolution of SQL Server

Are you leveraging the best technology available? SQL Server 2000

1

Source: Microsoft Sales, 2011

Platform Modernization SQL Standard Edition

CHALLENGE:

“We need effective and secure data management with high performance, reliable infrastructure, comprehensive development and up-to-date, technology.”

SOLUTION: • • • •

80% of SMB customers use SE edition Basic Database, Reporting, and Analytics Programming, Developer, & Management Tools Best Choice for cost conscious customers

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.

Platform Modernization SQL Enterprise Edition

CHALLENGE:

“We don’t have all the IT capabilities in house, and we’re 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”

• • • • • •

Includes all SQL Server 2008 R2 Datacenter & BI Edition capabilities Advanced Security (auditing, transparent data encryption) Data Warehousing Maximum Scalability & Performance AlwaysOn high availability Unlimited Virtualization Licensing with SA

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

Platform Modernization SQL Server Lineup

• • • •

80% of SMB customers use Standard edition (SE) Basic Database, Reporting, and Analytics Programming, Developer, & Management Tools Best Choice for cost conscious customers

• • • • •

Brand New Edition Includes all SE capabilities Enterprise Data Mgmt. (data quality, master data services) PowerView, PowerPivot for SharePoint Server Corporate BI (Semantic model, advanced analytics)

• • • • • •

Includes all SQL Server 2008 R2 Datacenter & BI Edition capabilities Advanced Security (auditing, transparent data encryption) Data Warehousing Maximum Scalability & Performance AlwaysOn high availability Unlimited Virtualization Licensing with Software Assurance

https://www.pass4sureexam.com/70-461.html

Mission Critical Confidence Real world examples

NEW SQL Server AlwaysOn

Mediterranean Shipping Company runs their business critical global shipping logistics application on SQL Server. Getting the required 9’s is absolutely critical for the business. World’s largest container shipping company

NEW SQL Server AlwaysOn Online company reduces downtime and helps its customers to improve service

Breakthrough Insight Real world example

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.

https://www.pass4sureexam.com/70-461.html

Breakthrough Insight Real world examples

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.

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.

Cloud on Your Terms Real world example

Common Architecture and Tools Miami’s 911 system ran on a mainframe. Today when someone dials 911 in Miami, emergency personnel are dispatched from the system’s Windows Server. Data from the system is stored in a SQL Server database.

https://www.pass4sureexam.com/70-461.html

Leading TCO

Cloud-Optimized

Pay As You Grow

Simplified Licensing Models

License Hardware Capacity by Cores Enterprise Business Intelligence Standard

License by User or Device Enterprise Business Intelligence Standard

https://www.pass4sureexam.com/70-461.html

Lihat lebih banyak...

Comentários

Copyright © 2017 DADOSPDF Inc.