{"id":683,"date":"2014-11-06T08:07:28","date_gmt":"2014-11-06T16:07:28","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=683"},"modified":"2018-12-14T09:07:20","modified_gmt":"2018-12-14T17:07:20","slug":"pass-summit-2014-day-2","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/","title":{"rendered":"PASS Summit 2014: Day 2"},"content":{"rendered":"<p>We&#8217;re kicking off Thursday&#8217;s <a title=\"PASS Summit Day 2 Keynote\" href=\"http:\/\/www.pass.org\/summit\/2014\/Sessions\/Keynotes.aspx#Day2Keynote\">PASS Summit keynote<\/a> in about 5 minutes, and the good news is that I have network connectivity today and I&#8217;ll <strong>really<\/strong> be live-blogging today.\u00a0 Stay tuned for updates throughout the morning!<\/p>\n<p>Ok, I guess I need to start with this picture of Brent Ozar and Grant Fritchey:<\/p>\n<figure id=\"attachment_685\" aria-describedby=\"caption-attachment-685\" style=\"width: 225px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo-e1415290253313.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-685\" src=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo-e1415290253313-225x300.jpg\" alt=\"Brent and Grant with their rainbow leggings to support Doctors Without Borders\" width=\"225\" height=\"300\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo-e1415290253313-225x300.jpg 225w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo-e1415290253313-768x1024.jpg 768w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo-e1415290253313-900x1200.jpg 900w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo-e1415290253313.jpg 1224w\" sizes=\"(max-width: 225px) 100vw, 225px\" \/><\/a><figcaption id=\"caption-attachment-685\" class=\"wp-caption-text\">Brent and Grant with their rainbow leggings to support Doctors Without Borders<\/figcaption><\/figure>\n<p>Brent and Grant will be wearing these lovely leggings today when they present as part of an effort by to help raise money for <a title=\"Argenis&#039; campaign\" href=\"https:\/\/events.doctorswithoutborders.org\/index.cfm?fuseaction=donordrive.personalcampaign&amp;participantID=2216\">Doctors Without Borders<\/a>.\u00a0 You can still donate!<\/p>\n<p><strong>8:15 AM<\/strong><\/p>\n<p>We&#8217;re off and running with Adam Jorgensen, PASS EVP of Finance.\u00a0 Adam is going to provide an update about the financial status of PASS.\u00a0 Funny enough, doing this at Summit satisfies the requirements of the by-laws.\u00a0 The largest source of revenue is the PASS Summit (not a surprise): 96% of the revenue for PASS is generated by Summit and the Business Analytics conference.\u00a0 The money raised goes to provide activities throughout the community, and there are reserves of over one million dollars (pretty good).\u00a0 These funds protect the PASS Community in case the Summit is cancelled due to a natural disaster.\u00a0 In fiscal year 2016, PASS wants to focus on projects already scoped and also provide funds for new projects that are yet to be determined.\u00a0 PASS publishes the budget every year.\u00a0 The community members have access to this, and starting in 2016 portfolio-level budgets will be published so it&#8217;s easier to drill into the areas of PASS which interest members the most.\u00a0 The focus in 2015 includes conferences, the global alliance program, investing in IT, community events, data culture, and the business and data analytics community.<\/p>\n<p><strong>8:22 AM<\/strong><\/p>\n<p>Adam finishes up and PASS President Tom LaRock comes on stage.\u00a0 Tom takes a few minutes to say goodbye to members who are ending their term on the board, including Sri Sridharan and Olivier Matrat.\u00a0 Sri managed the Volunteer profile within PASS and did a phenomenal job trying to bring more volunteers into the community to help PASS.\u00a0 Tom also introduces new Board members: Sanja Mishra and Grant Fritchey.\u00a0 Next up is Denise McInerney, EVP of Marketing.<\/p>\n<p>Denise mentions that over 5000 people are watching today&#8217;s keynote online on PASStv in over 113 countries.\u00a0 Denise starts by talking about her involvement with PASS, which started back in 2002 with a session she attended by Kimberly Tripp. <em>(ES: SQLskills shout out!)<\/em>\u00a0 Denise then got involved locally and at the national level.\u00a0 When you volunteer for PASS you help other members, and you broaden your own network.\u00a0 A point from Denise: many of the people she met in the beginning are the ones she still turns to.\u00a0 Denise announces this year&#8217;s PASSion Award winner: Andrey Korshikov, who is based in Russia and a SQL Server MVP and BI Developer.\u00a0 Andrey is a PASS Regional Mentor and the founder of the Russian VC.\u00a0 He&#8217;s managed four SQLSaturdays and three Russian editions of 24 Hours of PASS.<\/p>\n<p>Denise also mentions those who were also nominated for the PASSion award &#8211; but I couldn&#8217;t type them all fast enough \ud83d\ude42\u00a0 She then highlights the PASS Outstanding Volunteers that have been recognized through the year and asks them to stand and be recognized.\u00a0 <em>(ES: It takes a village &#8211; there are so many fantastic people who contribute to this community.)\u00a0<\/em><\/p>\n<p>On Friday, from 2:15 to 2:45, in room 307\/308, there will be a Business Analytics Direction Board Discussion.\u00a0 If you want to provide feedback about the Business Analytics Conference (taking place April 20-22, 2015 in Santa Clara, CA) and\/or this direction that PASS is going, please attend the discussion.\u00a0 Denise also reminds people to update their PASS profile, particularly if you want to volunteer and and get involved.<\/p>\n<p>The next PASS Summit will be in Seattle, October 27-30, 2015.\u00a0 Registration is already open!<\/p>\n<p><strong>\u00a08:35 AM<\/strong><\/p>\n<p>Dr. Rimma Nehme finally takes the stage for her keynote: Cloud Databases 101.\u00a0 She is a Principal Research Engineer at the Microsoft Jim Gray Systems Lab.<\/p>\n<p>Dr. Nehme has been watching this conference for the past 5 years, and starts by thanking the organizers for inviting her, and mentions Dr. DeWitt.\u00a0 And she was thinking about how she could be like Dr. DeWitt, and then realized, &#8220;trying to be a man is a waste of a woman&#8221;.\u00a0 She won&#8217;t try to be like Dr. DeWitt, she will just be herself.\u00a0 Yes.\u00a0 Dr. Nehme was born in Belarus, she knows a little bit about databases from an academic and real-world perspective, and she is learning a lit bit about business too.\u00a0 <em>(Dr. Nehme is getting her MBA in her &#8220;spare time&#8221;&#8230;seriously&#8230;and did I mention that she&#8217;s also a mom of two kids?\u00a0 SO impressive.)<\/em>\u00a0 Dr. Nehme is a big fan of the PASS Community.<\/p>\n<p>Today&#8217;s topic is: What is a cloud database?\u00a0 Our roadmap for today:<\/p>\n<ul>\n<li>Why Cloud?<\/li>\n<li>What&#8217;s a Cloud Database?<\/li>\n<li>How are they built?<\/li>\n<li>What&#8217;s my role as a DBA?<\/li>\n<li>Summary<\/li>\n<\/ul>\n<p>Cloud technology is still relatively new, and it has &#8220;Shiny Object Syndrome&#8221; around it.\u00a0 Dr. Nehme&#8217;s goal is to explain why cloud is special.\u00a0 Basic equation to remember is that cloud = service.\u00a0 More precisely defined: the cloud is computing and software resources that are delivered on demand, as a service that is always on, accessible from anywhere, and at any time.\u00a0 This is also known as the 5the utility.\u00a0 Why is it called cloud computing?\u00a0 Blame the network people (not database people).\u00a0 Cloud computing characteristics:<\/p>\n<ul>\n<li>on-demand self-service &#8211; demand for resources can be filled automatically<\/li>\n<li>location transparent resource pooling &#8211; resources are pooled to several customers<\/li>\n<li>ubiquitous network access &#8211; all resources available over the network that allows data exchange<\/li>\n<li>rapid elasticity &#8211; capability provided on-demand when needed, then releases<\/li>\n<li>measure service with pay per use &#8211; resource charges as based on the quantity used<\/li>\n<\/ul>\n<p>Think about it: one woman or a man, and a credit card, can tap into some of the largest computing solution in the world.<\/p>\n<p>A brief history: the wave of computing started in the 1960s.\u00a0 The concept of computation was born in this time by one of the MIT professors.\u00a0 In the 1990s, the first cloud application was offered.\u00a0 In the 2002, Amazon Web Services was launched, and Windows and Google launched offerings in the 2008 timeframe.<\/p>\n<p>Question: Where does the cloud live?\u00a0 In a data center.\u00a0 Let&#8217;s go on a virtual tour of a Microsoft Data Center.\u00a0 The data center in Chicago looks like a fancy trailer park.\u00a0 What&#8217;s inside those big containers?\u00a0 Lots and lots of servers.\u00a0 When we think of a data center we think of lots of servers, raised floors, etc.\u00a0 There is more to it, there are transformers, cooling towers, chillers, UPS&#8217;, powers, and people.\u00a0 One way to describe a data center is by its efficiency.\u00a0 Optimizing for energy efficiency is a good thing.\u00a0 We are socially responsibility to pay attention to our use of resources.\u00a0 One way that efficiency is calculated is by using PUE = power usage effectiveness.\u00a0 The formula is the total facility power divided by IT equipment power.\u00a0 This is valuable as a broad efficiency ratio.\u00a0 The PUE ration for a modular data center (hosting cloud resources) is 1.15, whereas for a traditional data center it is 2.0.\u00a0 Interestingly enough, the cooling for the modular data center is 0%.\u00a0 One example of how this is done is swamp cooling (aka evaporative cooling)&#8230;put cold water in front of fans.\u00a0 <em>ES: Rob Farley tells me this is how its done in Australia.<\/em>\u00a0 Data centers have significantly evolved since the late 1980s.\u00a0 There are over 100 data centers in more than 40 countries &#8211; more than 1 million servers.\u00a0 What does Microsoft consider with site selection?\u00a0 There are over 35 factors, the top 3 are proximity to the customers, energy and fiber infrastructure, and the skilled workforce.<\/p>\n<p>The main takeaways for why cloud: elasticity, no cap ex, pay per use, focus on business, and fast time to market.\u00a0 This is why cloud computing is special.<\/p>\n<p>What is a cloud database?\u00a0 Everything in the cloud is a service.\u00a0 So you&#8217;re getting a database, as a service.\u00a0 Cloud services has 3 layers: infrastructure, platforms, and applications (and these are also all services).\u00a0 The Microsoft Cloud has the same thing &#8211; infrastructure services, platform services (e.g. Windows Azure, SQL Azure), application services.\u00a0 When you have a data center on site, you manage everything.\u00a0 When it&#8217;s infrastructure as a service, part of that stack is outsourced to a vendor.\u00a0 With platform as a services, you&#8217;re responsible for the application and data &#8211; everything else is outsourced to the vendor.\u00a0 With software as a service &#8211; you outsource everything.\u00a0 Dr. Nehme takes this and then does &#8220;pizza-as-a-service&#8221; analogy:<\/p>\n<ul>\n<li>On Premise = you buy everything and make the pizza at home<\/li>\n<li>IaaS = take and bake (pick up the pizza, you cook it at home)<\/li>\n<li>PaaS = pizza delivered<\/li>\n<li>SaaS = dining in the restaurant<\/li>\n<\/ul>\n<p>IAAS in the database world &#8211; you must still manage provisioning, backups, security, scaling, failover, replication, tuning, performance, etc.\u00a0 Dr. Nehme calls this lift and shift &#8211; take an earth version of a database and put it in the cloud.\u00a0 Existing applications don&#8217;t need to be modified.\u00a0 Just need to point to version of the DBMS in the cloud.<\/p>\n<p>PAAS = DBMS as a service &#8211; select the cloud vendor, select a DBMS.\u00a0 Here, the cloud vendor manages provisioning, backups, security, tuning, failover, etc.\u00a0 There might be some changes to the language surface compared to an earth version of a database.<\/p>\n<p>SAAS = select the cloud vendor, select a cloud app (SharePoint).\u00a0 The whole stack is outsource to the cloud vendor.<\/p>\n<p>Database as a service examples:<\/p>\n<ul>\n<li>Managed RDBMs (SQL Server)<\/li>\n<li>Managed No SQL (Doc DB, MongoHQ)<\/li>\n<li>Cloud-Only DBaaSS (Dynammo DB, Google F1)<\/li>\n<li>Analytics-as-a-Service (HDInsight, EMR)<\/li>\n<li>Object Stores (Azure storage, S3)<\/li>\n<\/ul>\n<p>Why virtualization?\u00a0 It&#8217;s a huge enabler for cloud computing.\u00a0 Unfortunately, many servers are grossly underutilized.\u00a0 Virtualization developed to put resources back to work.\u00a0 However, there are bottlenecks with these resources.\u00a0 What can be virtualized?\u00a0 CPU, network, memory, and disk.\u00a0 Keep in mind that there is no free lunch.\u00a0 Virtualization comes with limitations.\u00a0 Lose direct access to the computing resources.\u00a0 Now have an indirect path.\u00a0 Also, hiding the details of physical resources is unfortunate in terms of configurations.\u00a0 In addition, virtualization always causes some degree of performance penalty.\u00a0 Use cases are consolidation, migration and load balancing, and high availability.\u00a0\u00a0\u00a0 For consolidation, if CPU requirements are high for one server, and IO requirements are high for a second server, consolidating those two might be ideal (and can also equate to energy-savings).<\/p>\n<p>With migration and load balancing, assume one machine with a VM with a RDBMS that gets overloaded.\u00a0 It could be migrated to another machine to help maintain performance.\u00a0 And with high availability &#8211; one machine with a VM and then backup machine with VM image, will detect a failover, restart the image so the server stays up and available.<\/p>\n<p>There are four common approaches to multi-tenancy (with a lodging analogy):<\/p>\n<ul>\n<li>Private OS (SQL Server in a VM) &#8211; private apartment<\/li>\n<li>Private Process\/DB (MongoHQ) &#8211; private room<\/li>\n<li>Private Schema (Azure SQL DB) &#8211; share room<\/li>\n<li>Shared Schema (SalesForce) &#8211; share bed<\/li>\n<\/ul>\n<p>What&#8217;s the big deal with this?\u00a0 When you consider database as a service, what are the requirements for your database, for your data?\u00a0 If application independence is important, don&#8217;t go with a shared schema approach.\u00a0 You must do cost-benefit analysis.\u00a0 Given pros and cons, what works best for you?<\/p>\n<p>Service Level Agreements&#8230;when people talk about the cloud they talk about SLAs.\u00a0 It&#8217;s a common understanding about services, guarantees, and responsibilities.\u00a0 There is a legal component and a technical component.\u00a0 Service level objectives are measurable characteristics such as performance goals, deadlines, constraints, etc.\u00a0 Think of this in terms of availability and &#8220;nines&#8221;.\u00a0 If you require four nines (99.99%) up time, that&#8217;s about 4 minutes of downtime per month.\u00a0 Three nines (99.9%) is about 43 minutes per month.\u00a0 Just one nine can make a big difference.\u00a0 Container based hardware is three nines-reliable, but with SQL DB they are delivering four nines-reliability.<\/p>\n<p>Three main concepts behind Azure SQL DB:<\/p>\n<ul>\n<li>Account &#8211; 0 or more servers<\/li>\n<li>Server &#8211; 1 or more databases<\/li>\n<li>Database &#8211; standard SQL objects<\/li>\n<\/ul>\n<p>This was designed with high availability in mind.\u00a0 This means that there are multiple replicas of data.\u00a0 There is a primary and two secondaries.\u00a0 If a node goes down, the secondary becomes a primary, then replicate again so end up with two secondaries.\u00a0 Reads are completed on primary, writes replicated to secondaries.\u00a0 Four layers:<\/p>\n<ul>\n<li>client &#8211; used by application to communicate directly to SQL Database<\/li>\n<li>services &#8211; the gateway between the clients connecting to the SQL DB and the platform layer where computation occurs; provisioning, billing, routing for connections<\/li>\n<li>platform &#8211; physical services that support the services layer above, includes SQL Server, management services<\/li>\n<li>infrastructure &#8211; IT admin of physical hardware and OS<\/li>\n<\/ul>\n<p>Applications connect to the internet, go to the Azure cloud, get to the load balances, hit the gateway which are connected to the SQL DB nodes, and then under all that is the scalability and availability fabric which does failover, replication and load balancing.\u00a0 What does the SQL node look like?\u00a0 It&#8217;s a machine with a SQL instance with a single physical database for the entire node.\u00a0 The database files and logs are shared across every logical database &#8211; might be sharing log files with someone else.\u00a0 Each logical database is a silo with its own independent schema (sharing a room analogy).<\/p>\n<p>What we if create a database or run a query, how does it work?\u00a0 The Azure service will identify where to put the primary database (when creating a new one), then put secondaries on two other machines.\u00a0 When a user comes in to do a query, the SQL Azure gateway service will identify where the primary is located, get to it, perform computation, and return results to user.\u00a0 If you want to know more &#8211; go to the sessions here at PASS \ud83d\ude42<\/p>\n<p>Next up: my role as a DBA.\u00a0 From Dr. Nehme: &#8220;I have to be honest, I tried to put myself in your shoes.&#8221;\u00a0 She asks, do we still need a DBA in the cloud era?\u00a0 Dr. Nehme says yes.\u00a0 Cloud doesn&#8217;t have to an either\/or choice.\u00a0 You can augment on-premise systems with cloud (remember the stretched tables example for yesterday).\u00a0 This is the time to refresh your skills and adjust to this era in the cloud.\u00a0 The cloud was not designed to be a threat to DBAs.\u00a0 The number of DBAs vs. the number of database apps vs hardware computer capacity.\u00a0 The number of DBAs is much smaller than both.\u00a0 This is where cloud computing can help.\u00a0 Address issue of underutilized hardware and alleviate some of the work of overburdened DBAs.\u00a0 Dr. Nehme&#8217;s recommendation is to take current skills, add cloud skills, and call yourself a Cloud DBA.<\/p>\n<p>Some key things to remember:<\/p>\n<ol>\n<li>cloud database = a service, designe dto reduce admin and operational costs (pay as you go, elasticity), there is a wide spectrum of solution (rent a database, cloud database).<\/li>\n<li>If you get confused about cloud deployment options, remember the pizza analogy<\/li>\n<li>Do the cost benefit analysis, and you need to embrace the cloud.\u00a0 It presents a lot of opportunities.<\/li>\n<\/ol>\n<p>Dr. Nehme finishes up and takes a minute to thank Dr. DeWitt and has him come on stage. She hints at possibility a keynote with both of them in the future.\u00a0 I&#8217;d love that, but I&#8217;d also be happy to just hear Dr. Nehme again \ud83d\ude42\u00a0 Great session.\u00a0 Perry is overwhelmed&#8230;<\/p>\n<figure id=\"attachment_686\" aria-describedby=\"caption-attachment-686\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo1.jpg\"><img decoding=\"async\" class=\"wp-image-686 size-medium\" src=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo1-300x225.jpg\" alt=\"Perry after Dr. Nehme's talk...\" width=\"300\" height=\"225\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo1-300x225.jpg 300w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo1-1024x768.jpg 1024w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo1-900x675.jpg 900w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo1.jpg 1632w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-686\" class=\"wp-caption-text\">Perry after Dr. Nehme&#8217;s talk&#8230;<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p><em>Edit: 10:09AM In my original publishing I referred to Dr. Nehme as Rimma&#8230;and I think it&#8217;s because Dr. DeWitt always refers to her that way (and she refers to him as David).\u00a0 I updated the post to fix that.\u00a0 And also wanted to add a new pic (Dr. Nehme&#8217;s keynote and having the chance to chat with her was one of this week&#8217;s highlights):<\/em><\/p>\n<figure id=\"attachment_687\" aria-describedby=\"caption-attachment-687\" style=\"width: 225px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo2-e1415297758110.jpg\"><img decoding=\"async\" class=\"wp-image-687 size-medium\" src=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo2-e1415297758110-225x300.jpg\" alt=\"Dr. Nehme and me\" width=\"225\" height=\"300\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo2-e1415297758110-225x300.jpg 225w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo2-e1415297758110-768x1024.jpg 768w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo2-e1415297758110-900x1200.jpg 900w, https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo2-e1415297758110.jpg 1224w\" sizes=\"(max-width: 225px) 100vw, 225px\" \/><\/a><figcaption id=\"caption-attachment-687\" class=\"wp-caption-text\">Dr. Nehme and me<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>We&#8217;re kicking off Thursday&#8217;s PASS Summit keynote in about 5 minutes, and the good news is that I have network connectivity today and I&#8217;ll really be live-blogging today.\u00a0 Stay tuned for updates throughout the morning! Ok, I guess I need to start with this picture of Brent Ozar and Grant Fritchey: Brent and Grant will [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","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 2014: Day 2 - Erin Stellato<\/title>\n<meta name=\"description\" content=\"Day 2 of the 2014 PASS Summit kicks off with a keynote session by Rimma Nehme on Cloud Databases.\" \/>\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-2014-day-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PASS Summit 2014: Day 2 - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"Day 2 of the 2014 PASS Summit kicks off with a keynote session by Rimma Nehme on Cloud Databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-06T16:07:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-14T17:07:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo-e1415290253313-225x300.jpg\" \/>\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=\"13 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-2014-day-2\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/\",\"name\":\"PASS Summit 2014: Day 2 - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2014-11-06T16:07:28+00:00\",\"dateModified\":\"2018-12-14T17:07:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"Day 2 of the 2014 PASS Summit kicks off with a keynote session by Rimma Nehme on Cloud Databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PASS Summit 2014: Day 2\"}]},{\"@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 2014: Day 2 - Erin Stellato","description":"Day 2 of the 2014 PASS Summit kicks off with a keynote session by Rimma Nehme on Cloud Databases.","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-2014-day-2\/","og_locale":"en_US","og_type":"article","og_title":"PASS Summit 2014: Day 2 - Erin Stellato","og_description":"Day 2 of the 2014 PASS Summit kicks off with a keynote session by Rimma Nehme on Cloud Databases.","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/","og_site_name":"Erin Stellato","article_published_time":"2014-11-06T16:07:28+00:00","article_modified_time":"2018-12-14T17:07:20+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-content\/uploads\/2014\/11\/photo-e1415290253313-225x300.jpg"}],"author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/","name":"PASS Summit 2014: Day 2 - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2014-11-06T16:07:28+00:00","dateModified":"2018-12-14T17:07:20+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"Day 2 of the 2014 PASS Summit kicks off with a keynote session by Rimma Nehme on Cloud Databases.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2014-day-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"PASS Summit 2014: Day 2"}]},{"@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\/683"}],"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=683"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/683\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}