Transcription
The Fantastic12 of 2012The next wave of SQL Server investments will help extendorganizations beyond the database with a cloud-ready informationplatform that delivers mission critical confidence, breakthroughinsight, and cloud on your terms.Mission Critical ConfidenceSQL Server 2012 helps meet industry requirements for high availability with the new SQL Server AlwaysOn for mission critical availability while ColumnStore Index helps enable blazing-fast datawarehouse query performance.Breakthrough InsightSQL Server 2012 helps customers unlock new insights withpervasive data discovery across the organization while providingtools for IT to provide credible, consistent data and large-scaledata warehousing and analytic solutions.Cloud On Your TermsCustomers can enjoy built-in support for complex data types,greater interoperability with varied platforms, and common tools,like Management Studio and SQL Server Data Tools, to quicklycreate and scale innovative Hybrid IT solutions across server, privateor public cloud. Meanwhile, connection points across SQL Server2012 help make it easy to take advantage of the many benefitsoffered by the Windows Azure Platform, including SQL Azure.2012
Required 9s and Data ProtectionDeliver required uptime and data protection,server to cloud without wasting time and money2x faster failover, reduced downtime by yGreater Uptime SQL Server AlwaysOn: Help reduce planned and unplanneddowntime with the new integrated high availability anddisaster recovery solution. Achieve maximum applicationavailability and data protection with options to configuremultiple secondaries and the ability to quickly failover andrecover applications. Windows Server Core: Help reduce OS patching by as muchas 50-60%† with new support for Windows Server Core. Maintain uptime during maintenance operations usingenhanced online operations and eliminate planned downtimeon Hyper-V environment using Live Migration.Improved Productivity“Our business has to be online all the time .we were able to enable AlwaysOn in amatter of minutes.”Mediterranean Shipping Company Greater Hardware Utilization New HighCommon Tools: Configuration Wizard, Windows PowerShellsupport, dashboard, system views and System Centeralignment simplifies deploying and managing of AvailabilityGroups within AlwaysOn.Help reduce idle hardware and improve IT cost efficiencyand performance using Active Secondaries which enablesoffloading of various workloads to the secondary instances.Availability SolutionAlwaysOn¹Source: Internal Microsoft CTP TAP testing results. 2x faster than Database Mirroring in SQL Server 2008 R2† The percentage reduction in patching varies and can be less based on the server roles thatare enabled and the type of patches that are applied.
Blazing-Fast PerformanceGain breakthrough & predictable performancebacked by industry-leading benchmarks“400 percentimprovement inperformance.”First American TitleInsurance Company57,000transactions per second¹Accelerated Query Performance Full Text Search: Support blazing fast queries with dramaticimprovements to Full-Text Search that offer seriousperformance and scale advances.100,000,000transactions per day² Compression: Accelerate the performance of I/O intensiveworkloads by cutting growing volumes of data 50-60%1 withback up and data compression capabilities.Now, up to10x FasterNew ColumnStore Index¹Source: Microsoft customer evidence, Choice Hotels International²Source: Microsoft customer evidence, KAS Bank³Source: Microsoft customer testing; common data warehousing queries3 ColumnStore Index: Significantly boost data warehouse queryperformance, by up to 10x for star join and similar queries,using the new ColumnStore Index—built-in.Proactive Performance Management Resource Governor: Gain consistent performance forconcurrent and mixed workloads by defining resource usageacross different applications. Management Tools: Analyze query execution plans, capturedatabase activity, optimize indexes and structures, and helpensure consistent query performance within ManagementStudio.Industry-Verified Benchmarks: SQL Server continuously leads in industry-relevantTPC-E and TPC-H performance benchmarks. SAP-Certified: Release over release SQL Server is SAP-certifiedto run some of the industry’s most demanding workloads.¹Source: TechNet Books Online
Organizational Securityand Compliance“Most secure of any of themajor database platforms.”Help enable security and compliance with built-insecurity and IT controlsData Protection Encryption: Protect data with built-in encryption capabilitiesthat help protect confidential information including TransparentData Encryption that adds advanced protection without requiringchanges to the application. Certifications: Maintain confidence with third-party verifications;release over release, SQL Server pursues and achieves globallyrecognized Common Criteria Certifications.Control AccessNIST Reported Common Vulnerabilities and ExposuresJan 2002 – Jun 2010Betterseparation &of dutiesNew in2012Source: ITIC 2011: SQL Server Delivers Industry-Leading SecurityExpandedAUDIT User-Defined Server Roles: Easily manage permissions arounddata access to support separation of duties. Default Schema for Groups: Help increase manageability anddecrease complexity of database schema by allowing a defaultdatabase schema for Windows group user accounts. Contained Database Authentication: Help control database accessto deployed applications while improving manageability with selfcontained access to information without the need for server logins. Active Directory: Help secure end user data analytics with newSharePoint and ActiveDirectory security models for end userreports published and shared in SharePoint.Ensure Compliance SQL Server Audit: Help ensure compliance related to auditingwith audit resilience, filtering, user-defined audit, and enablementacross all SQL Server editions. Policy-Based Management: Define configuration policies andapply them to servers, databases, tables, and other targets acrossa server environment to help ensure policy compliance acrossthe environment.
Peace of MindPRODUCTION-LIKEapplication testingFree tools,migrate & upgradeEcosystem of partners70,000Help ensure peace of mind with the right product tools,premier services and support, a trusted partner ecosystem,and a wealth of no-fee tools.Product Enhancements Distributed Replay: Simplify application testing and help minimizeerrors with application changes, configuration changes, andupgrades. System Center Alignment: Up-to-date Management Packsenable centralized monitoring across SQL Server versionsincluding SQL Server 2012. System Center Advisor: Help reduce overall downtime withongoing assessments of SQL Server configurations and changesover time. No-fee Service Packs: Unlike many software companies,Microsoft offers free access to software service packs.Free Planning Tools PREMIER SUPPORT Predictability & savingsQuickly plan for an upgrade or migration with a wealth ofno-fee tools like Migration Assistant, Upgrade Advisor, andMAPS developed by Microsoft engineers and available fordownload online.Tailored Support and Licensing Programs Mission Critical Support: Microsoft’s Premier Mission CriticalSupport and the Microsoft Critical Advantage Program, providethe services and support needed for companies to establishthe proactive IT environment and operations necessary todeliver maximum availability and performance to their MissionCritical Applications. Enrollment for Application Platform: Microsoft delivers pieceof mind with the licensing program EAP which offers unlimitedsupport to customers with specific software assurance plans andup to 40% savings on license costs for new deployments.through licensing programs
Rapid Data Exploration& Visualization“Only 28% of potential users are using thestandard BI platform of choice in organizations¹”Empower end users with new insights through rapiddata exploration and visualizationSelf-Service Analytics PowerPivot: Empowering users of all levels to access and mashup data from virtually any source, create compelling reports andanalytical applications, and easily collaborate and share insightsusing familiar tools in Microsoft Excel 2010 and MicrosoftSharePoint 2010.Stunning, interactive data visualization Mashup data,PowerPivotStunning, interactivedata visualizations,Power ViewFamiliar Toolsbuilt on Excel &SharePoint¹ Gartner, “The Consumerization of BI Drives Greater Adoption,” James Richardson, June 3, 2011Power View: Discover new insights at the speed of thought withhighly interactive, browser-based data exploration, visualization,and presentation experiences for users of all levels. Now anyonecan create a report in just seconds, transform the “shape”of data with a single click, add powerful timed animationsequences to quickly identify trends or anomalies, and make amore convincing case through rich presentation of discoveredinsights.
Managed Self-Service BIEnable users with Self-Service BI while gaining bettermonitoring and management capabilities for IT“We can balance ouremployees’ need forrich information andcollaboration with IT’sneed to manage thesafety & confidentialityof information.”Gain insight and oversight PowerPivot for SharePoint: Balance the need to monitor,manage, and govern the data and analytics end users create withIT dashboards and controls that help IT monitor end user activity,data source usage, and gather performance metrics from servers.Enable IT Efficiency End user created, IT managed: SQL Server 2012 bridges thegap between end user created BI applications and IT managedcorporate solutions by providing the ability to import PowerPivotmodels into Analysis Services so that they can be professionallymanaged and transformed into corporate grade solutions. Ease of administration through SharePoint: Enable end useralerting from reports published to SharePoint and benefit fromthe ease of consolidated management through the SharePoint2010 Central Administration. SQL Azure Reporting: Extend rich user insights to even morepeople with SQL Azure Reporting that removes the need fordeploying and maintaining a reporting infrastructure.CareGroup Healthcare SystemGaininsight& oversightEnd usercreated,IT managedSingleadministrationfrom SharePoint
Credible, Consistent DataCompanies with accurate data perform better1Hrs spent peremployee each weeksearching for info% of master data complete& accurateTop 20%Performers91%Middle 50%PerformersBottom 30%Performers68%Deliver credible, consistent data to the right usersacross the organization with a complete end-toend solutionOne Single Semantic Model 1.2hrs2.8hrsSeamlessly Integrate Data Under 50%DataQualityServicesMasterDataServices6hrsSingle BISemanticBI Semantic Model: A single, scalable model for BusinessIntelligence applications, from reporting and analysis todashboards and scorecards, that helps provide a consistent viewacross heterogeneous data sources. IT and developers can createa single model to be consumed by front-end tools for their BIApplications across both tabular and multidimensional models.Integration Services: Help reduce time-to-solution for innovative,team-based data integration across data sources, includingthe cloud, by utilizing the industry-leading tools in IntegrationServices (SSIS) that help deliver credible, consistent datareliably and efficiently. New improvements include significantimprovements in the user experience for dramatic efficiencies.Cleanse Organizational Data ModelData Quality Services: Help improve data quality by usingorganizational knowledge and 3rd party reference data providers,including cloud-based providers, by enabling data managers toreliably profile, cleanse, and match data —run as a standalonetool or leverage within SSIS.Efficiently Manage DataDelivered with 2012¹Source: “Turning Pain into Productivity with Master Data Management,” Aberdeen Group, Feb 2011Master Data Services: Help create, maintain, store, and accessmaster data structures used for object mapping, reference data,metadata management with Master Data Services (MDS), while anew MDS Add-in for Excel makes it easy for end users to manageand maintain central data.
Scalable Analytics &Data WarehousingAchieve scale and flexibility with analy tic and datawarehousing solutions that offer massive scale atlow cost“Parallel DataWarehouse runscomplex queriesabout 160 times faster,providing a data loadover 1 Tb/Hour andfully integrates into acomplete BI Solution” 24TBANALYTICAL SOLUTIONS² 600TBFlexibility and Choice Hardware and deployment options: Suit unique organizationalneeds with Fast Track configurations from 11 hardware vendorsor software only solutions, reference architectures and appliances. Optimized Solutions: Leverage best practices and drive fasttime to market with data warehouse reference architectures andappliances that help deliver faster time to solution.Massive Scale at Low Cost Built-in Functionality: Scale data warehouses with built-indatabase features like Remote Blob Storage and partitionedtables that scale to 15,000 partitions and support large slidingwindow scenarios. Support for Powerful Hardware: Gain high scale with supportfor up to 256 logical cores that helps enable high-performancefor very large workloads or consolidation scenarios. Parallel Data Warehouse: Scale to 600 TB while maintaininghigh performance through massively parallel processing (MPP)architecture.DATA WAREHOUSES W/ TRUE MPP²DirectEdge, US Stock ExchangeMassive Scale,Low CostFLEXIBILITY& Choice¹Source: Microsoft evidence: McLaren Electronic Systems²MS Evidence: Yahoo & Microsoft testingCompleteBI SOLUTIONComplete BI Solution Scalable OLAP: Deploy more than just breathtaking end useranalytics tools, SQL Server continues to deliver end-to-end BIthrough easy to stand up and manage traditional OLAP andreporting cubes that are proven to scale into the 10s of TB.
Scale On DemandScale on demand with flexible and hybrid deploymentoptions on your terms server to cloudElastic ScalePrivate Cloud/Hybrid Cloud Self-service Deployments: Gain virtualized, on-demandcapacity and self-service provisioning & usage metering withMicrosoft private and public cloud offerings across SQL Server2012 and SQL Azure. SQL Azure Federation: Support bursting scenarios by deployingall or part of an application to SQL Azure where Auto Scalepolicies create databases on-the-fly to support elastic demand.Flexibility and ChoicePublic Cloud/HostedOn-premisesMigrate apps with interoperableDeployment Options Contained Databases: Seamlessly migrate databases betweenor extend apps across different instances of SQL Server and SQLAzure with Contained Databases that define and contain theschemas and objects required to support an application. License Mobility: Support Hybrid IT, a flexible deploymentenvironment across server and cloud, through unique licensinguse rights that allow organizations to move licenses acrossserver, private and public cloud. Data Sync: Enable new, creative hybrid application scenarioswith bi-directional data synchronization between databasesacross datacenter and cloud.Connection points toWINDOWS AZUREprivate & publicCLOUD OFFERINGSDelivered with2012¹Source: IDC, Worldwide and Regional Public IT Cloud Services 2011–2015 Forecast,Doc # 228485, Jun 2011
Fast Time To SolutionHelp reduce complexity and accelerate time to solutionwith turn-key appliance and cloud offeringsPre-packaged appliances andreference architecturesScenario-optimizedBusiness intelligence, consolidation, Accelerate top organizational priorities with appliances fordata warehousing of varying sizes, business intelligence,consolidation, and transaction processing. SQL Server offers Appliances built jointly with HP and Dell:Co-engineered with hardware partners HP Enterprise Database Consolidation Appliance HP Enterprise Data Warehouse Appliance HP Business Decision Appliance HP Business Data Warehouse Appliance Dell Parallel Data Warehouse ApplianceComplete SolutionsHardware software support, reduce time“The appliance can be deployed in a matter of days vs.weeks or months for traditional implementations.”Brian KnightPragmatic Works Microsoft deeply co-engineers the appliances with partnersto ensure highly tuned solutions, fully integrated , with singlesupport for all the Hardware and Software, with enhancedappliance-only software, and that deliver great price/performance.Agility Speed time to solution with SQL Server appliances byeliminating the time to design, tune and test all the relatedhardware and software components. Provision databases in minutes without any physicaladministration or infrastructure investments with SQL Azure.
Optimized ProductivityOptimize IT and developer productivity across server andcloud with common toolsBuild78%Common ToolsTOTAL COST OFADMINISTRATION SAVINGSOVER ORACLE¹ SQL Server Data Tools: Take database development to the next levelwith SQL Server Data Tools, an integrated development experiencefor developers building next-generation web, enterprise and dataaware mobile applications across on-premises and public cloud. T-SQL Enhancements: Simplify complex programming tasks withT-SQL enhancements and ease database migrations with improvedsupport for ANSI SQL standards. Additionally, the new Sequenceobject enables developers to tie unique row identifiers acrossmultiple tables.Extend Common tools: Build, extend, and manage database or businessintelligence solutions across on-premises and cloud environmentsusing the same development tools, frameworks and T-SQL basedmodel.Manage new unifiedDEV EXPERIENCEBuild, extend& manage apps anywhere¹Source: Microsoft SQL Server and Oracle Database: A Comparative Study on TotalCost of Administration (TCA), Alinean, Jan 2010SQL Server Management Studio: Manage efficiently at scale witha single console to deploy and manage database assets acrossservers, private cloud and public cloud. Additionally, use SSMS tomanage high availability configurations, BI services, and resourceutilization. Automate infrastructure maintenance tasks, streamlinetroubleshooting and diagnostics and optimize hardwareresources with built-in easy-to-use manageability tools. Streamline virtualization management with System CenterVirtual Machine Manager. Support for Windows PowerShell 2.0 automates managementtasks across the Microsoft platform.
Extend Any Data, Anywhere“The total worldwide volume of data is growingat 59% per year, with the number of filesgrowing at 88% per year.¹”Gartner estimates that 70-85%of data is ‘unstructured’¹More storageoptions forunstructured data&Complete data management Support for Any Data: Manage and extend relational and nonrelational data including XML data, Windows files, and spatialinformation.Enhanced search functionality15%85%UnstructuredE x tend the reach of data most anywhere across serverand/or cloud with expansive developer technologies Seamlessly extend data OData: Provide a consistent and open data-feed to powermultiple user experiences across the web, devices and desktopwith OData, an open protocol built on widely used webstandards. SQL Azure DataMarket: Monetize accumulated data bypublishing data for purchase and consumption by otherentities. Enhanced interop support: Extend heterogeneousenvironments by connecting to SQL Server and SQL Azureapplications using any industry standard APIs (ADO.NET, ODBC,JDBC, PDO, and ADO) across varied platforms including .NET,C/C , Java, and PHP.StructuredGreaterinteropDelivered with2012¹Source: Gartner Symposium Presentation ‘Information Management Goes ‘Extreme’:The Biggest Challenges for 21st-Century CIOs, Mark Beyer, October 2011Statistical Semantic Full-Text Search: Enable T-SQL developersto bring deep insight to the organization within non-structureddata files stored in the SQL Server database by uncoveringpreviously undiscovered relationships across stored files.
serverwww.facebook.com/sqlserver 2011 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 thecurrent 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 informationprovided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
The next wave of SQL Server investments will help extend . organizational knowledge and 3rd party reference data providers, including cloud-based providers, by enabling data managers to reliably profile, cleanse, and match data —run as a standalone . Complete BI Solution S
