Artemakis is a long-standing SQL Server MVP, Senior SQL Server Architect and Software Developer. He has over 10 years’ experience in the IT industry in various roles as a consultant, software developer and database administrator/developer. Artemakis is the author of ‘The SQL Server and .NET Blog eBook Series’ which features three eBooks on SQL Server with the titles: ‘Administering SQL Server’, ‘Tuning SQL Server’ and ‘Developing SQL Server’. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Additionally he is the founder of the “Artemiou Data Tools” initiative that aims to provide the technical community with simple, yet useful, data tools for the Windows Operating System and especially SQL Server. The highlight of these tools is ‘In-Memory OLTP Simulator’ (https://www.inmemoltpsim.com); a tool that allows the user to easily simulate virtually any workload against the SQL Server In-Memory OLTP Engine. Follow Artemakis through his blog at http://aartemiou.blogspot.com or at http://twitter.com/artemakis
How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step-by-step guide to implementing an in-memory OLTP solution.… Read more30 September 2015
In-Memory OLTP, aka Hekaton, originally shipped with 2014, and although it certainly helped the performance of certain types of workload, it then had certain restrictions that impeded its widespread adoption.With SQL Server 2016, there is more support for In-Memory OLTP and a more seamless integration with SQL Server's Database Engine. It is time to consider whether In-Memory OLTP can help those pinch-points in your data throughput, explains Artemakis Artemiou.… Read more
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Want more? Subscribe to our fortnightly newsletter