{"id":4963,"date":"2016-11-21T16:46:19","date_gmt":"2016-11-21T16:46:19","guid":{"rendered":"http:\/\/www.onomi.co.uk\/?p=4963"},"modified":"2018-08-21T11:07:10","modified_gmt":"2018-08-21T10:07:10","slug":"sql-server-linux","status":"publish","type":"post","link":"http:\/\/content.n4stack.io\/2016\/11\/21\/sql-server-linux\/","title":{"rendered":"A first look at Microsoft SQL Server on Linux"},"content":{"rendered":"

[et_pb_section bb_built=”1″ admin_label=”section” transparent_background=”off” allow_player_pause=”off” inner_shadow=”off” parallax=”off” parallax_method=”on” padding_mobile=”off” make_fullwidth=”off” use_custom_width=”off” width_unit=”off” custom_width_px=”1080px” custom_width_percent=”80%” make_equal=”off” use_custom_gutter=”off” fullwidth=”off” specialty=”off” disabled=”off” custom_padding_tablet=”50px|0|50px|0″ custom_padding_last_edited=”on|desktop” prev_background_color=”#000000″ next_background_color=”#000000″][et_pb_row admin_label=”row” make_fullwidth=”off” use_custom_width=”off” width_unit=”off” custom_width_px=”1080px” custom_width_percent=”80%” use_custom_gutter=”off” gutter_width=”3″ padding_mobile=”off” allow_player_pause=”off” parallax=”off” parallax_method=”on” make_equal=”off” column_padding_mobile=”on” parallax_1=”off” parallax_method_1=”on” parallax_2=”off” parallax_method_2=”on” parallax_3=”off” parallax_method_3=”on” parallax_4=”off” parallax_method_4=”on” disabled=”off” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text use_border_color=”off” disabled=”off” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.8″]<\/p>\n

SQL Server on Linux – Getting started and a few interesting observations.<\/h1>\n

Regardless of whether you view this as a major step forwards or backwards, the future release of SQL Server on Linux is highly anticipated. Personally, I couldn’t wait to have a first look so as soon as the preview was released last week, I thought I’d have a peek at this initial offering.<\/p>\n

The installation of SQL Server on Linux could not be easier, really. The instructions provided by Microsoft https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-setup-ubuntu<\/a><\/span>\u00a0for installing on Ubuntu 16.04 worked seamlessly and I managed to get an instance running within a couple of minutes.<\/p>\n

There is minimal configuration required on setup, as you can see from the screen shot below:
\n\"SQL<\/p>\n

I was then able to connect to the database via SSMS, upon which I found some interesting points:<\/p>\n

1) Looking at the SQL Server version number (14.0.1.246) makes me think that this might be coming in the next major release, historically major releases have caused the first value to increase i.e. SQL Server 2014 (12.x), 2016 (13.x) etc.. therefore we may have to wait a while for it to go GA.<\/p>\n

\"SQL<\/p>\n

2) The default file location of your data\/log files is \\var\\opt\\mssql\\data, which is displayed in SSMS with C: prepended.
\n\"SQL<\/p>\n

3) Compatibility level list is blank at the moment, \u00a0I presume the plan is to provide\u00a0backward compatibility for older database releases.<\/p>\n

\"SQL<\/p>\n

4) Trace flags enabled by default. This is the one that probably made me twitch a bit more, this seems like a big list of trace flags enabled on installation.<\/p>\n

\"SQL<\/p>\n

The preview comes with a number of key features not supported on Linux as mentioned here https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-release-notes<\/a><\/span>. Furthermore, there are rumours that the first release would probably have these features missing.<\/p>\n

We constantly innovate and like to be cutting-edge when it comes to database management. However, this, on first impression, seems to provoke more questions than answers. So don’t get too excited, just yet… watch this space!<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

SQL Server on Linux – Getting started and a few interesting observations. Regardless of whether you view this as a major step forwards or backwards, the future release of SQL Server on Linux is highly anticipated. Personally, I couldn’t wait to have a first look so as soon as the preview was released last week, […]<\/p>\n","protected":false},"author":1,"featured_media":4964,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":""},"categories":[484,344],"tags":[354,315,355],"yst_prominent_words":[1966,159,1911,1968,1964,1961,1965,1963,1967,1970,1850,409,1959,570,175,1958,1969,1930,1962,1960],"_links":{"self":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/4963"}],"collection":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/comments?post=4963"}],"version-history":[{"count":2,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/4963\/revisions"}],"predecessor-version":[{"id":52846,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/4963\/revisions\/52846"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/media\/4964"}],"wp:attachment":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/media?parent=4963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/categories?post=4963"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/tags?post=4963"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/yst_prominent_words?post=4963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}