{"id":877,"date":"2017-11-01T08:11:40","date_gmt":"2017-11-01T15:11:40","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=877"},"modified":"2018-12-14T09:05:53","modified_gmt":"2018-12-14T17:05:53","slug":"pass-summit-2017-day-1","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/","title":{"rendered":"PASS Summit 2017: Day 1"},"content":{"rendered":"<p>Hey friends!\u00a0 After a one-year hiatus I am BACK at the PASS Summit and ready to blog the day 1 keynote \ud83d\ude42\u00a0 I will update this post throughout the morning so refresh every so often to see the changes.\u00a0 You can also follow along on Twitter &#8211; check out the #PASSsummit hashtag.<\/p>\n<p>Reminder: My session is today at 1:30 in 6B, <a href=\"http:\/\/www.pass.org\/summit\/2017\/Sessions\/Details.aspx?sid=68987\">Query Store and Automatic Tuning in SQL Server<\/a>, I hope to see you there!<\/p>\n<p>Today&#8217;s <a href=\"http:\/\/www.pass.org\/summit\/2017\/Sessions\/Keynotes.aspx\">keynote is headlined by Rohan Kumar<\/a> (who I just got to meet thank you Mark Souza) and he&#8217;s stated that it will be a lot fun &#8211; you can preview what&#8217;s coming <a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2017\/10\/30\/top-five-reasons-to-join-us-for-the-pass-summit-2017-day-1-keynote\/\">here<\/a>.\u00a0 Rohan is the General Manager Database Systems Engineering for Microsoft, and there are a fair number of demos coming our way.<\/p>\n<h1>PASS News<\/h1>\n<p><a href=\"http:\/\/www.pass.org\/Governance\/BoardofDirectors.aspx\">PASS<\/a> President Adam Jorgensen starts off the day &#8211; this is the 19th PASS Summit.\u00a0 Holy cow.\u00a0 The PASS keynote is being streamed live via <a href=\"http:\/\/www.pass.org\/summit\/2017\/Live.aspx\">PASStv<\/a> if you&#8217;re not available to be here in person.\u00a0 If you are at the Summit this week and you have any [problem with your SQL Server implementation that you need answered, go to the Microsoft Clinic.\u00a0 It is on the 4th floor near the Community Zone, and there are numerous Microsoft Engineers available to help.\u00a0 It&#8217;s an amazing resource at this conference.<\/p>\n<p>Adam takes a moment to thank the individuals that volunteer for PASS &#8211; the organization is primarily run by volunteers, and that includes the PASS Board.\u00a0 The Board will have an open meeting on Friday at 2PM which anyone can attend. I f you have feedback or want to better understand how things work, definitely attend.\u00a0 Outgoing PASS Board members are Jen Stirrup and Chirs Woodruff.\u00a0 New elected members are John Martin, Diego Nogare, and Chris Yates.\u00a0 Adam takes a moment to thank outgoing Past President Tom LaRock and Exec Board member Denise McInerney as their time on the Board comes to a close.<\/p>\n<p>Please take time to meet our sponsors in the Exhibit Hall.\u00a0 The support of our sponsors makes *so* many things possible not just at Summit, but throughout the year.<\/p>\n<p>And Rohan takes the stage&#8230;<\/p>\n<h1>SQL Server 2017<\/h1>\n<p>Data, AI, and Cloud are three disruptive technology trends&#8230;and we need to figure out how to better migrate data to the cloud (I&#8217;m asking: how do we make it easier?).<\/p>\n<p>At it&#8217;s core, the modern data estate enables simplicity.\u00a0 It takes in any type of data, and allows a hybrid setup between on-premises and the cloud.\u00a0 Rohan asks how many people believe they can move their data\/solution to the cloud?\u00a0 About 1% of the attendees raise their hand.\u00a0 He then asks how many people think that deploying to the cloud or on-prem is what&#8217;s needed in the future?\u00a0 The majority of people raise their hands.<\/p>\n<p>SQL Server 2017 was released October 2, 2017, and SQL Server 2016 was released April 1, 2016&#8230;that&#8217;s a very fast release cycle for Microsoft, and that&#8217;s been possible because of the cloud-first approach, which translates to an increased cadence of SP and CU releases.\u00a0 Reminder: in SQL Server 2017 there&#8217;s a shift to CU releases every month, and no more SPs.\u00a0 Glenn <a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/modern-sql-server-servicing-model\/\">blogged about this<\/a> in September.\u00a0 Rohan brings Bob Ward and Conor Cunningham on stage for the first demo.\u00a0 They&#8217;re wearing Cowboys jerseys.\u00a0 *sigh*\u00a0 If you see Bob this week ask him how the Rangers did this year&#8230;<\/p>\n<p>Bob and Conor step through a demo showing the performance benefit of a new HPE DL580 Gen 10, using persistent scalable memory NVDIMMs &#8211; a query that takes 15 seconds on SSDs takes about 2 seconds on the HP storage.\u00a0 And it&#8217;s cheaper?\u00a0 I&#8217;m deferring to Glenn for the hardware details!!<\/p>\n<p>Bob introduces a &#8220;typical&#8221; parameter sniffing issue &#8211; and then shows how to use Automatic Plan Correction (which relies on Query Store under the covers)&#8230;which I&#8217;ll be showing today in my session as well!<\/p>\n<p>New features in SQL Server 2017:<\/p>\n<ul>\n<li>Advanced Machine Learning with R and Python<\/li>\n<li>Support for graph data and queries<\/li>\n<li>Native T-SQL scoring<\/li>\n<li>Adaptive Query Processing and Automatic Plan Correction<\/li>\n<\/ul>\n<p>There is much more available in 2017, as noted in the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-2017\">release notes<\/a>.<\/p>\n<h1>Docker Containers<\/h1>\n<p>Tobias Ternstrom and Mihaela Blendea take the stage to talk about containers running SQL Server.\u00a0 Mihaela shows the build definition, which starts a container based on the SQL Server build.\u00a0 On top of that, restore production database to it and run any additional scripts (e.g. obfuscate and remove some data), then push out the images.\u00a0 Tobias starts typing in a command line window&#8230;this I love.\u00a0 He knows what he&#8217;s doing, but he&#8217;s always kind of winging it.\u00a0 Tobais gives a sneak peak of a tool that shows up as being named Carbon, but Rohan introduces it as Microsoft SQL Operations Studio.\u00a0 It works on Windows, Linux, and Mac to connect to a SQL Server database.\u00a0 So at some point SSMS will be deprecated?\u00a0 Yeah&#8230;just like Profiler \ud83d\ude09<\/p>\n<p>Rohan comes back and talks a bit more about the cloud-first approach.\u00a0 Azure SQL Database is updated regularly, and on a monthly basis new CUs are being pushed out (<a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4038634\/cumulative-update-1-for-sql-server-2017\">CU1 for SQL Server 2017<\/a> has ALREADY been released).\u00a0 Multiple terabytes (yes TERABYTES) of telemetry data are captured every day from Azure implementations.\u00a0 This feedback goes right into making the product better (how else do you think they&#8217;re able to release builds and CUs faster?).<\/p>\n<h1>Managed Instances<\/h1>\n<p>New deployment option in Azure: Managed Instances.\u00a0 It&#8217;s currently in private preview, but you get an entire SQL Server instance with PaaS benefits.\u00a0 This allows for much more of a lift and shift migration with minimal code changes.\u00a0 Microsoft is also working on a database migration service &#8211; this will not be easy and may not work for every solution, but it&#8217;s a step in the direction of making that process better and more reliable.<\/p>\n<h1>Working with Large Data\/BI Solutions<\/h1>\n<p>The next data is showing performance and scale with Azure SQL Database hosted by Danielle Dean, a Principal Data Scientist at Microsoft.\u00a0 Reading in a lot of data &#8211; ingesting patient vitals into Azure database (1.4 million rows\/sec via columnstore and in-memory).\u00a0 Azure Machine Learning Workbench is then used to take an existing model and put it into Azure SQL Database.\u00a0 Switching to SSMS (it&#8217;s not dead yet folks!!) you can query that model (it &#8220;looks&#8221; like a table), and use a stored procedure to predict against the model.<\/p>\n<p>Scott Currie, the creator of Biml, on stage to talk about using the new Azure Data Factory with Biml.\u00a0 I&#8217;ll admit, this isn&#8217;t a technology I know, so I&#8221;m just listening at this point \ud83d\ude42<\/p>\n<p>Azure SQL Data Warehouse Designed from ground up to separate out storage and compute so that you can scale each independently.\u00a0 This design is very flexible and powerful, and provides significant ability to scale (up to 60 nodes currently), and it&#8217;s secure.\u00a0 Also launched in early in October: Azure SQL Data Warehouse Compute-Optimized Tier.\u00a0 This was a result of feedback from customers who had some DW queries that were running REALLY slow in Azure.\u00a0 The solution caches column segments (data) locally, and this cache survives failures, which then provides high performance for DW queries.\u00a0 Julie Strauss, a Principal Group Program Manager comes on stage to demo this.<\/p>\n<p>Why are these behavioral analytic queries so compute-intensive?\u00a0 It&#8217;s a combination of the data that&#8217;s needed and the complexity of the query.\u00a0 Two kinds of analysis &#8211; funnel and cohort.\u00a0 Both use telemetry from customer interactions\/purchases from web site clicks.\u00a0 The sophistication of the query is taking the vast about of data (100TB) and then fold it many times to create the different cohorts &#8211; the query takes about 6 seconds to read through that 100TB of data.\u00a0 I&#8217;d like to know how this is done&#8230;<\/p>\n<p>PowerBI quick demo against data with 100+ million rows.\u00a0 Model built from Visual Studio sourcing data from Azure SQL Data Warehouse &#8211; very easy to deploy the model and then generate different visuals in PowerBI (clicky clicky drop was the &#8220;official&#8221; term used&#8230;I&#8217;m not kidding).\u00a0 Ability to also scale in Azure very quickly so only using resources really need (and thus only pay for what need and use).<\/p>\n<p>Ok, there was one more demo but I&#8217;ll admit, I&#8217;m fading.\u00a0 \ud83d\ude42<\/p>\n<p>Rohan is wrapping up the keynote and talks about community and all of us working together and lifting each other up.\u00a0 Rohan gives a shout out to members of the community that have really given a lot back to others.\u00a0 He also mentioned Denny Cherry, a member of the community who had surgery a couple weeks ago.\u00a0 I had a recent update from a colleague that Denny is doing well &#8211; please send good thoughts his way!<\/p>\n<p>And that&#8217;s a wrap.\u00a0 Off for a day of learning &#8211; have a great one friends!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hey friends!\u00a0 After a one-year hiatus I am BACK at the PASS Summit and ready to blog the day 1 keynote \ud83d\ude42\u00a0 I will update this post throughout the morning so refresh every so often to see the changes.\u00a0 You can also follow along on Twitter &#8211; check out the #PASSsummit hashtag. Reminder: My session [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PASS Summit 2017: Day 1 - Erin Stellato<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PASS Summit 2017: Day 1 - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"Hey friends!\u00a0 After a one-year hiatus I am BACK at the PASS Summit and ready to blog the day 1 keynote \ud83d\ude42\u00a0 I will update this post throughout the morning so refresh every so often to see the changes.\u00a0 You can also follow along on Twitter &#8211; check out the #PASSsummit hashtag. Reminder: My session [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-01T15:11:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-14T17:05:53+00:00\" \/>\n<meta name=\"author\" content=\"Erin Stellato\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erin Stellato\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/\",\"name\":\"PASS Summit 2017: Day 1 - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2017-11-01T15:11:40+00:00\",\"dateModified\":\"2018-12-14T17:05:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PASS Summit 2017: Day 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\",\"name\":\"Erin Stellato\",\"description\":\"The SQL Sequel\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\",\"name\":\"Erin Stellato\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"caption\":\"Erin Stellato\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/erin\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PASS Summit 2017: Day 1 - Erin Stellato","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:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/","og_locale":"en_US","og_type":"article","og_title":"PASS Summit 2017: Day 1 - Erin Stellato","og_description":"Hey friends!\u00a0 After a one-year hiatus I am BACK at the PASS Summit and ready to blog the day 1 keynote \ud83d\ude42\u00a0 I will update this post throughout the morning so refresh every so often to see the changes.\u00a0 You can also follow along on Twitter &#8211; check out the #PASSsummit hashtag. Reminder: My session [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/","og_site_name":"Erin Stellato","article_published_time":"2017-11-01T15:11:40+00:00","article_modified_time":"2018-12-14T17:05:53+00:00","author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/","name":"PASS Summit 2017: Day 1 - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2017-11-01T15:11:40+00:00","dateModified":"2018-12-14T17:05:53+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2017-day-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"PASS Summit 2017: Day 1"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/","name":"Erin Stellato","description":"The SQL Sequel","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158","name":"Erin Stellato","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","caption":"Erin Stellato"},"sameAs":["http:\/\/3.209.169.194\/blogs\/erin"],"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/877"}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/comments?post=877"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/877\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}