All About Data Retention: Tactics for optimizing computing resources

Data Engineers in Toronto April 2026 Semimonthly Meeting

Topic: All About Data Retention: Tactics for optimizing computing resources

Abstract:
How long should data be kept for? How should it be handled as it moves from actively used hot data to seldom used cool data? What tactics can be used to optimize computing resources when handling data of different types, from different systems, and of different ages.

Retention is a seldom-discussed topic, but one that can be used to reduce cloud hosting bills, improve performance, improve predictability, and ensure that an application remains in compliance with legal and contractual obligations,

This session dives into data retention from all angles and provides a wide variety of tactics for creating retention policies and implementing technical solutions.

Speaker: Edward Pollack, Data Architect & Microsoft Data Platform MVP

Speaker Profile:
Ed Pollack is a Microsoft Data Platform MVP with a passion for learning how Data Platforms work and sharing that knowledge with the community. His experiences in data architecture, database design, performance optimization, and data security are motivation for public speaking, writing, coding, and other community activities.

Ed has spoken at SQL Saturday events, SQL Bits, PASS Summit, EightKB, and many other regional and international events. Ed is the organizer of the Capital Area SQL Server Group and SQL Saturday Albany, as well as a co-organizer of SQL Saturday New York City, and Future Data Driven. He has published a number of books, including "Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server", "Expert Performance Indexing in Azure SQL and SQL Server 2022", and "Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads". Ed is also an active contributor of content to SimpleTalk.

In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.

The meeting is over Microsoft Teams, and the joining link is https://teams.microsoft.com/l/meetup-join/19%3ameeting_NzZkYWIyOTAtODk1MC00MjVmLWJlNjUtNTRiODZmODA2Zjdh%40thread.v2/0?context=%7b%22Tid%22%3a%22bd9727e8-f539-4c76-983c-6c30130c0bee%22%2c%22Oid%22%3a%229e8d5a64-e773-4ca2-90f6-9a266129171e%22%7d

See you at the meeting!