Optimizing OLTP and Data Warehousing with SQL Server 2014

MP4 | AVC 332kbps | English | 1024x768 | 15fps | 2h 19mins | AAC stereo 127kbps | 353 MB

Genre: Video Training

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.

│ optimizing-oltp-data-warehousing-sql-server-2014.zip

│

├───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