2014
Pluralsight
Ahmad Alkilani
2h 19m
English

This course focuses on SQL Server 2014 and two of the latest additions to the database engine. We first look at how the shift in technology trends established the need for a different breed of technologies. Columnar, or Column-Oriented, databases have become increasingly popular in data warehousing applications because they allow for better compression and multi-fold performance improvements, and we'll see how SQL Server 2014 implements this with clustered columnstore indexes. In addition, as technology makes a bigger shift in hardware to multi-core CPU architectures and large amounts of memory are even cheaper and more attainable, it's important for software to adjust and utilize these changes. We'll see how In-Memory OLTP addresses these trends and more, letting you create tables in memory, eliminating locks and implementing optimistic multi-version concurrency. This course discusses in depth In-Memory OLTP (memory optimized tables), previously known as Hekaton. We'll cover creating memory-optimized tables, loading data, durability and the affect that has on the transaction log. We'll also look at indexing in detail, explaining the new index types created specifically to support In-Memory OLTP and how and when to apply each type based on your use case and we'll discuss how In-Memory OLTP and Clustered Columnstore indexes can fit a variety of applications while comparing them with each other and traditional disk-based tables and indexes.

01. In-Memory OLTP
01. Introduction.mp4
02. Course Overview.mp4
03. Software Requirements.mp4
04. Technology Drivers and Hardware Trends.mp4
05. In-Memory OLTP Overview.mp4
06. Architecture.mp4
07. Durability for In-Memory Tables.mp4
08. Scaling Up Efficiently.mp4
09. Demo Memory Optimized Filegroups.mp4
10. Demo Table and Data Setup.mp4
11. Demo Create In-Memory Table - Part 1.mp4
12. Demo Create In-Memory Table - Part 2.mp4
13. Summary.mp4

02. Data & Indexes for Memory Optimized Tables
01. Introduction.mp4
02. Demo Loading Data & Transaction Log Impact.mp4
03. Indexes on Memory Optimized Tables.mp4
04. Demo Hash Indexes.mp4
05. Hash Indexes Architecture.mp4
06. Demo Range Indexes.mp4
07. Demo Index Statistics.mp4
08. Demo Advanced Indexing.mp4
09. Summary.mp4

03. Advanced In-Memory OLTP
01. Introduction.mp4
02. Natively Compiled Stored Procedures.mp4
03. Demo Natively Compiled Procedures Part 1.mp4
04. Atomic Blocks.mp4
05. Demo Natively Compiled Procedures Part 2.mp4
06. Concurrency Control.mp4
07. Isolation Levels.mp4
08. Demo In-Memory OLTP Isolation Levels.mp4
09. Other Considerations.mp4
10. Summary.mp4

04. Clustered Columnstore Indexes
01. Introduction.mp4
02. Use Cases for Clustered Columnstore Indexes.mp4
03. Clustered Column Store vs. Row Store.mp4
04. Demo DDL and DML for CCI.mp4
05. Demo Querying CCI.mp4
06. Summary.mp4

http://pluralsight.com/

Download File Size:340.46 MB

---