SQL Server 2014 In Memory

Since I work in the financial industry, computing speed fascinates me (not just the hardware kind). There are times when a project or product is deemed nonviable because it is, well too slow.

So seeing one of my two most favorite RDBMS, SQL Server has added the In memory feature was exciting. Some of the recent products out of Microsoft are well thought out and this is one of them. The design is quite simple and integrates well with the base RDBMS features. It runs on commodity hardware which should let customers adopt quickly. Also, license cost is built into Enterprise edition, which should help as well.

Anyway, I intend to make good use of my couch time and write a few blog entries. The plan is to blog about:

SQL Server 2014 In memory - Links to reference material
Creating a Virtual Box VM
Installing Windows 2012 R2 Server on the VM
Installing SQL Server 2014 on the VM
Demo: Create a Database and enable for In Memory
Demo: Create a Memory Optimized Table
Demo: Creating Native Stored Procedures
Demo: Tx Log optimization for In Memory transactions
Demo: Data and Delta File layout for Memory Optimized tables
Demo: Transaction Isolation Levels with Memory Optimized tables
More demos..

So look back very soon..

Note: SQL Server 2014 is still in CTP1. While CTP1 has many restrictions, CTP2 is expected to remove some of those restrictions and contain more features.