70-461 Querying Microsoft SQL Server 2012

Views:
 
Category: Entertainment
     
 

Presentation Description

Exam 70-461 is intended for SQL Server database administrators, implementers, system engineers, and developers to prove their skills in writing queries.https://www.pass4sureexam.com/70-461.html

Comments

Presentation Transcript

Querying Microsoft SQL Server 2012:

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

Modernize. Save. Grow.:

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

[Company Name] | What We Do:

[ Company Name] | What We Do Expertise and Services [e.g. Cloud Services] History and E xperience [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:

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:

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

We need…:

We need… ? Availability 9 s Speed Compliance Data Exploration Consistent Data Scale On Demand Fast Time to Market Increased Productivity Anywhere Access Scalable Analytics Self-Service BI https:// www.pass4sureexam.com/70-461.html

The solution…:

Windows Azure Marketplace & Data Sync 24+TB¹ C ubes 15K P artitions Tier 1 Scalability AlwaysOn In-Memory ColumnStore Windows Server Core Support PowerPivot SharePoint Data Quality Services & BI Semantic Model Unlimited Virtualization & License Mobility Flexible Deployment Common Management & D evelopment Tools The solution… Availability 9 s Speed Compliance Fast Time to Market Self-Service BI Increased Productivity Data Exploration Consistent Data Scale On Demand Anywhere Access Scalable Analytics ? https:// www.pass4sureexam.com/70-461.html

SQL Server 2012 A Modernized Platform :

SQL Server 2012 A Modernized Platform Breakthrough Insight Mission-Critical Confidence Cloud on Your Terms https:// www.pass4sureexam.com/70-461.html

The Journey to a Modernized Platform :

The Journey to a Modernized Platform https:// www.pass4sureexam.com/70-461.html

A modernized platform for all:

A modernized platform for all TRANSFORM Upper Mid-Market ( > 250 PCs ) Extend Your Data Anywhere Core Mid-Market (50-250 PCs) GROW Accelerate Business Growth Lower Mid-Market (25-49 PCs) RUN Reduce ownership costs https:// www.pass4sureexam.com/70-461.html

Why Upgrade? :

Maintenance Why Upgrade? Licensing Availability Productivity 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. “ ” Reduce your TCO RUN https:// www.pass4sureexam.com/70-461.html

Upgrade to SQL Server 2012 :

Upgrade to SQL Server 2012 RUN 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. “ ” Standard Edition Reduce your TCO

Why Modernize? :

Why Modernize? Protection Speed Availability Our current database can no longer meet the scalability and performance requirements of our most demanding applications. “ ” Accelerate your business g rowth GROW 9 s

Modernize Your Application Platform:

Modernize Your Application Platform GROW Accelerate your business g rowth Our current database can no longer meet the scalability and performance requirements of our most demanding applications. “ ” Standard Edition & Enterprise Edition Windows Server 8 Modern Hardware

Why the Cloud? :

Why the Cloud? Reach 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. “ ” Extend your r each …almost a nywhere Fast to Solution Scale On Demand TRANSFORM

Get Ready for the Cloud :

Get Ready for the Cloud TRANSFORM 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. “ ” Extend your r each …almost a nywhere Standard Edition & Enterprise Edition Windows Server 8

We Can Help:

We Can Help https:// www.pass4sureexam.com/70-461.html

Next Steps:

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.microsoft.com/sqlserver

Contact Us:

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

Appendix:

Appendix

Evolution of SQL Server Are you leveraging the best technology available?:

Evolution of SQL Server Are you leveraging the best technology available? XML support Data mining and d ata scripting Failover clustering PowerPivot for SharePoint Report Builder 3.0 Support for up to 256 logical p rocessors Master Data Services Multi-server m anagement Hyper-V live m igration Data Tier Application Management (VS Integration) Complex event p rocessing System prep Unicode compression All Capabilities from SQL Server 2008 Release Transparent Data Encryption Enhanced BI sync framework Policy-based m anagement Resource governor Data compression / backup compression New data types (spatial , dates and time) All Capabilities from SQL Server 2005 Release All Capabilities from SQL Server 2008 R2 Release Power View PowerPivot Enhancements Single BI semantic model Managed self-service analytics Transparent data encryption Advanced auditing Column Store index DW compression DW partitioning SQL Server AlwaysOn 1 Source: Microsoft Sales, 2011 Database mirroring SSAS and ad h oc r eporting ETL and SSIS Service Broker All Capabilities from SQL Server 2000 Release SQL Server 2000

Platform Modernization SQL Standard Edition:

Basic OLTP & BI 80% of SMB customers use SE edition Basic Database , Reporting , and Analytics Programming, Developer, & Management Tools Best Choice for cost conscious customers 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: 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:

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” 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 Premium OLTP, BI, & DW 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

Platform Modernization SQL Server Lineup:

Basic OLTP & BI 80% of SMB customers use Standard edition (SE) Basic Database , Reporting , and Analytics Programming, Developer, & Management Tools Best Choice for cost conscious customers Platform Modernization SQL Server Lineup Premium OLTP, BI, & DW 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 Premium & Self Service BI 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 ) https:// www.pass4sureexam.com/70-461.html

Mission Critical Confidence Real world examples:

Mission Critical Confidence Real world examples World’s largest container shipping company Greater High Availability 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. “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.” “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 it’s huge for us and our customers .” Reduced Downtime NEW SQL Server AlwaysOn Online company reduces downtime and helps i ts c ustomers to improve service

Breakthrough Insight Real world example:

Breakthrough Insight Real 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

Breakthrough Insight Real world examples:

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. 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.” “We need to be nimble, offer innovative services, and ensure customer satisfaction. With SQL Server 2012 …that’s what we can do: deliver better solutions up to 50 percent faster, for less money .” Fast Innovative BI NEW Reporting Services

Cloud on Your Terms Real world example:

Cloud on Your Terms Real world example New Hybrid IT scenarios 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. “The cloud is absolutely the future, and Microsoft has made it easy to migrate mainframe applications.” https:// www.pass4sureexam.com/70-461.html

New Pricing Benefits:

New Pricing Benefits Continued high-value leader among major vendors Leading TCO 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

Simplified Licensing Models:

Editions Licensing Models Server+CAL | Core-based Changes to Licensing Business critical OLTP & BI EE Processor licenses are changing to cores EE Server+CAL model discontinued for new purchases Premium BI BI Server available only through Server+CAL model Same CAL as Standard Edition Basic DB & BI Standard Processor licenses are changing to cores Standard also available through Server+CAL model Simplified Licensing Models NEW!

License Hardware Capacity by Cores:

License Hardware Capacity by Cores Physical Server Licensing Virtual Machine Licensing License all physical cores on hardware Minimum of 4 cores per Processor EE w/SA provides unlimited virtualization OR License virtual cores Minimum of 4 virtual cores per VM License mobility with Software Assurance Pay only for what you use Pay for the power you need Cores are a precise and flexible measure of capacity for hybrid environments PRINCIPAL EDITIONS LICENSING OPTIONS Server+CAL Core-based Enterprise Business Intelligence NEW! Standard

License by User or Device:

License by User or Device License The Server License Users or Devices License each individual Server License single virtual machines License mobility with Software Assurance Physical Server Licensing Virtual Machine Licensing Users or Devices License each user/device SQL Server CALs access any SQL Server OR 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 PRINCIPAL EDITIONS LICENSING OPTIONS Server+CAL Core-based Enterprise Business Intelligence NEW! Standard

Slide33:

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

authorStream Live Help