SQL and MongoDB - When Two Worlds Collide
Explore the convergence of SQL and NoSQL databases in this comprehensive conference talk. Gain insights into the differences between SQL and NoSQL systems before delving into scenarios where a hybrid solution leveraging both technologies proves advantageous. Learn how to access MongoDB from SQL Server, focusing on Microsoft's native integration in SQL 2019. Discover techniques for archiving data, feeding web farms, and enhancing BI reporting capabilities. Examine the intricacies of querying normalized SQL and denormalized document database structures simultaneously, addressing data consistency and performance implications. Master the art of writing to document-based systems from relational databases, equipping yourself with the knowledge to implement powerful hybrid database solutions.