Data Driven cover image

Data Driven

Latest episodes

undefined
Oct 9, 2020 • 27min

How Do Voice Assistants Work?

In this episode, Frank and Andy explore voice assistants and the behind the scenes technology that makes them tick.AI Generated Transcript00:00:02 British Voiceover AI LadyHello and welcome to data driven, the podcast where we explore the emerging fields of data science, machine learning and artificial intelligence and will not be the only AI generated voice today. As Frank and Andy interview, my Cousins Alexa, Cortana, Siri and the Google assistant.00:00:18 British Voiceover AI LadyNow that I think of it, the Google assistant needs a proper name.00:00:22 British Voiceover AI LadyDoesn't it?00:00:23 British Voiceover AI LadyWithout further ado, here are your hosts Frank Lavigna and Andy Leonard.00:00:29 FrankSo we're both together and we're going to be talking about voice assistants and kind of how they work and.00:00:38 FrankUh, we have some special guests with us today.00:00:42 FrankWelcome once again, if you're just joining us live. It's Andy later tonight we are here and we are live streaming, data driven podcast where we explore the emerging fields of data science, machine learning an artificial intelligence.00:00:55 FrankHow are you doing Andy?00:00:56 AndyI'm doing pretty good Frank. How are you?00:00:59 FrankI'm doing well. I know you have a hard stop so I won't Yammer too long we have.00:01:04 FrankThree special guests with us today.00:01:06 FrankAnd E 3 three.00:01:09 FrankThat's a record. It is a record.00:01:14 FrankThese guests are.00:01:19 AndyAlexa Hello Alexa.00:01:22 FrankShe's going to say hello back, I'm sure.00:01:26 AndyYeah.00:01:28 FrankCortana.00:01:30 AndyHello Cortana.00:01:33 FrankAnd.00:01:36 FrankOn my phone, I have Google Assistant.00:01:38 AndyHello Google Assistant Hey Google.00:01:41 FrankThat didn't work. It now correctly phones on. Let me tell you whenever there's a training video or like a keynote where they talk about the integration between them. It's pandemonium in my Home Office, because I usually have all three and it's just harder pandemonium.00:01:59 FrankSo I want to switch to, so we're recording this last. If you're watching live. Thank you. If you're watching later, thank you. We always try to respond to the comments. I think we're pretty good about that. And if you're watching this, if you're listening to this on the podcast, I will try to transcribe everything I'm saying. So let me switch.00:02:18 FrankHere.00:02:19 FrankAn I'll see if I can put us in the little bottom here, how do?00:02:22 FrankI do that.00:02:24 FrankThere we go.00:02:27 FrankOh well anyway.00:02:30 AndySo there we.00:02:31 AndyAre were there this is a closed.00:02:34 FrankAlmost there, this is the. This is a quote.00:02:38 FrankFrom Charles the 5th, who if you're not up in your history he was kind of a big deal. I think he was a hapsburg. I don't remember shame on me but he has this quote where he says I speak Spanish to God, Italian to women, French to men in German to my horse.00:02:57 FrankNow you're probably wondering what the heck does this have to do with anything? Well, here's what it has to do with.00:03:03 FrankOh no, PowerPoint is going to crash.00:03:07 FrankNo, you can tell.00:03:08 FrankWe're live here we go. This is what I want to say.00:03:11 FrankThis is the my my modern take on this. I speak to Elexa when I'm home to Cortana. When I'm at work and Google Assistant when I'm in my car or have my phone with me.00:03:24 FrankYou can also replace that with Siri. I don't. I do have an iPad, but it's not with me.00:03:28 AndyThat's Frank, the 1st right.00:03:30 FrankFrank the 1st.00:03:34 FrankI rather like that I rather like that.00:03:38 FrankSo the idea here is you know how do these things work.00:03:41 FrankYou know what?00:03:44 FrankAn you know, in terms of the guests and and kind of things and I know you have a A Time Constraint so I just want to kind of demonstrate something that I've had the chance for a work engagement had a chance to kind of study up on all three because it was a competitive situation between Louis.00:04:03 FrankWhich is ultimately what powers Cortana, kind of behind the scenes, and Lex which is the Alexa version for processing text and dialogue flow, which is the Google version, so it's a lot of mouthfuls an I did. Let's see if we can get our guests to introduce themselves Alexa.00:04:24 FrankHi how are you?00:04:27 Speaker 3I'm feeling like a home run.00:04:29 Speaker 3This weekend I'll be watching a lot of my favorite sports.00:04:35 FrankOK.00:04:38 FrankI'm getting a warning sign on my stream ability here, so I don't know what's going on.00:04:42 AndyWhat's up with that?00:04:43 FrankI don't know Well, you're still hear me so that's a good sign.00:04:46 AndyYeah, you're you're good with me and I'm out here on the in the boondocks with 25 minutes bro.00:04:50 FrankThere you go.00:04:52 FrankHey Cortana.00:04:54 FrankHow are you?00:04:57 Speaker 4Great thanks.00:04:59 FrankThere you go.00:05:00 FrankAnd let's see what our friend Google Assistant.00:05:03 FrankHas to say.00:05:10 FrankHey court, I'm sorry. OK Google, how are you?00:05:18 FrankOops, it's on my Bluetooth, that's why OK.00:05:22 FrankYou could tell where life looks 'cause it's just all bloopers.00:05:27 FrankHow are you?00:05:32 FrankSo we've returned a bunch of short search results, OK?00:05:39 FrankWhat's interesting about these three is that they're all trying to solve essentially the same problem, right? The they they are trying to solve.00:05:46 FrankThe ability to take human language.00:05:49 FrankAnd type, it in and convert it to let me see if I get this screen back up.00:05:55 FrankAn I will maximize that there we go see my fancy setup I do. It's cool, isn't it? Yes.00:06:04 FrankAlright, so ultimately they're all trying to say the same problem. Hey, we have a comment wise guy. Yes I am miserable. OK, alright, so here's the problem that all these devices want to solve, right? This is a human. This is some speaker device thingy.00:06:21 FrankRight?00:06:23 FrankAnd.00:06:25 FrankYou have the cloud.00:06:27 FrankWhich I think is really makes this.00:06:29 FrankPossible in a lot of ways or not. Just possible and practical? Yeah yeah.00:06:34 FrankI say.00:06:36 FrankYou know, turn.00:06:39 FrankI have to be careful 'cause I actually do have the lights in my Home Office so.00:06:43Set up to this.00:06:46 FrankRight, right? So this gets digitized into audio.00:06:51 FrankRight?00:06:52 FrankHere right, I'll draw that by Squiggly Lines.00:06:55 AndyRight, I like to squiggly lines.00:06:57 FrankSee, I'm talented, I'm very.00:06:59 AndyHard you are. You're an artist.00:07:01 FrankThen a cloud service, right? Whether that's Louis.00:07:07 FrankDialogflow00:07:09 FrankOr Lax.00:07:12 FrankConverts that into.00:07:15 FrankBack into text or into text, right? Right turn the.00:07:20 FrankLights on.00:07:27 FrankThen what happens is then you have to figure out what does that mean. What's the context here, right? What's the intent? That's the official word.00:07:34 FrankSo that's turn lights.00:07:38 FrankAnd then on now most people will argue with me. Is that technically this is the intent?00:07:43 FrankAnd this is the the destination or slot.00:07:48 FrankLex calls us a slot and this is the state that you want, right? So ultimately there's 100 different ways I can say that, and this is what makes the really kind of an LP problem, right? Please turn the lights on or do would you kindly turn the lights on right bioshock?00:08:02 FrankRight there for you.00:08:05 FrankUm?00:08:06 FrankThat sort of thing, and then whatever that happens, is that this will then parse that into an action, right?00:08:12 FrankWhich, if you have smart plugs, it will then send a message back through the magic of the Internet and then turn the actual.00:08:20 FrankOh, I like how that's doing that. Turn the actual light on.00:08:27 FrankRight, so that's that's basically solving the same problem.00:08:30 FrankRight?00:08:32 FrankAnd what's interesting about this? I just realized I didn't say it out loud for folks listening on the podcast, but ultimately what happens is my words get translated into an electronic signal, right? A sign? A wave of sorts.00:08:45 FrankAnd then that is then.00:08:47 FrankRe on the other side, it's then sent from the speaker to the cloud, where it will turn those that sound form that sound wave back into text, right? Or words and then it'll go through and it'll parse out.00:09:02 FrankWhat I'm saying is try to get an intent from it or an action to it, and then based on that, some other program that also lives in the cloud.00:09:11 FrankMostly, we'll then take an action based on that. Does that make sense like that? Explain that clearly.00:09:17 AndyI think so yeah, yeah I like it. I like the flow.00:09:21 FrankYeah, and it's it's it's.00:09:22 FrankAmazing how simple this is, right? This is not rocket science inside your average in inside your average you know echo device. You know it's not rocket science, it's just well, this one is the fancy one with the screen, but you know the the typical kind of .1 or whatever is a microphone and speaker in a Wi-Fi connection. It's essentially all it is, right?00:09:42 FrankSo ultimately the the goal then is that let me see if I can D minimize minimize this. So the the goal is is that I have an example of that, and this is essentially a build your own voice kit that I saw at Micro Center for.00:10:01 FrankLike $5 or something like that.00:10:03 FrankAn inside is a speaker, a button, and a Cardboard box.00:10:09 FrankAnd if you attach your Raspberry Pi to this.00:10:12 FrankYou basically have a Google home assistant.00:10:17 AndyThat's nice, yeah.00:10:19 FrankShame on me because I bought this longer ago than I care to admit and I haven't built it yet.00:10:26 FrankBut that's just to demonstrate. The point is that these these actual devices are rather simple in terms of, you know, just them being their own thing, right? So what's interesting about this, and this is where the cutting edge comes is when you when I talk.00:10:41 FrankWe have our human brains or whole.00:10:44 FrankSome will debate about.00:10:45 FrankWhether or not I have a human brain, but let's let's go with you.00:10:49 FrankSo.00:10:51 FrankThe short of it is, is that.00:10:54 FrankI have the ability to understand context right from my previous statement.00:10:58 FrankSo I'm going to mute some of these devices because if I start to hear their name, they'll start going wild. What's interesting is how good Cortana is at this. How good the Google assistant is at this, and how.00:11:14 FrankAlexa needs some room for improvement, right, right? So for instance, if you haven't caught on the shirt I'm wearing says cream cash rules everything around me, that's from a Wu Tang clan song, so I will ask this simple question from Alexa Alexa, who is the Wu Tang clan.00:11:36 Speaker 3According to Wikipedia, Wu Tang clan is an American hip hop group formed in Staten Island, NY city in 1992 original.00:11:45 British Voiceover AI LadyHopes.00:11:46 FrankAlexa.00:11:48 FrankWhat was their first album?00:11:51 Speaker 3According to Wikipedia, the first album is the debut studio album by German dual Modern Talking. It was released on April 1st, 19.00:11:59 Frank80 so you get the idea you and I know like if you asked me who they who the Wu Tang clan were an, then what was their first album? I would tell you right, right?00:12:09 FrankIt does not have the notion of context. This is turns out to be very difficult problem for computers to solve. OK, because.00:12:19 FrankThere's a lot going on, right? So if I start talking to you is like handy. I was at this great restaurant last night that and then we switch to another.00:12:27 FrankTopic.00:12:28 FrankThen00:12:29 FrankWe would, we would then say, Hey where was that place? And then I would kind of know if you said place I would know what you were talking about right? That is humans have trouble with this right? 'cause I have many conversations with my wife that kind of go in different directions 'cause I have no idea where she's talking about.00:12:47 FrankBut I mean it's hard for humans. It's really hard for machines, so let's try and see if Cortana does this any better. Hey Cortana?00:12:54 FrankWho is the Wu Tang clan?00:12:58 Speaker 4According to wikipedia.org Wu Tang, clan is an American hip hop group formed in Staten Island, NY city in 1992. Originally composed of rza.00:13:10 FrankHey Cortana, what was their first album?00:13:15 Speaker 4Should I read a snippet from Wikipedia?00:13:17 Speaker 4That might be related.00:13:19 FrankYeah, I'm afraid.00:13:23 Speaker 4The Wu Tang clan is a NYC based hip hop musical group consisting of 10 American rappers, rza, gza, Method Man, Raekwon, Ghostface Killah.00:13:34 FrankThere's a lot of members of the Wu Tang clan. In case you didn't know.00:13:37 Speaker 4Cappadonna and the label dirty *******00:13:42 FrankHey Cortana, what was their first album?00:13:49 Speaker 4There might be something on Wikipedia.00:13:51 Speaker 4Should I read it?00:13:53 FrankYeah.00:13:56 Speaker 4The Wu Tang clan is a NYC.00:13:58 FrankBased all right?00:13:59 FrankWell, in the past she did get that right.00:14:03 AndyWell, she wasn't completely off base, wasn't completely off. Now she she kept it. Seems like some kind of workflow thing put her into.00:14:11 AndyIt shot well at at least identify the context back to your previous question.00:14:16 FrankIt did on that's a new active. That's a new behavior. I swear I I used to do this demo all the time and depending on the audience it would be Wu Tang clan or you know Aerosmith, you know. So let's see what Google has to say. OK, Google.00:14:32 FrankWho is the Wu Tang clan?00:14:39 FrankAlright, you're not very talkative today.00:14:45 FrankWhat was their first album?00:14:50 FrankOK, the demo gods are not kind to me today.00:14:54 FrankBut in the past this has worked on.00:14:56 FrankOn home assistant, an Cortana.00:15:00 FrankOK, so.00:15:05 FrankSo the reason?00:15:05 FrankWhy we're doing this today, and I know Andy has a hard stop in a couple of minutes is because we are hoping to get data driven as a flash briefing on Alexa.00:15:15 FrankAnd.00:15:17 FrankAlexa.00:15:20 FrankSo I was trying to do this whole surprise thing, but apparently since the demo failed, I figured I'd break into that.00:15:27 FrankInto that, but that's ultimately the goal. But I also think this is an interesting, interesting topic, because for a lot of folks, this is just this magical black box. There is listening, right? An you know it's not magical and it all comes down to math and science, right? An and the key is to understand, kind of how it's built. And once you understand how it's built, you can build your own systems and it's actually not that hard.00:15:47 FrankThere are more moving parts than you would think, but ultimately it just comes down to.00:15:53 FrankYou know you're taking that speed that sound data, converting it into text, then taking that text and then converting that back into some kind of intent in action, right?00:16:04 FrankYeah, and then on the other side, I'm sorry, go ahead.00:16:07 AndyNo, Mark Taylor just said it's a do loop and he's right, he's.00:16:10 FrankA do loop. We have Mark joining us again. Thanks for watching mark.00:16:14 FrankI really should ask this.00:16:17 FrankBut unfortunately to be is a bit of a bit of A.00:16:21 FrankNot a nice word or not a professional word for LinkedIn.00:16:25Yeah.00:16:28 FrankBut they don't have enough memory. I think not at all.00:16:33No they don't.00:16:34 FrankBut it's an interesting. It's an interesting thing where you, you know, 'cause I'm a nerd. I have I happen to have all three different types, but you know, actually 4 if you count Siri. Let's see if Siri will do any better on the on the album question.00:16:49 FrankSo Andy, we actually have 4 special guests.00:16:52 AndyWow, thank you.00:16:54 AndyNot crazy, that's that's a new record.00:16:56 FrankHey Siri, who is the Wu Tang clan?00:17:03 Speaker 4Here's some information.00:17:05 FrankAlright, so she basically.00:17:07 FrankPointed to Wikipedia.00:17:13 FrankWhat was their first album?00:17:25 FrankSo it did the transcription.00:17:27 FrankWhat I said is good.00:17:30 Speaker 3I don't recognize this song.00:17:32 AndyOK oh OK.00:17:34 FrankSo I swear this it did work before, but I mean ultimately it's a very hard problem. In fact, one of the things that they showed a couple of years ago at ignite I or build.00:17:44 FrankThey showed this concept video of this lady talking to Cortana and it was on her phone.00:17:51 FrankMore on that in a minute. It was on her phone an as she was driving into work. She'd be like, Oh, remind me to tell this person.00:18:00 FrankYou know have a meeting with them.00:18:03 FrankAnd then the the logic would then go and then schedule the meeting through the through the outlook calendar and then tell her you know so and so rejected the request. But they are able to meet 30 minutes later. Is that OK? Yes, oh and invite so and so to this meeting as well.00:18:20 FrankRight,...
undefined
Sep 12, 2020 • 35min

