{"id":4192,"date":"2020-09-22T15:07:33","date_gmt":"2020-09-22T15:07:33","guid":{"rendered":"https:\/\/iatechcenter.com\/?p=4192"},"modified":"2020-09-22T15:07:33","modified_gmt":"2020-09-22T15:07:33","slug":"financial-tech-company-gains-sql-server-performance-and-scalability-on-linux","status":"publish","type":"post","link":"https:\/\/iatechcenter.com\/?p=4192","title":{"rendered":"Financial tech company gains SQL Server performance and scalability on Linux"},"content":{"rendered":"<p><!-- VIDEO --><br \/>\n    The dv01 financial reporting and analytics platform offers institutional investors transparency and insight into consumer lending markets. Based initially on PostgreSQL and Redshift data warehouse, the dv01 applications began to run slower as complexity increased. After exploring multiple solutions, dv01 eventually moved to Microsoft SQL Server 2016 running on Azure Virtual Machines. This move provided the scalability it needed to handle rapid growth, reduce query response time from 30 seconds to 1-2 seconds, and cut management time by 90 percent.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As many startups grow, they encounter scaling challenges and latency. For dv01, a financial reporting and analytics company, Microsoft SQL Server provided the solution. Watch this video to learn how @MicrosoftAzure enabled faster response times and cut #dv01&#8217;s management time by 90%.<\/p>\n","protected":false},"author":1,"featured_media":4191,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_mo_disable_npp":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-4192","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","blog-post","animate"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Financial tech company gains SQL Server performance and scalability on Linux &#8211; Interactive America, Inc.<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Financial tech company gains SQL Server performance and scalability on Linux &#8211; Interactive America, Inc.\" \/>\n<meta property=\"og:description\" content=\"As many startups grow, they encounter scaling challenges and latency. For dv01, a financial reporting and analytics company, Microsoft SQL Server provided the solution. Watch this video to learn how @MicrosoftAzure enabled faster response times and cut #dv01&#039;s management time by 90%.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/iatechcenter.com\/?p=4192\" \/>\n<meta property=\"og:site_name\" content=\"Interactive America, Inc.\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/iainc.org\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-22T15:07:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/iatechcenter.com\/wp-content\/uploads\/2020\/09\/smb-c1-w8-video-thumb-png2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"gkarlwalker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"gkarlwalker\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192\"},\"author\":{\"name\":\"gkarlwalker\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#\\\/schema\\\/person\\\/bfc7e1876c2b33592a99625530a60854\"},\"headline\":\"Financial tech company gains SQL Server performance and scalability on Linux\",\"datePublished\":\"2020-09-22T15:07:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192\"},\"wordCount\":88,\"publisher\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/iatechcenter.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/smb-c1-w8-video-thumb-png2.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192\",\"url\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192\",\"name\":\"Financial tech company gains SQL Server performance and scalability on Linux &#8211; Interactive America, Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/iatechcenter.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/smb-c1-w8-video-thumb-png2.png\",\"datePublished\":\"2020-09-22T15:07:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/iatechcenter.com\\\/?p=4192\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192#primaryimage\",\"url\":\"https:\\\/\\\/iatechcenter.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/smb-c1-w8-video-thumb-png2.png\",\"contentUrl\":\"https:\\\/\\\/iatechcenter.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/smb-c1-w8-video-thumb-png2.png\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/?p=4192#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/iatechcenter.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financial tech company gains SQL Server performance and scalability on Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#website\",\"url\":\"https:\\\/\\\/iatechcenter.com\\\/\",\"name\":\"Interactive America, Inc.\",\"description\":\"Powered by United States Veterans\",\"publisher\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/iatechcenter.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#organization\",\"name\":\"Interactive America, Inc.\",\"url\":\"https:\\\/\\\/iatechcenter.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/iatechcenter.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/2iainc.png\",\"contentUrl\":\"https:\\\/\\\/iatechcenter.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/2iainc.png\",\"width\":92,\"height\":85,\"caption\":\"Interactive America, Inc.\"},\"image\":{\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/iainc.org\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/iatechcenter.com\\\/#\\\/schema\\\/person\\\/bfc7e1876c2b33592a99625530a60854\",\"name\":\"gkarlwalker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/670912c1d599a0ff2ef887eaf634ade626d169604fdf07472c617f3d3c0d6fa3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/670912c1d599a0ff2ef887eaf634ade626d169604fdf07472c617f3d3c0d6fa3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/670912c1d599a0ff2ef887eaf634ade626d169604fdf07472c617f3d3c0d6fa3?s=96&d=mm&r=g\",\"caption\":\"gkarlwalker\"},\"sameAs\":[\"https:\\\/\\\/iatechcenter.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Financial tech company gains SQL Server performance and scalability on Linux &#8211; Interactive America, Inc.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Financial tech company gains SQL Server performance and scalability on Linux &#8211; Interactive America, Inc.","og_description":"As many startups grow, they encounter scaling challenges and latency. For dv01, a financial reporting and analytics company, Microsoft SQL Server provided the solution. Watch this video to learn how @MicrosoftAzure enabled faster response times and cut #dv01's management time by 90%.","og_url":"https:\/\/iatechcenter.com\/?p=4192","og_site_name":"Interactive America, Inc.","article_publisher":"https:\/\/www.facebook.com\/iainc.org\/","article_published_time":"2020-09-22T15:07:33+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/iatechcenter.com\/wp-content\/uploads\/2020\/09\/smb-c1-w8-video-thumb-png2.png","type":"image\/png"}],"author":"gkarlwalker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"gkarlwalker"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/iatechcenter.com\/?p=4192#article","isPartOf":{"@id":"https:\/\/iatechcenter.com\/?p=4192"},"author":{"name":"gkarlwalker","@id":"https:\/\/iatechcenter.com\/#\/schema\/person\/bfc7e1876c2b33592a99625530a60854"},"headline":"Financial tech company gains SQL Server performance and scalability on Linux","datePublished":"2020-09-22T15:07:33+00:00","mainEntityOfPage":{"@id":"https:\/\/iatechcenter.com\/?p=4192"},"wordCount":88,"publisher":{"@id":"https:\/\/iatechcenter.com\/#organization"},"image":{"@id":"https:\/\/iatechcenter.com\/?p=4192#primaryimage"},"thumbnailUrl":"https:\/\/iatechcenter.com\/wp-content\/uploads\/2020\/09\/smb-c1-w8-video-thumb-png2.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/iatechcenter.com\/?p=4192","url":"https:\/\/iatechcenter.com\/?p=4192","name":"Financial tech company gains SQL Server performance and scalability on Linux &#8211; Interactive America, Inc.","isPartOf":{"@id":"https:\/\/iatechcenter.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/iatechcenter.com\/?p=4192#primaryimage"},"image":{"@id":"https:\/\/iatechcenter.com\/?p=4192#primaryimage"},"thumbnailUrl":"https:\/\/iatechcenter.com\/wp-content\/uploads\/2020\/09\/smb-c1-w8-video-thumb-png2.png","datePublished":"2020-09-22T15:07:33+00:00","breadcrumb":{"@id":"https:\/\/iatechcenter.com\/?p=4192#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/iatechcenter.com\/?p=4192"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/iatechcenter.com\/?p=4192#primaryimage","url":"https:\/\/iatechcenter.com\/wp-content\/uploads\/2020\/09\/smb-c1-w8-video-thumb-png2.png","contentUrl":"https:\/\/iatechcenter.com\/wp-content\/uploads\/2020\/09\/smb-c1-w8-video-thumb-png2.png","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/iatechcenter.com\/?p=4192#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/iatechcenter.com\/"},{"@type":"ListItem","position":2,"name":"Financial tech company gains SQL Server performance and scalability on Linux"}]},{"@type":"WebSite","@id":"https:\/\/iatechcenter.com\/#website","url":"https:\/\/iatechcenter.com\/","name":"Interactive America, Inc.","description":"Powered by United States Veterans","publisher":{"@id":"https:\/\/iatechcenter.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/iatechcenter.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/iatechcenter.com\/#organization","name":"Interactive America, Inc.","url":"https:\/\/iatechcenter.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/iatechcenter.com\/#\/schema\/logo\/image\/","url":"https:\/\/iatechcenter.com\/wp-content\/uploads\/2020\/04\/2iainc.png","contentUrl":"https:\/\/iatechcenter.com\/wp-content\/uploads\/2020\/04\/2iainc.png","width":92,"height":85,"caption":"Interactive America, Inc."},"image":{"@id":"https:\/\/iatechcenter.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/iainc.org\/"]},{"@type":"Person","@id":"https:\/\/iatechcenter.com\/#\/schema\/person\/bfc7e1876c2b33592a99625530a60854","name":"gkarlwalker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/670912c1d599a0ff2ef887eaf634ade626d169604fdf07472c617f3d3c0d6fa3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/670912c1d599a0ff2ef887eaf634ade626d169604fdf07472c617f3d3c0d6fa3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/670912c1d599a0ff2ef887eaf634ade626d169604fdf07472c617f3d3c0d6fa3?s=96&d=mm&r=g","caption":"gkarlwalker"},"sameAs":["https:\/\/iatechcenter.com"]}]}},"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/iatechcenter.com\/index.php?rest_route=\/wp\/v2\/posts\/4192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iatechcenter.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iatechcenter.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iatechcenter.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iatechcenter.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4192"}],"version-history":[{"count":1,"href":"https:\/\/iatechcenter.com\/index.php?rest_route=\/wp\/v2\/posts\/4192\/revisions"}],"predecessor-version":[{"id":4193,"href":"https:\/\/iatechcenter.com\/index.php?rest_route=\/wp\/v2\/posts\/4192\/revisions\/4193"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iatechcenter.com\/index.php?rest_route=\/wp\/v2\/media\/4191"}],"wp:attachment":[{"href":"https:\/\/iatechcenter.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iatechcenter.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iatechcenter.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}