{"id":1,"date":"2021-05-28T18:34:29","date_gmt":"2021-05-28T17:34:29","guid":{"rendered":"https:\/\/www.fulldata.nl\/blog\/?p=1"},"modified":"2021-08-31T21:03:28","modified_gmt":"2021-08-31T20:03:28","slug":"8tb","status":"publish","type":"post","link":"https:\/\/www.fulldata.nl\/blog\/8tb\/","title":{"rendered":"Loading data into Azure SQL Server @Speed"},"content":{"rendered":"\n<p>To start with some numbers:  Below an impression of the SQL Server record breaking throughput in the Microsoft Azure Cloud! <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"380\" src=\"https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/05\/20MillionRows_bulkinsert-1024x380.png\" alt=\"\" class=\"wp-image-186\" srcset=\"https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/05\/20MillionRows_bulkinsert-1024x380.png 1024w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/05\/20MillionRows_bulkinsert-300x111.png 300w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/05\/20MillionRows_bulkinsert-768x285.png 768w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/05\/20MillionRows_bulkinsert-1536x570.png 1536w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/05\/20MillionRows_bulkinsert-2048x760.png 2048w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/05\/20MillionRows_bulkinsert-1200x445.png 1200w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/05\/20MillionRows_bulkinsert-1980x734.png 1980w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Picture: Impression of the Gigabytes of data being processed while inserting 20 Million rows of data per second.<\/figcaption><\/figure>\n\n\n\n<p>The secret? The very high throughput of GByte\/sec per VM is delivered via the iSCSI interface providing a scalable data platform that supports storage capacities ranging from tens, up to hundreds of Terabytes of storage capacity with very low latency.  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"576\" src=\"https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/08\/Silk_Architecture-1-1024x576.png\" alt=\"\" class=\"wp-image-220\" srcset=\"https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/08\/Silk_Architecture-1-1024x576.png 1024w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/08\/Silk_Architecture-1-300x169.png 300w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/08\/Silk_Architecture-1-768x432.png 768w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/08\/Silk_Architecture-1-1536x864.png 1536w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/08\/Silk_Architecture-1-2048x1152.png 2048w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/08\/Silk_Architecture-1-1200x675.png 1200w, https:\/\/www.fulldata.nl\/blog\/wp-content\/uploads\/2021\/08\/Silk_Architecture-1-1980x1114.png 1980w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>The Silk scalable data platform architecture.<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>A short video with background information on the data loading record is <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"New World Record Data Loading  with SQL Server 2019 in Azure.\" width=\"750\" height=\"422\" src=\"https:\/\/www.youtube.com\/embed\/aQPjejAfUgE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><figcaption>1<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>If your data platform has also such high data processing throughput demands or if you would like to process your data faster? Please contact us for assistance at <a href=\"mailto:info@fulldata.nl\" target=\"_blank\" rel=\"noreferrer noopener\">info@fulldata.nl<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#8217;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[8,9],"acf":[],"_links":{"self":[{"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/posts\/1"}],"collection":[{"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/comments?post=1"}],"version-history":[{"count":36,"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/posts\/1\/revisions"}],"predecessor-version":[{"id":306,"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/posts\/1\/revisions\/306"}],"wp:attachment":[{"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/media?parent=1"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/categories?post=1"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fulldata.nl\/blog\/wp-json\/wp\/v2\/tags?post=1"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}