This, Too, Shall Pass

This episode is entitled "This, Too, Shall Pass" and it was recorded Tuesday the eighth of September in this foul year of our Lord two thousand twenty. Frank and Andy tend to wander off the old conversational trail. But you knew that already. Thanks for listening to the Data Driven podcast.  Visit us on the web at datadriven.tv and be sure to like us on Facebook. (Bonus points to you if you caught the Hunter Thompson reference in the intro)Recorded Live:https://www.youtube.com/watch?v=Tevc7Wr68OETranscription Coming Soon
undefined
Sep 4, 2020 • 6min

*DataPoint* Did We Just Replace a Human with AI?

In this DataPoint, Frank examines whether or not the new AI voice over tech really replaced a human or did it open up new creative options instead?Transcript Speaker 1 Hey, what's up? It's Frank here. Speaker 1 From data driven the podcast where we explore the emerging fields of data science machine learning and artificial intelligence, so the title of this data. Point is did AI take just take away someone's job. Well, yes, and no so here's an example so. Speaker 1 So rather, quantum answer, isn't it right? It's both yes and no at the same time. See what I did there? So this is actually in regards to the voice over artist that we used to have on the show, but for both data driven and. Speaker 1 Impact quantum but. Speaker 1 I just recorded something today for impact quantum, so this isn't this isn't just a cheap kind of product placement for the other show. This is a serious thing, so if we go and we listen to this. Speaker 2 Hello and welcome to this episode of impact quantum. This episode is titled freaking cubits how do they work? Speaker 1 So basically that is an artificially an AI generated voice that we've been using. Speaker 1 Probably since the three year anniversary prior to that we used someone an voiceover artist I found on fiber called shifty pop. Awesome work that she does. Speaker 1 Um and her turn around is pretty quick too, but. Speaker 1 She also doesn't do voiceover work anymore. She just singing kind of stuff which is still cool. So definitely check her out and tell her data driven center sent you. But the key here is that. Speaker 1 We would love to be in a position where budget Wise. We could have a voiceover artist custom do this. But just was never practical right for every show, however, with the AI. Speaker 1 I can. Speaker 1 Create a custom intro for every show and eventually a custom outro outro at the end too. Speaker 1 See we've done that were on data driven a few times an every episode of impact quantum has been that now part of that is just you know, practical right so I can type up what I need to type have the voice over artist say tweak the voice settings or whatever, although we have kind of a setting we like. Speaker 1 And hit generate and I have a wave file right away for MP3 actions. What generates. Speaker 1 Right away, right? So I have that instantaneous feedback, right? So there's the time and it doesn't cost me anything extra to do that. I I I spent $30 or something on some web based platform so it can actually pull in voice wave voice generation capabilities from Google, Amazon as well as as Azure so I have. Speaker 1 All that ability kind of depict the voices. Pick the accents. I can even do a child's voice a man's voice. I mean, it's obviously a lady's voice. I can do that. I can do that right away. I paid for it basically one time and I can get that. So in a sense. Speaker 1 I was actually having a discussion with my manager. Actually, wow, you've put somebody out of work. Speaker 1 And yes and No. Speaker 1 So I hired a voiceover artist three years ago. Speaker 1 Yeah, 3 1/2 years ago an I paid her I think was like ended up being $50 or so. So for less than the cost of re engaging her to do a voiceover I now can create custom voiceovers with different voices, different accents, different gender. Speaker 1 I can do all sorts different ages. I could do all sorts of things there, where as before I, I guess. I guess I could go through fiber and find that selection, but I can't do it on demand and a lot of case you haven't figured this out by now. A lot of what Andy and I do is ad hoc. We don't really do we do preparation, but not to the degree that I think. Speaker 1 We present it, we do so I think that what what? This gives us the agility an the cost point. So in a sense yes. did I replace a human being with an AI generated voice? Yes I did, but I wouldn't say that. Speaker 1 I put her out of work because I wasn't going to engage her anyway because it $30 to $50 or more per engagement. Speaker 1 Wasn't going to do it anyway. Speaker 1 Right, so this gets into that. That real question have I replaced? Speaker 1 A person and the answer is yes and no. In in, in the strictest sense, yes. But honestly, I really wasn't going to engage her for at least another year to do another voice over. Speaker 1 You know the podcast isn't well monetized right now. Speaking of monetizing. Speaker 1 You can check out this cool shirt I'm wearing. If you're watching the video, it's the data graffiti shirt. Just search for it on Amazon data graffiti. It looks an awful lot like the obey stickers you might have seen up and down East Coast, and I think I've seen it in London a few times. Speaker 1 Once you see it, you'll kind of. It'll trigger your memory. Also, we are looking for sponsors, so if you want to sponsor this show, hit me up. Speaker 1 But so in a sense. Speaker 1 AI has opened up an opportunity for us that was really kind of closed before. Speaker 1 And I'm sure there's a fancy economic word or economic model for this, but this is just something AI has enabled that really wasn't going to spring the money for a custom voiceover. Speaker 1 For every show. Speaker 1 So I don't know. I think this is worth further discussion, but I also think you know it's not exactly. Speaker 1 It's not as a clear cut answer yes or no. It's it's very quantum if you will. Speaker 1 So with that. Speaker 1 I'm going to. Speaker 1 Wish you a good day and hope you have a great weekend. 
undefined
Aug 14, 2020 • 43min

