{"id":15116,"date":"2016-11-17T11:35:52","date_gmt":"2016-11-17T11:35:52","guid":{"rendered":"http:\/\/www.biphoo.com\/bipnews\/?p=15116"},"modified":"2016-11-17T11:38:42","modified_gmt":"2016-11-17T11:38:42","slug":"microsoft-sql-server-linux-real-deal","status":"publish","type":"post","link":"https:\/\/www.biphoo.com\/bipnews\/technology\/microsoft-sql-server-linux-real-deal.html","title":{"rendered":"Microsoft: SQL Server for Linux is the real deal"},"content":{"rendered":"<h2 style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">Microsoft: SQL Server for Linux is the real deal<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">Those who wondered what it would be like to run Microsoft SQL Server on Linux now have an answer. Microsoft has released the first public preview of the long-promised product.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">Microsoft also wants to make clear this isn\u2019t a \u201cSQL Server Lite\u201d for those satisfied with a reduced feature set. Microsoft has a four-point plan to make this happen.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">[ The InfoWorld review: SQL Server 2016 boosts speed, analytics. | Cut to the key news in technology trends and IT breakthroughs with the InfoWorld Daily newsletter, our summary of the top tech happenings. ]<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">First is through broad support for all major enterprise-grade Linux editions: Red Hat Enterprise Linux, Ubuntu Linux, and soon Suse Linux Enterprise Server. \u201cSupport\u201d means behaving like other Linux applications on the distributions, not requiring a Microsoft-only methodology for installing or running the app. An introductory video depicts SQL Server installed on RHEL through the system\u2019s yum package manager, and a white paper describes launching SQL Server\u2019s services via systemd.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">Second, Microsoft promises the full set of SQL Server 2016\u2019s features for Linux users\u2014not only support for the T-SQL command set, but high-end items like in-memory OLTP, always-on encryption, and row-level security. It will be a first-class citizen on Linux, as SQL Server has been on Windows itself. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">Third is Linux support for the tooling around SQL Server\u2014not SQL Server Management Studio alone, but also the Migration Assistant for relocating workloads to Linux systems and the sqlps PowerShell module. This last item is in line with a possibility introduced when PowerShell was initially open-sourced: Once ported to Linux, it would become part of the support structure for other big-name Microsoft applications as they, too, showed up on the OS. That\u2019s now happening.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">By bringing SQL Server to Linux, Microsoft can compete more directly with Oracle, which has long provided its product on Linux. Oracle may be blunting the effects of the strategy by shifting customers toward a cloud-based service model, but any gains are likely to be hard-won.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">The other, immediate benefit is to provide Microsoft customers with more places to run SQL Server. Enterprises have historically run mixes of Linux and Windows systems, and SQL Server on Linux will let them shave the costs of running some infrastructure. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">Most of all, Microsoft is striving to prove a Microsoft shop can lose little, and preferably nothing, by making a switch\u2014and a new shop eyeing SQL Server has fewer reasons to opt for a competing database that\u2019s Linux-first. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 8pt;\">Source:http:\/\/www.infoworld.com\/article\/3142360\/sql\/microsoft-sql-server-for-linux-is-the-real-deal.html<\/span><\/p>\n<div class=\"fb-background-color\">\n\t\t\t  <div \n\t\t\t  \tclass = \"fb-comments\" \n\t\t\t  \tdata-href = \"https:\/\/www.biphoo.com\/bipnews\/technology\/microsoft-sql-server-linux-real-deal.html\"\n\t\t\t  \tdata-numposts = \"10\"\n\t\t\t  \tdata-lazy = \"true\"\n\t\t\t\tdata-colorscheme = \"light\"\n\t\t\t\tdata-order-by = \"social\"\n\t\t\t\tdata-mobile=true>\n\t\t\t  <\/div><\/div>\n\t\t  <style>\n\t\t    .fb-background-color {\n\t\t\t\tbackground: #ffffff !important;\n\t\t\t}\n\t\t\t.fb_iframe_widget_fluid_desktop iframe {\n\t\t\t    width: 630px !important;\n\t\t\t}\n\t\t  <\/style>\n\t\t  ","protected":false},"excerpt":{"rendered":"<p>Microsoft: SQL Server for Linux is the real deal Those who wondered what it would be like to run Microsoft SQL Server on Linux now have an answer. Microsoft has released the first public preview of the long-promised product. Microsoft also wants to make clear this isn\u2019t a \u201cSQL Server [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":15117,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[9311,9310,9314,9312,9315,9309,9313],"class_list":["post-15116","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-announcing-sql-server-on-linux","tag-latest-techonolgy-news","tag-microsoft-brings-sql-server-to-linux","tag-microsoft-is-bringing-sql-server-to-linux","tag-microsoft-sql-server-is-coming-to-linux","tag-microsoft-sql-server-for-linux-is-the-real-deal","tag-sql-server-for-linux"],"_links":{"self":[{"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/posts\/15116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/comments?post=15116"}],"version-history":[{"count":0,"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/posts\/15116\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/media\/15117"}],"wp:attachment":[{"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/media?parent=15116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/categories?post=15116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biphoo.com\/bipnews\/wp-json\/wp\/v2\/tags?post=15116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}