1 / 24

SQL Server vNext

SQL Server vNext. René Balzano & Roger Breu. Technology Solution Professionals Data Platform. Microsoft Switzerland. Agenda. «Denali» Overview Deployment and Configuration Coding and Debugging Processing and Querying Outlook. «Denali» Overview. SQL Server codename “Denali”.

gustave
Download Presentation

SQL Server vNext

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. SQL Server vNext René Balzano & Roger Breu Technology Solution Professionals Data Platform Microsoft Switzerland

  2. Agenda • «Denali» Overview • Deployment and Configuration • Coding and Debugging • Processing and Querying • Outlook

  3. «Denali» Overview

  4. SQL Server codename “Denali” MISSION-CRITICAL PLATFORM DEVELOPER and IT PRODUCTIVITY PERVASIVE INSIGHT Increase flexibility with integrated high availability Gain higher return on high availability investments Get breakthrough data warehousing scale and performance Expand the reach of BI to business users Get advanced analytic performance Deliver credible, consistent data to right users Realize lower cost of IT administration Accelerate time-to-market for developers Build more flexible, innovative applications

  5. Deployment and Configuration

  6. Setup/Configuration Changes • Windows Powershell is no longer installed by SQL Server Setup; now it’s a prerequisite for installation • .NET Framework 4.0 is a prerequisite for installing SQL Server codenamed “Denali”, .NET Framework 3.5SP1 for Setup on Windows Vista and Windows Server 2008 • Startup Options • Startup Parameters tab in SQL Server Configuration Manager

  7. HADR SQL Server “Denali” AlwaysOn • High Availability & Disaster Recovery (HADR) solution referred to as SQL Server “Always On” • Increase flexibility with new, integrated HADR solution • Faster failover, easier administration with Availability Groups • Identify databases to failover as a unit to reduce unplanned downtime • Faster application failover using virtual network name • Increase application uptime using flexible failover policy • Enable better data redundancy and protection with up to four secondaries and up to two synchronous secondaries • Multi Subnet Clustering • Limited downtime with enhanced online operations • Run Microsoft SQL Server® on Windows Server® Core to reduce planned downtime (50-60% fewer OS patch reboots) A A A A A A A A A

  8. Availability Group uses windows server failover cluster (WSFC) for Inter-node health detection, Failover coordination, Primary health detection, Distributed data store for Availability Group settings and state, Distributed change notifications Availability Group Architecture Windows Server Failover Cluster Database Active Log Synchronization Database Active Log Synchronization • WSFC Common Microsoft availability platform • SQL Server AlwaysOn Failover cluster instances • SQL Server AlwaysOn Availability Group • Microsoft Hyper-V • Microsoft Exchange • Built-in WSFC workloads (e.g. file share, NLB, etc) and third party workloads

  9. Availability Group Architecture Drilldown Client connections transparently redirected to primary via IP and network name resources User tells SQL to failover Availability Group 2 to Node1 Clients disconnected from AG2 SQL Server Instance SQL Server Instance SQL Server Instance Availability Group 1 Availability Group 2 Secondaries request primary connection WSFC Service WSFC Service WSFC Service WSFC tells AG Res DLL to bring AG2 online WSFC tells AG Res DLL to bring AG2 offline Notification of new primary SQL confirms and tells WSFC Notification of new primary AG Res DLL AG Res DLL AG Res DLL

  10. Advanced Failover Options • Diagnostics generated for Health State Components • System • Resource • Query Processing • IO Subsystem • Events • Exec sp_server_diagnostics

  11. Contained Databases • “PARTIAL” containment now available • User containment (database users with no instance-level login associated) • Collation containment (tempdb tables will also use the database collation for contained databases) • Sys.dm_db_uncontained_entities • Shows you what else in your DB is still uncontained

  12. Security Features • New Permissions • GRANT, REVOKE and DENY to: • SEARCH PROPERTY LIST/CREATE and ALTER ANY SERVER ROLE • New Role Management • User-defined server roles • Sp_addsrvrolemember and sp_dropsrvrolemember are deprecated / Use ALTER SERVER ROLE instead. • Hashing Algorithms • HASHBYTES function supports the SHA2_256 and SHA2_512 algorithms. • Database Engine Access through (Partial) Contained Databases

  13. Coding and Debugging

  14. SSMS Enhancements • IntelliSense • Substring matching in completion lists • Code Snippets (Expansion, Surround) • More Visual Studio Features • Multi Monitor Support • Zoom • Task List • Clipboard Ring

  15. Debugging Enhancements • Breakpoints • Conditional • Hit Count • Filter • Actions • Watch Expressions • DataTips

  16. T-SQL Enhancements • Result Set Metadata • sp_describe_first_result_set (sys.dm_exec_describe_first_result_set) • sp_describe_undeclared_parameters • sys.dm_exec_describe_first_result_set_for_object • EXECUTE ... WITH RESULT SETS • Ad-hoc Query Paging • ORDER BY ... OFFSET ... FETCH NEXT ... • Sequence Objects • CREATE SEQUENCE ... • INSERT ... VALUES(... NEXT VALUE FOR ...) ...

  17. Processing and Querying

  18. Columnar Index • Aimed at Data Warehouse Queries • Index Content is stored column-wise • Pages are highly compressed • Only queried attributes are accessed

  19. Outlook

  20. Resources • CTP 1 is public, you can get it here: • http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9 • Denali Books Online • http://msdn.microsoft.com/en-us/library/bb500435(SQL.110).aspx • http://blogs.technet.com/b/dataplatforminsider/ • http://www.microsoft.com.sqlserver/en/us/product-info/future-editions.aspx • ColumnstoreIndexes:http://download.microsoft.com/download/8/C/1/8C1CE06B-DE2F-40D1-9C5C-3EE521C25CE9/Columnstore%20Indexes%20for%20Fast%20DW%20QP%20SQL%20Server%2011.pdf

  21. Roadmap • CTP3 will be public again • Expected RTW in Summer 2011 • Release Candidate in Fall 2011 • RTM ??? 

  22. Summary • SQL Server Codename “Denali” introduces a variety of enhancements and new features • We have only talked about a few • SQL Server is the platform for your Mission Critical applications • IT and Developer Productivity will be greatly improved • New BI Enhancements allow the balancing act between Corporate BI and Personal BI

  23. Q&A

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