Frank and Andy Go Quantum

Like Star Trek in the 90s we are creating a spin off series.The new show is called Impact Quantum and will focus on quantum computing.Additionally, Frank and Andy explain how they keep creating content despite having full schedules.
undefined
Jul 29, 2020 • 1h 20min

Careers in Data Predictions, Transforming Organizational Culture, and DIY Solar Power

In this episode, Frank and Andy talk about why Data Engineering may be the next hot career, how Microsoft's culture has changed, and Frank's solar power experiments.Transcription & show notes coming soon.
undefined
Jul 9, 2020 • 28min

The 3 R’s of the 2020s: Robots, Retail, and Reskilling

In this episode Frank and Andy talk about the "three Rs" of the 2020s: robots, retail, and reskilling.Original live stream link:https://www.linkedin.com/posts/frank-lavigne_data-driven-live-robots-data-and-retail-activity-6687056930667548672-tVKqTranscriptioncoming soon
undefined
Jul 6, 2020 • 9min

*DataPoint* Robots at Walmart

In this Data Point, Frank sees a robot patrolling the aisles of his local Walmart and gets excited.The robot scans shelves and helps identify what needs to be restocked and what's out of place.https://www.businessinsider.com/walmart-adding-robots-help-stock-shelves-to-650-more-stores-2020-1
undefined
Jul 1, 2020 • 1h 2min

