Build fast, scalable data system on Azure SQL Database Hyperscale | Clearent

<p>How to build a fast, scalable data system on Azure SQL Database Hyperscale. Hyperscale’s flexible architecture scales with the pace of your business to process large amounts of data with a small amount of compute in just minutes, and allows you to back up data almost instantaneously.</p> <p>Zach Fransen, VP of data and AI at Xplor, joins Jeremy Chapman to share how credit card processing firm, Clearent by Xplor, built a fast, scalable merchant transaction reporting system on Azure SQL Database Hyperscale. Take a deep dive on their Hyperscale implementation, from their approach with micro-batching to continuously bring in billions of rows of transactional data, from their on-premises payment fulfillment system at scale, as well as their optimizations for near real-time query performance using clustered column store indexing for data aggregation.</p> <p>► QUICK LINKS:</p> <p>00:00 - Introduction</p> <p>00:35 - Intro to Clearent</p> <p>01:33 - Starting point and challenges</p> <p>03:12 - Clearant’s shift to Hyperscale</p> <p>04:53 - Near real-time reporting/micro-batching</p> <p>06:25 - See it in action</p> <p>08:28 - Processing large amounts of data</p> <p>09:42 - Named replicas</p> <p>10:34 - Query speed ups - clustered column store indexing</p> <p>11:45 - What’s next for Clearent by Xplor?</p> <p>12:26 - Wrap up</p> <p>► Link References:</p> <p>Learn more about Clearent by Xplor and what they're doing with Hyperscale at <a href= "https://aka.ms/ClearentMechanics">https://aka.ms/ClearentMechanics</a></p> <p>For more guidance on implementing Azure SQL Database Hyperscale, check out <a href= "https://aka.ms/MechanicsHyperscale">https://aka.ms/MechanicsHyperscale</a></p> <p>► Unfamiliar with Microsoft Mechanics? We are Microsoft’s official video series for IT. You can watch and share valuable content and demos of current and upcoming tech from the people who build it at #Microsoft.</p> <p>Subscribe to our YouTube: <a href= "https://www.youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1"> https://www.youtube