Keeping Historical Data in Tables Forever - Mission (Im)possible

Discover solutions for maintaining historical data in databases with seemingly impossible requirements in this 50-minute conference talk from SQLBits. Explore a real project case that tackles challenges like storing data in the same tables indefinitely while allowing simultaneous editing and querying, all while optimizing performance. Follow the design process from inception to final solution, learning how to satisfy both client and developer needs. Gain insights into database architecture, administration, and optimization techniques applicable to Azure, SQL 2019, Azure SQL Database, and SQL 2022 environments. Speaker Margarita Naumova guides you through this developer-focused session, covering topics such as data modeling, management, and infrastructure considerations for both on-premises and cloud-based solutions.

Keeping historical data in tables forever – mission (im)possible!