3 Year Retrospective

In this episode, Frank and Andy share their thoughts on three years of podcasting, stoicism, and climbing Mount Royal.Show NotesThis is the first show that we recorded via live stream. It also marks the debut of our AI voice over talent.SponsorGet a free audiobook on us at http://thedatadrivenbook.com/Transcription (AI Generated)The following was generated by YouTube's caption system.0:00:03.200,0:00:15.540hey Andy how it's going good how are you0:00:06.600,0:00:16.830good I'm seeing a black screen and for0:00:15.540,0:00:21.779some reason the audios being piped0:00:16.830,0:00:27.150through you know are you input should be0:00:21.779,0:00:29.640my my camera does on the pair of B let0:00:27.150,0:00:36.480me try turning it off and back on again0:00:29.640,0:00:40.670I know you have a call so for those of0:00:36.480,0:00:43.440you joining us on YouTube and our0:00:40.670,0:00:45.989Facebook live page Andy and I are doing0:00:43.440,0:00:49.039an experiment and what's data science0:00:45.989,0:00:53.489without experiments right Andy so true0:00:49.039,0:00:55.980so how's my audio your audios awesome0:00:53.489,0:01:00.469okay could you hear0:00:55.980,0:01:05.700all right I've turned my camera on main0:01:00.469,0:01:07.680using the app that came with it so the0:01:05.700,0:01:10.350software that we were explaining for0:01:07.680,0:01:14.220folks and for you Andy I'll bring our0:01:10.350,0:01:18.960listeners into this the image we haven't0:01:14.220,0:01:20.790started three years ago plus or minus a0:01:18.960,0:01:27.229few weeks we wanted to hold off on the0:01:20.790,0:01:30.060celebrations for a number of reasons and0:01:27.229,0:01:33.840we originally envisioned this show to0:01:30.060,0:01:37.110become a video podcast so technology and0:01:33.840,0:01:40.770costs have come down that if Sumi Annie0:01:37.110,0:01:45.360gets his camera going we will be able to0:01:40.770,0:01:49.770do there we go I see yeah I am here I0:01:45.360,0:01:53.250found the Settings button awesome so0:01:49.770,0:01:58.229this is good this is good so we have the0:01:53.250,0:01:59.219ability now to kind of do something more0:01:58.229,0:02:01.350long a lot to think what we were0:01:59.219,0:02:03.719originally envisioned so as awesome as0:02:01.350,0:02:05.520you may think the show has been we0:02:03.719,0:02:08.929actually had even we had even grander0:02:05.520,0:02:11.489plans so this is just an experiment0:02:08.929,0:02:12.770might even put this live on the feed is0:02:11.489,0:02:14.420kind of like a0:02:12.770,0:02:17.300call it a data point how about that Andy0:02:14.420,0:02:18.860I like it I like that a lot because the0:02:17.300,0:02:21.770advantage is that because I'm using a0:02:18.860,0:02:24.110product called restream that I can pipe0:02:21.770,0:02:25.340two different output so this is actually0:02:24.110,0:02:28.190going to Frank's world TV YouTube0:02:25.340,0:02:31.400channel our Facebook live feed and0:02:28.190,0:02:35.180because of the magic of automation this0:02:31.400,0:02:38.930is also going to be I'm actually going0:02:35.180,0:02:41.360to once this ends will see that it0:02:38.930,0:02:45.530should pick up the arm the video feed0:02:41.360,0:02:47.570from Facebook and then pipe that into an0:02:45.530,0:02:50.870mp3 file which should be ready for0:02:47.570,0:02:56.180upload to the scene so again it's data0:02:50.870,0:02:57.490science right in data magic it's not0:02:56.180,0:03:01.400science0:02:57.490,0:03:03.890I told that to customers a lot like you0:03:01.400,0:03:05.690know it's ok to fail because it's called0:03:03.890,0:03:09.740data science it's not in Dean in the0:03:05.690,0:03:11.660perfection so you know and and silently0:03:09.740,0:03:13.700calling it science what you say well it0:03:11.660,0:03:19.010failed but you know we weren't sure it0:03:13.700,0:03:20.600was gonna work so it's kind of so how's0:03:19.010,0:03:23.270it going I know you have a call in like0:03:20.600,0:03:27.380five minutes but yeah it's I'm I'm0:03:23.270,0:03:29.150waiting on someone and if they if they0:03:27.380,0:03:32.000don't show up that that's ok they're0:03:29.150,0:03:34.010busy it's a regular call with with0:03:32.000,0:03:37.190someone who subcontracts with me and0:03:34.010,0:03:39.620he's older but he is a data scientist as0:03:37.190,0:03:42.140well and he sometimes gets distracted0:03:39.620,0:03:43.550heads down that's why you pinged me0:03:42.140,0:03:45.080about five minutes till the call I was0:03:43.550,0:03:46.280like well I got a call in five minutes0:03:45.080,0:03:50.510five let's do it0:03:46.280,0:03:53.180I was upstairs drinking coffee when I0:03:50.510,0:03:55.310messaged you and I'm glad you did0:03:53.180,0:03:56.810this is our oh I like this Frank this is0:03:55.310,0:04:01.370you're right this is our vision that's0:03:56.810,0:04:02.960why we registered data-driven dot TV so0:04:01.370,0:04:04.700okay there's another reason we want to0:04:02.960,0:04:07.340register theirs right there's a reason0:04:04.700,0:04:08.930why we're distr dot TV but the real0:04:07.340,0:04:13.340reason we didn't do coms because it was0:04:08.930,0:04:16.460taken so well there was that full0:04:13.340,0:04:18.020transparency minor and convenience minor0:04:16.460,0:04:19.670inconvenience I turned it into a0:04:18.020,0:04:21.950potential opportunity to make it into a0:04:19.670,0:04:25.070video podcast but the and0:04:21.950,0:04:28.010look here we are so don't give up on0:04:25.070,0:04:29.450your dreams kids that's right no things0:04:28.010,0:04:33.200are things are going good here today0:04:29.450,0:04:35.170Franco a little busy it's um it's an0:04:33.200,0:04:38.900interesting time to be an entrepreneur0:04:35.170,0:04:42.410right in technology it's it's usually0:04:38.900,0:04:46.520feast or famine but there's a lot of0:04:42.410,0:04:47.690factors kind of weighing in on all of0:04:46.520,0:04:50.480that today0:04:47.690,0:04:53.990I think 2020 has been that kind of year0:04:50.480,0:04:58.040where it's just been you know one thing0:04:53.990,0:05:02.000after after another but Frank you and I0:04:58.040,0:05:04.070are both people of faith right and what0:05:02.000,0:05:07.070I say when it's good times and bad times0:05:04.070,0:05:08.960is you know we're in God's hands and a0:05:07.070,0:05:13.760lot of people don't like us mixing that0:05:08.960,0:05:15.830kind of stuff that way if you're if0:05:13.760,0:05:19.300you're don't believe in God then you0:05:15.830,0:05:22.940know you can take the stoic approaches0:05:19.300,0:05:25.100um anyway I mean well and we have you0:05:22.940,0:05:27.410know we had I remember a couple of0:05:25.100,0:05:29.090people that we interviewed brought that0:05:27.410,0:05:31.700up brought up the stove approach Brent0:05:29.090,0:05:35.930those are stands out right right0:05:31.700,0:05:38.870Raven the last one so and in Bob Ward0:05:35.930,0:05:41.960spoke a lot about his face right all0:05:38.870,0:05:43.580right at the end of it and I'm gonna go0:05:41.960,0:05:48.950I'm gonna go out on a limb and say I0:05:43.580,0:05:50.630still believe this room I mean something0:05:48.950,0:05:52.130I read it might have been from talev but0:05:50.630,0:05:53.240wasn't in one of his books it might have0:05:52.130,0:05:59.060been like a tweet or something like that0:05:53.240,0:06:01.880you know that wars and plagues happen so0:05:59.060,0:06:04.490frequently in human history yet we're0:06:01.880,0:06:06.350still surprised when they happen yeah0:06:04.490,0:06:09.320and that kind of that kind of stuck with0:06:06.350,0:06:10.820me and and you know if you are person of0:06:09.320,0:06:13.280faith Amen that's cool if you're not0:06:10.820,0:06:17.720that's cool too we all have to live on0:06:13.280,0:06:24.130the same planet we did until Mars is an0:06:17.720,0:06:27.230option then we'll share too but I mean0:06:24.130,0:06:28.910you know as someone you know you all0:06:27.230,0:06:31.850know I mean I don't not everyone knows0:06:28.910,0:06:35.630but you know I was at the World Trade0:06:31.850,0:06:38.780Center I had PTSD0:06:35.630,0:06:44.510and one of the lasting legacies is a0:06:38.780,0:06:49.340PTSD is kind of the the overreaction to0:06:44.510,0:06:51.740stress now to say the 20/20 has been0:06:49.340,0:06:55.040stressful here both for family reasons0:06:51.740,0:06:59.870I'm kind of side this is an0:06:55.040,0:07:05.210understatement and you know I you know I0:06:59.870,0:07:07.220it's it's it's very easy to cower and0:07:05.210,0:07:09.200kind of like just zone out and I've done0:07:07.220,0:07:10.820that like you can figure out when that0:07:09.200,0:07:12.290happened when if you would look at the0:07:10.820,0:07:15.290blog when kind of the post kind of0:07:12.290,0:07:18.620dipped as well as the podcast when we0:07:15.290,0:07:21.760didn't record but kind of I had this0:07:18.620,0:07:25.370moment of of clarity that you know0:07:21.760,0:07:27.140reading reading uh things you know about0:07:25.370,0:07:29.800stoicism it was a really good book0:07:27.140,0:07:32.990called the obstacles the way yeah and0:07:29.800,0:07:34.670you know there are two things in this0:07:32.990,0:07:36.230world right there's one way to look at0:07:34.670,0:07:38.480I'm paraphrasing but basically things0:07:36.230,0:07:40.310you can control and things you can you0:07:38.480,0:07:43.490know so things you can control0:07:40.310,0:07:48.050well you know laying in bed all day it's0:07:43.490,0:07:49.220not kind of fix it right and things you0:07:48.050,0:07:51.680can't control0:07:49.220,0:07:55.180you can't do anything about it so at0:07:51.680,0:08:00.560some point I kind of this thought that0:07:55.180,0:08:03.110how can I make this how can I be a0:08:00.560,0:08:06.160better person despite all this how can I0:08:03.110,0:08:08.000be a better father how can I be a better0:08:06.160,0:08:09.590technologist not gonna be better like0:08:08.000,0:08:14.270human being just in general right0:08:09.590,0:08:15.890because you know I I've listened to a0:08:14.270,0:08:17.750lot of Tony Robbins over the years and0:08:15.890,0:08:20.270some people like him some people hate0:08:17.750,0:08:21.560him but one of the things he says that0:08:20.270,0:08:23.750the quality of your life is largely0:08:21.560,0:08:28.880determined by the questions you ask0:08:23.750,0:08:32.930yourself and we're really off topic here0:08:28.880,0:08:35.120that's okay we live in a very odd year0:08:32.930,0:08:37.219but I mean you know if you ask yourself0:08:35.120,0:08:39.740constantly why is this happening or why0:08:37.219,0:08:44.390is this being allowed to happen by you0:08:39.740,0:08:46.550know some divine entity you you're going0:08:44.390,0:08:49.500to get answers that lead I think to0:08:46.550,0:08:52.950despair but if you ask your0:08:49.500,0:08:54.900self questions of how can I use this to0:08:52.950,0:09:00.180be a better person what can I learn from0:08:54.900,0:09:02.490this you're gonna put your head in a0:09:00.180,0:09:05.250better place now I'm not saying that's0:09:02.490,0:09:09.570gonna magically solve everything but0:09:05.250,0:09:10.520honestly and if falling apart isn't0:09:09.570,0:09:14.640going to help anyone0:09:10.520,0:09:18.620it's interesting the where you know0:09:14.640,0:09:22.080where the euler's overlap between0:09:18.620,0:09:24.270stoicism and and faith and where they0:09:22.080,0:09:25.830don't right and I think it's you know0:09:24.270,0:09:27.030it's a it makes it's important0:09:25.830,0:09:29.820distinctions and I think there's0:09:27.030,0:09:31.980different flavors of both stoicism enter0:09:29.820,0:09:34.380or is it a Venn diagram well I think0:09:31.980,0:09:39.300this would that you could probably get0:09:34.380,0:09:40.650away with a ban on this although since0:09:39.300,0:09:44.070we're doing experiments let me try this0:09:40.650,0:09:49.440let me try this yeah do your pen thing I0:09:44.070,0:09:51.180see your pen I got my pen and let me0:09:49.440,0:09:53.820make sure customer notes I had a huge0:09:51.180,0:09:56.190customer engagement yesterday which is0:09:53.820,0:09:58.440why my LinkedIn live feed yesterday was0:09:56.190,0:09:59.670kind of like it was short because I had0:09:58.440,0:10:02.850to pick up the one of the kids from0:09:59.670,0:10:05.670daycare but okay I leave my frame was0:10:02.850,0:10:08.250pretty much melted I miss Frank and and0:10:05.670,0:10:09.960while you're bringing that up no I don't0:10:08.250,0:10:13.860know if the our listeners know it or not0:10:09.960,0:10:17.160but I've been doing twitch yes oh you0:10:13.860,0:10:20.250see that screenshot I said I I think I0:10:17.160,0:10:22.410did well you send me a bunch Frank let0:10:20.250,0:10:24.180me finish this fuck I spend I spend a0:10:22.410,0:10:26.760while stop forehead let me scroll up the0:10:24.180,0:10:31.320one I think I said there whose is it's0:10:26.760,0:10:33.480not the profile one is it no let me0:10:31.320,0:10:36.120finish this is one of you on art there's0:10:33.480,0:10:38.040another view on live there you are0:10:36.120,0:10:41.610alright update assurance I want to do a0:10:38.040,0:10:44.280joke okay do a joke so this is your0:10:41.610,0:10:46.200right I think it is ven em no no I0:10:44.280,0:10:56.790spelled it I spilled it all out because0:10:46.200,0:10:57.270you'll see okay bad movies diesel it's a0:10:56.790,0:11:00.310joke0:10:57.270,0:11:06.320I don't know0:11:00.310,0:11:09.470yeah it is it is actually then and I0:11:06.320,0:11:12.020think it's to ends but this is cool so0:11:09.470,0:11:17.060we can actually do we can go further the0:11:12.020,0:11:18.230original vision in terms of you know0:11:17.060,0:11:19.240doing architectures and stuff because0:11:18.230,0:11:21.590when you're talking about data0:11:19.240,0:11:24.560engineering aspect especially in some of0:11:21.590,0:11:28.820the more esoteric kind of mathematical0:11:24.560,0:11:31.490concepts around data science in AI I0:11:28.820,0:11:33.830think having that whiteboard will...
undefined
Jun 22, 2020 • 1h 1min

