{"id":5779,"date":"2020-04-28T08:55:00","date_gmt":"2020-04-28T06:55:00","guid":{"rendered":"https:\/\/whiteduck.de\/?p=5779"},"modified":"2021-09-21T16:06:47","modified_gmt":"2021-09-21T14:06:47","slug":"sql-database-edge-an-iot-game-changer","status":"publish","type":"post","link":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/","title":{"rendered":"SQL Database Edge – An IoT Game Changer"},"content":{"rendered":"

<\/div>
<\/div>
<\/div><\/div><\/div>

<\/p>\n

SQL Database Edge – An IoT Game Changer<\/p>\n

<\/h1><\/div>

<\/div><\/p>\n

I don’t remember the last time I got excited so much about a new database technology, or a new database offering to be more precise. SQL Database Edge<\/a> is the inevitable result of recent  Database and IoT developments in the Microsoft data platform. It is still in preview though.<\/p>\n

But what is SQL Database Edge? In short, it is built on the same familiar Microsoft SQL Server engine, running through a container on every ARM- and x64-based device with at least 500 MB RAM. So you can choose either Windows or Linux as the operating system, and even use Kubernetes to orchestrate your device infrastructure for better efficiency and automation.<\/p>\n\n\n

\"\"<\/figure>\n\n\n

SQL Database Edge integrates with Azure IoT Edge and can use Azure IoT Hub as an input stream.  This enables deployment at scale. For example, customers can use Azure IoT Edge to deploy the SQL Database Edge module to all of their edge devices globally at the same time, or only to a subset of those edge devices as a group based on site location or some other criteria.<\/p>\n

In addition to that, Microsoft claims  that it will eventually support an offline-only deployment model independent of Azure IoT Edge. Let’s see! You can use any tools related to Microsoft SQL Server, such as Microsoft SQL Server Management Studio (SSMS) or Microsoft Azure Data Studio, to connect to and manage your Edge database.<\/p>\n

Why is this technology important?<\/h3>\n

I have always believed that for IoT applications to enjoy widespread adoption,  powerful local storage and processing capabilities are indispensable. Just sending everything to the cloud just does not cut it. Until now, although you could locally process data, it has been pretty cumbersome and proprietary. Now, it all seems familiar and accessible to the average database developer.<\/p>\n

More Info<\/h3>\n

Check out the following video for more details:<\/p>\n

You are currently viewing a placeholder content from Default<\/strong>. To access the actual content, click the button below. Please note that doing so will share data with third-party providers.<\/p>

Unblock content<\/a> Accept required service and unblock content<\/a> <\/div> More Information<\/a> <\/div><\/div><\/p>\n

<\/p>\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

I don’t remember the last time I got excited so much about a new database technology, or a new database offering to be more precise. SQL Database Edge is the inevitable result of recent  Database and IoT developments in the Microsoft data platform. It is still in preview though. But what is SQL Database Edge? <\/p>\n

[…]<\/div>\n

<\/a><\/p>\n","protected":false},"author":4,"featured_media":5783,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_tribe_events_control_status":"","_tribe_events_control_status_canceled_reason":"","_tribe_events_control_status_postponed_reason":"","_tribe_events_control_online":"","_tribe_events_control_online_url":"","footnotes":""},"categories":[431],"tags":[108,258,263,257,255,259,264,262,175,159,261,79,119,260],"class_list":["post-5779","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-iot","tag-azure-iot","tag-azure-iot-edge","tag-azure-iot-edge-integration","tag-azure-iot-hub","tag-cloud-data-management","tag-data-management","tag-daten-management","tag-edge-database","tag-iot","tag-kubernetes","tag-microsoft-data-platform","tag-sql","tag-sql-database","tag-sql-database-edge"],"yoast_head":"\nSQL Database Edge - An IoT Game Changer - white duck<\/title>\n<meta name=\"description\" content=\"But what is SQL Database Edge? It is built on the same familiar Microsoft SQL Server engine, running through a container on every ARM- and x64-based device with at least 500 MB RAM. SQL Database Edge - An IoT Game Changer\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Database Edge - An IoT Game Changer - white duck\" \/>\n<meta property=\"og:description\" content=\"But what is SQL Database Edge? It is built on the same familiar Microsoft SQL Server engine, running through a container on every ARM- and x64-based device with at least 500 MB RAM. SQL Database Edge - An IoT Game Changer\" \/>\n<meta property=\"og:url\" content=\"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/\" \/>\n<meta property=\"og:site_name\" content=\"white duck\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/whiteduckgmbh\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-28T06:55:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-21T14:06:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/whiteduck.de\/wp-content\/uploads\/sql-db-edge-a.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1180\" \/>\n\t<meta property=\"og:image:height\" content=\"663\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dr. Ilias Michalarias\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@whiteduck_gmbh\" \/>\n<meta name=\"twitter:site\" content=\"@whiteduck_gmbh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. Ilias Michalarias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/\"},\"author\":{\"name\":\"Dr. Ilias Michalarias\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/8ab1d892787c0fa9732dc581e679963a\"},\"headline\":\"SQL Database Edge – An IoT Game Changer\",\"datePublished\":\"2020-04-28T06:55:00+00:00\",\"dateModified\":\"2021-09-21T14:06:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/\"},\"wordCount\":557,\"image\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/sql-db-edge-a.png\",\"keywords\":[\"Azure IoT\",\"Azure IoT Edge\",\"Azure IoT Edge Integration\",\"Azure IoT Hub\",\"Cloud & Data Management\",\"data management\",\"Daten Management\",\"Edge database\",\"IoT\",\"Kubernetes\",\"Microsoft data platform\",\"SQL\",\"SQL Database\",\"SQL Database Edge\"],\"articleSection\":[\"IoT\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/\",\"name\":\"SQL Database Edge - An IoT Game Changer - white duck\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/sql-db-edge-a.png\",\"datePublished\":\"2020-04-28T06:55:00+00:00\",\"dateModified\":\"2021-09-21T14:06:47+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/8ab1d892787c0fa9732dc581e679963a\"},\"description\":\"But what is SQL Database Edge? It is built on the same familiar Microsoft SQL Server engine, running through a container on every ARM- and x64-based device with at least 500 MB RAM. SQL Database Edge - An IoT Game Changer\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/#primaryimage\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/sql-db-edge-a.png\",\"contentUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/sql-db-edge-a.png\",\"width\":1180,\"height\":663,\"caption\":\"sql azure\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/sql-database-edge-an-iot-game-changer\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Database Edge – An IoT Game Changer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/\",\"name\":\"white duck\",\"description\":\"Your Partner for Microsoft Azure & AI\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/8ab1d892787c0fa9732dc581e679963a\",\"name\":\"Dr. Ilias Michalarias\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/author\\\/dr-ilias-michalarias\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Database Edge - An IoT Game Changer - white duck","description":"But what is SQL Database Edge? It is built on the same familiar Microsoft SQL Server engine, running through a container on every ARM- and x64-based device with at least 500 MB RAM. SQL Database Edge - An IoT Game Changer","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:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/","og_locale":"en_US","og_type":"article","og_title":"SQL Database Edge - An IoT Game Changer - white duck","og_description":"But what is SQL Database Edge? It is built on the same familiar Microsoft SQL Server engine, running through a container on every ARM- and x64-based device with at least 500 MB RAM. SQL Database Edge - An IoT Game Changer","og_url":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/","og_site_name":"white duck","article_publisher":"https:\/\/www.facebook.com\/whiteduckgmbh","article_published_time":"2020-04-28T06:55:00+00:00","article_modified_time":"2021-09-21T14:06:47+00:00","og_image":[{"width":1180,"height":663,"url":"https:\/\/whiteduck.de\/wp-content\/uploads\/sql-db-edge-a.png","type":"image\/png"}],"author":"Dr. Ilias Michalarias","twitter_card":"summary_large_image","twitter_creator":"@whiteduck_gmbh","twitter_site":"@whiteduck_gmbh","twitter_misc":{"Written by":"Dr. Ilias Michalarias","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/#article","isPartOf":{"@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/"},"author":{"name":"Dr. Ilias Michalarias","@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/8ab1d892787c0fa9732dc581e679963a"},"headline":"SQL Database Edge – An IoT Game Changer","datePublished":"2020-04-28T06:55:00+00:00","dateModified":"2021-09-21T14:06:47+00:00","mainEntityOfPage":{"@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/"},"wordCount":557,"image":{"@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/#primaryimage"},"thumbnailUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/sql-db-edge-a.png","keywords":["Azure IoT","Azure IoT Edge","Azure IoT Edge Integration","Azure IoT Hub","Cloud & Data Management","data management","Daten Management","Edge database","IoT","Kubernetes","Microsoft data platform","SQL","SQL Database","SQL Database Edge"],"articleSection":["IoT"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/","url":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/","name":"SQL Database Edge - An IoT Game Changer - white duck","isPartOf":{"@id":"https:\/\/whiteduck.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/#primaryimage"},"image":{"@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/#primaryimage"},"thumbnailUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/sql-db-edge-a.png","datePublished":"2020-04-28T06:55:00+00:00","dateModified":"2021-09-21T14:06:47+00:00","author":{"@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/8ab1d892787c0fa9732dc581e679963a"},"description":"But what is SQL Database Edge? It is built on the same familiar Microsoft SQL Server engine, running through a container on every ARM- and x64-based device with at least 500 MB RAM. SQL Database Edge - An IoT Game Changer","breadcrumb":{"@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/#primaryimage","url":"https:\/\/whiteduck.de\/wp-content\/uploads\/sql-db-edge-a.png","contentUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/sql-db-edge-a.png","width":1180,"height":663,"caption":"sql azure"},{"@type":"BreadcrumbList","@id":"https:\/\/whiteduck.de\/en\/sql-database-edge-an-iot-game-changer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/whiteduck.de\/en\/"},{"@type":"ListItem","position":2,"name":"SQL Database Edge – An IoT Game Changer"}]},{"@type":"WebSite","@id":"https:\/\/whiteduck.de\/en\/#website","url":"https:\/\/whiteduck.de\/en\/","name":"white duck","description":"Your Partner for Microsoft Azure & AI","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/whiteduck.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/8ab1d892787c0fa9732dc581e679963a","name":"Dr. Ilias Michalarias","url":"https:\/\/whiteduck.de\/en\/author\/dr-ilias-michalarias\/"}]}},"_links":{"self":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts\/5779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/comments?post=5779"}],"version-history":[{"count":0,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts\/5779\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/media\/5783"}],"wp:attachment":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/media?parent=5779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/categories?post=5779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/tags?post=5779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}