December SQL Server / PowerBI User Group meeting

This is a past event

19 people went

Location image of event venue


Free pizza and drinks at 5:30, session starts at 6.

Caching Data in SQL Server Memory Optimized Tables

In this session, we’ll follow the journey the development team at Payworks took while implementing a caching system for their web application. We’ll start from why we needed to implement caching, briefly cover our initial Redis-backed implementation and it’s challenges, then follow the trail of unit tests we created while to switching to Memory Optimized tables in SQL. Along the way, we’ll discover a number of issues, implement solutions to overcome them, and compare the performance of our new system with the Redis-backed implementation.

Dale Brajczuk is a Technical Lead, Development at Payworks Inc. He has over 10 years of experience as a developer, over 5 as a DBA, and a Master of Science in Computer Science from the University of Manitoba. Dale’s technological interests include .Net Development, SQL Server, Automation, Virtualization, and Software Architecture.