Bob Ward on SQL, Faith, and the Dallas Cowboys

In this episode, Frank and Andy talk with the legendary Bob Ward.Links Sponsor: Audible.com - Get a free audio book when you sign up for a free trial!Notable QuotesOn playing the "plague or pollen" game. (02:30) Regarding sportsball... (05:30) Virtual is the new norm. (06:30) Bob and Azure (07:30) Frank caught Bob in person at Microsoft Ready (08:15) On sharing code...(9:30) Bob on SQL Server 2019 Big Data Clusters (11:00) ... and PolyBase (12:30) "Keep the data where it lives, access it through the language you're familiar with." - Bob on PolyBase (13:48) Regarding Synapse (14:48) ...even for AS/400... (18:20) PolyBase as an incremental migration strategy... (19:30) COBOL, and more COBOL, and Y2K (20:30) "Buck Woody works with me..." - Bob Ward (21:00) An aside about NFL Football teams and rivalries. (23:00) We all miss baseball. (23:50) "Did you find data or did data find you?" (25:00) How Bob was recruited by Microsoft 26 years ago (26:45) Anna Hoffman... (28:15) Bob's Book: SQL Server 2019 Revealed (31:00) "So this Bob Ward guy... he's kinda a big deal..." - Frank (32:45) "I have people like my wife to keep me humble." - Bob (34:00) "There's always somebody smarter..." - Bob (34:45) "The Silverlight apocalypse..." (35:30) "When I'm not working, I enjoy ____." (36:30) Some Good News (37:30) A Quiet Place (38:15) "I think the coolest thing in technology today is ____." (38:45) Bob started at Microsoft in 1993. (40:15) "There's no way somebody is going to put a SQL Server in the cloud." (42:00) FranksWorld.com (42:40) On remote training (44:00) "I look forward to the day when I can technology to ____." (45:30) "IoT-ness" - Bob, circa 2020 (46:40) "Share something different about myself." (48:00) "We're all screwing up!" (49:30) Grace is Greater, by Kyle Idleman (50:20) Bob on LinkedIn (51:30) aka.ms/bobwardms (51:45) aka.ms/sqlworkshops (52:30) Tom Clancy series (53:00) Sherlock Holmes series (54:00) Sherlock - BBC (54:45) "John Krasinski is a great Jack Ryan." - Bob (58:00)Transcript (AI Generated)Hello and welcome to data driven,thepodcast where we explore the emergingfield of data science. We bring the best mindsin data, software, engineering, machine learning and artificial intelligence.Now hear your hosts Frank Lavignaand Andy Leonard. Hello and welcome back to data driven.The podcast or we explore the emerging fields of datascience,machine learning and artificial intelligence.If you like to think of data as the newoil,then you can consider as well like Car Talk andwith me on his epic road trip down.The information superhighway is Andy Leonard.Although. I think we are now currently in lock downso that road ship and has been postponed.It has and wow what a you knowwhat an interesting time to live in right Frank.Right right, we are recording this on April 15th.You know it's serious when even the government postpones taxcollection.True, yeah today would have been the day that yourtaxes were doing US,but they pushed it back.I forgot three months formonths whatever. Yeah, yeah, three months,but it's in Julies coming up on my birthday.That's how I remember it.Like I need another paper.They give it kind of.Yeah exactly, but you know it's been an interesting dayhere.This I live in Virginia.You know? This uh, FarmVille,VA Ann. I imagine you may have gotten different weatherthan I did,even a little more odd for this time of year.This late in spring. It is extremely odd to have,uh, you know, an overnight temperature in the 30s.Not only that, but we saw flurries this morning.I believe this is the latest I've ever seen.Snow flurries. Just crazy.Well, you're at a higher elevation.I think I know. Western Maryland had some snow overnighttoo,so.It could be definitely could be,yeah. It's hilly here where I am.I'm a little little East of themountains. OK, but it isallergy season so we're having just loads of fun herewith that.How's things going with you Frank?How's the family well? Well,we'redoing good. We're allsequestered together, and Fortunately I don't live in New YorkCity anymore.In a small apartment. Otherwise,I think I probably would've lost my mind by now.Wow, yeah we my have allergies,and I think my older son is developing allergies,so we're playing the plague or pollen game.And so terriblegame to play, isn't it?Especially when you're outside.It's like, although I found that wearing kind of likeface masks and stuff does help the sneezing and actuallyin watery eyes.So yeah,actually does so.Yeah, I I.It's funny like I watch TV now and they showold clips or something andI'm like they're sitting too close together.And that's the truth. I've seen it.I'vekind of noticed that too.Soenough about enoughabout the stuff that'sgoing on with that. I have an announcement,Frank.What's your nationality? I amso excited about this. My 17 year old son StevieRay has been selected to present at SQL Saturday.Richmond is going to be a virtual event at nearlythe last Saturday of April to 25th.He came to me about a year ago.He's been going to these things with me for overhalf his life and he came to him 10 monthsa year ago and says I want to do oneof these. I think I can do a presentation.How do I go about it and I said,well? You know, pick something shiny as a topic.And he actually doubled up on that.He is presenting on how to install SQL Server 2017.On on Linux, running on a π three a RaspberryPi 3.And I was like, you know,you could have picked something hardermaybe. No, but he worked on this and it's been.I wouldestimate he's got 4 or 500 hours on it.I helped him out as much as I could withyou.Know like technical stuff, but I was mostly kind ofstanding back just to see if he was going todo this and he beat through it.Frank and he got it to work nice and rightafter that he put together.I think so too and I'm so excited we're I'mpresenting in the first slot a week from Saturday.He's presenting in a second right behind me and inthat same channel so.I just I'm so proud of him.You know these proud Papa moments,right? You gotta eat.These are totally, totally. I'llnever forget the day my.He was nine at the time he went.He was over to play date a friends house andhe fixed their router.So yeah,now soproud that's awesome. Well, Speakingof Speakingof being Super Smartand probably at a youngage to we are we are very honored today tohave.I'm going to say the Bob Ward on the showtoday as our guest.Bob works for Microsoft. He doesn't awful lot of speakingat the major major conferences is usually on the bigstage and in the big room.And doing keynotes and stuff.The only bad thing I think I can say aboutBob is I've seen him at the past summit afew times wearing a Dallas Cowboys Jersey.Goodness, gracious Bob. I don't know whatto say about that, but.Will will let you select.I'll confess, I'm aRedskins fan an you know,understand because I'lladmit it now. Onrecording, you know at least you're not an Eagles fans.Ican, you know, Redskins. Was this rivalry from years agoin the 70s right now?Not so much for us.It's the Eagles pretty much so.If you're an Eagles fan,I might have todrop off the call right now.But it it please I if you do not knowwhoBob Ward is Gogo, checking out,popping his name into you know into your favorite searchengine and check him out in my favorite search engineactually is is Bing so I can say that,but he's a lot of talks about data you doa lot of free webinars.You do a lot of speaking an you know youdo more than just talk about this.I know you're engaged with the future of SQL Server.And the data products I want to Azure and we'rejust honored to have you here Bob.Welcome today.I'm happy to be here.Thanks for thanks for inviting metoday. Appreciate it. While we sure appreciate your time.Tell us a little bit about what you've been workingon lately,what, what'scool, what's going on? You know?Of course, these are interesting times as you guys startedoff the call,so a lot of the things that I've been doingin terms of showing up at a big event personallyhave altered and changed obviously quite a bit,so there's a lot of pivot within Microsoft and evenoutside of Microsoft.But how do we do things more virtual and digital?I spent over the last year and a half leadingup to the end of last year on SQL 19.Our latest release of SQL Server.I mean, I was just immersed from this from thebeginning.Uh, an, which again landed ultimately in launching of theproduct last November,December. Over the Holidays, I'm up in Redmond when Icould travel back then the Redmond and I'm with myboss,but I'm talking about, you know,what should I focus on in calendar year 20 andhe's like you know what?It would be really cool if you could spend sometime in Azure,which I had done a little bit in the past,but not near as much.So lately I've been spending a little bit more timeon that space on the Azure Sequel space.Still doesn't mean that I'm not doing SQL Server,that's still my my pride and joy.My passion, right? So I heard you talk here atthe beginning about doing your son doing SQL Linux ona pie.I mean, that's amazing. I spent a lot of timeon the Linux side with SQL,spent a lot of time doing things with Linux fromcontainers and so forth.But yeah, doing little cloud work right now actually kindof a little bit of my focus in the lastfew months,so.Very. I'm sorry, go ahead friend.So I mayhave the distinction of attending one of your last publicin person talks,Bob. I was in the session you did delivered itready.OhOK it ready. Yes in February?Well it's funny because I did the ready thing andthat was when the virus situation was all kind ofjust just starting a little bit internationally.And so I was pretty comfortable that ironically I wentto Charlotte,NC at the end of February and I also wentto Charleston up to that.'cause my son lives in Charleston,SC. So I was there in Charlotte.I did a little bit of an event there inCharlotte and I did cover sequel 19 in Azure sequeland so forth.But yeah, it's it's interesting.You are ready. WhenI was there, OK?Yeah, great session, great session by the way I Iso for those who don't know ready is on.I think if they're if they're an active listener ofthe show that I did a couple of live streamsfrom ready.Outside the building, 'cause it's you know,super secret of course. It's an internal event for toget field people ready for technologies that are coming out.Yeah we even did a workshop there on if yougot a chance to be part of that but umone of the things I've pivoted on over the lastyear and doing more of it again this year aswell is making sure not just doing a talk whereI'm up there just bloviating on slides and just talkingabout technology and so forth but some real hands onstuff so you know we did a sequel 19 workshopat the past summit last year it all on GitHubit's all out there and so we kind of dida mini version of that ready very very popular 'causewe were teaching people hands on like how to usethe new sequel 19 features how to deploy your owncontainer was the container what is all this kind ofstuff right.Um, so we did all sorts of things like that,and that's a big pivot.Now for me is to make sure what I'm doinganything publicly or even internally.You know, can I get that stuff on a GitHubsite and make it readily available so people can tryit?That's a fantastic idea and absolutely love all of theseways.We can now share code,especially those of us who've been doing presentations for years.It's it's awesome when you could stand up there andtalk like you said you could talk about it formaybe 75 minutes.There's not usually enough time in a 75 minute slotto have everybody open their laptop and work through this,but it's awesome, especially when you can put it onthese markdown sites like GitHub,an Azure Azure DevOps. I've been using that a lotnow to kind of.I've got some code in one location,summon another. Love is that they can go through an.I've started sticking the slides up there,Bob Even so they can walk me through.My slides are for me right?All the notes are about say this then say thisthen do that.But it's it's incredible that we could do that.and I know from experience just an watching you speakat events like to pass on it that you did.It seemed to me maybe I'm maybe I'm out ofline here but tell me it seemed to be youfocused a lot on.On the clusters of the big data clusters in 2019,yeah. I mean, it's obviouslyone of the hero capabilitiesof SQL 19, so I talk about SQL lighting allup like I'm one of the few people in theteam to just cover everything we do in the productin 19, right? But one big folks have that inmy colleague Buck.Would you spend a lot of time in this aswell?One big focus of 19 is this big data clustertechnology.This is radical stuff. This is like you know,people are used to the SQL engine,which is great obviously. But then all of a suddennow we're installing Hadoop,were installing spark. We're combining it with big data technologiesall in a Kubernetes cluster,and people are like. I'm sorry,what did you say? Hadoop spark Kubernetes that's not asequel thing like?What do you mean? So for us to come outthere?And by the way, if you got a sequel license,you just get this thing like we just allow youto install this.So that's that's one of the things I focus alot of time on is try to make sure we'restill doing that.We're still trying to make sure we get the wordout that if you want to start building kind ofyour own data Lake within your environment and incorporate thesebig data technologies with SQL things like machine learning aswell big data clusters,this is probably a good solution for you.So yeah, that was, uh.Big focus of 19.Yeah, I will saythis is that I'm really impressed with the kind ofthe thinking.Is it in order to adapt to kind of thebig data world?How much engineering is got into updating and improving?Uh, and adapting to kind of this new,bigger data world that SQL Server is done.You know that big data cluster technology,onething about it, the heart of it,is that this technology called Poly base.You probably heard of right?And this? This is really us just kind of lookingat the landscape of the industry and realizing,hey, we'd love for everybody to store data in SQLServer like right ETL jobs and do all the convertedfrom all your data sources.But the reality is customer saying I can't do thatlike there's some reasons I really let it really can'teven move the data.So Poly base which started in 16 we just tookthat thing exploded it.We're like, OK, now you can use Poly based access.Anything you want. Literally with an odbc driver,let the day to stay where it is,but access it through like external tables in SQL asthat hub and then you know quite frankly customer saidlike well,I like that Hadoop thing,but I don't have a hoe to cluster laying aroundwere like OK,will just install one for you.You know, listens to do for you.You just copy files in there,like even petabytes of files.And you just access them like tables and will justmake it scalable andqueryable. Pretty cool. Yeah, that's awesome.That mean that excites me,because that's, you know. As a data scientist Emil engineer,you know, whatever you know,you want to call Maine.Althoughkeep it PG. Uh, you know.I mean that excites me.That kind of that beyond kind of the Relational Datastores.And you know that SQL Server is definitely catching up.One point is for those who are not familiar withPoly base,what would you be? Your kind of your elevator pitchfor Poly base?Keepthedata where it lives, access it through the language,or use 2T SQL. That's really what it comes downto.You know leverage or T SQL skills go access thisdata.Keep it where it lives.Run SQL queries. Looks like a table results.You know, brought back to you.That's really what it's about.Awesome,that's a great description.I would also want to.I wantto ask you a question.How does this relate to what we're seeing with synapse?It's a great question. Synapses,a complete platform as a service analytics...
undefined
Jun 16, 2020 • 3min

