The Public Face of Power BI, w/ Adam Saxton of Guy in a Cube

Raw Data By P3 Adaptive - Un pódcast de P3 Adaptive - Martes

Categorías:

He's just a guy in a cube helping people.  That's the simplest way to describe who Adam Saxton is.  He turned a childhood fascination for computers into an amazing career at Microsoft (he's currently a member of the elite Power BI CAT Team), he has a hugely successful YouTube channel, Guy In A Cube, with his partner Patrick LeBlanc, and is a respected fixture in the data community.  He sits down with the Raw Data Crew and talks about his origin story, the work he puts in for the YouTube channel, Power BI, life on the road, and everything in between.  Enjoy our conversation with Adam Saxton, he's A Guy In A Cube Guy In A Cube Website Guy In A Cube Twitter Guy In A Cube Youtube Episode Transcript: Rob Collie (00:00:00): Today, we welcome Adam Saxton, founder of, and co-creator, ongoing co-host of Guy in a Cube. I could just probably stop there. You know who I'm talking about. Amazing story. Really just sort of a gift to the community, so it's just really, really gratifying to get to spend... We were recording for almost two hours. Rob Collie (00:00:19): We talk about Power BI. Of course, we talk about Power BI. But really, we also focus a lot on just his story, like how did he find himself in this situation? What was his road that brought him here? How does he look at his job? How does he look at his two jobs? And I found it all incredibly fascinating. I finally got to ask him a bunch of questions. I've been meaning to ask for a long time, and I hope you enjoy it as much as we did. So let's get into it. Announcer (00:00:45): Ladies and gentlemen, may I have your attention, please? Announcer (00:00:49): This is the Raw Data by P3 Podcast, with your host, Rob Collie, and your co-host, Thomas LaRock. Find out what the experts at P3 can do for your business. Go to powerpivotpro.com. Raw Data by P3 is data with the human element. Rob Collie (00:01:07): Welcome to the show. Adam Saxton. How are you, man? Adam Saxton (00:01:12): Yo. Living the dream, my friend. Rob Collie (00:01:14): Living the dream indeed. Adam Saxton (00:01:16): Living the dream. Rob Collie (00:01:17): Yeah. I can get behind that. I think I could understand that. Adam Saxton (00:01:20): I got a roof over my head, my kids are healthy. I got no issues. Rob Collie (00:01:24): The fundamentals. Adam Saxton (00:01:25): Yes. Rob Collie (00:01:26): You got a pretty hot gig too. Adam Saxton (00:01:27): Can't complain. Can't complain. Rob Collie (00:01:29): Yeah. Yeah. Well, you know how it is? Adam Saxton (00:01:33): Yeah. Rob Collie (00:01:33): Always, always. Adam Saxton (00:01:33): There's always something to complain about. Rob Collie (00:01:34): You can always complain. Adam Saxton (00:01:35): Yeah. But seriously, living the dream there. From the day job perspective, it's an amazing job with a lot of freedom and it definitely pays the bills, and then I get to also do the fun stuff on the side for my passion. Wife is very supportive, so it's nothing to complain about really on that. There's people with much worse problems than what I've got. Rob Collie (00:01:57): Oh my gosh. Yeah. Like you said, the contrast between our work from home knowledge worker jobs and how good that is for all of us is just so, so, so in such sharp focus over the last year. In a way, our lives haven't changed. They have. Adam Saxton (00:02:16): I miss traveling. Rob Collie (00:02:17): Yeah. Adam Saxton (00:02:19): I want to travel again. Rob Collie (00:02:20): I miss seeing my kids. They're living the teenage life and so they're quarantining with their mom, who doesn't seem to have the same, I don't know, level of paranoia about this disease that my wife and I do. Adam Saxton (00:02:37): It's a problem when you're not on the same page. That could be disheartening. Rob Collie (00:02:39): Yeah, it is. But what it really is, I'm actually kind of grateful for it, because how are you going to fence in a couple of teenagers who are just now discovering the dating life and all of that? I'm actually sort of in a weird way, grateful that my ex is actually willing to take the risk. I don't know. It would just be unending conflict if they didn't have a place to stay. Adam Saxton (00:03:03): Right. Rob Collie (00:03:03): It sounds like I'm complaining, but actually I'm like, "Well, I do miss my kids," but even there, we lucked out. Even there, we lucked out. Adam Saxton (00:03:11): Yeah. Rob Collie (00:03:11): And that's crazy. Adam Saxton (00:03:12): I remember just some folks I talked to, because I'm like, "Oh, I work from home. My wife actually has a job where she works from home as well." Adam Saxton (00:03:20): And they're like, "Oh, because of COVID and all?" Adam Saxton (00:03:23): I'm like, "No, I've been working from home for years," so I'm like, "Nothing on that front changed." Rob Collie (00:03:27): Our whole company, we like to joke, we were working from home before it was cool. Adam Saxton (00:03:31): Yes. Rob Collie (00:03:32): Except we did travel. We did go and visit some people. We would visit our clients. So we've had to make that change. Adam Saxton (00:03:40): There's customers I work with, where one of them in particular, right before everything got shut down, I was actually planning with them saying, "I'm going to come out monthly," and then that didn't happen. Thomas LaRock (00:03:52): So I will say, you're talking about teenagers in COVID. I got a senior and a junior in high school. Adam Saxton (00:03:58): Yeah. Thomas LaRock (00:03:58): One of them really doesn't leave the house anyway, so no issues there. Adam Saxton (00:04:02): Yeah. I have the same situation. Sophomore in high school, her sweet spot is just laying on her bed, drawing, watching videos, playing games. She's basically my clone. Thomas LaRock (00:04:14): And we've been remote learning since last March. Adam Saxton (00:04:17): Yeah. Thomas LaRock (00:04:18): They sent all the kids home, then they tried to get through the end of the school year, remote learning, and it wasn't as good, but they put together a good plan here. And we were remote for the first four months and now they are hybrid. But we elected to keep our kids remote. We weren't forced to go back. Adam Saxton (00:04:36): Right. Rob Collie (00:04:36): My kids, they were exactly that. They were the digital life. They lived on their phones, they never left the house, and that was how it was for years. I was always kind of trying to encourage, "Well what about going out into the real world every now and then?" They really got into the real world right around the time of COVID. That's when they turned the corner. I'm like, "Ah, no." Adam Saxton (00:04:59): Yeah, that sucks. Yeah. My younger daughter, she's 13 now and she's always active and wants to ride horses, she wants to go hang out with friends, so it's really hard on her. But my older daughter, she's 15 going on 16, and she's like, "Yeah, I don't care. I don't like to people." Rob Collie (00:05:16): Yeah. Well, like I said, I was living that life as a parent and then in the space of two months, boom. Adam Saxton (00:05:22): Yeah, that sucks. That is tough. That is very tough. Very tough. Rob Collie (00:05:27): I'm discovering things like what, there's a Tinder for teens? What? Adam Saxton (00:05:31): Whoa. I didn't even know that. Rob Collie (00:05:34): The other kids meeting people on Tinder, it's like, "What?" Adam Saxton (00:05:39): That doesn't seem safe. Rob Collie (00:05:41): What about at Xbox? Just go back to being the Xbox recluse. Adam Saxton (00:05:46): Yes. Rob Collie (00:05:47): All right. So let's get back to talking about Adam. Enough about our kids. Adam Saxton (00:05:52): Yeah. Rob Collie (00:05:53): In our inaugural episode, Tom and I talked about how we first met and the backdrop for all of that was SQL Twitter. Adam Saxton (00:06:02): Yes. Rob Collie (00:06:02): When I first saw Guy in a Cube show up on Twitter, I'm like, "Hey, I recognize that face. That's A. Saxton." Adam Saxton (00:06:11): Yeah. Rob Collie (00:06:11): You know how you get this weird, crazy ability to recognize people based on Twitter? Adam Saxton (00:06:18): Funny story about the Twitter thing, because I absolutely agree. I met so much of, at the time it was the SQL family, and then it's expanded past that. The way I met folks and got to know some of the MVPs and other folks in the community was through Twitter. I remember being at PASS Summit one year and this big guy comes up to me, he's like, "Adam Saxton." Adam Saxton (00:06:37): And I'm like, "Hey, how's it going?" Adam Saxton (00:06:39): He's like, "Dude, it's great to finally see you face-to-face." Adam Saxton (00:06:41): I'm like, "Yeah." And I'm looking at his badge, I see his name. I'm like, "I have no idea who you are, dude. What is this?" Adam Saxton (00:06:47): He's like, "Oh, I'm SQL Chicken." Adam Saxton (00:06:49): And I'm like, "Oh, okay. I know you buy your Twitter handle. I don't know you by..." Because a lot of folks didn't even have pictures of themselves either, so I'm like, "I have no way to connect with who you are." Rob Collie (00:06:59): That's right. But you, when you were on Twitter as A. Saxton, it was a picture of you, wasn't it? Adam Saxton (00:07:04): Yeah. My awsaxton's always had a picture of me and then Guy in a Cube has not. Rob Collie (00:07:09): Okay. Adam Saxton (00:07:09): For a little while, I had my little animated picture, but then that changed also. Rob Collie (00:07:15): All right. So back in around 2010, 2011, in the early 2010s, what were you doing professionally? Adam Saxton (00:07:23): I was a support engineer in SQL support at Microsoft, and actually not working on SQL. They had four different groups that were part of the SQL support group. One was actual SQL engine, then there was this advance performance team, and then there was the analysis services team. And then my team, which was originally called the web data team, and we owned all of connectivity, so connecting to SQL and then all of the developer support, so ADO, ADO.NET. And it also included reporting services because they didn't know where else to put it. Rob Collie (00:07:58): It just totally belongs here. ADO, ADO.NET, reporting services. Adam Saxton (00:08:02): Yes, absolutely. Rob Collie (00:08:03): Yeah. Adam Saxton (00:08:04): It's a web product, so it's developer. Rob Collie (00:08:06): Oh, yeah. Adam Saxton (00:08:06): Sure. Rob Collie (00:08:07): Yeah. Adam Saxton (00:08:07): Sure. Rob Collie (00:08:07): Yeah. I didn't know that. I didn't know that you were Microsoft, even back in the day. Adam Saxton (00:08:13): Yeah. I started on the web data team. So actually, I started doing support for Microsoft when I was a senior in high school. I did that for four-and-a-half years. That was my job when I was a senior in high school, so that was a Monday through Friday, 3:00 to 7:00 PM. It was an awesome- Thomas LaRock (00:08:29): I'm sorry, you were a senior for four-and-a-half years? Adam Saxton (00:08:32): No, no, no, no. I started when I was a senior and I did that job for four-and-a-half years. Thomas LaRock (00:08:37): Okay. Okay. Adam Saxton (00:08:38): So, that was supporting. Yeah, I was a senior for four-and-a-half years and... Rob Collie (00:08:44): There's some sort of Matthew McConaughey joke in here. Adam Saxton (00:08:47): Yeah. Rob Collie (00:08:47): I get older, the queries stay the same age. Adam Saxton (00:08:51): That's it. That's it. But yeah, I was supporting. I started there supporting Windows 95 and then Windows 98, Windows Millennium. Rob Collie (00:08:59): What? Adam Saxton (00:09:00): Oh yeah. And then right into Windows 2000. Then I started getting developer skills at that point, and then I went off just doing different developer jobs, all self-taught. Then in 2005 I saw a job for a contractor position. It was in Charlotte. It was under a contracting name, the actual contractor, not Microsoft, but the way it read, I was like, "Man, that sounded like the Microsoft support." And it said web data. I didn't know what that was at that point. And then I went and it was support. So I started doing support as a contractor in 2005 on the web data team. And then 2006, I became a full-time employee. Rob Collie (00:09:35): Did you move to Charlotte for that? Adam Saxton (00:09:36): I did. I was living in Tucson, Arizona at the time. And then we relocated to Charlotte. We were in Charlotte for about a year and a half, and then we found out that there was a site in Dallas, Texas, the Las Colinas site. And my wife's originally from Texas, her family's outside of Houston, and so we relocated to Dallas, and that's when I got to meet folks like Bob Ward and Bob Dorr on the SQL side, and they basically became my mentors at that point, and it went from there. So I've been doing Microsoft for almost 15 years now. Rob Collie (00:10:08): Okay. Let's go back because again, another unknown thing I didn't know. Microsoft support. Adam Saxton (00:10:16): Yeah. Rob Collie (00:10:16): In high school? Adam Saxton (00:10:18): Yes. Rob Collie (00:10:18): All right. Adam Saxton (00:10:18): Yeah. So I started November 1996, is when I started doing that. Rob Collie (00:10:24): Oh my gosh. So I had started at Microsoft in Redmond in July 1996. Adam Saxton (00:10:28): Nice. Nice. Rob Collie (00:10:30): We're basically twins, you and me. Adam Saxton (00:10:32): Yeah. That was very IT-focused at the time, so it was all Windows, I was playing around on with Exchange Server and Active Directory, once that eventually came out. Rob Collie (00:10:40): That's what an average high school kid does. Adam Saxton (00:10:42): Yeah. Rob Collie (00:10:42): Just play around with a little Active Directory. Adam Saxton (00:10:44): Oh, yeah. Thomas LaRock (00:10:45): How does a high schooler get hired by Microsoft though? Rob Collie (00:10:47): So I built my first computer when I think I was 15. And then when I turned 16, I had to get a job. I was very passionate about the fact that I was not going to get a job in the food industry. So restaurants, grocery store, whatever. Nothing against that. But I was just like, "Look, I love computers. I want to work with computers. I'm going to get a job with computers." And in the mid 90s, it's still kind of new. If you were on the internet, if there was such a thing, it was AOL or CompuServe. It wasn't what we have today. Rob Collie (00:11:18): So there was a little retail shop that was in Tucson. It was called Egghead Software. I don't know if you remember that. It was a retail job, selling software. So I got a job at Egghead Software for a little bit. One of the guys I met working there, because they started a call center in Tucson, Arizona for support, he ended up working there and he called me up. He's like, "Adam, I think you would love this job. They're hiring some more people for Windows 95 support. Do you want to apply?" Rob Collie (00:11:46): So I was like, "Yeah, let's do this." Rob Collie (00:11:48): Then I came home one day and my mom was like, "Why aren't you at work?" Rob Collie (00:11:52): And I'm like, "I got a job with Microsoft." Rob Collie (00:11:53): She's like, "Don't lie to me." Rob Collie (00:11:54): And I'm like, "No, seriously look." So in high school, I have an orange badge for Microsoft and I'm a senior in high school and I'm studying for MCP. Rob Collie (00:12:05): That's so cool. I just didn't have any worthwhile hobbies in high school. The first PC that I had, I got it when I was a freshman in college. I had never really been all that into it. Adam Saxton (00:12:17): Yeah. So my first computer was a Commodore 64, 128 combo. And I had two five-and-a-quarter-inch floppy drives, and that was everything. Rob Collie (00:12:26): Two? Adam Saxton (00:12:26): Yeah. I remember programming on basic there. I was really just a video gamer. That's all I wanted. Then my dad ended up, he had a 386 and he upgraded to a 486 with a turbo button. I remember that. That was very exciting. So then he gave me the 386, and I was 11 or 12 at the time. He said, "Look, I'm going to give you this computer, but if you're going to use it, you're going to know how to use it." Adam Saxton (00:12:54): I'm like, "Okay." So I had to go through this tutorial on DOS 6 and it was Windows 3.0 and DOS 6. So I just learned how to do it and I was playing around with these commands. I'm like, "You know what? I'm going to do this on my dad's computer because it's a little faster." I said, "All right. Let me try this new command. What is this? F disk... Oh. Oh, crap. I don't know what that's doing. Right. We're going to turn that off." Adam Saxton (00:13:20): Then my dad comes home and was like, "Oh my God, my computer won't boot. What's going on?" Adam Saxton (00:13:23): And I'm like, "I have no idea." Rob Collie (00:13:25): Yeah. Adam Saxton (00:13:25): I'm like, "My computer's fine." So I learned all that stuff, and then by the time I was 12, I knew way more than he did. I remember he had a game, so this may bring back some memories. He had a game called Leisure Suit Larry. Thomas LaRock (00:13:40): Oh, yeah. Adam Saxton (00:13:43): All the pixels. One of the things they had, they had this kid protection in front of it where you had to answer these historical questions. Rob Collie (00:13:51): Yeah. Adam Saxton (00:13:51): And at the time I was in Pennsylvania and we had a basement and so the computers were down there. I'd yell up to my mom during the day because again, I'm 12 years old, we didn't have the internet, I couldn't just go look this up. So I was like, "Mom, which war was Franklin Roosevelt a part of?" Adam Saxton (00:14:07): And she's like, "I think it was World War II." Adam Saxton (00:14:09): I'm like, "Select." I'm like, "All right, I'm in." Rob Collie (00:14:13): Yeah. It had an adult level. The game became dirtier if you could prove that you were a grownup. Adam Saxton (00:14:21): Yes. That's how I hacked Leisure Suit Larry. I started with the social engineering. Rob Collie (00:14:27): Yeah, that's right. That's right. You also mentioned having the two, five-and-a-quarter-inch floppy drives on the Commodore. You were the shit back then. Adam Saxton (00:14:34): Yes. Rob Collie (00:14:35): Because you could make copies of games without having to swap disks every so many. Adam Saxton (00:14:39): Yeah. Rob Collie (00:14:40): Luke and I were part of that culture from the Apple two perspective. I never had the dual drive. Adam Saxton (00:14:46): I was PC all the way. So I remember when I was a senior in high school, there was also this issue at my high school where I guess someone deployed some virus. They were using, it was a Novell infrastructure. And they deployed a virus and I was pulled into this office or whatever. I was one of three people that they tagged as suspicious for this activity. I'm like, "Wow. Thank you. It wasn't me, but I appreciate that." Then there was this other time I came in and I saw my teacher scrambling, he was on his Mac. They all used Macs, and I'm like, "What's going on?" Adam Saxton (00:15:20): He's like, "Ah, it's just the network's just not working. Adam Saxton (00:15:24): I actually had a laptop. I was senior in high school working at Microsoft. I had a laptop and I'm like, "Well, what's going on?" Adam Saxton (00:15:30): It was like, "Well, no one on this floor is working." And they had the computer guy come into the room and he's messing around on his computer. And I'm like, "All right, well, if the whole floor is down, that ain't going to fix anything." So I told the teacher, I was just like, "Look, do you want me to look at it?" I'm like, "It's probably like an issue with the hub or the router or something. Where's it at?" Adam Saxton (00:15:51): The computer guy is like, "No, I can't take you to that. It's sensitive and you're not allowed." Adam Saxton (00:15:56): And then the vice principal came in and said, "No, just show him." So they walked me down to the janitor's closet and the broomstick... Seriously, I kid you not, the broomstick fell and knocked the power cord out of the wall. And when they plugged it back in, the whole floor was better. Thomas LaRock (00:16:10): Exactly. Adam Saxton (00:16:10): I was like, "You guys are stupid." Rob Collie (00:16:13): That's like a movie scene. Some sort of crisis going on, and then there's this outsider, and the outsider's just like, "I know how to fix it." And the there's the establishment that says, "No, we're not letting it..." But then someone comes in and overrules. Adam Saxton (00:16:26): Yes. Rob Collie (00:16:27): They say, "Give him a chance." Adam Saxton (00:16:29): Yes. Rob Collie (00:16:29): And the music swells. Adam Saxton (00:16:31): Dun, dun, dun. Rob Collie (00:16:33): Yes. Adam Saxton (00:16:34): You open the janitor door. Dun, dun, dun. Rob Collie (00:16:38): Yeah. That's right. That's right. Adam Saxton (00:16:39): People were like, "No way." Adam Saxton (00:16:41): That was like, "I swear to God, it was the classic trope of..." Yes. So one of the best stories I have from support. So the old modems. Even before the main modems, you had the coupler modems. Rob Collie (00:16:58): The ones like in more games. Adam Saxton (00:17:00): Right. So this guy calls up and he's just like, "Look, I'm trying to connect to my BBS server and every time it does, it just disconnects, it drops it. It used to work fine, but it just started not working." Adam Saxton (00:17:11): I'm like, "All right. Well, let's go through and let's see what it sounds like." Adam Saxton (00:17:14): So he starts doing it and you hear something in the background and I'm like, "What's that noise in the background?" Adam Saxton (00:17:21): "Oh, that's my parrot. I just got that a couple weeks ago." Adam Saxton (00:17:25): And I'm like, "Hmm, can you move the parrot to the other room?" And then all of a sudden, it starts working. It's like, "Oh my gosh." The parrot was mimicking the modem sounds. Rob Collie (00:17:35): Yeah, that's crazy. Is that on the flow chart? Like reboot, reinstall the drivers, move the parrot. Adam Saxton (00:17:43): Windows 95 and 98, it was always a clean boot, safe mode, or safe mode then clean boot. And then it's just bring it down to the simplest form, remove options and keep trying, and that's support. That's troubleshooting. Rob Collie (00:17:57): And then you get escalated to tier three. Adam Saxton (00:18:00): That's right. Rob Collie (00:18:00): Where they talk about "Well, talk to me about the pets." Adam Saxton (00:18:03): Yeah. Tier three is animal control. You got to... Rob Collie (00:18:08): That's great. That is really, a really a good story. Adam Saxton (00:18:11): There's many more. There's many more like crazy, weird. Oh my gosh. Rob Collie (00:18:16): I have the same sorts of stories about bugs. Adam Saxton (00:18:18): You mean software bugs. Yeah. Not real bugs. Not like an Indiana Jones bug moment in a tunnel. Rob Collie (00:18:24): If you get real bugs, I recommend you just get a parrot. That will hoover those things up. But sometimes the way that the real world conspires, chaos can leak into a finely-crafted system, in the form of a parrot in this case. Adam Saxton (00:18:39): Yes. Rob Collie (00:18:39): Just sometimes it's just beautiful, isn't it? Adam Saxton (00:18:41): Yeah. Rob Collie (00:18:42): It's just beautiful what can happen. Adam Saxton (00:18:44): Yeah. It's always amazing. That's the other thing I loved in the developer support side of it, just working with code and I got into memory dumps and going through all of that and just being able to logically, just follow it and trace it down and this is the line of code where the problem is, and being able to get fixes for that, and that was always fun. Rob Collie (00:19:04): Yeah. There's nothing more fun for me than going through a memory dump. Adam Saxton (00:19:08): Yes. I love the smell of dumps in the morning. Rob Collie (00:19:12): Yeah. I'm actually completely kidding. I've never once... Adam Saxton (00:19:16): I love memory... I live to go through a memory dump. Patrick. I remember my business partner, Patrick, we were in his basement one time. Microsoft had acquired, I don't even remember the name of them anymore. It was Dataviz or some third-party company we took over and ended up getting incorporated into a Power BI Report Server, and also SQL Server Reporting Services. Rob Collie (00:19:41): Datazen. Adam Saxton (00:19:41): Datazen. Rob Collie (00:19:41): You're talking about Datazen. Adam Saxton (00:19:41): That's it. Yeah, Datazen. Thomas LaRock (00:19:41): Datazen. Adam Saxton (00:19:42): There was this weird thing where they had their little builder thing and it was trying to get data, and he's like, "Why is this so slow?" Adam Saxton (00:19:52): I'm like, "You must be working with big data." I'm like, "What is it?" Adam Saxton (00:19:55): He's like, "It's like 30,000 rows in an Excel file." Adam Saxton (00:19:57): I'm like, "Whew, that's really big." So I'm like, "Well, just give me a memory dump. I'll see what's going on." Adam Saxton (00:20:04): And he's like, "What?" So we start looking at the dump and I'm like, "Oh no, here it is. Right here's the call stack. This is what you're doing. You're getting stuck in this weird loop. It's just really slow." Adam Saxton (00:20:13): He looks at that and he is like, "Dude, that's like the matrix. What are you looking at?" Adam Saxton (00:20:17): And I'm like, "Ah, I just see a blonde, brunette, redhead. It's fun." Rob Collie (00:20:19): Yeah. And then you point to this other place on the screen and you turn and look at him and go, "Naughty. Naughty." Adam Saxton (00:20:26): Yes. There was one time I was asking a guy, he wrote this third-party extension thing for Reporting Services, and he was claiming that it was fine. I'm like, "Look, this error is coming from your extension." Adam Saxton (00:20:41): He's like, "No, it's not." Adam Saxton (00:20:42): And I'm like, "Can you send me the source code for what you do?" Adam Saxton (00:20:45): "No, I can't send you the source code." Adam Saxton (00:20:46): I'm like, "Can you send me a memory dump?" Adam Saxton (00:20:49): "Oh yeah, I can send you that." Adam Saxton (00:20:50): I'm like, "All right." And it was .NET, so I'm like, "Oh, I'll just extract the binaries and here you go. It's on line 18." Adam Saxton (00:20:57): And he's like, "Oh, you're right. How'd you know that?" Adam Saxton (00:21:00): "It's magic." Rob Collie (00:21:01): Adam, I completely did not plan to ask this, but in your support days, you said up through Windows 2000. Did you ever end up crossing paths with supporting the Windows Installer MSI? Adam Saxton (00:21:14): Not on the Windows 2000 side, because I know that was a whole different architecture from the Windows 95 and 98 stuff. So I didn't end up actually dealing with any of that. It was right when I was going out was when they started bringing the Windows 2000 stuff. Rob Collie (00:21:28): Okay. 2000 was NT. It was the first time that they- Adam Saxton (00:21:31): Yes. It was the NT kernel. Rob Collie (00:21:31): It sort of thrown out the consumer Windows. Adam Saxton (00:21:34): Yeah. Rob Collie (00:21:35): Yeah. Adam Saxton (00:21:35): Bringing it together. Rob Collie (00:21:36): We could have really nerded out. You were saying that you've been into Active Directory and all of that. Yeah. I might actually have spent more time in total time in over career in Regedit. Adam Saxton (00:21:47): Yeah. Oh, yeah. Rob Collie (00:21:47): Than you. Adam Saxton (00:21:48): Yeah, probably. Rob Collie (00:21:50): Maybe. Adam Saxton (00:21:50): Maybe. Rob Collie (00:21:50): Just because of my two years in setup. Adam Saxton (00:21:52): I will say though, the experience of going through on the IT side and understanding things like Active Directory, networking, Exchange Server and having that foundation and then going into SQL support, because one of the challenges I've always had, even today, folks that are doing Power BI and when we're connecting to data sources, they don't necessarily understand everything involved in that pattern. And I'm like, "Look, it's a data source. We're going to go over the network. We're going to have some protocol to go get that. We've got to wait for it to come back. How many hops in latency do we have in between?" And just having that foundation has really helped to understand the whole picture and not just my funneled or little tunnel vision of whatever product I'm working on, and so just being able to go past that and play around with it. That's how I got into Kerberos. I love Kerberos. Rob Collie (00:22:43): Oh man. Oh gosh. Again, back in the early 2010s, everyone loved setting up Kerberos. Adam Saxton (00:22:51): Oh, SharePoint. Rob Collie (00:22:52): Yeah. SharePoint. Kerberos It's the worst thing ever. Adam Saxton (00:22:53): SharePoint Integration with reporting services. I knew everything about it because nobody else wanted to touch it. Rob Collie (00:22:59): Yeah. And Power Pivot for SharePoint, right? Adam Saxton (00:23:01): Yes. The gallery. The gallery with Silverlight. That was amazing. Rob Collie (00:23:05): Oh, yes, yes, yes. Adam Saxton (00:23:07): Yes. Good times. Rob Collie (00:23:07): I think Power Pivot for SharePoint was the peak awkward server product. It was- Adam Saxton (00:23:13): It was so awful. Rob Collie (00:23:14): Oh. Adam Saxton (00:23:14): It was so bad to set up and so fragile. Rob Collie (00:23:18): Yeah. At the company I was with, when I first left Microsoft, we eventually resorted to writing agents that were just constantly polling to see if various services had died. Adam Saxton (00:23:27): Yeah. Rob Collie (00:23:28): And if they had, forget trying to diagnose it, don't even try to get to root cause. Adam Saxton (00:23:33): Just no. Just restart it. Rob Collie (00:23:33): Just restart it. Adam Saxton (00:23:34): Just restart. Rob Collie (00:23:34): Restart it automatically. "Oh, it's out? It'll be back. It's no big deal." Adam Saxton (00:23:38): Yes. I actually had a blog post one time. I titled the blog post When in Doubt, Reboot. It just fixed it. It's not worth going into any of the other details. Rob Collie (00:23:50): And move the parrot. Adam Saxton (00:23:51): Yes. Move the parrot. Rob Collie (00:23:52): Definitely move the parrot. Adam Saxton (00:23:53): Move the parrot. Rob Collie (00:23:54): All right. Let's- Thomas LaRock (00:23:55): Woo. Adam Saxton (00:23:57): That was my 200-plus pound dog getting a little excited. Rob Collie (00:24:00): Oh, that's okay. That's okay. I've got a combined 200 pounds of dog. Adam Saxton (00:24:06): I have five dogs, but he's the biggest. Rob Collie (00:24:09): I have two dogs, four cats. Adam Saxton (00:24:13): I don't like cats. Rob Collie (00:24:14): Yeah. I didn't either for a long time. Adam Saxton (00:24:16): Yeah, nice. Rob Collie (00:24:16): Now I've converted. Adam Saxton (00:24:18): I will never like cats. Rob Collie (00:24:18): Yeah. You know how it is. Adam Saxton (00:24:20): I'm on the Power BI cat team, but I don't like cats. Rob Collie (00:24:23): You know how it is, if you don't like scotch and you're around someone that really likes scotch and you say, "I don't like scotch." You know what's going to happen is you're going to spend the next couple of hours drinking scotch. Adam Saxton (00:24:34): Yes. Rob Collie (00:24:36): And at the end of it, you're like, "Nope." Adam Saxton (00:24:39): I'd like to say that's how I got into Jägermeister, but that's not what happened. Rob Collie (00:24:42): No, that's not how anyone- Adam Saxton (00:24:44): I just got it and I'm a like, "Sure, I'll try it." I'm like, "Oh, this is delicious." Rob Collie (00:24:48): Oh, really? Adam Saxton (00:24:48): Yes. Rob Collie (00:24:48): It wasn't a lot of people standing around you, chanting, "Go, go, go"? Adam Saxton (00:24:52): No, this was the whole, the incident thing I was referring to earlier with, and Tom was part of that. Rob Collie (00:24:59): All right. Well, I do want to get to that. Adam Saxton (00:25:00): Yes, okay. Rob Collie (00:25:01): I want to get to that. Adam Saxton (00:25:02): Okay. Rob Collie (00:25:03): But just chronologically, I'm the worst about this, staying on topic. Adam Saxton (00:25:08): Yes, we're not there yet. Thomas LaRock (00:25:10): Okay. I'm going to get ready for it though. I'm going to bring up on Swarm- Adam Saxton (00:25:15): Yes, there is a check in on a location. Thomas LaRock (00:25:16): ... the Adam Saxton memorial washroom. Adam Saxton (00:25:19): Yes. I have a screenshot of that. Rob Collie (00:25:22): All right. You know what? Let's save this for late in the podcast. It's like the reward for people who stick around. Adam Saxton (00:25:28): Yes. Rob Collie (00:25:28): You know? Adam Saxton (00:25:28): Yes. Stay tuned till the end where you hear this embarrassing moment. Rob Collie (00:25:32): That's right. That's right. It's not like they have fast forward technology in podcasts. Adam Saxton (00:25:38): No. Thomas LaRock (00:25:38): There's nothing embarrassing about Jägermeister. Adam Saxton (00:25:40): No. But no, there's... Sure. Rob Collie (00:25:43): Okay. Look at that restraint. I saw it. Adam Saxton (00:25:46): Yes, sure. Rob Collie (00:25:47): I could feel that restraint. Adam Saxton (00:25:49): Yes. Rob Collie (00:25:49): Okay. So let's go back. Adam Saxton (00:25:50): It's taunting me. I want to jump right in and I'm holding back. Rob Collie (00:25:54): So you're awsaxton, you're on Twitter. Adam Saxton (00:25:58): I'm just a guy in a cube, doing the work. Rob Collie (00:26:01): Lower case guy in a cube, right? Adam Saxton (00:26:04): Yeah. Just, I was literally in a cubicle, in a Las Colinas, just doing support cases. Rob Collie (00:26:09): Yeah. I was laughing when you said, "I was supporting SQL, but not actually doing any SQL." Adam Saxton (00:26:13): Yeah, I wasn't doing SQL. Rob Collie (00:26:15): Yeah. Well, that's okay. At the same time I was a SQL server at MPB and wasn't doing any SQL. Adam Saxton (00:26:18): Right, yes. Rob Collie (00:26:19): That was just sort of what we did. SQL was this gigantic catchall branding thing. Data platform's probably more accurate. So a number of things change for you. If you fast forward to today. I don't have the chronology. Adam Saxton (00:26:32): Yeah. I didn't give you the timeline. Rob Collie (00:26:34): That's okay. That's what we're here for. We're here for the origin story. Adam Saxton (00:26:37): Yes. Rob Collie (00:26:37): That's what we want. Adam Saxton (00:26:38): Yes. Rob Collie (00:26:39): What was the vat that you fell into, or the radiation you were exposed to turn into your current form? Adam Saxton (00:26:45): I would say that that was Bob Ward is what did that. Rob Collie (00:26:49): Well, at a high level, there's really two questions. Number one, there's the transition from SQL, if you will, to such a strong presence in Power BI today. Rob Collie (00:27:03): ... to such a strong presence in Power BI today. Adam Saxton (00:27:04): Yep. Rob Collie (00:27:04): So, there's a very interesting, I think, evolution in even just in the type of technology that you work with. Adam Saxton (00:27:11): Yep. Rob Collie (00:27:12): A lot of people, and I don't trivialize this because a lot of people struggle with a sequel to Power BI transition, even though you wouldn't necessarily expect it. Adam Saxton (00:27:23): Well, I mean, It's a different mindset. Rob Collie (00:27:25): It's totally a different mindset. Adam Saxton (00:27:26): I know. Rob Collie (00:27:26): Right. It's not surprising to me really, but it was when I first encountered it. It was news but the other one is, obviously, the transition from support to essentially a public figure. Adam Saxton (00:27:37): Yeah. Rob Collie (00:27:38): So, there's the Guy in a Cube, Twitter handle and show and brand, and all of that. How do these things all come to pass? Adam Saxton (00:27:46): I love working with technology, I love working with people. When I was in the SQL support group, a lot of the foundations for that evolved there. I've been very fortunate in my career path since high school on, that I've always naturally had a mentor of sorts. Adam Saxton (00:28:02): I always hate when the forced mentor, when I was in support, they were like, "You need to mentor X, Y, and Z." I'm like, "That's not how this works." I'm like, "I love when it's more naturally, it just comes about." I've always been able to... I've been fortunate to just have that regardless of where I was, and in SQL support that person was Bob Ward. Adam Saxton (00:28:20): He was very active in the community. I didn't even know the community existed before him. I didn't even know that was a thing. I remember when I was doing just actual, just Web development on my own that when I hit an issue, I was like, "I scour the forums." I'm trying to figure out an answer. Adam Saxton (00:28:39): I'm trying to reverse-engineer things. I didn't even know you could call support for help. I ended up working in support where people would have those problems and call up for help. I'm like, "I didn't even know that was the thing." I'm like, "Wow, that was amazing." Adam Saxton (00:28:53): So, I go through that, I get introduced to SQL PASS, and the SQL community at large get into Twitter. I start blogging because Bob asked me to start blogging with him and Bob adored. So, I'm giving back, I love that action. In support, we had this mantra of, they called it front of the funnel. Adam Saxton (00:29:13): So, what can we do for case deflection? At the time I was like, "Well, blogging is great because it's a one-to-many activity. I can just get it out there. People can search for it and find it." Then, that got to a point we did in this internal training, we called them triages where we spent an hour, someone would present on a topic, "How do you troubleshoot something?" Answer some questions. At that point, I'm like, "This is weird." Adam Saxton (00:29:39): I'm like, "This is great information to get out there." I would say 80-90% of it is not confidential. It's just like, what logs do you collect? What do you look for in the logs? Then, what do you go? What settings do you go change to address the issue? Nothing confidential. Adam Saxton (00:29:55): So, I was sitting there one time and I was just like, "You know what? I'm going to try this YouTube thing." Because I was doing the blogging. I was doing that, once a month I would do a blog. I'm like, "What if I did a video with the blog?" I'll start this YouTube channel, but what do I call it? I could have called it Adam Saxton, but I'm like, "I want something else." Adam Saxton (00:30:15): So, Bob would always say, we joke with him because he was the senior technical leader. He was like this principal architect, big poobah kind of person in the group. So, we'd always joke with him like, "you're up on high. We're just the folks in the trenches. This is what we do." Adam Saxton (00:30:33): He would always laugh. He's like, "Dude, I'm just a guy in a cube." We were all in cubes at the time. He's like, "I'm just a guy in a cube." So, I was like, "Man, if I steal that?" He's like, "What do you mean?" I'm like, "Well, I'm creating this YouTube channel and I want to do a branding thing." I just want to call it Guy in a Cube because I aligned with him in his mentality of approaching that stuff. He's like, "Yeah, that's fine, whatever." Adam Saxton (00:30:53): I remember, he and I talking, it was about a year or two ago and he's like, "I had no idea this would become this." I'm like, "I didn't, either. So, here we are." That's the philosophy I've had is I'm just doing the work. Even when I present, I'll say like, I'm a PM on the product team, I don't care about the title. The official title is Principal program manager. Adam Saxton (00:31:16): I never put the Principal in there. Other people will for me, I don't care about that. I'm just here helping you. I don't care where I'm at in the org chart. I'm just trying to help you fix something. That's what I like to do and that's what I've always done in support. Going in, that's what made me do the blogging, that's what made me do the video now for six years. That's what we're still doing. Rob Collie (00:31:38): I remember, Guy in a Cube used to be you. Adam Saxton (00:31:42): It was just me. Rob Collie (00:31:43): In a cube? Adam Saxton (00:31:43): This was part of the problem was I didn't have any forethought. I actually thought it was going to be shut down. So, when I first started, I told my... I love gear. If you can't tell, I know folks listening to this, can't see it. But most people understand that production quality on my end is very good. I like gear, I like spending money on gear. Adam Saxton (00:32:03): My wife knows that. When I first started doing, I'm like, "Yeah, I want to buy this, this, and this." She's like, "Let's hold on. Why don't we figure out if this is actually just going to be another six-month fad for you before we start spending a lot of money." Adam Saxton (00:32:18): So, I was like, "Fair enough." Then, I think, was two years into it, I was like, "I don't think it's a fad, honey." She's like, "No, you're right." When I went to go get the camera I'm on now for my main videos, I mean that's a $6,000 rig and she even... She's like, "Yeah, get it." I'm like, "Okay, let's get it." Rob Collie (00:32:35): The picture of your setup, your gear that you sent to us backstage, Luke was getting pretty jealous. Yeah. Adam Saxton (00:32:42): He and I were talking a little bit before and he was just like, "Oh my gosh." I was showing up because I've got all my stream. This is my actual live-stream setup. So, I can just touch of a button and do a bunch of things and it's amazing. Rob Collie (00:32:53): They didn't give Luke that level of gear when he was working at the radio station. Adam Saxton (00:32:57): Yeah. I know because they had to worry with budgets and all that. I don't care. I just spent money on stuff. It's the Banana setup. Rob Collie (00:33:06): Yeah. Adam Saxton (00:33:07): It was that evolution of like that's my passions now in life have become Power BI as a technology is a passion. Then, my other passion is turned into video production and the YouTube side of it. The fact that I can marry both of those together from Guy in a Cube standpoint is just, it's a love of doing it and that's what's kept it going. It's been an incredible journey on that front. Rob Collie (00:33:31): You did me without knowing it, you did me a huge favor. I just loved your early videos. It was so freeing to see the way you edited. Adam Saxton (00:33:40): I had no idea what I was doing. Rob Collie (00:33:42): But it Totally worked. There would obviously be splicing together of several takes in your videos. It was just like calm and confident the way you did it. Just no transition, no fade, nothing like that. [crosstalk 00:33:56] Adam Saxton (00:33:56): Just hard cuts. Rob Collie (00:33:57): Just hard jump cuts. Adam Saxton (00:33:59): That's The YouTube way. That's the thing is I've always looked at what others are doing to understand. That's how I learned. I learned by example and by doing it. At the time, I didn't know anything about video production or YouTube or anything. I didn't know. I went and bought Camtasia. How do I even use this? It's all self-taught. Even today, I'm still learning new things. I actually have a video editor now. Adam Saxton (00:34:28): Up until September of last year, I edited everything. Every all post-production was me. Patrick didn't do anything. All he did was turn on the camera, record it, drop it in this OneDrive folder and it just magically showed up on YouTube. That's all he ever did. People would always ask him, "What do you use to do all?" He's like, "I have no idea. Go ask Adam." Now, I've got a video editor so that has given a lot of my life back to me. Rob Collie (00:34:54): Let's talk about that. It's like when you make a movie, the actors have no idea how good the movie's going to be. Adam Saxton (00:35:01): Yep. Rob Collie (00:35:02): The movies are made in the editing room. Adam Saxton (00:35:04): Yep. Rob Collie (00:35:05): The same is true for YouTube videos. Adam Saxton (00:35:09): Yes. Rob Collie (00:35:09): So, it is hard to outsource the editing of your videos. Adam Saxton (00:35:17): It was like letting go of my baby. I like video editing. I do a weekly Roundup on Mondays. I'm still editing those because it's a really fast turnaround, but the video editors editing the main technical videos. I remember, Patrick first saw it and he's like, "Adam, you have to stop editing my videos." I'm like, "Yes, I agree. That's why we're doing this." I'm like, "Because they're better at what they're doing." Rob Collie (00:35:40): But it's still a challenge there. In that video editor, you find someone who's good at editing video, they don't come from your subject matter. Adam Saxton (00:35:49): Nope. Rob Collie (00:35:49): They don't necessarily have the same, I don't know, sort of tone in their fingers that you would... How do you sort of maintain the direction of the content? There's some edits you can make that actually will result in something that's misleading on a technical basis. Adam Saxton (00:36:05): Yes. Rob Collie (00:36:05): Right? Adam Saxton (00:36:05): Yep. Rob Collie (00:36:05): Even though it was a good video edit, how do you quality-control for that? How do you train and pass that kind of tribal knowledge off? Adam Saxton (00:36:13): I will tell you that. So, the video editor, it's actually a team of three people. So, I never know which one of that three people is actually editing the video. It's coming from their company. I will tell you that I've given little to no direction to them on any of it. We'll do an edit pass, so they'll put it up on Frame.io and I look over and I'm like, "Yep, good to go. No edits needed." There was one video, where it was super in the weeds. I think it was around Power BI embedded. So, it was like, they needed some help on that. Rob Collie (00:36:47): Yeah. Adam Saxton (00:36:48): But I've been very fortunate that they are very good at what they do. I think some of it also comes to the way Patrick and I go through the content and the way we lead through it, that it's fairly obvious where we're going. Adam Saxton (00:37:02): I think some of that is just the style that we've had, we try and make it as simple as possible. By doing that, even if you don't know anything about it, you kind of understand the context of where we're at and what we're doing. I think that's helped them from an edit perspective as well. Rob Collie (00:37:19): We're living that experience right now with the podcast, we really do a good job with it. I say we, I mean, Luke. Adam Saxton (00:37:24): Yes. Rob Collie (00:37:25): Outsourcing, post-production, it's easy to say. Adam Saxton (00:37:29): It's always interesting too. One thing I do miss also as editing Patrick's videos, he will comment on the videos too. He's like, "Oh my gosh, Adam. I'm so sorry, man. I totally... Just cut. Cut all this out." I'm like, "No, I'm going to cut this out." I'm like, "Yes. Obviously, you screwed that up." Adam Saxton (00:37:48): So, he'll add color to some of the things he's doing and it's great. He did this one thing and the first video that our video editor did, Patrick did this thing subconsciously, where he likes to use a phrase like, "Look, this is going to show you your ugly baby. You've got an ugly baby. Adam Saxton (00:38:04): You're not admitting it and we're going to show it to you." So, he did this thing. He's like, "Look doing this action is just going to give you a nice-looking baby." She put this whole Lego, little baby wrap over his arms. It was like, "Oh my gosh, that is so good." That was awesome. But he'll do those things, or he's a lot more spontaneous than I am. Rob Collie (00:38:26): I think, you're pretty spontaneous. Adam Saxton (00:38:29): When I brought him on though, I said, "Look, Patrick, we're both technical." He's very smart. But I said, "Look, I'm bringing you on for the entertainment. So, I'm more of the corporate kind of feel and you're the entertainer. We balance each other." Adam Saxton (00:38:42): That's why it's stuff that we present, it's always better when we do it together than if we do it separate because he's chaos and I'm order. He's funny and I'm more of the like, "Let's just get down to business." I've learned some things from him. He learns from me. It's a very good relationship on that front. Rob Collie (00:39:00): Well, let's continue the evolution. So, you started the YouTube channel while you were still officially in support. Adam Saxton (00:39:07): December, 2014. Rob Collie (00:39:09): Okay. Now, it's quote-unquote, just an unpaid side gig habit... Adam Saxton (00:39:15): Was a hobby. Rob Collie (00:39:16): Hobby. Adam Saxton (00:39:17): Labor of love. Rob Collie (00:39:17): Right. Okay. At some point along the way, it becomes a part of your official... I don't even know. It's such an untraditional arrangement. Adam Saxton (00:39:27): It's never been part of my day job. It's never been. Rob Collie (00:39:30): Okay. Your job changed at Microsoft at some point. Adam Saxton (00:39:35): Yes. Rob Collie (00:39:35): I don't know actually the details of the relationship of Guy in a Cube to Microsoft. Adam Saxton (00:39:41): Mm-hmm (affirmative). Rob Collie (00:39:42): What can you tell us about all of that? It's really kind of cool. Adam Saxton (00:39:46): Yep. Rob Collie (00:39:46): Not what I would expect. Adam Saxton (00:39:47): So, this is one of those things where I tell people, where this was something I never asked permission, I just started doing it. I'm like, "Look, I've got a passion. I see a need and an opportunity." From the Microsoft side, I've always looked at things. I'm like, "Look, I always have had the flexibility to do the right thing as it aligns to the business." Adam Saxton (00:40:08): Because that's what they care about is we need to make sure we're aligning to our core business priorities and what we're doing. As long as everything is met there, we have a ton of flexibility of what we can do, whether it's taking the initiative to do certain things and trying to help. So, I saw this as it's an opportunity. I'm not going to ask for permission. I'm just going to start doing the being mindful of the business. So, I'm not slamming Microsoft. I'm not. Adam Saxton (00:40:34): I'm being very thoughtful and just trying to help people. As part of that, I remember, right when I started doing the Guy in a Cube stuff, nobody knew who I was, from that standpoint. I already had a lot of relationships on the product team, just from the support interactions that I've had. I was on-site in Redmond with the engineering teams for a week. Adam Saxton (00:40:58): This was right when James Phillips came in, who's now the president of Business Applications Group, who owns Power Platform and Dynamics at the time though, he was brought on for Power BI. So, I just set up a one-on-one with him. I was like, "Hey, I'm in support. I want to make sure we understand the relationship and how in support can we help you from an engineering side? This Power BI thing is just going to be rolling out. Adam Saxton (00:41:22): We want to make sure that we're ramped up to be able to support this." Then, I also mentioned, I was like, "By the way, I've also started this video and I'm doing blogging, this Guy in a Cube thing, and I'm doing technical videos to help people out." He's like, "I love it. Sounds amazing. Keep doing it." I always thought marketing was going to shut me down because I've always done my own thing. I'm not necessarily aligning to the core messaging that they want to do, but no, even the marketing folks are telling me, they love it. It's great. Adam Saxton (00:41:51): I'm just promoting the product and helping people adopt it and whatnot. That went on and that's how I kind of became that Power BI guy. No one in support wanted to touch it because, in support, it's always about what are the call volumes that are coming in. What are we getting calls on, that's where we're going to go focus. I saw this Power BI thing. I'm like, "This is where the product team is going. This is the direction nobody's paying attention to it." Nobody is paying attention to it because we're getting no calls. Adam Saxton (00:42:23): This was in the original Power BI for Office 365 before what it is today. So, I said, "Look, I'm going to be that guy." So, I just started digging into it. I started meeting with the engineering teams. I'm like, "Okay, where are the specs for this? How does this actually work? What's the flow? How are these things connected?" I just started playing with it. Adam Saxton (00:42:41): Then, I started doing videos on it and then we started getting calls, but it was such a low volume that they routed all of those calls just to me, because it was seriously, maybe five calls a week. It was nothing. So, the videos and blogs I was doing were basically the summaries of the support calls that I was getting. This was the scenario and this is how we fixed this. This is how this works. Rob Collie (00:43:03): This is so parallel to me to what I did with my blog around PowerPivot. It was like it was in this place that kind of no one cared about. Adam Saxton (00:43:13): Yep. Rob Collie (00:43:14): The existing Analysis Services folks in the community... Adam Saxton (00:43:18): I was there in support when all of that came out. Rob Collie (00:43:20): Mostly, Analysis Services crew in the community had no interest in this thing that was embedded in Excel. Adam Saxton (00:43:27): No, that was like, "This is just a cute little thing they're playing around with. It's never going to make it." Rob Collie (00:43:31): I had moved to the Mid West and so I needed a new job. So, I just started blogging about it. Most of my blog posts for the first three years were just things that I was doing with PowerPivot in my day job, problems that I've had to solve and overcome, and all of that. Like you, I didn't really know or expect it to turn into what it... Adam Saxton (00:43:55): I had no forethought on where this was going. I was like, "It's just me. I'm toying around. Maybe, at some point, I'll stop it. I don't know." Rob Collie (00:44:02): I started the blog primarily as just like a digital resume. Adam Saxton (00:44:05): See, I wasn't even thinking about that, either. Because I was like, "I'm in support. I'm not going anywhere." All of my thought and focus on that was like, "I'm just helping customers." That's all I was doing. I didn't really think about any other aspect of it. Adam Saxton (00:44:17): I was just like, "Look, I just want to give back to the community." Seriously, that was all I thought about. I should have thought more about it at the time and I didn't. Looking back, I was like, "I made a lot of mistakes." Rob Collie (00:44:28): Yeah. You wouldn't, if you just planned it out a little better, you wouldn't be the massive failure that you are today. Adam Saxton (00:44:33): Right. Exactly. Rob Collie (00:44:35): Yeah. You're really... Adam Saxton (00:44:36): I'm glad you recognized that. Rob Collie (00:44:37): Yeah. You're really a disappointment to all of us, Adam. That's why we had you on the show, really. Adam Saxton (00:44:41): Yes. Rob Collie (00:44:42): You know? Adam Saxton (00:44:43): Yes. You just wanted to just bash me in and give me the reckoning that is needed. Rob Collie (00:44:49): You finally met your match. Adam Saxton (00:44:51): Yes. This is the intervention call, right? That's what this is. Rob Collie (00:44:56): I don't know. We're pretty bad at that. Thomas LaRock (00:45:00): So, I want to ask something about Guy in the Cube. Adam Saxton (00:45:03): Guy in a Cube, not the Cube. Thomas LaRock (00:45:05): The comment that you made was, it's not part of your day job. Adam Saxton (00:45:08): Yep. Thomas LaRock (00:45:09): So, do you do all the recording in your off hours then? Adam Saxton (00:45:14): Yes. Honestly, in my day job, I'm always busy doing the day job. I don't have time for doing the Guy in a Cube stuff. Thomas LaRock (00:45:20): My question was going to be more about like, you have to have some level of support at Microsoft and you did mention that the marketing team... Adam Saxton (00:45:27): I mean, they didn't. They loved me doing it, but they didn't. Thomas LaRock (00:45:29): That's right. Adam Saxton (00:45:30): Yeah. They didn't stop me. Thomas LaRock (00:45:30): No. That's what I'm saying is that they didn't stop you. You have some level of support and encouragement from your employer for what you [crosstalk 00:45:37]. Adam Saxton (00:45:37): That's always been there. Thomas LaRock (00:45:37): Yeah. Adam Saxton (00:45:37): Yes. That's always been. Every manager I've had and the different teams that I've been on... Once I left support, part of the thing that I had and I had this in my mind and when I left support, I was still... Maybe, not even 10,000 subscribers yet when that happened. But even at that point, I knew that I was the... I've told every manager since then I was like, "Look, I'm going, to be honest with you the day that you tell me to quit YouTube or stop it is the day I leave Microsoft." Adam Saxton (00:46:07): I was like, "I'm just going to say that, right now." So, I'm like, "Let's come to an agreement. Let's come to an understanding. But if you are against that, then..." That's actually part of the reason why I left support was because they were starting to say, they're like, "Look, we see everything you're doing on certain things. We really want your community involvement." Adam Saxton (00:46:22): Because I was doing other things outside of Guy in a Cube, but I was just really focused on community and they were starting to put the cramp down saying, I shouldn't do the Guy in a Cube stuff. I'm like, "Well, that has nothing to do with my day job stuff. I'm still doing." They're like, "Yes, but we don't want you to focus that much on, we only want you to do 10% of community engagement." I'm like, "Well, I want to do 100%. Maybe, I need to go find a different gig." Adam Saxton (00:46:46): So, I did, but every manager I've had... So, when I left support, I went to the Power BI documentation team because it was content-related. I felt like that was more in line from then support because video and that stuff is content. So, I'm like, "This kind of aligns." But even then, they were like... Everyone on the engineering team, the marketing teams, and then my managers on the product side, I've always been very supportive of the Guy in a Cube. Adam Saxton (00:47:11): They want that to still happen. When I was brought on the Power BI CAT team, obviously folks there knew I had my technical acumen was there. My manager was very upfront and he's like, "Look, he's like, I want the Guy in a Cube. This is like the CAT team is the A-team of people working on the Power BI product. I want Guy in a Cube as part of this." I'm like, "Okay. Let's do it." Rob Collie (00:47:34): I imagine That somewhere back in the hallways of Redmond and the marketing department, there was the equivalent of the... Should we let him into the Janitor's Closet kind of conversation? Rob Collie (00:47:43): There was someone saying, "No, this guy's out there sort of doing marketing on our behalf. He's rogue. We need to reign him in." Someone said, "No, let him into the closet, give him the access." You got support, not support, or the lack of opposition. Adam Saxton (00:47:59): Yes. Rob Collie (00:48:00): Knowing Microsoft, there was definitely a conversation at some point. Adam Saxton (00:48:04): At this point of where I'm at now, I've actually heard some things about conversations that have happened and for different reasons but I know that stuff about that has happened. I don't necessarily know the details of it, but... Rob Collie (00:48:18): But now it's too late. There's no way they can go back. You're like, "What do you know, who I am?" Adam Saxton (00:48:26): Yeah. No, I don't. Rob Collie (00:48:26): You don't seem like that kind of guy. Adam Saxton (00:48:28): No, I'm not. I remember, Amir Netz, who's the CTO for Power BI, we were at a conference one time, just having dinner. There was a bunch of us there and he's just like, "Wow, you became the face of Power BI." He's like, "How'd you do that?" I'm like, "one video at a time for six years." I'm like, "I'm just there." I was there before anyone else. Rob Collie (00:48:52): Yeah. Adam Saxton (00:48:53): It's just consistency. It's a lot of hard work. This is not easy. Rob Collie (00:48:58): Yeah, the grind. Adam Saxton (00:48:59): Yeah. Rob Collie (00:49:00): I was two blog posts a week. You've made fun of how long my blog posts are in the past and they're encyclopedias. That's part of the reason why I don't do them anymore is because that just... Adam Saxton (00:49:08): A lot of work. Rob Collie (00:49:10): There's too many other things competing for my time. Plus honestly, there's so many people even at our company, who are so much better at these tools than I ever was, I sort of feel like I had my run. I want to do something different now. Adam Saxton (00:49:25): I could see from your perspective, letting other people shine, where their strong suits are, and let them help them build up what you're working on and building. Rob Collie (00:49:34): I go to my own company's people, my own team with DAX questions. Adam Saxton (00:49:39): Yeah. Rob Collie (00:49:41): It's like, "Why didn't you write a book on that?" "Well, yeah." Adam Saxton (00:49:45): Yeah. I did. Rob Collie (00:49:46): But it turns out you're still a lot better. Adam Saxton (00:49:47): I'm old, so. Rob Collie (00:49:50): Yeah. Adam Saxton (00:49:52): There's that. Rob Collie (00:49:52): There's that too. Yeah. Okay. That's great. I didn't know any of that backstory and I've been really, keenly interested in it for a long time. So, you described Patrick as your business partner. Adam Saxton (00:50:05): Yep. He's my second wife. I described him that way as well. Rob Collie (00:50:08): Okay. So, business partner in Guy in a Cube? Adam Saxton (00:50:11): Yeah. Rob Collie (00:50:12): This is obvious but Microsoft doesn't own Guy in a Cube. It's not a Microsoft thing. Adam Saxton (00:50:18): That's correct. Rob Collie (00:50:18): So, you've got your own LLC or whatever. Adam Saxton (00:50:22): I do now. Yeah. I didn't, originally. Rob Collie (00:50:23): Yeah. That's fascinating. So, you work two jobs. Adam Saxton (00:50:27): Yes. Rob Collie (00:50:28): I think a lot of people would probably assume looking in from the outside that Guy in a Cube is part of your Microsoft duties. Adam Saxton (00:50:35): Well, I've had people comment on things, especially, when I first started doing it. There was one video I did in 2015 where I actually had some friends of mine, they had some camera gear and they helped me film something. Adam Saxton (00:50:47): I actually did that video on the Power BI YouTube channel, because they had asked me to... At the time, I wasn't monetizing anything. I was so small. I was just helping out. The comment on that video was, "Wow, Microsoft really stepped up their production quality." I'm like, "Yeah. No, they didn't. That was me." Rob Collie (00:51:05): All right. Let's talk about your day job then. Adam Saxton (00:51:08): Yeah. Rob Collie (00:51:09): What does that look like? Adam Saxton (00:51:10): So, the way I describe is the Power BI CAT team or the customer advisory team or something... I actually don't even remember what CAT stands for anymore because we just always call it CAT and it's customer advisory team or something like that. The way I describe this to people, because when we come in and they say, "We're part of the CAT team." They're like, "I have no idea what that is." Adam Saxton (00:51:29): That's why I just don't even say it. I'm like, "We're a team of elite ninjas that drop in and help unblock you to gain adoption with Power BI." They're like, "Well, that makes sense." Our team deals with the largest customers, enterprise customers working with Power BI. Those, that are trying to push the limits and push the product, it's part of the product team. Adam Saxton (00:51:47): It's the voice of the customer for the engineering teams. We're working with it... It's honestly amazing, the level of amount of data that some of our customers are working with. So, I joke sometimes because there's people that will complain and say, "Well, I'm doing 300 million rows and Power BI just can't handle it." Adam Saxton (00:52:10): I'm like, "That's cute. That's itty-bitty data." So, I'm like, "I'm working with a customer, where they have a 100% imported into a tabular model of 1.5 billion rows inside a Power BI and that thing's running like a champ." Rob Collie (00:52:22): Yeah. Adam Saxton (00:52:22): So, 300 million rows. I'm like, " Probably, got a bad data model." Rob Collie (00:52:33): Completely. Adam Saxton (00:52:33): Yes. Rob Collie (00:52:33): Completely. Adam Saxton (00:52:34): Yes. That's, honestly. It's a broken record. That's what Patrick's and my day job. It was just like, you've got people coming in and saying, "I want to go to a P4 or P5 because I need more memory and space." I'm like, "No you don't. Give me 30 minutes and DAX Studio, and Tabular Editor. I'll give you 9-10 recommendations to optimize your model." Rob Collie (00:52:53): Boy, I bet, you see a lot of data models, quote-unquote, that are just one wide table. Adam Saxton (00:52:59): Yes. It's amazing. We had our Phil Seamark ended up joining our team. He was an MVP. I remember, a month or two after he joined the team, he's like, "Wow, I just had this in my head. I mean, these are the largest enterprise customers in the world. Adam Saxton (00:53:14): This is Fortune 500. These are all companies that everybody knows the name of these companies. I just imagine, they've got these rock-solid teams that are building this stuff and it's really going to push my... They're doing some really wonky things." I'm like, "One giant table with 300 columns." I'm like, "What are you doing?" Rob Collie (00:53:34): Well, this is where that sequel to Power BI transition really lands with both feet. Adam Saxton (00:53:39): Well, I'd say Excel to Power BI as well. Rob Collie (00:53:42): Well, but I mean, IT doesn't even understand Excel. The average IT professional can't write a VLOOKUP. Adam Saxton (00:53:51): In fairness, I can't write a VLOOKUP, either. Rob Collie (00:53:53): You never needed to. It's okay. We forgive you. Adam Saxton (00:53:55): Yes. Rob Collie (00:53:56): True story. I'll hide the names. Adam Saxton (00:53:58): Protect the innocent. Rob Collie (00:53:59): Well, some of the people in this story are not... Rob Collie (00:54:03): Some of the people in this story are not innocent. So many people in this story are committing a sin. Adam Saxton (00:54:08): Data blasphemy. Rob Collie (00:54:09): Yeah. Well also just like an interpersonal bad human sin in my opinion, but we were a subcontractor to another contractor. Actually, there was a three level contract job. We don't usually do this kind of thing at all. Adam Saxton (00:54:22): Like layers of wrongness. Rob Collie (00:54:23): Layers of wrongness already. At one of the world's largest energy firms. We'll keep it like that. And there were different legs of this project. We were doing part of one part of it but then there was a sibling part that was like one universe over next to us. And they had brought in one of the big four accounting and consulting firms to do that part of it. Rob Collie (00:54:48): Now they were both power BI tabular. Right, all that kind of stuff. And you know, the 300 million rows, all that kind of stuff. Like we were loading just you know how it goes just insane amounts of data. Like every single transaction that ever like happened in the history of this company forever. Adam Saxton (00:55:02): And I need all of this. Rob Collie (00:55:03): And we were just crunching, just absolutely destroying it. You know, it was like, "oh, you want a 10 year trend"? no problem. It's just like we had it all. So in the meantime, our sibling, over in that other parallel universe, we kept hearing these rumors, like they're struggling to get one month of data loaded. And we go because you know, we're friendly people. Can we take a look? We can help. Rob Collie (00:55:26): And we got told, no, you are not allowed access to that closet. Right. We said, listen, we have the Big Four over there, and you know what else? The Big Four, that company, they sent their number one, Microsoft power BI expert to do this. Adam Saxton (00:55:44): All right. Rob Collie (00:55:45): And we go, oh, well then that must be something really complicated going on over there. We believe them. We're so naive. And then another two months goes by and they still can't get it, it's just a total failure. And so after hours, when like no one was looking, someone said, "Hey, can you come over and take a look?" We opened it up. Yep. One big wide table. And we're slapping our forehead, okay, this is how much dishonesty is running around in the world. And you know, the amount of money being charged for that number one, Ms. Power. it's [crosstalk 00:56:18]. Adam Saxton (00:56:18): That and it's one of the Big Four. I'm like there's money there. Rob Collie (00:56:21): It was fraud. They were committing... It should be charged with a crime. Thomas LaRock (00:56:27): Hold on. Just remember this. When you graduate medical school, right. They're going to call you a doctor, but not every doctor graduates top of the class. So that company could legitimately be saying, this is my number one power BI guy, Microsoft. That doesn't mean he's top of the class. Adam Saxton (00:56:45): Yes. That's a fair statement. Rob Collie (00:56:47): But it's top of the class for them. Thomas LaRock (00:56:50): That's the best they could find. You know, that there's a dearth of people that can do proper data analysis. That was the best that they had. Rob Collie (00:57:00): I will tell you now, one of the struggles we have when we're getting into some of these engagements, I will be completely honest with you that there's only a handful of people that really understand how to do it. And they don't work at these companies. Thomas LaRock (00:57:13): Right. So I was surprised Rob, that you didn't know that guy. Because when they said, Hey here's you is our number one guy. He works at power BI I'm like you probably there's what a dozen of you in the world, you should have known exactly who that guy was. As soon as you didn't know him, you, you should have just questioned and go. Never heard of him. Rob Collie (00:57:29): Let Me let you guys in on a little secret. Adam Saxton (00:57:30): You don't Know everyone? Rob Collie (00:57:32): Well, I don't know everyone, but the world is every day right now, manufacturing, just legions of people who are really, really good at this. And they're all on the business side. And they're all well, not all but overwhelmingly unknown and underappreciated. Adam Saxton (00:57:53): Yep. I would Agree with that. Rob Collie (00:57:54): They're not going to find their way into that room where they had the Big Four best power BI expert deployed because it's just like a different career path. It's entirely too authentic essentially, to find yourself in that situation, I'll be completely fine. This is part of our business model. I believe this. I mean in a way that I bet my career on it. This is the future. It's the people who are good at business. Good at communicating. If, they come from a tech background. Great. But they also have to have this other stuff. It's this hybrid that we're always talking about on this show. I think that most IT organizations are really struggling to embrace this fact, that their best data modelers, their best BI people are that unknown man or woman hiding in the finance department. It's not the CFO. It's not even the director. Right? It's this hidden diamond in the rough, this gem. And they're everywhere. Now Adam Saxton (00:58:56): Working with one of my customers, there is that person, they work in finance and they came out of that world and he understands like all the finance aspects of stuff from the business side and he applies and he's an amazing data modeler. He's one of the best. And I've even said everyone needs that person in their company. We need clones of that person cause he's making amazing things. You and it's just incredible. And we do on the power BI CAT team, there's a program called the power BI enterprise voice, where we bring in direct people from those enterprise customers. And they have direct communication with feedback with the engineering teams. And one of the things we try and do is get someone from the business persona and then someone from the technical persona to try and get both represented in the program. Adam Saxton (00:59:44): And I'll be honest, like the technical folks are good and I enjoy working with them. But the business folks, we seem to get more and or different types of feedback come from the business folks that tend to be more actionable than the technical cause the technical, we get on the tech side, we just get siloed in on this problem or this specific space instead of understanding the whole picture of that business side, along with it and how that would impact. And so having those business folks as part of that discussion is very important. Rob Collie (01:00:13): Well, I'm glad that's also showing up on your radar. I think that as an outsider now, I think that Microsoft tends to miss this in my conversations with Redmond. It's very, very often about what it takes to convince a CIO, to commit to power BI as a platform. I see that a lot. And then I love that you are more engaged on the adoption side. What happens after you make the sale? Adam Saxton (01:00:43): Well, I mean we're still engaged. So, where there as part of the adoption, but then it's an ongoing discussion of, I mean, I've been working with companies that have been using power BI for years, but it's still about adoption, right? It's about growth. It's about how else can we help you within the business? You know, help us scale it up. All of that. The other thing I would say is one thing I, I would agree in the beginning of my Microsoft career you're right. It was all about, we got to convince the CIO or the CMO or the CDO, like some C level has got to make that decision. Whereas now I've seen that conversation shift more to we need to find the influencer and it doesn't necessarily have to be the C level. Maybe it's a director level type person. Some of that has enough influence and has those connections in the business to help us be that sponsor and to push that. And we do have evidence that absolutely helps from an adoption perspective. And typically I'll be honest. I'll lot of times that person's in finance. Rob Collie (01:01:40): Yes that's our experience as well. Adam Saxton (01:01:43): If you Can find that person, sometimes we're not as successful there, but sometimes we are. Or sometimes that person that's in that influence role is not necessarily pro Microsoft, which is hard. And sometimes that's forced upon them. It's just interesting to see it's definitely moved away from the C level. Although those discussions do happen, especially at certain companies, but it's more about the influencer who can actually influence that decision from a business side of it. That's how we're going to grow adoption and actually get past the self-service grassroots stuff into real, the mix of the service and the IT central type of implementation. Thomas LaRock (01:02:23): I was going to ask you, Adam, you used to travel how much? 50% or? Adam Saxton (01:02:30): I always like to say it was 25%, but I think it was closer to 50% at certain points there were peaks and valleys, but yeah. Rob Collie (01:02:37): Yeah, Same. Adam Saxton (01:02:37): That was all self inflicted by the way. That was just because I wanted to go to conferences and speak and... Thomas LaRock (01:02:42): Sure. Yeah. But I remember specifically the time that you were trying to get home to Houston and it was flooding. Right. And I've been there as well where I've been on the road and something's happening at home. Adam Saxton (01:02:59): Yeah. It was Hurricane Harvey. Thomas LaRock (01:03:00): Yeah. And usually for me, it's like a snowstorm and my family makes the best they can when I'm not here to clear it all the way. But I've had incidents and where I couldn't get home and I think it was the same for you. And I thought you might want... I think there are people out there that experience, that same thing where you're on the road. It's self-inflicted as you said, it's something you're doing that you love, you enjoy. And at the same time, there's something just weighing on you. You're like I need to get home. Adam Saxton (01:03:31): Oh. And I was constantly talking to my wife, getting status, looking at the weather, looking at the news. And I was coming from Israel and there was a stop in Newark, New Jersey and then from Newark to Houston. And when I got to Newark and I'm looking, I'm like, there's no way we're going to take off because it's the storm's going to be right over Houston at the time that we're supposed to land. We took off and I'm, constantly in contact with my wife saying like, look, I'm, going to try, make sure you're safe, what do you need. Thankfully, her parents were about an hour and a half away. She wasn't necessarily alone, but yes it was, nerve-wracking absolutely a hundred percent just worried about them. And I there's nothing. Absolutely nothing I can do. cause I'm not there. Thomas LaRock (01:04:18): Yes, exactly you're sitting there. There's nothing more that I can do. There's nothing I can lift. There's nothing, right. It's just this emotionally draining experience. And for those of us that hit the road from time to time, I don't think people understand that enough. It's not just being away. There's also all sorts of things. You know, I've missed soccer games and things like that. But the times I wasn't able to come home and I get home and they're telling me, "It was an ice storm and we had no power and you could just hear that the branches of the trees just breaking and creaking all night and we couldn't sleep." And I'm like, okay, this... So you, you have to have that balance between everything you're doing. Adam Saxton (01:05:07): Well and everything I've done too. it's conversation with my wife as well, understanding the family and making sure we're not impacting anything there and the balance of work, play and family. Thomas LaRock (01:05:20): Now the play part, see everybody thinks my kids are oh, you're going to all these places. And it's all happy, fun play time. Adam Saxton (01:05:30): Yeah. It's just a party. It's just always a party. Thomas LaRock (01:05:32): And it's not, it really isn't except for the times where it is. so my first trip to Damastown, I was the president of pass and I was asked to go over to attend their 10th anniversary celebration. And they were holding this sequel conference in Damastown. Stop. Yes. And it's easy to get there. You're fly to Frankfurt. Adam Saxton (01:05:54): Frankfurt, the airport that is the bane of my existence. Thomas LaRock (01:05:59): I don't mind Frankfurt. Adam Saxton (01:06:00): Oh, I had an experience there. So [inaudible 01:06:02] Thomas LaRock (01:06:02): I [inaudible 01:06:03] mine. Adam Saxton (01:06:04): Oh, okay. I've never been to that one. Thomas LaRock (01:06:07): I love the event. It's probably my favorite event of the year. And I can't go this year and that's really, it's sad. The thing about the Germans and this is mostly for Rob's benefit. So they, they threw this 10th anniversary party my first year and it was fabulous. It was, it was a lot of fun. They had a lot of fun putting it together and it was a nice environment to be in. It was to explain it for Rob. It was really like being with another extended family. And what's weird for me is all these people kind of knew me. They'd come up to me. They'd thanked me for my work with past. And I'm like, I really have no idea who you are. This is my first trip to Germany. Who are you? So at some point that first night somebody there, they're German. So there's a meeting of two cultures happening here. First is the love of Jägermeister for the SQL community at that point in time. And I'm in the home of Jägermeister right? Jägermeister comes from a little town, not [crosstalk 01:07:10]. Adam Saxton (01:07:09): Going through the Frankfurt airport and there's just massive displays in the [inaudible 01:07:14] Thomas LaRock (01:07:14): So they bring out two handles of Jägermeister and it's special. Jägermeister, because it comes from the town and somebody brought it in specifically for their birthday celebration. And so we finished those bottles and there were a lot of people. It wasn't just like, [crosstalk 01:07:29] yeah, Adam Saxton (01:07:29): It's not just six men in a corner finishing two bottles. Thomas LaRock (01:07:32): Right, they were a lot anyway. Adam Saxton (01:07:34): And these bottles are not small bottles. Thomas LaRock (01:07:36): They're handles. That's a 1.75. It's big. I get to go back the following year and they're like, okay, next thing I know there's two bottles of Jägermeister. I'm like, are we doing this again? Adam Saxton (01:07:47): I have very similar experience. Thomas LaRock (01:07:49): Are we doing this again? I thought that was just for your birthday. They're like, no, no, So Adam shows up at SQL conference one year and [crosstalk 01:08:01]. Adam Saxton (01:08:01): So naive, and naive Little Adam Thomas LaRock (01:08:05): We're at their basically attendee event. They have some food, they have some drinks and we grab some seats and I forget how many, maybe a dozen of us were just hanging out, getting caught up for a lot of us, talking with people from all over the world. Right. But at some point during the night out comes those two bottles and they always find me. They're like Mr. Jägermeister. They bring the bottles straight to me. And of course Adam's right next to me. Adam Saxton (01:08:34): You were the second half of that. That was the second bottle I had parked. I was already halfway gone by the time I got to you. Okay. So there's a whole other part of it before I even got to you. Thomas LaRock (01:08:44): So the play part. So the incident, I don't want to get into too many details, but I have a feeling Adam Saxton (01:08:50): I'll get into the details. Thomas LaRock (01:08:51): Okay. Yeah. well, Adam Saxton (01:08:52): Some of the details, Thomas LaRock (01:08:53): Right, some of the details because I don't think you remember. Adam Saxton (01:08:56): This is one of the few moments in my life where I... So people have told me. So like the whole, the check-in thing Thomas LaRock (01:09:03): On swarm. Yes. Adam Saxton (01:09:04): I don't remember that part. Thomas LaRock (01:09:05): No. Well we, we created the Adam Saxton Memorial washroom in your honor. Specifically because of events that night. Adam Saxton (01:09:13): Oh no, I got that part. So Karen Lopez was with us as well. Yes. And so I distinctly remember waking up the next morning going, I just remember there was something about level nine. Karen was talking to me about something level nine. I don't know if that was real. I had to go look. It was like some NASA like level nine tours at the Houston facility. Thomas LaRock (01:09:36): Right. Adam Saxton (01:09:36): And I had to look that up because I was like, was that real? Or am I just imagining that? Because, we had this whole conversation about it. I'm like, oh that was real. All right. I'm good. I'm right. Thomas LaRock (01:09:45): The lesson. I always try to tell, especially when that first time visitors, the secret conference is pace yourself because the Jägermeister is coming. Adam Saxton (01:09:53): Remember. So like the shots that I got, these were not small shots. It's not like a little shot glass. This was like a big cup. And it's like got a good, healthy portion inside of it. And I think I had nine of those out of two separate bottles. Thomas LaRock (01:10:06): So, and the thing about Jägermeister is that it really is something you can have a lot more of than you need. I really enjoyed the event. Not just for the Jägermeister, but the camaraderie. Yes. The, the feeling of closeness with all those people that I've met for. And I've gone for six or seven years now. But I do remember, so Adam has not returned since. Adam Saxton (01:10:27): No I had two. I went the year after that as well. Thomas LaRock (01:10:30): Did you? Adam Saxton (01:10:30): Yes I did. I don't remember. [crosstalk 01:10:33] Rob Collie (01:10:34): Don't don't let the truth get in the way of a good story. Thomas LaRock (01:10:36): No, no, no. Wait didn't you guys. I think now remember the second year. Didn't you do the power BI hour? Adam Saxton (01:10:43): Yes. Thomas LaRock (01:10:43): Did you do that both years or the second years? Adam Saxton (01:10:45): No. So the first year Casper did it, I was on the sidelines. I was recording it. Then the second year, then they moved it to the big auditorium and I was part of that, Thomas LaRock (01:10:54): Which is awesome. So these guys and didn't you do like a presentation on beer? Adam Saxton (01:10:58): No, [crosstalk 01:10:59] what I did there. I could not do in the U.S. Because it involved. I believe it involved Trump at the time. So I wasn't brave enough to do that in the U.S. Thomas LaRock (01:11:09): So I Love the power BI hour that they do. Adam Saxton (01:11:14): Oh the power hour. Yeah. Thomas LaRock (01:11:15): Power hour. Is that done anywhere else or is that just a German [inaudible 01:11:19] Adam Saxton (01:11:19): No, no, no, no. So that, actually has roots outside of that event. So it was done at past summit. It was done at a bunch of different, I think it was done at TechHead. It was done at TechReady inside of Microsoft. It's been done at Pass. We did one. The last one we did at the Atlanta Business Application Summit, Matthew Roach. And I kind of organized that. We were able to get 1300 people in that room. Yeah. For the power hour. It has a following. Thomas LaRock (01:11:44): Yeah. Yeah. Those things are great. Adam Saxton (01:11:46): It's amazing. Thomas LaRock (01:11:46): And you guys pick a topic. Adam Saxton (01:11:48): Preface it with you are not going to learn anything actionable out of this, but we're going to have fun with the technology and do things that you never thought about doing and. Thomas LaRock (01:11:58): No it's brilliant. It really is. Adam Saxton (01:12:00): But I will say the Germans at the sequel conference, it's a whole other level. Like it is not like in the U.S. It's fairly politically correct? I would say. And in Germany. No, no. Thomas LaRock (01:12:10): They're passing out beers. Adam Saxton (01:12:13): Passing out beers isn't the thing. But I remember the first year I went, one of them did, like, it was a whole skit on like the Ashley Madison database. And I was like, whoa. okay, here we go. Thomas LaRock (01:12:23): I've seen that one too. Adam Saxton (01:12:24): Yep. So it was, it was great. Rob Collie (01:12:27): Adam, on a previous podcast, he told the story of my parallel story to that. It was tequila. It was Southern California. And the one part of your story that I kind of raised an eyebrow, was that you're like, I'm not sure that I really remember most much of the much of the evening. There're parts of it that are gone. But then, but you happen to know how many shots you had. Adam Saxton (01:12:46): Oh, I know exactly how many shots. Rob Collie (01:12:48): But no, no you do not. Adam Saxton (01:12:54): Fair, point. Rob Collie (01:12:54): That is exactly what I was getting at is that the morning after my incident, I woke up and told people the straight face, but guys, I only had two of those margaritas and they looked at each other like, no, oh my God, [crosstalk 01:13:07] he's thing. Adam Saxton (01:13:08): That's the thing thing I'll add to that. And this goes back to the whole community thing and family. And some people always ask like, oh man, that's really dangerous. And I do know that there are, you do have to be mindful about that. Especially just be safe in what you're doing. And I was, I was surrounded with people I trust implicitly and I knew so like Casper de young was right there. Tom was right there. Karen Lopez was, these are people. I implicitly trust. I've known them for a long time. And there's very few times I've gone that far. It was to the point like Casper had to walk me back to my hotel room. Like he was there. He had to take my phone away from me as well. That was part of the incident. It involved my wife. And it was bad. Not like bad, bad but it was a [inaudible 01:13:50] that could have been avoided. And have been avoided Rob Collie (01:13:54): Have you seen the quote unquote documentary movie about Motley crue? The Dirt? Adam Saxton (01:13:59): No. I haven't. Seen that. Rob Collie (01:14:02): He wakes up in the morning and he's on tour and he is handcuffed to his bed. Adam Saxton (01:14:07): Oh no. Rob Collie (01:14:09): Then they replay the events or the past night it ends with his manager handcuffing him to the bed. Adam Saxton (01:14:15): No, no [crosstalk 01:14:17] just stop. So at the point of this, what I remember of the evening was Casper taking my phone away from me, responding back to my wife, saying, I'm drunk, I'm going to bed. I will talk to you in the morning. That's what he sent. And then he put the phone back in my pocket that whatever you do, do not text anyone, do not answer any calls until you have woken up and you're sober. And I was like, thank you, sir. Rob Collie (01:14:41): You were Still, you were still receiving and absorbing instructions so. Adam Saxton (01:14:44): Yes. Rob Collie (01:14:45): But at least at that point. Rob Collie (01:14:46): Well, because at that point I had transitioned to water because that's all they were giving me at that point. Rob Collie (01:14:53): You had good minders. Adam Saxton (01:14:54): Yes. Like I Said, those are people I trust and they were looking out and we were having a good time. Rob Collie (01:14:59): And mostly people were just taking pictures of me. Adam Saxton (01:15:02): Oh, there is a picture. In fact, the only way I can find this picture, it's in my email, but I have to search for, it's only the subject of the email. It was sent by Casper to Patrick and then Patrick forwarded it to me "its fucked up". And it's a picture of me kind of like strown out and yeah, that's the only way I can find that picture. I Rob Collie (01:15:25): I Missed me some Casper. We're going to have, to have him on the show. Adam Saxton (01:15:30): Casper's like my brother also, man, we've had adventures together. And I actually, it's interesting because the folks on my team were kind of all over the place. Good portion of them are in Redmond. But I there's a point like with all the traveling and everything, I would tell people that Casper is the person on the team that I physically see the most. Which is interesting because I would go to Europe a bunch. I go to Europe and he's at the things that I'm at in Europe, but also he's at the items in the U.S. As well. And so I'm seeing him on both ends. Whereas the folks in the U.S. I only see at some of the U.S. Things, not all of the U.S. Things. So it just got to the point where I saw him more than I saw Patrick face to face. Rob Collie (01:16:14): It's a weird new reality. Like us moving around the country, sort of like just sort of being where the kids are until they're done with high school, and being approaching late forties I now have more friends in other countries than I do in my own city. And it's just like, this is not how it's supposed to be. Adam Saxton (01:16:32): I tell that to folks too. Like when I'm at, when I was at past summit or ignite or anything like that, I'm like the Europe folks. I see them more than I see anyone else just because I'm going to both sides of it. We've had a lot of fun. I would say that the folks in Europe, I would argue that I have little bit more fun over there than I do in the U.S. Just because it's really open there. Right? Like they just enjoy themselves. It's a work hard, play, hard mentality over there of like they're very focused when we need to be serious, but they can actually enjoy themselves at the evening and, and whatnot. And so it's always fun to hang out with them and also being in Europe too, just getting new experiences of life and one pro tip I'll give folks if they do travel for conferences, whenever we get to do that again is try to work in family hacks into those trips. Adam Saxton (01:17:21): Right. So there're times like when I've been to SQL Bits or SQL conference or whatnot, where I brought my family with me and so my daughters and they were older when we did this was a couple years ago. So they actively remember it. We went to London when SQL Bits was in London and I brought my wife and kids. Came out two days before, did some sight seeing. And then they spent during the conference, my wife spent a day or two just sight seeing London with my kids because I'd already seen it from a different trip. And so they've been to London, they've been to Paris, they've seen Stonehenge. So they've gotten to experience some of the culture outside of the U.S. And can relate to some of that. And it's very different from the U.S. and we've done that too when we've gone to Orlando for some things. So going to like universal and Disney with the kids as part of the work trip, bringing them with me as well. So working that in, Rob Collie (01:18:13): Exposing them to that Orlando exotic culture Adam Saxton (01:18:16): Absolutely. So the reason I brought them. The second time I went was because the first time I went and I went to the Harry Potter stuff and daughter loved Harry Potter. And so I'm just sending her pictures of me like posing and the dragons right behind me. And she's like, you're Awful. Rob Collie (01:18:33): Yeah. You learned your lesson, didn't you? I don't think I've done as well at that as I could have, but it is good advice. Adam Saxton (01:18:40): I mean, I could have done better as well, but I've tried to because my wife, the number one thing is my wife. Like she's just wants to travel. That's her thing. So once I started traveling to Europe and it was always interesting to, I never thought I'd get to travel outside of the U.S. And when I finally got around to doing it, I found that how easy it was and this really surprised me as well, because the way I hacked traveling to Europe because Microsoft wouldn't pay for it. And so I worked in was I would do these pre-con sessions, a full day thing. And because I was a Microsoft employee, they couldn't actually pay me to do the pre-con. And so the arrangement we did was look, pay for hotel and flight I'll cover food and all that. That's fine. Adam Saxton (01:19:20): And so that's how I got to go to a lot of this Europe doing, not since I've been on the power BI CAT team they'll that just gets paid for. But before that I would make those arrangements. And it was interesting that the Europe crowds, even if it was a smaller event, they would do it. Whereas, and I tried making that arrangement with some folks in the U.S. For some SQL Saturdays or things of that nature and they wouldn't do it. And I'm like, it's way cheaper. Like I don't understand. Rob Collie (01:19:48): Yeah. Now it is interesting. Either Europe puts more value on these events or there's something oddly cool about having an American come over, which will be harder to understand. Adam Saxton (01:19:58): Some Of that is because from an international perspective, they're like, oh it's really good if we can get Americans to, or especially like Microsoft employees or folks like that, they elevate the event apparently at some stages. So Rob Collie (01:20:12): I wonder if post COVID they'll have the same attitude. they'll be like, do we really want to bring an American over here? Adam Saxton (01:20:17): Yeah, I know. Yeah. Oh that's true. Rob Collie (01:20:18): I Don't know. Maybe it's time for us to go solo. Adam Saxton (01:20:24): Yeah. So it's been interesting and just the experiences that I've had on that front have been, and the friends that I've made by doing that has been amazing. Rob Collie (01:20:37): So back to power BI for a moment. Adam Saxton (01:20:38): Yeah. Rob Collie (01:20:39): How much opportunity do you find for doing like end to end project work? Do you ever get A chance to do something like that? Adam Saxton (01:20:44): No. No I don't. And I would say this is something that is a gap on my side or just something I don't get exposed to I'm not a consultant. Right. So I don't do those type of projects. I'm very focused on the power BI side. I do find ways to interact with some of the data components, but the re [inaudible 01:21:03] Adam Saxton (01:21:03): I do find ways to interact with some of the data components, but the real true end to end, I don't really get into that much. I try and find opportunities, especially if it's a Microsoft technology like Azure Synapse Analytics as news, or we're trying to do stuff there. But even Data bricks, I have some high knowledge of it, but at that point, I'm like, look, we got to get someone from that side to help with it, and Power BI. Rob Collie (01:21:27): And so much of a project is the long tail of all the little details. Adam Saxton (01:21:31): Yes. Rob Collie (01:21:31): And so, probably it wouldn't require the metaphor you used earlier, the ninjas who parachute in. Adam Saxton (01:21:38): Yes. Rob Collie (01:21:38): And this is like a real early 1980s low budget film. Adam Saxton (01:21:42): Yes. Rob Collie (01:21:43): It's like, we're going to send you to Paratrooper school and Ninja school. Adam Saxton (01:21:46): Yes. And so our team, even when I have to set expectations with folks too, it's like we are not consultants. We do not do the implementation. It's more of an advising consent type role. Rob Collie (01:21:59): Mm-hmm (affirmative). Adam Saxton (01:21:59): So we will evaluate what you're doing, we'll make recommendations based on best practices and then in some cases we'll get into the weeds a little bit. Some of that's just, do I have bandwidth to do that? And also, is it really interesting and is it really going to help unblock something. Specifically around model design and things of that nature, but I still won't do implementation. So I may come up with a sample or something to illustrate something but past that I'm like, either you have to do that as a company or you have to engage a partner or MCS or something of that nature. Rob Collie (01:22:31): That makes sense. I bet that they're constantly trying to creep that line. Adam Saxton (01:22:36): Everyone does. They try and bamboozle me. Rob Collie (01:22:39): Yeah. But if you were going to write this formula. Adam Saxton (01:22:43): Yes. But it'll be really quick. It would really help us. Rob Collie (01:22:47): Yeah. Wait a second. You're the client. I'm...Okay. Adam Saxton (01:22:53): Yes. And of course, I'm not even Support. So with Support, there's cost associated with that. Whether you're doing professional support and you're actually paying for it, or you're on the premier side where you have a premier contract that has certain hours that you've costed. And, or an MCS engagement where there's cost in that too. When it comes to the CAT team, there's no cost. We're just engaged. There's no billing that happens there. It's a quote on quote free for them to get anything out of us that they can. Rob Collie (01:23:22): Yeah, totally. Adam Saxton (01:23:23): They want to try and get like, can you come on site and help us? And I'm like, man, no. Sometimes I will, but still I won't do implementation. Sometimes I've gone on site for customers where we'll do an architectural review, where it's like a one or two day thing with a bunch of different folks from different tech areas and we'll do that type of effort. Rob Collie (01:23:43): And I think one of the things that I've really, my whole history over the last 10 years with this stuff. Whether as a solo individual or with the company that we've been growing, the exposure to so many different industries, so many different problems. The velocity at which we move our projects, we don't turn a project into a multiyear affair. We get through those things as fast as possible, so that necessarily ups the pace on how much we're exposed to. Adam Saxton (01:24:13): Yes. Rob Collie (01:24:13): We still need to be utilized. We still need to be doing work. Adam Saxton (01:24:16): And that's the other beauty of my job too. When I was in Support, we had to worry about utilization as well. I had to log that time, so that's where that struggle was is, okay, how much time do I spend playing around with something versus actually working a case and logging the hours. Whereas on the CAT side, I'm like, I don't have that. I just do what I need to do to get it done, which is amazing. Which is part of why it's a dream job, right? Rob Collie (01:24:41): Yes. Adam Saxton (01:24:42): I'm like, we've got budget, we've got the tools around the bleeding edge. I've got complete access to the engineering teams. Rob Collie (01:24:47): Mm-hmm (affirmative). Adam Saxton (01:24:48): Our whole mission is to just help unblock people with the technology, whatever we need to do. Rob Collie (01:24:53): Almost all the upsides, very few of the downsides. Even as you were describing, I'm sitting going, this is ideal, right? I could ask the question, do you get to do full implementation? But there's also the question of, do you have to? Adam Saxton (01:25:08): Yeah, I don't have to. And honestly, that's frowned upon because that's not a good use of our time in terms of what we're trying to do. Rob Collie (01:25:15): Yeah. Adam Saxton (01:25:15): Now the other thing I'll say with that though, is people are like, I want to get on. How do I get on that team? I'm like, if you look at the people on the team, this is literally the A-team. It's Casper De Young, it's myself, it's Matthew Roach. It's Patrick, it's Phil Seamark. It's a lot of folks that are top tier at what we do. It's a very work hard, play hard mentality. Our manager, Mark Ragera, he is amazing at hiring and finding people that fit that bill, that are very low maintenance. He's not a micromanager either. So he is like, look, you need to get things done. Let me know how I can unblock you, pass that. Go do your job. Rob Collie (01:25:54): Yeah. I had a chance to talk to Mark really for the first time because he kind of rose to prominence within Microsoft as a voice for this stuff after I'd left. I was very impressed. I was very impressed with Mark. Adam Saxton (01:26:05): Yeah, he's amazing. Rob Collie (01:26:07): Yeah. We should also have him on the show. Adam Saxton (01:26:09): That would be fun. And he'll freely admit he's not the deep technical guy. He's more on the business side. And he came from the finance world also. He gets all of it. His whole thing is he's hiring people and surrounding himself by the technical rock stars, so to speak. He helps shield us from the junk. Rob Collie (01:26:28): That's great. That's kind of where I've found myself. The fact that I have somewhat of a technical history with this stuff is almost a historical accident at this point. Adam Saxton (01:26:37): Yeah. Rob Collie (01:26:37): I'm much more about the dynamics of the market and, and understanding and just sort of like what it does for the industry than I am about the tax formulas anymore. Adam Saxton (01:26:48): Yeah. Rob Collie (01:26:49): I still dabble. Adam Saxton (01:26:50): Yeah, there's obviously some passion there. Right? Rob Collie (01:26:53): Uh-huh (affirmative). Adam Saxton (01:26:53): So it's like you enjoy it. Rob Collie (01:26:55): Yeah. Adam Saxton (01:26:55): You don't want to not do it at all. But at the same time, especially in your role of the company, it's like, look, you've got to pay attention to other things too. Rob Collie (01:27:04): We have a lot of reports. We have a pretty sophisticated data model now for our digital advertising and the whole marketing side of the house. And that's not a hundred percent me. I have help, but I'm kind of the ring leader of that process. Adam Saxton (01:27:17): One thing we struggle with, that Patrick and I have been struggling with, especially being on the CAT team, it's this balance between the CAT team and the Guy in a Cube stuff, because they're dynamically opposed to each other. In stance of on the CAT side, we're getting deep into the weeds of the technology. This is the super geeky stuff model optimization, large scale data, which when you look at it from an overall usage of Power BI, when we look at massive data, large model type, that's a small fraction of the usage of the technology. A Lot of it it's smaller businesses. Adam Saxton (01:27:52): And even at large enterprise companies, there's a lot of folks that are doing stuff that I wouldn't consider large data. They're doing smaller operation type stuff specific to that business vertical or that team need. So we're in the nitty gritty of the largest stuff that excites both Patrick and I. We love digging into that and understanding how do we optimize this more even at the engine perspective, whereas on the Guy in a Cube side, I'm the destroyer of video ideas for Patrick, because he'll be like, look this cool thing I did in tabular editor and I'm doing this scripting thing, this is going to be a great video. I'm like, nobody's going to watch that dude. Nobody cares. Adam Saxton (01:28:29): So on the Guy in a Cube side, it's more of the stuff that gets traction on that end is more of the intro and more of definitely not the deep technical side of it because what we're focusing on in our day job that it's all deep technical, but that doesn't translate to Guy in a Cube. And so Patrick is struggling with that way more than I am where he's like, you need to help me to figure out some video ideas that are going to actually be worth doing on the Guy in a Cube side because all I've got is this deep technical and that's not working over there. And I've told him, I was like, if you want to do one video a month on that, go for it. That's fine. But it can't be every week because our views will suffer. Rob Collie (01:29:10): Talking about views. I would assume that views and subscribers are always trending up. Adam Saxton (01:29:15): No, not after being off for two weeks and not doing anything. It's actually going to a nose dive. But, yeah. In general, yes, it curves up. Rob Collie (01:29:22): Taking a, a little breather there. Adam Saxton (01:29:24): Yeah, it hurt. Rob Collie (01:29:26): Boy, why would you be so lazy? Adam Saxton (01:29:28): Yes. Rob Collie (01:29:29): And like two whole weeks. Adam Saxton (01:29:31): Two weeks. And then basically slashed our numbers in half. Rob Collie (01:29:35): That's the temporary. Adam Saxton (01:29:36): Yeah. Rob Collie (01:29:37): But what about COVID in general? That the slope of the curve change at all with COVID, people sitting at home, more time on their hands? Adam Saxton (01:29:45): I don't know that COVID had really anything to do with it. I'm sure it did at some level, but the thing I've found over the journey is the numbers themselves, the subscribers is everything it was an exponential growth. It took me almost a year and a half to hit a thousand subscribers. Rob Collie (01:30:01): Mm-hmm (affirmative). Adam Saxton (01:30:02): And then it took me six months to get to 5,000. It was just like, it was always faster than next level. Rob Collie (01:30:08): Yeah. Rob Collie (01:30:08): And so we hit 100,000 in April of 2020. April of 2020 is when we hit 100,000. And we hit 150,000, December 14th. We hit 150,000. So I'm like, it was that much of a spread. Whereas it took me almost five years to get to 100,000 and then it took what? Another from April to December to get to 150,000. Rob Collie (01:30:37): Yeah. Adam Saxton (01:30:38): And then we're poised to hit 200,000, maybe a little over a year after hitting 100,000. Rob Collie (01:30:43): That's crazy. Adam Saxton (01:30:44): And it's insane. Rob Collie (01:30:45): Yeah. Adam Saxton (01:30:46): But it goes to consistency and the work and everything. So it definitely does not come overnight. And everyone's start wanting to start... There's lot of... One thing I will say in COVID is YouTube has been, especially in the power BI niche, has been flooded with new people starting channels and doing videos. That's one thing that has changed is it's gotten diluted. When I first started doing Guy in a Cube there was no one doing videos on. Adam Saxton (01:31:13): Actually in general, even in the text base, from what I saw and I may be wrong, but it looked like there was just very little going on YouTube in general. A lot of it was focused on blogging and things of that nature. No one was doing video. Some people were, but not seriously. Now it's like everybody's doing it. Rob Collie (01:31:32): Dilution is an ongoing thing. Adam Saxton (01:31:34): Yeah. Rob Collie (01:31:35): For a long time there I was the all only person grinding. Adam Saxton (01:31:38): Yes. Rob Collie (01:31:39): I had that luxury. No one else was grinding in competition. Adam Saxton (01:31:43): Mm-hmm (affirmative). Rob Collie (01:31:43): But, yeah. Now there's obviously huge differences in quality and level of engagement and all of that. Not all are created equal, but yeah. It's like who hasn't started a Power BI YouTube channel. Adam Saxton (01:31:57): And Patrick comments on this also. And I tell him to just ignore it, because it's going to happen of where you see some videos or stuff that people are doing and they're imitating what we're doing on the Guy in a Cube side, they're imitating what others are doing as well. And I was there. When I first started doing YouTube, you go after, okay, what caught your eye? And you're looking at other people and you're trying to figure out your voice when you're early on. Adam Saxton (01:32:20): I get it. People are trying to do that. It doesn't necessarily bother me. It bothers Patrick a lot, but I'm like, we got to do our thing and people are going to come up to our level or they're going to try to. And it's more than just production quality. You've got to have the entertainment factor. You got to have the key chemistry, the personality. I would say that's weighted way more than the production quality. Who cares? As long as your audio's okay, who cares about the rest of that? It doesn't matter. Adam Saxton (01:32:47): Audio is important, because if you can't stand listening to it, you're going to abandon that really quick. Rob Collie (01:32:51): Mm-hmm (affirmative). Adam Saxton (01:32:52): But the video, use your cell phone. I don't care. Use a webcam. It doesn't matter. Don't use a web. A lot of people just do screen capture. The thing that Patrick and I have is the chemistry between us and the balance that we bring to each other. We understand what each other's thinking. We're on the very same wavelength. We've been doing it for years now so it's the content quality. It's the value. It's understanding that. That's what they have to rise up to. And then we have to think about, okay, we got to do something that separates us now. What's the next thing we can do to separate it. Adam Saxton (01:33:24): And me getting the video editor was part of that because most people aren't doing that. And so the production quality is a lot higher. It does add value to what we're doing but we got to maintain the content quality as well. Rob Collie (01:33:36): I have a couple other quick questions here that are more on the technical front. Adam Saxton (01:33:40): All right. Rob Collie (01:33:40): Or about the tools with enterprise customers, what are for like large Power BI customers struggling with the most these days? What are the things that you're most commonly either asked to help with? Maybe on the technical level, but maybe also on that kind of like social engineering level. Are there any common threads there or is it pretty much every single instance is different? Adam Saxton (01:34:03): There's differences in each approach. The theme is I've already said it earlier that sometimes we feel like a broken record that we're always having to do model optimization. It's not...And I tell people, even in press presentations I do. I'm like nine times out of 10. Your issue is the model. When it comes to performance, it's because of the model. And not because necessarily the amount of data you have, but just the structure of the data and the fact that either the one table with all the columns or you're doing just some funky table stuff. Adam Saxton (01:34:32): You're not sticking to just a [inaudible 01:34:34], right? Maybe you've got some transactional database and you just pulled all of it in the way it was. And you've gone to the ninth normal form and I'm like, all right, this is not going to perform. The other thing that's interesting and because of the customers we work with, we're working with larger sets of data. And usually when we go to do presentations on performance and we're giving best practices and stuff and someone will raise their hand and be like, I'm not doing any of that and my stuff is fine. I'm like, sure. Adam Saxton (01:35:06): If you're doing like a million rows of data, you're never going to hit. I shouldn't say never, but you're not going to be as impacted on this. When you start getting to scale though, this becomes a massive problem. Now that being said, though, I've had some models where they had the one table and 300, some odd columns, they had about 8 million rows in the data. And this thing was just slow. It was because they didn't break out the dimensions. Adam Saxton (01:35:29): They're trying to do a slicer with six unique values that was coming off of an 8 million row table. And I'm like, all right, come on, let's get a little real here. So typically it's either, it comes down to one of two things, either one, it's the model that needs to be optimized or two, it's that customer that wants to slap 120 visuals on the canvas and wonders why. And all of the docs, if you look at performance analyzer, all of the docs is like sub-second, like 30 milliseconds. It's fast. It's not your model. Adam Saxton (01:35:58): It's the number of visuals that you had. And you're just trying to create a page native report in a Power BI report. And you don't understand the product and the tool that will help you be successful in what you're trying tell from a data perspective. In general, I would say the common theme at almost every customer is not taking the time to understand the story that you want to tell with your data and then figuring out how to do that both from a model structure, as well as your report structure, to communicate that story in an effective way. That's the theme. And nobody wants to. And part of it is it takes time to do that and everyone just we're all under deadlines. I got to get this out by next Friday so I'm just going to do what I can to throw it out the door. And then you know how it goes. It hits the fan and then they're calling Support. They're calling the CAT team like, Hey, we need to fix this. Rob Collie (01:36:49): I think this comes back to like, again, just the overwhelming past success of SQL and of things like reporting services. And I just over and over again, I see large IT departments just look at Power BI and go, look, the new reporting services. Adam Saxton (01:37:04): Yeah. Rob Collie (01:37:04): And I'm like, no. Adam Saxton (01:37:06): I want a Power BI report. And I want to just have this giant table with a bunch of columns and millions of rows. Wait, why isn't this performing? I'm like, that's not, we don't use Power BI for that. Rob Collie (01:37:17): Even if it was performing, it's like, so missing the most valuable things that you can do with these tools, that mindset precludes you from ever discovering them. Adam Saxton (01:37:27): And it's like the old, when I was in Support for reporting services where they're like, we've got this 300 page report that we got to print out. And I'm like, do they ever really read that? Rob Collie (01:37:35): No. Adam Saxton (01:37:36): They look at the first page and that's it. Nobody looks at that Rob Collie (01:37:39): And then they export it to Excel. Adam Saxton (01:37:41): Yes. Rob Collie (01:37:41): Believe it. Adam Saxton (01:37:43): And they complain because the color in Excel didn't match the color in the table in reporting services because it doesn't align to the color palette of that was a server down issue. Rob Collie (01:37:54): Yeah. Adam Saxton (01:37:55): That was not the right blue. Rob Collie (01:37:56): One of them uses CMYK color scheme, right? Adam Saxton (01:38:00): Yes. And Excel didn't use the same color palette. And so it looked purple when it was blue in their report. Can we make it bluer? Rob Collie (01:38:07): Purple? You're going to get purple and you're going to like it. Adam Saxton (01:38:09): Yes. That's just the people they need to take time and really understand. And it is just that sometimes they just don't get that time to do it or the business isn't helping them to grow in that area either. Rob Collie (01:38:24): All right, here we go. Last technical question. Adam Saxton (01:38:26): All right. Rob Collie (01:38:26): Not even really technical. Adam Saxton (01:38:27): Yeah, sure. Rob Collie (01:38:28): When the dust settles, what do you think the number one sort of impact or usage case is going to be for composite models? I debated asking this as composite models, high end niche feature or guardrail to guardrail world beater. This is more nuanced. Adam Saxton (01:38:44): Yeah. Rob Collie (01:38:44): It's where is it going to be most impactful? Adam Saxton (01:38:46): Marco Russa has called it the holy grail of BI. I will be honest. It scares me going back to what I said, people aren't taking the time to structure their data and understand the story that they want to tell. We've got this model out there, this big model, that's maybe the finance model and I've got my Excel spreadsheet. I want to bring them right next to it. And augment it little bit. That part I'm fine with. That doesn't necessarily scare me. Adam Saxton (01:39:11): But now I've got this giant finance model. I've got this giant HR model, and now I want to bring in an Excel spreadsheet and I want to do direct query to my SQL server to bring in some other data as well. And that's where I'm starting to wonder. First off, it's the direct query over the live Power BI data set, which is really what we're talking about here is, it's enabling but I would also say it's very new to the point where I don't necessarily have best practices for it yet to understand what those performance implications are. Adam Saxton (01:39:41): So the thing I'm telling people is yes, it is a very cool feature. It does enable some great things. Walk, do not run. Be mindful about what you're doing and what you're connecting to and how you're trying to relate that data. And the thing I just tell customers in general, I'm like, you've got to have a clean model. If you don't, Power BI is just one of those things where if your model is not clean, it's going to show you your ugly baby really fast. And that's when you start getting frustration, things aren't going to work very well. And you start calling us and complaining and I'm like, look, it's not a good data model. Adam Saxton (01:40:18): We've got all this stuff. And every time we have this conversation, I'm like, it's just not... One customer I wrote an eight-page writeup of recommendations for why your model, why you have an ugly baby. I should have titled the Word doc that way, but I was more professional with it. That was in May and I'm still arguing with them over it today. And I'm like, why do you even call me? I don't even understand that. But yes, I understand you think your people are really good and I'm sure they have amazing skills in certain areas. But I'm telling you, this is how the product works. And these are the changes you need to make for this to be performant and then combine that with this composite model feature of direct query over Power BI data sets. And you're just amplifying the problem. Adam Saxton (01:41:01): I think that's the biggest concern. And then the key is going to be is how changes could be made with that technology to make it more forgiving in those scenarios and making it smarter, to be able to optimize on the fly to accommodate that. That's really going to be the key and it's too early to even know. It's public preview. People are just getting their hands on it. We don't necessarily know what the best practices are yet. It's new. I don't have a magic answer for you on that one. Rob Collie (01:41:28): I appreciate that. I didn't know what you were going to say. That's why I asked the question, but at the same time, I'm like I can recognize the wisdom and the authenticity of what you just said. That is probably the only right answer. Adam Saxton (01:41:40): Yeah. It's not rocket science. It's garbage in, garbage out. It's the old saying, right? it's if you're not taking that time to really make it pristine and I've only come across a few models that I would even say or like that. Rob Collie (01:41:52): Pristine is tough. Adam Saxton (01:41:54): Yes. They do exist. Rob Collie (01:41:56): Even when you really know what you're doing, the hard realities of life drive you in some interesting directions. Adam Saxton (01:42:02): One thing you mentioned before though, talking about the business. The business persona, that person being the person that's modeling that more, the places where I've seen those pristine models is they understand the business. Rob Collie (01:42:14): Yeah. Adam Saxton (01:42:15): And they understand like I don't need all this other garbage, right? Rob Collie (01:42:18): Mm-hmm (affirmative). Adam Saxton (01:42:18): This is the problem I'm trying to answer. This is how I can do it. And this is how I can be smarter about it maybe with some pre aggregations or summarizing over here and not needing the actual detail row. Or if I do need those detail rows, there are ways we can handle that to make that more, I don't need it right up front. That's where I've seen success. Rob Collie (01:42:37): Yeah. Those are tremendous amount of over-engineering in the IT driven mindset. Adam Saxton (01:42:42): Yes. Rob Collie (01:42:43): I have a fight starter that I can use in certain situations like in a past conference or something like that. I can start a fight in a conference really quickly by saying, 90% of slowly changing dimensions implemented in the world were unnecessary. Adam Saxton (01:42:56): Yes. Rob Collie (01:42:57): It's like, how do you data warehouse? I'm like, see. Adam Saxton (01:43:01): Yeah. Rob Collie (01:43:02): We talk about faucets over plumbing. you can build plumbing all day long if you never have to worry about faucets and pipes running everywhere that no one ever needs a drink. Adam Saxton (01:43:12): Yes. Rob Collie (01:43:13): Yeah. I agree. The business is capable again with the right people, these unicorns. Adam Saxton (01:43:19): I fully believe IT could do it too, if they actively really worked with the business to understand that before they just try and go engineer it. I'm coming from that IT central admin type persona of where I just want to start building it, right? Rob Collie (01:43:32): Yeah. Adam Saxton (01:43:32): Let's just get it done and then you put that out there and it's not what they need, and or it just doesn't perform. Rob Collie (01:43:38): I actually I'm going to politely disagree. I don't think that IT could ever pull it off. But not for the reasons that you might suspect. It's just the fact that there's not enough time. There's just not enough IT people. There's plenty of business people. Adam Saxton (01:43:51): No, I would agree with that. Rob Collie (01:43:52): Just the ratio alone is unfair. Adam Saxton (01:43:55): I think that's why we're seeing a shift also when we talk about the self-service versus the central IT. It's one thing Mark Ragera likes to talk about is central at the core, but soft on the outside. Enable the self-service. Enable those business folks to get what they need to be done because they've got the numbers. They can do it. And it's hard for central IT groups to find that balance or to find a way to even enable that where people aren't just going to go rogue and get the data that they need to get the job done. Rob Collie (01:44:26): Yeah, agreed. I think a top down driven one version of the truth is inflicted on the business. Adam Saxton (01:44:34): Yes. Rob Collie (01:44:35): And it doesn't work. However, a bottom up sort of meritocracy, you find the one that actually works the best and then you make it. You bless it at that point, right? Adam Saxton (01:44:45): Yes. Rob Collie (01:44:45): That is awesome. Adam Saxton (01:44:47): Yes. Rob Collie (01:44:48): I think there's probably still, in my opinion, too much of the mindset of we're going to top down it. Adam Saxton (01:44:55): Mm-hmm (affirmative). Because that's the old school, right? Rob Collie (01:44:58): It is. Adam Saxton (01:44:58): That's how it's always been done. Rob Collie (01:44:59): It is, yeah. Adam Saxton (01:44:59): And the thing I've seen in organizations is that culture shift is hard and trying to get people to agree to it and, or move it. And I love some of the customers I work with because they have people there that are very forward thinking and like, yes, we want to change. We want to shift. We want to do it this way. We know we've always done it this way. Let's move over here and try it a different way. And those are really fun to work with. The ones where you've got that person in and they're like, no, we can't do that. We can't open this up to everyone. That's insane. I'm like, okay, it's not going to be successful. Rob Collie (01:45:40): Did you ever hear what Max Planck said about scientific revolutions? Adam Saxton (01:45:44): I did not. Rob Collie (01:45:44): It's chilling and it's awesome. He said, there's all this talk about the scientific method and the scientific community. It's this meritocracy of ideas and it's proof driven and all of that. And that's how science moves forward, is by constantly testing itself. He said, no, it's not what actually happens at all. What happens is, is that that new ideas do emerge. They are better, but they do not gain traction at all until the old school dies. It requires that clean slate. Adam Saxton (01:46:15): The change of regime, yes. Rob Collie (01:46:18): And it's just so cynical and yet you can recognize it. Adam Saxton (01:46:22): And I've seen that. Even on different organizations I've worked with and even in Microsoft, you get some of the leadership changes and that's when things happen. Rob Collie (01:46:31): People don't need to die. They just need to leave. Adam Saxton (01:46:33): No. Rob Collie (01:46:33): They need to retire or something. Adam Saxton (01:46:34): I know. Rob Collie (01:46:35): It does require some degree. And even that person who leaves and goes somewhere else, oftentimes they find themselves with a fresh perspective. Adam Saxton (01:46:43): Yes. Rob Collie (01:46:43): And they're no longer trapped by their former reputation. Adam Saxton (01:46:46): Yeah. Rob Collie (01:46:47): But as long as they stayed there, the change that was required, wasn't going to happen. Adam Saxton (01:46:53): Yes. Rob Collie (01:46:54): No matter how much evidence. Adam Saxton (01:46:56): Yes, I've seen that time and time again. Rob Collie (01:46:59): Man, this has been a blast. Adam Saxton (01:47:01): Yeah. Rob Collie (01:47:01): In hindsight, I'm sad we waited this long to do it. Adam Saxton (01:47:03): Yes. Rob Collie (01:47:05): I really appreciate you taking the time. I know all you have is two jobs now. Adam Saxton (01:47:09): I only have two jobs, yeah. But I've got plenty of time. Rob Collie (01:47:11): Even if we didn't put the podcast live, it was worth it. Adam Saxton (01:47:14): I look forward to the day where we can just go get a beer and hang out. Thomas LaRock. (01:47:17): Or some Yager Rob Collie (01:47:18): Yager, that's that's where it gets fun. Rob Collie (01:47:21): Dude, so much fun. Thank you so much. Rob Collie (01:47:23): Yeah, no worries. Rob Collie (01:47:24): Bye, Adam.    

Visit the podcast's native language site