1 / 17

Building mission critical database apps with SQL Server code name "Denali"

SAC-806T. Building mission critical database apps with SQL Server code name "Denali". Roger Doherty Sr. Technical Evangelist Microsoft Corporation. Agenda. WHO WILL BENEFIT FROM THIS TALK. TOPICS. WHAT YOU’LL LEAVE WITH.

belisma
Download Presentation

Building mission critical database apps with SQL Server code name "Denali"

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAC-806T Building mission critical database apps with SQL Server code name "Denali" Roger Doherty Sr. Technical Evangelist Microsoft Corporation

  2. Agenda WHO WILL BENEFIT FROM THIS TALK TOPICS WHAT YOU’LL LEAVE WITH • A burning desire to download Denali CTP3 and start testing it in your environment • SQL Server “Denali” overview • AlwaysOn HA / DR • “Apollo” data warehouse query technology • Rich support for content • Database Developers • Database Administrators

  3. Information Platform Requirements

  4. SQL Server Code Name “Denali” * New / Improved in Denali Wave

  5. Introducing AlwaysOn • New high-availability and disaster recovery solution • Replaces legacy failover clustering and database mirroring features • Integrated solution across direct attached and shared storage • Leverages common Windows Server Availability Platform (WSFC) • What does it provide? • Application-centric failover of multiple databases (Availability Groups) • Sync / Asyncredundancy across secondary replicas (up to four) • Improved resource utilization with readable secondaryreplicas • Redundancy across multiple datacenters (geo-clustering) • Policy-based configuration of failover behavior

  6. AlwaysOn Architecture Windows Server Failover Cluster • Availability Groups use WSFC for: • Inter-node health detection • Failover coordination • Primary health detection • Distributed data store for settings and state • Distributed change notifications • WSFC Convergence: • Windows 8 File Shares • Microsoft Hyper-V • Microsoft Exchange • AlwaysOn Failover Clustering • AlwaysOn Availability Groups Secondary Replica Transaction log (sync/async) Primary Replica Secondary Replica Transaction log (sync/async)

  7. Demo SQL Server “Denali” AlwaysOn Application Redundancy with Availability Groups

  8. Introducing Project “Apollo” • New index and query execution capability • New Columnstore index type (makes source data read-only) • New vector-based query execution capability (Batch execution) • What does it provide? • Support for large data warehouse queries (10s of Terabytes) • Near-instant response times • Ideal for ad-hoc queries with unpredictable patterns • Automatic usage via cost-based query optimization • Built-in support for SMP • Great compression

  9. Columnstore Architecture • Column Segment • Segment contains values from one column for a set of rows • Segments for the same set of rows comprise a row group • Segments are compressed • Each segment stored in a separate LOB • Segment is unit of transfer between disk and memory Segment C1 C4 C5 C6 C3 C2 Row group

  10. Demo Columnstore indexes Accelerating Data Warehouse Queries

  11. Introducing Rich Support for Content • Enhanced support for managing content in the database • Improved performance, scale and manageability of blob storage • Seamless movement of content to/from database environment • Powerful search capabilities across structured / non-structured data • What does it provide? • Integrated management of unstructured data (FILESTREAM) • Easy Win32 access to database-persisted files (FileTable) • Improved indexing of content (Fulltext Indexes) • Breakthrough content search capabilities for users (Semantic Search)

  12. Unstructured Data: An Architectural View Programmability Rich Data Programming Capabilities Win 32 T-SQL/Data Types Spatial, XML, HierarchyID Rich Query and Search Services over all Data Search Query and Type Operations XQuery Spatial ops Semantic Platform Efficient Storage for BR Data Semi-structured Data/XML Structured Data Unstructured Data B-trees Files XML, FTS, Spatial Indices Filestream Manageability& Availability

  13. Demo Semantic Search Comparing Content Based on Meaning

  14. For more information RELATED SESSIONS DOCUMENTATION & ARTICLES Download SQL Server Code Name “Denali” CTP3 at:http://www.microsoft.com/denali What’s New In Windows Azure OData Futures: Creating the Web of Data Creating Immersive Data Experiences with Entity Framework CONTACT: sqldevx@microsoft.com

  15. thank you Feedback and questions http://forums.dev.windows.com Session feedbackhttp://bldw.in/SessionFeedback

  16. © 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 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.

More Related