Microsoft Virtual Academy
Get 50% off eBooks plus
40% off print books at
The Microsoft Press Store
SQL Server pros, do you want to find out how SQL Server 2014 can help you improve performance speed by 10–30 times—using the same hardware you have today—and improve reliability at the same time? Get in on a technical preview of the new Mission Critical features of SQL Server 2014, led by the team of Microsoft experts who own the features.
Instructors | Kevin Liu - Microsoft Engineering PM; Jos de Bruijn - Microsoft Program Manager; Luis Carlos Vargas Herring - Microsoft Program Manager; Ajay Jagannathan - Microsoft Senior Program Manager; Darmadi Komo - Microsoft Marketing PM; Evgeny Krivosheev - Microsoft Program Manager
SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this database developer-focused session, we discuss the new memory-optimized tables and indexes. You will learn how to access memory-optimized tables using interpreted Transact-SQL and how to optimize data access using the new natively compiled stored procedures. Finally, you will learn how to work with the new lock-free transaction semantics for in-memory OLTP.
SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this DBA-focused session, we discuss how ACID is achieved, especially around storage. We also take a deep dive into memory provisioning and high availability, in addition to manageability and supportability.
SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. There are some specific scenarios which stand to benefit more than others from In-Memory OLTP. We will discuss these scenarios and application patterns which can take advantage of In-Memory OLTP, and we will reference what we have learned in working with customers using early bits.
In this session, we’ll discuss the AlwaysOn (Availability Groups and Failover Cluster Instances) enhancements in SQL Server 2014, from increasing the number of secondary replicas and keeping them available for reads at all times, to deploying in them easily to Windows Azure. You’ll understand the business value of these enhancements and see them in action.
The online database operations feature in SQL Server 2014 is an interim step toward providing true online capability for database maintenance and OLTP workloads, thereby greatly increasing enterprise application availability by reducing maintenance downtime impact. This feature offers additional manageability options for Tier 1 customers to deal with table locks acquired by a partition SWITCH operation or during an Online Index Rebuild (OIR). This feature also introduces Online Index Rebuild for a Single Partition (SPOIR). The primary audiences for this improvement are DBA administrators for Enterprise T1 and DW systems that use table partition SWITCH operation and Online Index Rebuild (OIR).
Buffer Pool Extension can potentially increase performance of OLTP application by allowing extension of SQL Server buffer pool to non-volatile disks, such as Solid State Drives (SSDs). In addition, enhancement of Resource Governor in SQL Server 2014 on IO allows much better control of physical IO in SQL Server resource pools.
Please peruse this section for additional information that supports this Jump Start event. This is an opportunity for you to dive deeper into mission critical performance with SQL Server 2014 at your own pace.