{"id":20114,"date":"2025-09-04T09:05:00","date_gmt":"2025-09-04T16:05:00","guid":{"rendered":"https:\/\/www.microsoft.com\/insidetrack\/blog\/?p=20114"},"modified":"2025-09-03T16:15:14","modified_gmt":"2025-09-03T23:15:14","slug":"how-our-team-chose-between-dataverse-and-sql-server","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/","title":{"rendered":"How our team chose between Dataverse and SQL Server"},"content":{"rendered":"\n<aside class=\"wp-block-group aside-for-guide has-global-padding is-content-justification-right is-layout-constrained wp-container-core-group-is-layout-20b44f8d wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<figure class=\"wp-block-image alignleft size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"190\" src=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Microsoft-Digital-stories-badge.png\" alt=\"\" class=\"wp-image-19499\" style=\"object-fit:cover;width:75px;height:75px\" srcset=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Microsoft-Digital-stories-badge.png 190w, https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Microsoft-Digital-stories-badge-150x150.png 150w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/figure>\n\n\n\n<p class=\"has-body-xl-font-size wp-block-paragraph\" style=\"margin-top:0;margin-bottom:0;padding-top:var(--wp--preset--spacing--spacing-8)\">Microsoft Digital stories<\/p>\n<\/aside>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Editor\u2019s note: This story was created with the help of artificial intelligence. To learn more about how Inside Track is using the power of generative AI to augment our human staff, see our story,&nbsp;<\/em><a href=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/reimagining-content-creation-with-our-azure-ai-powered-inside-track-story-bot\/\"><em>Reimagining content creation with our Azure AI-powered Inside Track story bot<\/em><\/a><em>.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The choices we make today regarding technology platforms shape the success or failure of critical projects in the future.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For our Employee Productivity Engineering (EPE) team within Microsoft Digital, the company\u2019s IT organization, the challenge of choosing between Microsoft Dataverse, our low-code data platform that is part of the Microsoft Power Platform, and Microsoft SQL Server, our relational database management system (RDBMS) used for storing and retrieving data as requested by other software applications, was more than a technical decision.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It was a balancing act between empowering business users, meeting operational demands, and aligning with our company\u2019s strategic vision for scalable, secure, and high-performing solutions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Faced with competing priorities, the EPE team embarked on a journey to evaluate these two powerful platforms, ultimately uncovering lessons and strategies that would guide their work and inspire our enterprise customers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Crossroads: Business needs and technical demands<\/h2>\n\n\n\n<div class=\"wp-block-group aside-for-guide has-gray-1100-background-color has-background has-global-padding is-content-justification-right is-layout-constrained wp-container-core-group-is-layout-576308da wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--spacing-20);padding-right:var(--wp--preset--spacing--spacing-20);padding-bottom:var(--wp--preset--spacing--spacing-20);padding-left:var(--wp--preset--spacing--spacing-20)\">\n<p class=\"wp-block-paragraph\"><strong>Engage with our experts!<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Customers or Microsoft account team representatives from Fortune 500 companies&nbsp;<a href=\"mailto:msitstaff@microsoft.com\">are welcome to request a virtual engagement<\/a>&nbsp;on this topic with experts from our Microsoft Digital team.<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The challenge of choosing between Dataverse and SQL Server wasn\u2019t a simple one.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u201cOur project requirements pulled us in two very different directions,\u201d says Urvi Sengar, a senior software engineer on the EPE team here in Microsoft Digital. \u201cOn one hand, we wanted the low-code, rapid development capabilities of Dataverse to empower business users. On the other hand, our backend demanded high-performance querying, advanced reporting, and seamless integration with other systems.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The team\u2019s decision wasn\u2019t purely technical, it was rooted in six key dimensions: low-code development, security, extensibility, cost, governance, and performance. These considerations reflected the immediate needs of the projects and the long-term goals of enabling innovation while adhering to the company\u2019s rigorous standards for compliance and scalability.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Mapping needs to capabilities<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To navigate the complexity of the decision, the EPE team adopted a structured approach. They mapped their requirements across the six dimensions and evaluated Dataverse and SQL Server based on their unique strengths:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><strong>Low-code development<\/strong>: Dataverse emerged as the clear winner for user-facing applications, thanks to its seamless integration with the Power Platform. Business users can use its low-code capabilities to build apps and automate workflows without relying heavily on engineering resources. The native connectors and templates further accelerate development timelines.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Security and compliance<\/strong>: While both platforms offered robust controls, Dataverse\u2019s role-based access and encryption\u2014tightly integrated with the Microsoft cloud ecosystem\u2014simplified compliance for business-centric apps. SQL Server, however, provided the granular control needed for systems handling sensitive or regulated data.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Extensibility<\/strong>: The team found that Dataverse worked best for apps staying within the Power Platform ecosystem, while SQL Server excelled in complex backend operations and external integrations.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Cost and governance<\/strong>: Dataverse\u2019s licensing model was cost-effective for smaller-scale applications but became expensive at scale. SQL Server, with its mature governance models, offered predictable costs and reduced operational overhead when integrated into existing infrastructure.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Performance and scalability<\/strong>: For data-intensive applications requiring real-time exports and complex joins, SQL Server\u2019s ability to handle large datasets and optimize queries made it the superior choice.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The team didn\u2019t rely on a single framework to evaluate the platforms\u2014they blended the power of several tools together.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u201cWe combined internal benchmarks, stakeholder interviews, and scenario-based analysis,\u201d Sengar says. \u201cThe decision wasn\u2019t binary\u2014it was contextual, tailored to the unique needs of each project.\u201d<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Context-driven choices in action<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The team\u2019s thoughtful evaluation process came to life in two key projects, each showcasing the strengths of one platform over the other.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dataverse was chosen as the data backbone for the&nbsp;Customer Validation Power App\u2014a user-facing Power App designed to validate customer data. Its low-code capabilities and seamless integration with the Power Platform means that business users can use it to validate customer data, synchronize updates, and maintain compliance with Microsoft\u2019s policies. They can also use the app to independently manage app features, which helps accelerate development cycles and reduce reliance on engineering resources.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<div class=\"wp-block-columns is-not-stacked-on-mobile is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex has-2-columns\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u201cDataverse is a game-changer for business-centric, low-code solutions, while SQL Server remains a cornerstone for high-performance, data-intensive applications.\u201d<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:150px\">\n<figure class=\"wp-block-image alignright size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"500\" src=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/Urvi-Sengar.png\" alt=\"An image of Sengar.\" class=\"wp-image-20118\" style=\"width:150px\" srcset=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/Urvi-Sengar.png 500w, https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/Urvi-Sengar-300x300.png 300w, https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/Urvi-Sengar-150x150.png 150w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/figure>\n<\/div>\n<\/div>\n<cite>Urvi Sengar, senior software engineer, Microsoft Digital<\/cite><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">In contrast,&nbsp;SQL Server&nbsp;proved indispensable for backend systems requiring high-performance querying and advanced analytics. By using SQL Server\u2019s structured data control, computed columns, and user-defined functions, the team delivered real-time analytics and secure access management for sensitive data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u201cSQL Server handled complex workloads with predictable performance, enabling us to integrate with external systems and legacy applications seamlessly,\u201d Sengar says.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It came down to having to choose between two good options.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Looking ahead: A balanced approach to innovation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The EPE team\u2019s work demonstrates the power of a contextual, thoughtful approach to technology selection. By understanding the strengths and trade-offs of both Dataverse and SQL Server, they not only delivered successful projects but also established a model for future decisions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u201cThe key takeaway for us was that the right choice depends on the specific context,\u201d Sengar says. \u201cDataverse is a game-changer for business-centric, low-code solutions, while SQL Server remains a cornerstone for high-performance, data-intensive applications.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As we continue to innovate here in Microsoft Digital and across the company, the lessons from our journey can serve as a guide for other teams navigating the complexities of platform decisions. By sharing their story, the EPE team hopes to inspire our enterprise customers to embrace a balanced approach to innovation, using the best of both worlds to achieve their goals.<\/p>\n\n\n\n<div class=\"wp-block-group has-global-padding is-content-justification-left is-layout-constrained wp-container-core-group-is-layout-c0392459 wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-container-core-group-is-layout-7db9d80f wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<figure class=\"wp-block-image alignleft size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"190\" src=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Key-takeaways-badge.png\" alt=\"\" class=\"wp-image-19493\" style=\"object-fit:cover;width:75px;height:75px\" srcset=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Key-takeaways-badge.png 190w, https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Key-takeaways-badge-150x150.png 150w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/figure>\n\n\n\n<p class=\"has-body-xl-font-size wp-block-paragraph\" style=\"margin-top:var(--wp--preset--spacing--spacing-24);margin-bottom:0;padding-top:var(--wp--preset--spacing--spacing-24)\">Key takeaways<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The EPE team\u2019s journey revealed key lessons and best practices that other IT teams can apply:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><strong>Context is everything<\/strong>: Dataverse and SQL Server serve different purposes, so your choice between the two should align with the specific needs of your application, user base, and operational goals.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Don\u2019t underestimate governance complexity<\/strong>: While Dataverse simplifies some aspects of governance, SQL Server offers granular controls that are critical for compliance-heavy systems.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Integration isn\u2019t always seamless<\/strong>: Testing real-time data flows early is essential to avoid surprises later, particularly when integrating Dataverse with external enterprise systems.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Developer readiness matters<\/strong>: A successful transition to Dataverse requires investments in training and community engagement to ensure smooth adoption.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><strong>Evaluate, align, and pilot<\/strong>: Among the best practices, Urvi highlights the importance of using a&nbsp;decision tree or framework&nbsp;to evaluate platform fit, aligning stakeholders early to surface hidden requirements, and running pilots before scaling to validate assumptions and uncover edge cases.<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-group has-global-padding is-content-justification-left is-layout-constrained wp-container-core-group-is-layout-c0392459 wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-container-core-group-is-layout-7db9d80f wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<figure class=\"wp-block-image alignleft size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"190\" src=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Try-it-out-badge.png\" alt=\"\" class=\"wp-image-19492\" style=\"object-fit:cover;width:75px;height:75px\" srcset=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Try-it-out-badge.png 190w, https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Try-it-out-badge-150x150.png 150w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/figure>\n\n\n\n<p class=\"has-body-xl-font-size wp-block-paragraph\" style=\"margin-top:var(--wp--preset--spacing--spacing-24);margin-bottom:0;padding-top:var(--wp--preset--spacing--spacing-24)\">Try it out<\/p>\n<\/div>\n\n\n\n<ul class=\"wp-block-list is-style-list-no-bullets\">\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/dataverse?OCID=InsideTrack_Product_10720\" target=\"_blank\" rel=\"noreferrer noopener\">Get started with Dataverse and sign up for a free trial of Microsoft Copilot.<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server?OCID=InsideTrack_Product_10720\" target=\"_blank\" rel=\"noreferrer noopener\">Learn more about SQL Server 2025.<\/a><\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-group has-global-padding is-content-justification-left is-layout-constrained wp-container-core-group-is-layout-c0392459 wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-container-core-group-is-layout-7db9d80f wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<figure class=\"wp-block-image alignleft size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"190\" src=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Related-links-badge.png\" alt=\"\" class=\"wp-image-19491\" style=\"object-fit:cover;width:75px;height:75px\" srcset=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Related-links-badge.png 190w, https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Related-links-badge-150x150.png 150w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/figure>\n\n\n\n<p class=\"has-body-xl-font-size wp-block-paragraph\" style=\"margin-top:var(--wp--preset--spacing--spacing-24);margin-bottom:0;padding-top:var(--wp--preset--spacing--spacing-24)\">Related links<\/p>\n<\/div>\n\n\n\n<ul style=\"margin-top:var(--wp--preset--spacing--spacing-20)\" class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/data-platform\/data-platform-intro\" target=\"_blank\" rel=\"noreferrer noopener\">Explore the Microsoft Dataverse documentation.<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\" target=\"_blank\" rel=\"noreferrer noopener\">Learn more about the Microsoft Power Platform.<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/educational-sql-resources?view=sql-server-ver17\" target=\"_blank\" rel=\"noreferrer noopener\">Explore educational SQL resources.<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/?view=sql-server-ver17\" target=\"_blank\" rel=\"noreferrer noopener\">Read more on SQL Server technical documentation.<\/a><\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-group has-global-padding is-content-justification-left is-layout-constrained wp-container-core-group-is-layout-c0392459 wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-container-core-group-is-layout-7db9d80f wp-block-group-is-layout-constrained\" style=\"padding-right:0;padding-left:0\">\n<figure class=\"wp-block-image alignleft size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"190\" src=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Wed-like-to-hear-from-you-badge.png\" alt=\"\" class=\"wp-image-19490\" style=\"object-fit:cover;width:75px;height:75px\" srcset=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Wed-like-to-hear-from-you-badge.png 190w, https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/07\/Wed-like-to-hear-from-you-badge-150x150.png 150w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/figure>\n\n\n\n<p class=\"has-body-xl-font-size wp-block-paragraph\" style=\"margin-top:var(--wp--preset--spacing--spacing-24);margin-bottom:0;padding-top:var(--wp--preset--spacing--spacing-24)\">We&#8217;d like to hear from you!<\/p>\n<\/div>\n\n\n\n<ul style=\"margin-top:var(--wp--preset--spacing--spacing-20)\" class=\"wp-block-list is-style-list-no-bullets\">\n<li class=\"wp-block-list-item\"><a href=\"mailto:msitstaff@microsoft.com\">Want more information? Email us and include a link to this story and we\u2019ll get back to you.<\/a><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Digital stories Editor\u2019s note: This story was created with the help of artificial intelligence. To learn more about how Inside Track is using the power of generative AI to augment our human staff, see our story,&nbsp;Reimagining content creation with our Azure AI-powered Inside Track story bot. The choices we make today regarding technology platforms [&hellip;]<\/p>\n","protected":false},"author":191,"featured_media":20116,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_hide_featured_on_single":false,"_show_featured_caption_on_single":true,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[850,852,423,424],"coauthors":[796],"class_list":["post-20114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-end-user-services-and-support","tag-it-and-business-operations","tag-modern-engineering","tag-power-platform","m-blog-post"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How our team chose between Dataverse and SQL Server - Inside Track Blog<\/title>\n<meta name=\"description\" content=\"Find out how we chose between Dataverse and SQL Server internally at Microsoft.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How our team chose between Dataverse and SQL Server - Inside Track Blog\" \/>\n<meta property=\"og:description\" content=\"Find out how we chose between Dataverse and SQL Server internally at Microsoft.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Inside Track Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-04T16:05:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/10720-Hero_image.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2300\" \/>\n\t<meta property=\"og:image:height\" content=\"1293\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Inside Track bot\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Inside Track bot\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/\"},\"author\":{\"name\":\"Inside Track bot\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/#\\\/schema\\\/person\\\/01cce1fe0ed8ec17bfe48ba925606425\"},\"headline\":\"How our team chose between Dataverse and SQL Server\",\"datePublished\":\"2025-09-04T16:05:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/\"},\"wordCount\":1205,\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/uploads\\\/prod\\\/2025\\\/09\\\/10720-Hero_image.jpg\",\"keywords\":[\"End user services and support\",\"IT and business operations\",\"Modern engineering\",\"Power Platform\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/\",\"name\":\"How our team chose between Dataverse and SQL Server - Inside Track Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/uploads\\\/prod\\\/2025\\\/09\\\/10720-Hero_image.jpg\",\"datePublished\":\"2025-09-04T16:05:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/#\\\/schema\\\/person\\\/01cce1fe0ed8ec17bfe48ba925606425\"},\"description\":\"Find out how we chose between Dataverse and SQL Server internally at Microsoft.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/uploads\\\/prod\\\/2025\\\/09\\\/10720-Hero_image.jpg\",\"contentUrl\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/uploads\\\/prod\\\/2025\\\/09\\\/10720-Hero_image.jpg\",\"width\":2300,\"height\":1293,\"caption\":\"Choosing between Microsoft Dataverse and Microsoft SQL Server resulted in us having to decide between two good options.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/how-our-team-chose-between-dataverse-and-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How our team chose between Dataverse and SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/\",\"name\":\"Inside Track Blog\",\"description\":\"How Microsoft does IT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/#\\\/schema\\\/person\\\/01cce1fe0ed8ec17bfe48ba925606425\",\"name\":\"Inside Track bot\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e7b8de0ba03bd98b60820639e973e40ee32fab6fed2fbbbb1e02cc705a26759a?s=96&d=mm&r=gb7d03be8f5ba8a8d95f3b8e83e8d4a91\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e7b8de0ba03bd98b60820639e973e40ee32fab6fed2fbbbb1e02cc705a26759a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e7b8de0ba03bd98b60820639e973e40ee32fab6fed2fbbbb1e02cc705a26759a?s=96&d=mm&r=g\",\"caption\":\"Inside Track bot\"},\"url\":\"https:\\\/\\\/www.microsoft.com\\\/insidetrack\\\/blog\\\/author\\\/inside-track-bot\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How our team chose between Dataverse and SQL Server - Inside Track Blog","description":"Find out how we chose between Dataverse and SQL Server internally at Microsoft.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How our team chose between Dataverse and SQL Server - Inside Track Blog","og_description":"Find out how we chose between Dataverse and SQL Server internally at Microsoft.","og_url":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/","og_site_name":"Inside Track Blog","article_published_time":"2025-09-04T16:05:00+00:00","og_image":[{"width":2300,"height":1293,"url":"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/10720-Hero_image.jpg","type":"image\/jpeg"}],"author":"Inside Track bot","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Inside Track bot","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/"},"author":{"name":"Inside Track bot","@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/#\/schema\/person\/01cce1fe0ed8ec17bfe48ba925606425"},"headline":"How our team chose between Dataverse and SQL Server","datePublished":"2025-09-04T16:05:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/"},"wordCount":1205,"image":{"@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/10720-Hero_image.jpg","keywords":["End user services and support","IT and business operations","Modern engineering","Power Platform"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/","url":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/","name":"How our team chose between Dataverse and SQL Server - Inside Track Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/10720-Hero_image.jpg","datePublished":"2025-09-04T16:05:00+00:00","author":{"@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/#\/schema\/person\/01cce1fe0ed8ec17bfe48ba925606425"},"description":"Find out how we chose between Dataverse and SQL Server internally at Microsoft.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/#primaryimage","url":"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/10720-Hero_image.jpg","contentUrl":"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/10720-Hero_image.jpg","width":2300,"height":1293,"caption":"Choosing between Microsoft Dataverse and Microsoft SQL Server resulted in us having to decide between two good options."},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/how-our-team-chose-between-dataverse-and-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/insidetrack\/blog\/"},{"@type":"ListItem","position":2,"name":"How our team chose between Dataverse and SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/#website","url":"https:\/\/www.microsoft.com\/insidetrack\/blog\/","name":"Inside Track Blog","description":"How Microsoft does IT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/insidetrack\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/insidetrack\/blog\/#\/schema\/person\/01cce1fe0ed8ec17bfe48ba925606425","name":"Inside Track bot","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e7b8de0ba03bd98b60820639e973e40ee32fab6fed2fbbbb1e02cc705a26759a?s=96&d=mm&r=gb7d03be8f5ba8a8d95f3b8e83e8d4a91","url":"https:\/\/secure.gravatar.com\/avatar\/e7b8de0ba03bd98b60820639e973e40ee32fab6fed2fbbbb1e02cc705a26759a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e7b8de0ba03bd98b60820639e973e40ee32fab6fed2fbbbb1e02cc705a26759a?s=96&d=mm&r=g","caption":"Inside Track bot"},"url":"https:\/\/www.microsoft.com\/insidetrack\/blog\/author\/inside-track-bot\/"}]}},"jetpack_featured_media_url":"https:\/\/www.microsoft.com\/insidetrack\/blog\/uploads\/prod\/2025\/09\/10720-Hero_image.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9hcZA-5eq","_links":{"self":[{"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/posts\/20114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/users\/191"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/comments?post=20114"}],"version-history":[{"count":15,"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/posts\/20114\/revisions"}],"predecessor-version":[{"id":20183,"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/posts\/20114\/revisions\/20183"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/media\/20116"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/media?parent=20114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/categories?post=20114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/tags?post=20114"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/insidetrack\/blog\/wp-json\/wp\/v2\/coauthors?post=20114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}