1 / 22

SQL Server 2014 Overview by Phil Brammer

Learn about SQL Server 2014 features including In-Memory OLTP, Columnstore improvements, query performance enhancements, and more. Discover Azure integration, HA capabilities, and smart backup solutions. Enhance your database management skills and explore hybrid scenarios.

gus
Download Presentation

SQL Server 2014 Overview by Phil Brammer

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 2014: Overview Phil Brammer @PhilBrammer ssistalk.com

  2. Phil Brammer • Over 13 years’ experience in database technologies, data warehousing, ETL, on-call… • Worked with Teradata at PayPal • Operationally manages multi-terabyte instances • Dabbles a bit in SSIS – ssistalk.com • Microsoft MVP, SQL Server – 7th year

  3. Breakthrough Performance & Scale • In-Memory OLTP (Hekaton) • Columnstore Improvements • Query Performance Improvements • Resource Governor for I/O • Buffer Pool Extension • Scale Optimizations for > 8 socket systems

  4. Enhanced High Availability • AlwaysOn Enhancements • Online Database Operations

  5. Hybrid Scenarios • Smart Backup • AlwaysOn Replica in Windows Azure VM • SQL Server with Azure Storage Integration • On-Prem to Azure Migration

  6. Other • Separation of Duties • Extending PowerView • Windows Server Enhancements

  7. BP & S: In-Memory OLTP • Up to 20-30x throughput • Easy to migrate existing applications • Integrated experience • Full ACID support • All in-memory. No buffer pool, B-Trees • No lock manager, latches, or spinlocks

  8. BP & S: Columnstore • New clustered option • Completely read/writeable • New archive option for even more compression

  9. BP & S: Query Performance Improvements • New cardinality estimator • Incremental statistics per partition

  10. BP & S: Resource Governor • Limit I/O to a Resource Pool • Limit CPU usage; percent, affinity • Limit DOP • Limit Memory

  11. BP & S: Buffer Pool Extension • Ability to extend buffer cache to any volume (SSD) • Improve OLTP performance • No risk of data loss (clean pages) • Easy to implement

  12. HA: AlwaysOn Enhancements • Up to 8 readable secondaries • Ability to use readable secondaries during network failures • Cluster Shared Volume support • Easier troubleshooting • Wizard to add replica to Azure

  13. HA: Online Operations • Single partition online index rebuild • Manage lock priority for SWITCH and online index rebuild operations

  14. Hybrid: Smart Backup • Input storage URL (Azure), retention • Automatically backs up databases • Automatically cleans up • Context aware • Minimal storage costs • Zero hardware management • No media decay

  15. Hybrid: Backup to Azure Storage • Near-bottomless storage • Offsite, geo-redundant • No provisioning • No device management • No media decay • Remote accessibility

  16. Hybrid: AlwaysOn Replica in Azure • Wizard to add a replica in Windows Azure VMs • Eliminates DR site needs (hardware, rent, etc…) • Offload read/backup workloads

  17. Hybrid: SQL & Azure Storage Integration • Native support for SQL Server database files stored as Azure blobs • Can move a single database at a time • Save storage costs • Backed by Azure Storage SLAs • Fast disaster recovery using database attach • Control security with on-prem model

  18. Hybrid: Migrations to Azure VMs • New Wizard to migrate databases to Azure VM • Perfect for DBAs new to Azure • No need of specific Azure knowledge • Time to transfer DB is limiting factor

  19. Other: Separation Of Duties • CONNECT ANY DATABASE • IMPERSONATE ANY LOGIN • SELECT ALL USER SECURABLES • Allows for greater role separations – audit vs admin

  20. Other: Power View for Multidimensional Models • Allows native support for DAX in Analysis Services • via BI Semantic Model

  21. Other: Windows Server Enhancements • ReFS Support • Online resize VHDX • Storage Tiering • SMB improvement • Hyper-V replica improvement • Faster live migrations

  22. End • Thank you for attending! • Phil Brammer • @PhilBrammer • http://www.ssistalk.com

More Related