{"id":8434,"date":"2017-07-29T00:00:16","date_gmt":"2017-07-29T00:00:16","guid":{"rendered":"http:\/\/craftydba.com\/?p=8434"},"modified":"2017-10-15T19:01:17","modified_gmt":"2017-10-15T19:01:17","slug":"albany-sql-saturday-622","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=8434","title":{"rendered":"Albany &#8211; SQL Saturday #622"},"content":{"rendered":"<p>Time to travel to the <a href = \"http:\/\/www.offices.net\/city-slogans.htm#A\">Cradle of the Union<\/a> to present at SQL Saturday <a href=\"http:\/\/www.sqlsaturday.com\/622\/schedule.aspx\">#622<\/a> in Albany, NY.  It will be a good time to meet old friends, make new ones and learn something new.<\/p>\n<p>I am really glad that my friend Matt decided to go on the road trip with me.  It is really boring driving 350+ miles by yourself!  <\/p>\n<p>&nbsp;<\/p>\n<p>Here are the details behind the <a href = \"http:\/\/www.sqlsaturday.com\/622\/Sessions\/Details.aspx?sid=60948\">presentation<\/a> that I gave that day.<\/p>\n<p><span style=\"color: #008000\">Topic:<\/span><\/p>\n<p>Public Preview of SQL on Linux<\/p>\n<p><span style=\"color: #008000\">Abstract:<\/span><\/p>\n<p>There was a lot of excitement at the Connect() developer conference in November 2016.  Two major announcements were made at the conference.<\/p>\n<p>First, visual studio code now runs on Windows, Linux and Mac.  Second, SQL Server v.Next is coming to Linux.  This means a developer can<\/p>\n<p>develop code against SQL Server in a Window less environment.  If you are really passionate about Linux, join the hundreds downloading and testing this preview release.<\/p>\n<p><span style=\"color: #008000\">Coverage:<\/span><\/p>\n<p>1 &#8211; Core code deployed for multiple environments.<\/p>\n<p>2 &#8211; Installs on Red Hat and Ubuntu flavors of linux. <\/p>\n<p>3 &#8211; Generate ssh key.<\/p>\n<p>4 &#8211; Deploy standard Red Hat image.<\/p>\n<p>5 &#8211; Install core engine and tools on linux.<\/p>\n<p>6 &#8211; Connect to engine via sqlcmd.<\/p>\n<p>7 &#8211; Open firewall for external access.<\/p>\n<p>8 &#8211; Create database on Linux via SSMS in windows.<\/p>\n<p>9 &#8211; Load data into table via bcp.<\/p>\n<p>10 &#8211; Supports docker (container) images.<\/p>\n<p>11 &#8211; Current limitations.<\/p>\n<p>12 &#8211; Future road map.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2017\/10\/presentation-sql4linux-public-preview.zip\">Presentation Bundle<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Time to travel to the Cradle of the Union to present at SQL Saturday #622 in Albany, NY. It will be a good time to meet old friends, make new ones and learn something new. I am really glad that my friend Matt decided to go on the road trip with me. It is really boring driving 350+ miles by yourself! &nbsp; Here are the details behind the presentation that I gave that day. Topic: Public Preview of SQL on Linux Abstract: There was a lot of excitement at the&hellip;<\/p>\n","protected":false},"author":1,"featured_media":8359,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1109],"class_list":["post-8434","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-john-f-miner-iii--pass--presentation--albany--new-york--sql-saturday--linux--public-preview"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8434"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8434\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/8359"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}