The PASS Application Development VG serves as a hub of free training and information for application developers working with the Microsoft Data Platform, sharing knowledge and techniques, helping fellow community members avoid trials and tribulations.

News and Updates

Please contact us at appdev@pass.org or via Twitter (@PASSAppDev)  to find out more! 

Missed a webinar you're interested into? Just looking for past recordings? Go to our YouTube Channel and get them: from 2017 and later all webinars for which we have the authorization from the speaker, will also be posted there.

Historical CRUD and Application Business Events

Wed, Nov 08 2017 19:00 UTC

RSVP: None

Historical CRUD and Application Business Events

Every time you update or delete a record in classic relational database you lose information. In particular, you lose the state of the entities which was current until you changed it. For many years this automatic loss of information didn’t represent a problem for companies. But now, in the days of big data and business intelligence, any data you lose is potentially money you lose. Until the release of SQL Server 2016, for updating the state of a system you had two options: lose old data or shift to another persistence paradigm like Event Sourcing. SQL Server 2016 provides an intriguing middle ground as it introduces concepts like temporal tables and native JSON serialization and indexing that combined with existing columnar indexing make it suitable to be the storage of choice even for event-driven systems. However, the real question is do you need plain CRUD or domain-specific CRUD? If it’s the latter, you need to move towards Event Sourcing.


Dino Esposito

A long-time trainer and consultant, Dino is the author of many popular books for Microsoft Press for .NET developers.including “Architecting Mobile Solutions for the Enterprise“ and “Programming ASP.NET MVC” both for Microsoft Press. CTO of Crionet, a firm specializing in Web-based and mobile solutions for sport events across Europe (http://www.crionet.com), at the moment Dino is also technical evangelist for JetBrains, where he focuses on Android and Kotlin development, and member of the team that manages WURFL—the database of mobile devices used by organizations such as Google and Facebook. Follow Dino through his blog at http://software2cents.wordpress.com or at http://twitter.com/despos. Check out Dino’s latest book “Microsoft .NET: Architecting Applications for the Enterprise”.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids