This is an ongoing “project”. The idea is to have links related to SQL Server 2014 in a single place, for easy access and reference.
- In memory OLTP (Hekaton) related links:
- Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper for CTP2
- Why Hekaton In-Memory OLTP Truly is Revolutionary
- What the Hekaton?
- SQL Server 2014: Pushing the Boundaries of In-Memory Performance
- Microsoft’s In-Memory OLTP: Why, What, and How
- In-Memory OLTP Engine FAQs
- In-Memory OLTP: High Availability for Databases with Memory-Optimized Tables
- Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton
- New In-Memory OLTP Sample for SQL Server 2014 CTP2
- SQL Server – Memory Optimization Advisor, SQL Server 2014
- In-Memory OLTP and the Identity Column
- SQL Server 2014 In-Memory OLTP: Nonclustered Indexes for Memory-Optimized Tables
- Overview of the Different In-Memory OLTP Index Types
- First steps with Extreme Transaction Processing – Hekaton
- Thinking about Hekaton? Then think about collations
- Overcoming storage speed limitations with Memory-Optimized Tables for SQL Server
- Workaround for lack of support for constraints on SQL Server Memory-Optimized Tables
- Choose your Hash Bucket Count very wisely in Hekaton!
- SQL Server 2014 In-Memory OLTP discussions at PASS Summit 2013
- Boosting Transaction Performance in Windows Azure Virtual Machines with In-Memory OLTP
- Hekaton with a twist: In-memory table-valued parameters
- Updating statistics for Memory-Optimized tables in SQL Server
- SQL Server 2014 In-Memory OLTP Architecture and Data Storage
- Understanding SQL Server Memory-Optimized Tables Hash Indexes
- Hekaton In-Memory Tables: HASH Indexes
- Determine BUCKET_COUNT for Hash Indexes for SQL Server Memory Optimized Tables
- Overview of Applications, Indexes and Limitations for SQL Server 2014 In-Memory OLTP Tables
- Getting started with the AMR tool for migration to SQL Server In-memory OLTP Tables
- SQL Server 2014 Memory Optimization Advisor
- Transaction dependencies and speculative reads with memory-optimized tables
- In-memory OLTP – read_set, write_set, and scan_set
- SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables
- Other subjects:
- Microsoft® SQL Server® 2014 CTP2 Product Guide
- New features in SQL Server 2014
- What’s New (Database Engine)
- sys.dm_exec_query_profiles – FAQ
- Backup and Restore Enhancements in SQL Server 2014 CTP2
- Changes to SQL Server 2014 AlwaysOn Availability Groups
- Delayed Durability–I start to like it!
- WAL is no more a dogma in SQL Server 2014
- SQL Server 2014 – Delayed Durability
- New Enhanced Column Store Index in SQL Server 2014 – Part 1
- Getting Started with Columnstore Index in SQL Server 2014 – Part 2
- Updateable columnstore index gotchas
- SQL Server clustered columnstore Tuple Mover
- IO Resource Governance in SQL Server 2014
- How to throttle your Storage with Resource Governor in SQL Server 2014
- Enabling Transparent Data Encryption on SQL Server 2014
- SQL Server Data Tools for SQL Server 2014 CTP2 is available
- Microsoft SQL Server Data Tools Update
- SQL Server 2014: Partition Improvements
- SQL Server – Backup Encryption, SQL 2014 CTP2
- SQL Server 2014 Hybrid: Storing data files in Azure storage – Bizarre or not?
- SQL Server 2014 overview part 1: In-memory, cloud integration features
- SQL Server 2014 overview part 2: Availability and scalability features
- SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines
- Platform for Hybrid Cloud with SQL Server 2014 Jump Start
- Introducing Managed Backups in SQL Server 2014
- A First Look at the New SQL Server Cardinality Estimator
- Correlating SQL Server 2014 cardinality events and query plan
- New SQL Server 2014 Dynamic Management Views
- Tracking execution stats of SQL Server 2014 natively-compiled sprocs
- How SQL Server 2014 improves Online Operations that aren’t Online Operations
Pingback: My links of the week – November 10, 2013 | R4
Pingback: My links of the week – November 17, 2013 | R4
Pingback: My links of the week – November 24, 2013 | R4