*DataPoint* Unplugging, empathy, and selfcare

In this DataPoint, Frank goes off topic.Transcript (AI Generated)Hey, what's up? It's Frank here from data driven.The podcast where we explore the emerging fields of datascience,machine learning, and artificial intelligence.I just wanted to take a minute to say I'mbasically.Uh. What's going on? The show we we've been bothkind of slammed.I've had some family issues I needed to take careof.I had the chance to release the show,but even all the Goings on last week or twoit seemed inappropriate thing.I just take a pause and reflect and I actuallyhad the chance today.To unplug, take a day off and.You know he was very refreshing,a kind of reconnect with my purpose.And realize, for instance, right now I'm I'm actually gettingmy car washed and it's been a long while andthey're going to do the interior and stuff like that,but. You know, we pull up in there like howit's going to be an hour.It could be an hour or more and I'm like.It's OK. I mean there's a lot of you knowwe went to a restaurant was a week ago.And,uh. You know it was pretty clear that they reducejust to take out,and I think as things slowly get back to.Normal. People are adjusting. People are stressed out.For many reasons, and I think that's the importance ofempathyright now. Any points of self care,I mean just I needed to have kind of adifferent work schedule this week because of some family commitments.But the key. Is I didn't have to really beunplugged today,but. I felt like I needed to and it definitelyhelp help me reconnectwith my purpose.Why we do the podcast all that stuff have anepisode going out,probably. Midnight or tomorrow. I'll work on getting it,edit it out and published and dumb.You know we're gonna. Do that and I've got areally good gas.Really great conversation. It was about data about.It was really. It was a great conversation and pouredit over a month ago an I hate when Ipulled off a show that long.Not really what I intended but here we are and.Just wanted to just say the most important thing youcan do for yourself,your family, but world is.Take care of yourself 1st and the second most importantthing you can do is be apathetic towards folks.Make sure that you know.Take a deep breath before you get upset.You know I was like I was like Oh myGod forsaken hour.He's like I could use it.Not a nice little shaded place were good and.There it is.

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app