{"id":6425,"date":"2015-08-20T08:08:14","date_gmt":"2015-08-20T08:08:14","guid":{"rendered":"http:\/\/www.esds.co.in\/blog\/?p=6425"},"modified":"2018-05-22T07:40:28","modified_gmt":"2018-05-22T07:40:28","slug":"microsoft-sql-server-2016","status":"publish","type":"post","link":"https:\/\/www.esds.co.in\/blog\/microsoft-sql-server-2016\/","title":{"rendered":"Microsoft SQL Server 2016: an expandable database on the Cloud"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6426 aligncenter\" src=\"https:\/\/www.esds.co.in\/blog\/wp-content\/uploads\/2015\/08\/463581-windows-server-2003-migration-plan-first-steps.jpg\" alt=\"463581-windows-server-2003-migration-plan-first-steps\" width=\"740\" height=\"417\" srcset=\"https:\/\/www.esds.co.in\/blog\/wp-content\/uploads\/2015\/08\/463581-windows-server-2003-migration-plan-first-steps.jpg 740w, https:\/\/www.esds.co.in\/blog\/wp-content\/uploads\/2015\/08\/463581-windows-server-2003-migration-plan-first-steps-300x169.jpg 300w, https:\/\/www.esds.co.in\/blog\/wp-content\/uploads\/2015\/08\/463581-windows-server-2003-migration-plan-first-steps-660x372.jpg 660w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.esds.co.in\/blog\/microsoft-sql-server-2016\/#Microsoft_SQL_Server_2016\" >Microsoft SQL Server 2016<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.esds.co.in\/blog\/microsoft-sql-server-2016\/#Summary\" >Summary:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.esds.co.in\/blog\/microsoft-sql-server-2016\/#Presentation\" >Presentation:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.esds.co.in\/blog\/microsoft-sql-server-2016\/#Encrypted_queries_in_encrypted_databases\" >Encrypted queries in encrypted databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.esds.co.in\/blog\/microsoft-sql-server-2016\/#Deport_the_cold_data_in_the_Cloud\" >Deport the cold data in the Cloud<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Microsoft_SQL_Server_2016\"><\/span>Microsoft SQL Server 2016<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">The new version of Microsoft\u2019s database, SQL Server 2016 arrived with functions for the Cloud, full encryption for databases.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Presentation\"><\/span>Presentation:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">The new version of Microsoft\u2019s database, SQL Server 2016 is now available in its public version. The database has over the years become a key product in Microsoft\u2019s strategy. And this is the product that has most contributed to the growth of Microsoft in the past three years. According to Microsoft, SQL Server\u2019s turnover is more than $6 billion.<\/p>\n<p style=\"text-align: justify;\">Microsoft\u2019s investment in this product focuses on three priorities: strengthening the functions to support critical applications, providing key capabilities in hand of the given operating and exploiting the growth of the potential volumes that is offered in the <a href=\"https:\/\/www.esds.co.in\/enlight-cloud-hosting\"><strong>Cloud<\/strong><\/a>. The main new features of SQL Server 2016 illustrate the priority to these three areas of development.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Encrypted_queries_in_encrypted_databases\"><\/span>Encrypted queries in encrypted databases<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Thus always encrypted, technology developed by Microsoft Research, allows generalizing encryption and performing operations on encrypted data. The key is stored in applications, which minimizes the changes to be made to existing applications, says Microsoft in a blog post. To the cloud version, it offers a feature called Transparent Query Encryption, which encrypts requests when the work of the day on databases is done and you leave the company and query of a database itself performs the encryption.<\/p>\n<p style=\"text-align: justify;\">A safety feature, according to Microsoft deploys sensitive data, which is accessible at one time or another to a system administrator or database administrator. This reduces the attack surface as the limited number of people will have access to the database.<\/p>\n<p style=\"text-align: justify;\">As for analytic functions, Microsoft integrated the R programming language, popular among statisticians and POLYBASE, a tool that allows for the junction between the SQL Hadoop world and the rest of the world. Most importantly, Microsoft insists reconciliation of its In-Memory technology OLTP (transactional) and warehouse management index in columns and memory (analytical). If this integration fits well in line with previous versions (including version 2014), it opens the way to real-time analytics applications in SQL Server 2016, in particular by eliminating the ETL process. The approach is reminiscent of SAP Hana, which by placing all data in memory allows you to merge transactional and analytical applications (Read more: <strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/www.esds.co.in\/blog\/5-main-questions-asked-by-the-market-about-sap-s4-hana\/\" target=\"_blank\" rel=\"noopener\">5 Main Questions Asked by the Market about SAP S\/4 Hana<\/a><\/span>)<\/strong>. But SAP\u2019s approach is all or nothing. Within SQL server, it is sufficient to place 2 or 3 most solicited tables in memory. This clears 90% of earnings would have brought a total transfer in memory for a moderate investment in infrastructure.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Deport_the_cold_data_in_the_Cloud\"><\/span>Deport the cold data in the Cloud<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">But ultimately the greatest originality of this version of SQL server 2016 is to be sought in the exploitation of Cloud capabilities. The Stretch Database function allows the use of Cloud with uphill load capabilities to extend a database on the Cloud (the cons). E.g. hosting a cold data which is least called by the applications. One way to enjoy a very low cost of cloud environment and at the same time unloads the internal infrastructure from little use of daily data. A change of rules economically; especially since the implementation of this option takes place without application change, promises Microsoft. The SQL query that distributes on server on-premises remains in tables and rest deports on Cloud. At this stage the single market and bear Stretch Table Query with Transparent Encryption.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The new version of Microsoft\u2019s database, SQL Server 2016 arrived with functions for the Cloud, full encryption for databases.<\/p>\n","protected":false},"author":24,"featured_media":6426,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[15],"tags":[1355],"class_list":["post-6425","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-computing","tag-microsoft-sql-server-2016"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/posts\/6425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/comments?post=6425"}],"version-history":[{"count":6,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/posts\/6425\/revisions"}],"predecessor-version":[{"id":9038,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/posts\/6425\/revisions\/9038"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/media\/6426"}],"wp:attachment":[{"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/media?parent=6425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/categories?post=6425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/tags?post=6425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}