In the past couple of months many of us heard about the new SQL Server 2014 and its In-Memory technologies, such as In-Memory OLTP for high-transactional application and the ColumnStore INDEX’s for BI apps. This comes in addition to various in-memory technologies outside of the SQL Server world, such as Oracle, IBM or few NewSQL startups.
There are plenty of benefits for in-memory solutions:
- Offloading expensive repeated database requests
- Acceleration of Database speed and application performance
- Scalability of applications
- Reducing database resources and licensing costs
The level of interest in performance in-memory technologies is clearly on a rise, so we’ll try to provide you with interesting news, investigation summaries and interesting webcasts, especially when it comes to the SQL Server databases, applications and users.
Choosing the right solution for you can be based on many factors:
- Application stage: a Greenfield new application, a Live production homegrown application or Commercial off-the-shelf application
- Application characteristics: Operational vs. Analytical BI application
- Effort level and time available to resolve a challenge: the level of effort, resources and costs you want to apply in setup, development, testing and deployment
Personally, I love webinars as they give an opportunity to learn very quickly one or two technologies; many times combining a view from 10,000 feet down to practical 100 foot level; learn various technologies aspects; either how to get started or help defining a realistic plan.
My friends at SafePeak, the software vendor of In-Memory Dynamic Caching for performance acceleration of SQL Server applications, are running next week (Wednesday 30th) a webinar under the title: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching.
The webinar plans to review the SQL Server 2014 In-Memory OLTP, how it works, various scenarios where it fits more and less, key benefits, key limitations (and how to overcome some of them), things to consider when planning to use it. Additionally the webinar will review SafePeak’s Automated In-Memory Caching for SQL Server applications, it’s internals or how it works, where it fits more and where it fits less, and run a technologies comparison of both SQL 2014 In-Memory OLTP and SafePeak Caching – and probably (as usually happens) show a live demo of both technologies to get a better grip of the content.
Should be interesting…
You can register the webinar here.
Reference: Pinal Dave (https://blog.sqlauthority.com)
