{"id":711,"date":"2015-10-29T08:51:44","date_gmt":"2015-10-29T15:51:44","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=711"},"modified":"2018-12-14T09:06:52","modified_gmt":"2018-12-14T17:06:52","slug":"pass-summit-2015-day-2","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/","title":{"rendered":"PASS Summit 2015: Day 2"},"content":{"rendered":"

8:20 AM<\/strong><\/p>\n

We\u2019re off and running with Adam Jorgensen, PASS EVP of Finance.\u00a0 Adam takes this opportunity to provide an update about the financial status of PASS as this satisfies the requirements of the by-laws.\u00a0 The largest source of revenue is the PASS Summit (not a surprise), bringing in just over 7 million dollars (of the 8 million generated in the 2015 fiscal year).\u00a0 The finances continue trend upward, which is great.\u00a0 Finances support the community through events all year long.\u00a0 This year, 78% of every dollar taken in goes back to a community program.\u00a0 PASS is in great financial health, increased reserves to 1.14 million dollars.\u00a0 Starting this year, portfolio-level budget summaries will be published, to make the process more transparent to the community.\u00a0 Last year goals for 2015 were to focus on support for SQLSaturdays and Chapters, among others.\u00a0 PASS Summit will be in Seattle through 2019.\u00a0 SQLSaturday website was relaunched this past year to help better support the events.\u00a0 This year, goals include the BA Community Portfolio, refocus investments to community profiles, global growth program, sales portfolio, technology investments (including a re-design of sqlpass.org ELS: this makes Jes happy<\/em>).\u00a0 Adam wraps up by thanking Amy Lewis, outgoing board member.<\/p>\n

8:33 AM<\/strong><\/p>\n

Adam finishes up and EVP Denise McInerney<\/a> comes on stage.\u00a0 Denise takes a minute to thank Bill Graziano, who is the outgoing Immediate Past President.\u00a0 Bill has been a member of the board for 10 years.\u00a0 ELS: I’m personally a big fan of Bill, I worked with him on the NomCom.<\/em><\/p>\n

Denise moves on to the PASSion Award.\u00a0 There were 71 Outstanding Volunteers this past year.\u00a0 This year’s PASSion Award goes to Lance Harra.\u00a0 He runs the Kansas City SQLSaturday and was an integral part of the program committee.\u00a0 If you are interested in becoming a part of the SQL Server leadership team, stop by the Community Zone this week.\u00a0 There are always ways to get involved with PASS.<\/p>\n

There are over 150,000 members of PASS.\u00a0 There are 3000 people from over 95 countries tuning in live.\u00a0 Yesterday PASS introduced foundation sessions, which were offered by Microsoft (four of them yesterday).\u00a0 Over the years PASS has grown its offerings to meet its members needs – virtual chapters, 24 Hours of PASS, SQLSaturday, user groups, and more.<\/p>\n

Today is the Women in Technology lunch (11:45) sponsored by SQLSentry, and the keynote speaker is Angie Chang.\u00a0 It will be live streamed on PASSTV.\u00a0 Today is the Board Q&A at 3:30.\u00a0 Tonight is the Community Appreciation Party at the EMP Museum at 7 PM.<\/p>\n

PASS Summit next year is scheduled for October 25 – October 28 – early bird pricing is available!<\/p>\n

Today’s keynote speakers are Dr. David DeWitt and Dr. Rimma Nehme. (ELS: TWO OF MY FAVORITES!!!)\u00a0 <\/em>They are both at the Microsoft Jim Gray Systems Lab in Madison.\u00a0 Data Management for the Internet of Things.<\/p>\n

8:45 AM<\/strong><\/p>\n

Dr. Nehme takes the stage.\u00a0 She mentions that it’s harder to present a keynote together than individually.\u00a0 She will start, Dr. DeWitt will come in, then Dr. Nehma will wrap up (dessert!).\u00a0 What, why, how and of IOT.<\/p>\n

Disclaimer: not announcing a product.\u00a0 Goal is to inform, educate, and inspire (and entertain a bit).<\/p>\n

Wants to begin with a new reality.\u00a0 Things around us have a voice that can communicate to us.\u00a0 IOT is a collection of devices and services that work together to do something useful.\u00a0 Basic formula: take a basic object, add controller, sensor and actuator, add the internet, and then you get the internet of things.<\/p>\n

Take the sensors and actuators, add connectivity and big data analytics, and then you can provide new services and optimization.\u00a0 The target is to create value (make money).\u00a0 What does that typically look like?\u00a0 Collect data from sensors, aggregate it, analyze, then act on it. This is a continuous loop.\u00a0 There are 2 types of IOT that people agree upon.\u00a0 On one side have a consumer internet of things – things that are wearable, related to us as humans (phone, watch, etc.) then have things that are industrial (cars, factories, etc.).<\/p>\n

Consumer IOT: fitbut, Nest, Lumo.\u00a0 What can they reveal about us?\u00a0 Health info, house information, driving habits.\u00a0 You can analyze that information and make predications\/revelations.\u00a0 The Industrial Internet of Things (IOT) can be connected, and then significant value can be realized, particularly in Industry.\u00a0 It is still in its infancy.\u00a0 There are four types of IOT capabilities: Monitoring, Control, Optimization, Autonomy.\u00a0 The analogy of this to human development..\u00a0 We are in the “terrible twos” of the IOT development.\u00a0 Why IOT?\u00a0 We are at the peak of the hype right now (based on Gartner).\u00a0 There is a growth of “things” connected to the internet.\u00a0 In 2003 had about 500 million devices connected to the internet.\u00a0 Have 12.5 billion by 2010.\u00a0 Around 2008, the number of things connected to the internet exceeded the number of people.\u00a0 In 2015, at 25 billion things connected to the internet.\u00a0 The value to customers is huge.\u00a0 The power of 1% – if you can improve 1% in fuel savings in an industry like aviation, health care, or power generation, that’s extremely significant.<\/p>\n

Why is this happening now?\u00a0 More mobile devices, better sensors and activators, and BI analysis.<\/p>\n

For IOT How?, Dr. DeWitt comes on stage.\u00a0 Dr. DeWitt is going to talk about the services available.\u00a0 There are a lot of challenges – a large number (and variety) of sensors.\u00a0 There are A LOT of devices sending data.\u00a0 Sensors are frequently dirty, and it’s hard to distinguish between dirty readings and anomalies.\u00a0 And then there is just the volume of data that’s being sent into the cloud.\u00a0 One of the biggest challenges is device security.\u00a0 How do you prevent them from overwhelming cloud infrastructure or impersonating a device?\u00a0 And then there’s cloud-to-device messaging.\u00a0 Sometimes the device is not online.\u00a0 Therefore the device may miss a message, so persistent queue and reliability is needed.\u00a0 How do you deploy this and get the IOT set up?\u00a0 We’re not going to tackle that today.<\/p>\n

There are differences between consumer and industrial IOT.\u00a0 In consumer IOT have to worry about battery and power failure, more cost-sensitive, and might be a simple embedded device, or it could be a powerful sensor, and finally, consumers have wireless (industrial has unlimited power, full-fledged, wired, and depends on needed functionality).\u00a0 Rest of talk will focus on industrial.\u00a0 Note: one size fits none.<\/p>\n

Today’s IOT: Just Do It Yourself.\u00a0 The state of the art is still rather primitive.\u00a0 What are the ingredients that go into IOT?\u00a0 The basic block diagram, out in the field you have devices with a sensor and actuator (e.g. sense temp, humidity, in a Nest thermostat).\u00a0 Up in the cloud, have event\/data aggregator.\u00a0 Device to Cloud (D2C) is how the data gets from the device up to the cloud.\u00a0 You can feed this data into an application, into event\/data storage, into a real-time processing engine (real time), and that *can* use a device controller and send it back to the device (C2D = Cloud to Device).\u00a0 Azure IOT services exist.\u00a0 Two main components: Azure Iot Hubs and Azure Event Hubs.\u00a0 The data management is done through Azure Stream Analytics, DocumentDB, SQL Azure and SQL-DW, Azure HDInsight and Azure Machine Learning.\u00a0 and then use PowerBI and Excel to visualize the data.<\/p>\n

Azure IOT Hub (an Azure PaaS Service), this is the cornerstone of IOT.\u00a0 It receives events and routes them.\u00a0 It is scalable to millions of devicees, and it provides per-device instance authentication.\u00a0 It can send commands back to the devices.\u00a0 Within the hug, every device has it’s own send endpoint, to which the sensors will send events.\u00a0 On the output side, is a set of partitions, into which data gets routed.\u00a0 The number of partitions is created when the service is created in the cloud.\u00a0 A hash function routes it to a partition.\u00a0 Event consumers then “pull” events from the Receive EndPoint.\u00a0 There is a C2D Send Endpoint that can send messages out, and then get routed to a message queue that guarantee once delivery out to the device’s actuator.<\/p>\n

One thing you can do with events is pull them out of the IOT HUB and they go to the Event Consumer such as SQL Azure (doesn’t have a nicer sexy symbol like SQL Server), into HDFS, into Azure Storage, or into DocDB (these are examples).\u00a0 Analyzing the events, then, can be done via SQL Server, or use SQL-DW and Polybase, Hadoop from HDFS (or Hvie\/Storm), or DocDB.\u00a0 All of these are great opportunities to store events.\u00a0 A neat thing to do with IOT data is LEARN from it (e.g. when the boiler might explode).<\/p>\n

Options for real-time query engine include Azure Stream Analytics or Apache Storm on HDInsight.\u00a0 What’s a real-time query engine?\u00a0 Traditional RDBMS with data on disk, send in a query, get data back.\u00a0 In Dr. DeWitt’s mind, the real-time streaming is taking a sequence of events, and some queries that will operate over those events, and the query will find IDs of boilers that are about ready to explode based on PSi.\u00a0 As query processes stream events, it will eventually produce results.\u00a0 Can have multiple queries operating over the same set of events, or different streams.\u00a0 Dr DeWitt encourages us to learn about stream analytics.<\/p>\n

There is no data stored, the queries are just continually running, data flows through the query, outputs results.\u00a0 When you see something important, what do you do?\u00a0 Send a message to IOT hub to do an action (e..g open pressure release valve).\u00a0 Field gateway – Raspberry Pi, running Windows 10, has WiFi – that’s a field gateway.\u00a0 There are two primary use cases: when a sensor\/device cannot itself connect to the internet, or for complex objects (e.g. smart cars) with multiple sensors\/actuators.\u00a0 Two flavors: opaque (only field gateway has identity in IOT hub) and transparent (each device is registered in IOT hub.\u00a0 The field gateway are processors with memory and processors.<\/p>\n

How to manage IOT metadata?\u00a0 per-device metadata is not stored in a database system at present time so no query support.<\/p>\n

Device security is super critical for IOT deployment.\u00a0 Devices must have unique identities, and must PULL to obtain C2D commands (no ports open to reduce attacks).\u00a0 Main takeway: it is PUSH to the cloud.\u00a0 All the IOT events get pushed up into the cloud.\u00a0 It was a good first effort.\u00a0 But what are the problems with pushing everything to the cloud? Not enough bandwidth, requires connectivity, latency, data deluge (from boring sensor readings), storage constraints (storing EVERY event), speed, main point: wastes network bandwidth, computational resources, storage capacity and bandwidth processing for NON-INTERESTING events.<\/p>\n

Go back to boiler example…Running the same query over and over, waste bandwidth sending the reading every second.\u00a0 Centralizing all data from multiple systems might overload the system.\u00a0 Here is their insight: exploit the capability of the field gateway.\u00a0 It can do local processing and control.\u00a0 Have the boiler with sensor and actuator.\u00a0 Then you have a field gateway, and in that, going to run a streaming database system, and install on that boiler gateway control program, and run data through.\u00a0 If run streaming engine there, can run any number of queries, might send average pressure reading for 60 seconds of data up to the IOT.\u00a0 This is a better approach – reduce what pushing up to the cloud, and what needs to be stored.<\/p>\n

How can we do better?\u00a0 Dr. Nehme comes back on stage…\u00a0 (she has changed her outfit…but don’t tweet about it…she’s a jeans and tshirt girl (I KNEW IT)<\/p>\n

Fog computing – all about computing on the edge.\u00a0 It is not cloud vs. fog, it is cloud + fog.<\/p>\n

What’s the fog?\u00a0 It’s like “predicate pushdown”.\u00a0 Never move the data to the computation, move the computation to the data.\u00a0 Devices perform some data pre-processing and compression, the cloud is a big gorilla that can do the management, processing, and machine learning.\u00a0 How can we do better?\u00a0 Real-time response, scalability, metadata management, GeoDR of IOT hubs.\u00a0 IOT is a database problem, not just a networking problem.\u00a0 It hasn’t been database-centric before, but trying to address that.<\/p>\n

Want to take existing IOT Azure services and expand on them.\u00a0 Proposing Polybase for IOT (not a product announcement, just an idea).\u00a0 What is vision? Declarative language, complex object modeling, scale able metadata management, discrete and continuous queries, multi-purpose querying, computation pushdown.<\/p>\n

Declarative language: if dealing with IOT, only choice is to use imperative language.\u00a0 Have to explicitly specify how you want to see something.\u00a0 What about IOT-SQL?\u00a0 A declarative language where you can select information from the sensors.\u00a0 If have tables specified as buildings, room, temperature sensors, etc.\u00a0 With temperature sensors, have columns that looks like regular database.\u00a0 Need to figure out how to model complex objects – for example, a room on a floor in a building, – need a model for this.\u00a0 Have a notion of a shell database – it is a regular database that stores metadata, statistics, and access privileges – can perform authentication, authorization and query optimization against that database.\u00a0 As far as these processes are concerned, they don’t need the actual data.\u00a0 Now expand this to the devices.\u00a0 The IOT shell also gives a simple abstraction for sensors, actuators, and distributors.\u00a0 The shell can be stored in SQL Azure, DocDB, etc.\u00a0 It’s JUST a database.<\/p>\n

What about querying devices?\u00a0 One query is ExecuteOnce: push select to device, it sends results, we’re done.\u00a0 ExecuteForever, push SELECT to device, then the device continually sends results back to client.\u00a0 When done, send signal we’re done and query stops running.\u00a0 Then have ExecuteAction: send a SELECT and then an action, and the action gets fired when predicate is met.\u00a0 Can do execution once, or forever.<\/p>\n

Back to temperature sensor table…need some delcarative queries.\u00a0 ExecuteOnce – get the count of all hot locations.\u00a0 The optimized plan is generated, data is moved, and then work is done up in the cloud.\u00a0 Not a lot of pushdown here.\u00a0 ExecuteForever query – record all hot locations up in the cloud, and execute forever, the optimizer might produce a different plan (does some partial aggregation before pushing data up into the cloud – larger computation is done in the “fog”).<\/p>\n

ExecuteAction: turn on AC in all the hot locations.\u00a0 Larger computation and the action is pushed down in the fog, and only interesting events are pushed up into the cloud.\u00a0 Multi-purpose query – based on results, some could go to one location, some could go to another location.<\/p>\n

The Polybase for IOT Wrapup – use SQL front end with Polybase for sensor\/actuator metadata management and querying.\u00a0 Exploit Polybase’s external attribute mechanism to allow SQL queries to reference sensor values…and then one more thing I didn’t get \ud83d\ude42<\/p>\n

Why should we, as data professionals, care?\u00a0 When a new technology rolls over you, you’re either part of the steamroller or part of the road (didn’t get the attribute).\u00a0 Key takeway: the amount of data to manage is exponentially going up.\u00a0 Need to step back to see what success looks like.<\/p>\n

Dr. Nehme has announced that this is their last keynote.\u00a0 Why? Dr. DeWitt…they have done 7 of these.\u00a0 There are a lot of great speakers at MS, and he is sure there are people who are better speakers.\u00a0 Dr. DeWitt and Dr. Rehme are “parting ways”.\u00a0 She is finishing up her MBA and moving on.\u00a0 Dr. DeWitt is starting to think about retirement.\u00a0 After 40 years thinks it’s about time to give up the full time gig.\u00a0 In 10 years…\u00a0 Have not seen the last of Dr. Rehma – whether it’s at Microsoft or at a competitive.\u00a0 Dr. DeWitt says this has been one of his brightest spots in his career.\u00a0 He says it’s been a terrific experience.\u00a0 He will think about this community for many years to come.\u00a0 (ELS: I admit, I’m a little teary.)<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

8:20 AM We\u2019re off and running with Adam Jorgensen, PASS EVP of Finance.\u00a0 Adam takes this opportunity to provide an update about the financial status of PASS as this satisfies the requirements of the by-laws.\u00a0 The largest source of revenue is the PASS Summit (not a surprise), bringing in just over 7 million dollars (of […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,14],"tags":[],"yoast_head":"\nPASS Summit 2015: Day 2 - 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-2015-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 2015: Day 2 - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"8:20 AM We\u2019re off and running with Adam Jorgensen, PASS EVP of Finance.\u00a0 Adam takes this opportunity to provide an update about the financial status of PASS as this satisfies the requirements of the by-laws.\u00a0 The largest source of revenue is the PASS Summit (not a surprise), bringing in just over 7 million dollars (of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-29T15:51:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-14T17:06:52+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=\"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-2015-day-2\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/\",\"name\":\"PASS Summit 2015: Day 2 - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2015-10-29T15:51:44+00:00\",\"dateModified\":\"2018-12-14T17:06:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PASS Summit 2015: 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 2015: Day 2 - 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-2015-day-2\/","og_locale":"en_US","og_type":"article","og_title":"PASS Summit 2015: Day 2 - Erin Stellato","og_description":"8:20 AM We\u2019re off and running with Adam Jorgensen, PASS EVP of Finance.\u00a0 Adam takes this opportunity to provide an update about the financial status of PASS as this satisfies the requirements of the by-laws.\u00a0 The largest source of revenue is the PASS Summit (not a surprise), bringing in just over 7 million dollars (of […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/","og_site_name":"Erin Stellato","article_published_time":"2015-10-29T15:51:44+00:00","article_modified_time":"2018-12-14T17:06:52+00:00","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-2015-day-2\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/","name":"PASS Summit 2015: Day 2 - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2015-10-29T15:51:44+00:00","dateModified":"2018-12-14T17:06:52+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/pass-summit-2015-day-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"PASS Summit 2015: 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\/711"}],"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=711"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/711\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}