Sql Server In-memory table implemented with Redis
<p>Starting from Sql Server 2014 Microsoft implemented In-Memory OLTP that IMO is very interesting feature!
I never tried it but I'm interested in because it can really speed up my "READ" actions (I mean select queries).</p>

<p>My idea is to run "WRITE" actions (insert, update, delete) directly to the disk (not in memory) to be sure that data are written persistently.
Instead "READ" actions (in particular queries on big tables, counters at Application_Startup, ecc) will be done in memory.</p>

<p>Now I have some questions: 
1) is in-memory table synchronized in some way with the data saved in disk?</p>

<p>2) Is possibile to implement what I wrote above or I misunderstood?</p>

<p>3) Because the enterprise version of Sql Server 2016 costs too much for a startup or a small company, is possible to implement all of this using Redis? 
   I'm new also on Redis and I'm not sure that it has a "in-memory" table feature.
   Searching on Google I found that it made a cache (it's not clear of what, queries?) and it's an in-memory data structure store (key-value pairs)</p>

<p>Thank you in advance guys</p>