Latest / Microsoft Cloud IT Pro Podcast / Episode 356 – The ROI of Microsoft 365 Copilot
Transcript
- 0:03Welcome to episode 356 of the Microsoft Cloud IT Pro podcast
- 0:08recorded live on October 6th, 2023.
- 0:11This is a show about Microsoft 365 and Azure from the perspective of it pros and
- 0:16end users where we discuss the topic or recent news and how it relates to you
- 0:20co-pilot and ai just don't go away.
- 0:23We are back this week revisiting some of the r o I of this service as well as
- 0:28some updates around licensing with the upcoming GA of Microsoft 365
- 0:32co-pilot and November 1st, 2023.
- 0:35After that we discussed some methods and challenges for bulk restores of items
- 0:40from the SharePoint recycle bin,
- 0:42as well as some upcoming changes to default outbound internet access for your
- 0:47Azure VMs.
- 0:50I need a co-pilot to help handle my calls. You.
- 0:53Need a co-pilot handle your calls, huh?
- 0:56Co-pilots for everybody because they're coming prepare th self. It's just money.
- 1:00So you say co-pilot for everyone. This is public enough.
- 1:05There's public blog posts out here. Co-pilot is not for everyone. Scott .
- 1:09I am disappointed by this. I mean we've talked.
- 1:11About the pricing in the past, so, so yeah, there's barriers to entry. We.
- 1:16Talked about the pricing but there's some new stuff.
- 1:19So copilot for everyone was $30 a user a month?
- 1:24It's expensive, I get it. I was willing. It is.
- 1:2754% The cost of your E three license if you want to
- 1:32think about it that way.
- 1:32Like it is literally more than the cost of your E three license to go and pick
- 1:36up co-pilot.
- 1:37But I was willing to pay for it.
- 1:38I absolutely would've paid 30 bucks a month for co-pilot at least to start to
- 1:42check it out.
- 1:43But then some news started coming out is it's gonna GA on November one and I got
- 1:48all excited and then I started looking at more news about it and it is gonna
- 1:53GA on November one and you can go get it if you have an enterprise agreement and
- 1:57you can get your Microsoft person to go set you up with it,
- 2:02which I don't have.
- 2:04And if you're willing to spend purchase a minimum of 300
- 2:09licenses. Yeah, I was.
- 2:10Gonna say 300 licenses or 300 seats licenses,
- 2:13therefore bringing you to what a cool, not nine K a month just to get started.
- 2:18Nine K a month.
- 2:20Not for your little SMBs.
- 2:2296, no, what is my math is failing me nine times 1200,
- 2:274,000. No, 90 108. 108. Yeah. 108.
- 2:32$108,000 a year for copilot, which.
- 2:35Remember that's basically double the cost of what you had before. So .
- 2:39That is not double the cost of what I had before.
- 2:41But for those organizations that are coming in, that.
- 2:44Is like for those organizations, yes, but.
- 2:47It's another one.
- 2:48I don't have any like skin in the game insight here but like from the outside
- 2:53is um, it's tough. It's a lot to swallow.
- 2:56You've gotta do a lot of R o I justification and I just wonder
- 3:02if people are like poking the bear,
- 3:04poking at the market and seeing what it will maintain from a pricing perspective
- 3:09just to get it there. But you,
- 3:12you won't know and I don't think M 365 or O 365
- 3:16like even break down the numbers this way in financial reports or anything like
- 3:21that. What ARPU ends up uh,
- 3:23like revenue per user and margin ends up being like per user within those
- 3:29product segments. But yeah,
- 3:31now that's funny 'cause somebody in the chat is saying they're TAM assures it
- 3:34will save us money. There are no more tams.
- 3:37So if somebody's still calling themself a tam a they've gotta get their heads
- 3:41out of the sand 'cause they haven't been a TAM for two years .
- 3:43But that's neither here nor there. Yeah,
- 3:46it is a weird barrier to entry too in that like you said,
- 3:49you have to basically be nominated in by a
- 3:54member of your account team and at Microsoft I,
- 3:58I don't know like I I imagine there's a whole gamut of folks who listen to this
- 4:02podcast and they're the enterprisey of the enterprisey and they've heard terms
- 4:06like TAM and CS a and they know who like their account executive is,
- 4:10they're ae like they've got all that stuff down or they,
- 4:13they we've got an at SS and and all that stuff running around and they live in
- 4:17the acronym soup of Microsoft. The majority, the vast majority,
- 4:21especially like those 300 seat organizations that would potentially be eligible,
- 4:26they don't usually have managed account teams.
- 4:29They're not big enough to get there.
- 4:30It doesn't justify it from like a sales cycle kind of thing.
- 4:33If you've just come in and picked up a hundred licenses, 150, 300 licenses,
- 4:38like you're still in the threshold of SS M B versus organizations that are in
- 4:43multiple thousands could be like single digit thousands all the way up to a
- 4:48hundred thousand plus seats.
- 4:49Yeah, I was gonna say Microsoft puts that just from a licensing perspective.
- 4:53They kind of put that S M B level at 300 'cause that's where you move out of the
- 4:57business into enterprise. But I'm with you.
- 4:59I weren't like some of my customers that are in those
- 5:03300 5400 employees.
- 5:07I don't know that they necessarily have EAs or TAMS or
- 5:12account teams or all the different acronyms because at that
- 5:17level they're still just going out and buying enterprises or going through A C S
- 5:20P or some of that.
- 5:21100%. So yeah,
- 5:22they effectively become unmanaged accounts which is fine in the grand scheme of
- 5:27things and it actually, I think for some of this like that's actually okay,
- 5:31I kind of want to see what happens when some of the biggest of the big kicks the
- 5:34tires and how that looks for them.
- 5:37And for the articles that are out there today about ways to think about
- 5:41justifying your R O I and your T C O with something
- 5:46like M 365 copilot.
- 5:48There's a lot of broad assumptions there because nobody has
- 5:52really been hands-on with it I think in the way that they're about to get
- 5:56hands-on with it.
- 5:57And that's gonna lead to a whole bunch of interesting
- 6:01observations and conclusions potentially six months from now.
- 6:04Like I would love to see the industry reports that come out of like Gartner and
- 6:09I D C and others after this has been out for a couple months,
- 6:12people have been hands-on with it.
- 6:13They've had a chance to effectively kick the tires and see what it
- 6:18can do for them. Okay.
- 6:19So this makes me laugh Scott.
- 6:21We just talked about the 300 LI license level and the whole SS M B thing.
- 6:26If you scroll down in that article from Schneider,
- 6:30IM that you post in Discord, we'll put it in the show notes.
- 6:33It's not every license is eligible for copilot.
- 6:36Microsoft 365 copilot is an add-on license. It works on top of the following.
- 6:40Microsoft 365 E five, Microsoft 365 E three, we knew both of those.
- 6:44Microsoft 365 business premium and Microsoft 365 business standard.
- 6:48Except that if you have business premium or business standard,
- 6:51the only way you're gonna be eligible is if you have exactly 300 licenses
- 6:55because yes, it doesn't allow you to have more and less and I get it,
- 6:59some people have missed and matched, right? You could have 300 premium,
- 7:03300 standard for your 600 users or have a few enterprise mixed in with your
- 7:08business premium.
- 7:09But it kind of makes me chuckled that 300 is the threshold and you can put it on
- 7:13these business plans.
- 7:14But most people that are at that level aren't on business plans because
- 7:19they get capped at 300. We'll see.
- 7:22Obviously there's insights from like the licensing site that,
- 7:26or the licensing side that only the folks who run the service are privy to
- 7:31and they know their house, their business and where they wanna be with it. Yeah,
- 7:35I don't know.
- 7:36I still haven't had a chance to get broadly hands-on with it.
- 7:41Like I'm very much looking forward to seeing that rollout.
- 7:44I don't know how that'll go even at Microsoft,
- 7:47like as Microsoft employee do I get access to that? Well I get GitHub copilot,
- 7:51I have that. I get Bing enterprise chat. Yep.
- 7:53All those kinds of things are available to me today.
- 7:56I think one of the other things too is I wonder how many organizations sit down
- 8:01and look at,
- 8:03they look at maybe the raw cost of just a chat G
- 8:08P T and going straight to open ai.
- 8:10Like why wouldn't you give open AI 20 bucks a month to depending
- 8:15on the functionality that you need, right?
- 8:16Falling need is L L M without context. Like okay,
- 8:22go ahead and save yourself 10 bucks a month and go over here and get this tool.
- 8:26I know a lot of conversations that I'm hearing are folks saying that part of the
- 8:30justification of the price is that you're staying kind of inside the
- 8:35four walls.
- 8:36So you're not just paying for functionality of a copilot and access to a large
- 8:39language model.
- 8:40You're paying for access to a large language model that has context and access
- 8:44to your data within a security boundary.
- 8:47And that's big for a lot of organizations.
- 8:50If you and I worked for two different orgs,
- 8:52we don't want to be just going off and firing off business secrets to chat G P T
- 8:57under whatever nebulous licensing it has given day of the week and learning
- 9:01those things and then surfacing them up to something I say to it gets surfaced
- 9:05to you. Or even worse, something we say to each other,
- 9:07it gets surfaced to somebody else.
- 9:09So a part of it is just kind of covering your bases and making sure you've got
- 9:13that too. And I don't know how you quantify that one.
- 9:16Like that one feels very fuzzy .
- 9:19Yeah and very like process regulatory driven, those kinds of things.
- 9:23So we'll see where that one falls out.
- 9:28But the varied ENT entry is definitely very high.
- 9:30So it's a really weird gold rushy time right now. I don't know,
- 9:35it's the best time if you're like skittish and you're not an early adopter,
- 9:39it's not the best time to dip your toe in.
- 9:41You might wanna like just take a step back and and see how it goes.
- 9:44I agree.
- 9:45And Sean said in the chat that they're including business premium standard.
- 9:48Maybe they anticipate lowering 300. I hope so. I was, I don't know.
- 9:53I could beat this horse for a while.
- 9:55That's probably not politically correct but.
- 9:57No you're talking about.
- 9:58Boiling the frog. That's politically correct. Yeah.
- 10:01I'm surprised they're not pushing it out to smaller businesses 'cause I feel
- 10:04like a lot of the SMBs are the ones that could benefit from this a lot.
- 10:07Like I could use it for summarizing my email for doing some of that type of
- 10:11stuff and to put the barrier to entry so high and Enterprisey
- 10:16feels like they're missing a huge target market and we've said it,
- 10:21AI is expensive.
- 10:22Maybe it's just the pure expense of they can't afford the expense
- 10:27of all these five person companies turning it on.
- 10:30They need some bigger commitments due to the cost of it.
- 10:33I was just listening to a podcast too.
- 10:37We had talked about it I think a little bit last week,
- 10:39but it was after we recorded the acquired podcast and they did an interview a
- 10:43three hour, not an interview,
- 10:45a three hour podcast on Nvidia and the cost of
- 10:50some of these servers in the compute from Nvidia that I don't
- 10:55know that it was used to train Microsoft 365 copilot.
- 10:58But that hardware from Nvidia and training these models
- 11:03is, I don't know that I ever thought about the cost.
- 11:06It's expensive listening to the cost of some of this hardware from Nvidia
- 11:11and what these companies need to train some of these models.
- 11:14You're talking like hundreds of millions of dollars just for the
- 11:19hardware alone. if not billions. Yes.
- 11:22In other news super computers are expensive.
- 11:25That's my co-pilot news for the day.
- 11:27It's out , I mean November one is coming up rapidly. So I think,
- 11:31like I said, the way I'm viewing this as hits November one,
- 11:35nobody does anything in November December anyway.
- 11:37It's a slow time basically worldwide folks come back,
- 11:41they start really kicking the tires in Q one calendar year 2024
- 11:46and by like March, April, may,
- 11:49June-ish timeframe next year I think you're gonna see like a crazy number of
- 11:54articles start to come out that talk to R O I and T C O
- 11:59around LLMs like this. Yep.
- 12:01Particularly in the context of office work, right? Like in in the M 365 world.
- 12:07The other interesting thing that's gonna happen,
- 12:09I don't know if you watched the Google event from this week for they,
- 12:14they did like hardware announcements for the pixel, things like that.
- 12:17But one of the things that's happening on that side is Google's been AI driven
- 12:22for a long time as well but a little bit more on the consumer side of the fence.
- 12:25So they recently announced that they're chat chatbot
- 12:31Bard is going to have access to Gmail
- 12:36and be able to interact with and pull that information in
- 12:41as well. So that was announced back in like mid-September a couple weeks ago.
- 12:46But if you have access to Bard today,
- 12:48you can actually go out and ask Bard to do things
- 12:53against the corpus of data that exists
- 12:58inside of your Gmail account. Which lots of us have,
- 13:03I think I've had a Gmail account, maybe not when it was in beta,
- 13:07but like I remember getting one very early on like it's been out there
- 13:12for quite a while.
- 13:13So I have this large body of data that is
- 13:19now kind of sitting in Gmail that very much like an M 365
- 13:24copilot.
- 13:25I can point a large language model against it and say hey start to go
- 13:30figure things out for me.
- 13:32When's the last time that I met with Ben and talked to Ben about
- 13:37podcast analytics?
- 13:38And it can just go like figure that out and pull that information out.
- 13:42If you're,
- 13:43if anybody listen to this like you're looking for maybe some like real world
- 13:46anecdotes around Bard,
- 13:48I would recommend there's another podcast from the New York Times called Hard
- 13:52Fork.
- 13:53Go give a listen to their episode on Bard and Gmail integration.
- 13:58The two hosts of that episode have also been Gmail users for a long time.
- 14:01So like their prompt and the results are kind of hilarious. Like yeah you,
- 14:05you do have to go listen to it.
- 14:07But their prompt is basically tell me what psychological problems I have based
- 14:12on my email .
- 14:14And go that's really funny and go.
- 14:15Out there and figure it out. So that's a good one as well. I.
- 14:17Am sure you had Gmail and beta. Do you remember Gmail? I just looked it up.
- 14:21Gmail was in beta for five years. Oh sure. do you remember?
- 14:25I remember that 'cause it was so long.
- 14:28I was thinking like the earliest of the early days. I don't know.
- 14:30I'd have to go back in and and see when my first message was there.
- 14:342004 It was released and it was in beta until 2009. I know.
- 14:37That I've had Gmail so long that I had enough data in there
- 14:42like before they even had paid plans that I had needed to start purging data and
- 14:46getting it out because I was,
- 14:48'cause I was over the threshold for for data stored along the way.
- 14:51That's funny. Yeah, I'll love to go listen to that.
- 14:54I have not played with Bard so I have Gmail so yeah, I'll be honest,
- 14:56I don't use Gmail.
- 14:57I still have an account but it is mostly junk mail at this point in time.
- 15:02Which could be really funny to ask Bard about considering there is very little
- 15:07actual personal email in my Gmail account at this point in time. Yeah,
- 15:11so this is gonna be really interesting too,
- 15:13especially if G Google starts offering Bard to smaller companies or if they
- 15:18start integrating it in with the G suite and Microsoft is stuck at this 300 user
- 15:22limit of .
- 15:24If that's gonna affect like where SMBs go, I don't know.
- 15:29That's all speculation at this point in time. I think it's.
- 15:32Another valid thing to think about.
- 15:35So I think one of the other things that I've been keying onto is folks talk a
- 15:39lot these days about how much of big tech over the last couple years uh,
- 15:44has really been related to the phenomenon of having access to
- 15:490% interest rates. And it was cheap for everything.
- 15:52It was cheap to acquire hardware, it was cheap to acquire software,
- 15:55it was cheap to acquire people.
- 15:57So the the whole people process technology thing where you were always trying to
- 16:00kind of balance those three different things,
- 16:03you really didn't have to worry about it anymore 'cause people were so cheap
- 16:06that didn't matter. Tech was so cheap that it didn't matter.
- 16:09And now that those things matter,
- 16:12folks need to sit down and and think about really like how to get the most
- 16:16of it and where it comes in. I don't know.
- 16:19It's gonna be fun to watch from the outside I think is kind of my
- 16:24take on it right now.
- 16:25I agree.
- 16:26So with that we can be done boiling the co-pilot frog or beating the co-pilot
- 16:31horse or pummeling the co-pilot something else.
- 16:35What else do you wanna talk about? We had some news we had talked about,
- 16:39I had mentioned I owed some people a SharePoint, recycle PowerShell update.
- 16:44Where should we go from here?
- 16:45Why don't we get through your update and then we'll see what else we can swing
- 16:48in.
- 16:52Do you feel overwhelmed by trying to manage your Office 365 environment?
- 16:56Are you facing unexpected issues that disrupt your company's productivity?
- 16:59Intelligent is here to help much like you take your car to the mechanic that has
- 17:03specialized knowledge on how to best keep your car running Intelligent helps you
- 17:08with your Microsoft cloud environment because that's their expertise.
- 17:11Intelligent keeps up with the latest updates in the Microsoft cloud to help keep
- 17:15your business running smoothly and ahead of the curve.
- 17:17Whether you are a small organization with just a few users up to an organization
- 17:22of several thousand employees they want to partner with you to implement and
- 17:26administer your Microsoft cloud technology,
- 17:29visit them at intelligent.com/podcast.
- 17:33That's I N T E L L I G I N
- 17:37k.com/podcast for more information or to schedule a 30
- 17:42minute call to get started with them today.
- 17:45Remember intelligent focuses on the Microsoft cloud so you can focus on your
- 17:49business. We had talked, I think it was a couple weeks ago,
- 17:54it was two or three weeks ago where I was waiting for a script to go run against
- 17:58the recycle bin.
- 18:00This is an interesting thing to think about 'cause I've had this happen to me a
- 18:03couple times now.
- 18:04I was in a situation with a client and this was in all
- 18:09honestly self incurred a bit.
- 18:11We had a power automate automation go awry
- 18:16that went in and deleted like thousands of files.
- 18:20So this was not just five or 10 files,
- 18:22it deleted somewhere in the realm of like 10,000 files out of
- 18:26SharePoint. And fortunately for me for them when you.
- 18:31Say deleted 10,000 files,
- 18:32like somebody might wanna delete in bulk a bunch of stuff.
- 18:35But in this case not by design a little rogue and maybe ran away 'cause it was
- 18:39missing a conditional or it.
- 18:40Was by design that this is a little bit of a uni unique scenario
- 18:45with this particular customer and how they want to use SharePoint.
- 18:49We may have talked about this like years ago.
- 18:51This process has been in place for them for probably three or four years now.
- 18:56Where as they move certain jobs that they're working
- 19:01with through the internal workflow. So,
- 19:05so through their internal process they reach a point in time
- 19:09and this could be over several years that it works its way through this process
- 19:15where they actually want to move an entire folder that contains all
- 19:20the files related to a job from one library to the next library to the next
- 19:24library.
- 19:24Move it down the assembly line.
- 19:26We could argue the validity of doing that in SharePoint and why you would not
- 19:30want to do that and all the issues I encountered.
- 19:33But it is working As part of that we are using
- 19:38moving a thousand files that can contain multiple gigabytes from one SharePoint
- 19:42site to another. SharePoint site is not an easy task.
- 19:45A folder to a folder within a library works great site to a site does not.
- 19:50So we're actually using sharegate with a hybrid worker process to
- 19:55issue a copy command to copy it from one site to another.
- 19:58'cause sharegate does way better than anything Microsoft has but it doesn't do a
- 20:02move.
- 20:02Which is interesting right? you think,
- 20:04you think there'd be an a P I to enable that but nah whatever.
- 20:07That in and of itself is very interesting but it does a copy.
- 20:10Sharegate doesn't have a move. So we do a copy and then a delete.
- 20:14Well if that server goes rogue we were missing some error checking and
- 20:19the copy did not run but the following step to delete did run.
- 20:24So instead of copying from location A to location B and then
- 20:29deleting from location A,
- 20:31it tried to copy failed and then just deleted from location A just missing.
- 20:35Like a little conditional check or.
- 20:36Something, right? Missing a, hey.
- 20:38Did I actually finish right or did I do what you thought I was gonna do?
- 20:42Did this job run successfully? Did it actually hit the hybrid worker?
- 20:46Was the hybrid worker on all that type of stuff. So for like a,
- 20:51it happened over the course of two or three days I think it was deleting
- 20:56these folders without doing the copy.
- 20:58So they all fortunately ended up in the recycle bin. That being said,
- 21:02un-deleting a thousand files or in this case 10,000 files from their psycho bin
- 21:08is not something Microsoft makes easy,
- 21:11especially when there's folders within folders. One,
- 21:14I am not gonna go through a psycho bin and scroll through and individually
- 21:17select 8,000 files or 10,000 files and even try to find
- 21:22the right ones.
- 21:23Because the only way you can find them in the recycle bin is by looking at the U
- 21:26R L and making sure you have the right U R L and then you're looking for certain
- 21:31folders or sub folders.
- 21:32There is a PowerShell script and this is what I was waiting to run to un-delete
- 21:37stuff from the recycle bin to do a restore item. You're.
- 21:40Thinking about kind of the P M P method,
- 21:43get a context to the web and just basically go to that recycle bin and just boom.
- 21:47Pull back everything. Yeah that's loop through it approach. Yes.
- 21:51Look at the U R L and then you do a restore item.
- 21:54If the U r L matches it worked by and large.
- 21:57I actually had a content type that inherited from a folder.
- 22:02I did not worry about this because it wasn't super important in this particular
- 22:06scenario. But if you try to restore an item before you restore the folder,
- 22:09it just creates a normal folder and it doesn't actually restore the folder.
- 22:13And then when it tries to restore the folder, that's actually a content type,
- 22:16it throws an error because the folder's already there.
- 22:19So if you really wanted to write this well you'd have to restore all of your
- 22:24folders first but restore them in the right order from the highest
- 22:28down to the lowest level to make sure you kept all the properties and the
- 22:33metadata and the content type and all of that. Mm-hmm ,
- 22:36it's a pain to do this. Again for this scenario, I didn't care.
- 22:40The really one I only cared about was the top level and I just let it go wild.
- 22:44If it created a folder, if it aired because the folder was already there,
- 22:47I let it air and then I just switched the content type at the root level and
- 22:50just put the metadata back on.
- 22:52This took a surprisingly long time for about 800 files.
- 22:57It's a lot of a p i requests like going back and forth.
- 23:00Like even just the initial like enumeration. It's, yeah,
- 23:04I mean you think about it like each one of those is effectively like an HT P
- 23:08request takes time, has latency, you might inject additional logic,
- 23:12you have the overhead of auth and all the other,
- 23:15there's a bunch of stuff that goes into it that isn't like readily apparent and
- 23:19you're like, oh I just, I need an easy button. Right?
- 23:21And I'm kind of surprised there isn't an easy button at this point,
- 23:24but I don't think the scenario of, hey, I deleted 10,000 objects,
- 23:29like whatever it happens to be is probably not like a high order bit.
- 23:33Probably not super common. No. And the other thing you can hit,
- 23:36because I absolutely hit it,
- 23:38is if you try to do 'em all at the same time or do 'em all sequentially,
- 23:42it takes,
- 23:43so it took about a hundred an hour to restore like 800 files.
- 23:48So 10,000 files, you're looking at 10 hours. I got throttled.
- 23:53Microsoft did not appreciate me hammering away at that a p I on that site for 10
- 23:57hours straight.
- 23:58And they started getting throttled because I would go try to visit the site to
- 24:02see are these showing up or not?
- 24:04And I was getting messages in the browser about being throttle. I was like,
- 24:08yeah, I cannot load this page. And if you go look at the U R L,
- 24:10it's the whole throttling thing. Now you've done it. To your point,
- 24:13Microsoft does not make this easy. I'm really hoping. So they have,
- 24:17and we talked about it before,
- 24:18some of the backup stuff coming to syntex later this year.
- 24:22Ideally in this scenario,
- 24:24I think this is one where having a backup or restore tool could
- 24:29potentially make this quicker. I don't know,
- 24:32I don't know what the APIs look like there.
- 24:34If you have a backup tool and you go through and select your top level folder
- 24:38and do a restore, if that will speed it up.
- 24:42Or if when Microsoft comes out with their backup and syntax,
- 24:46I know initially I think in that post they said they're not gonna have file or
- 24:51folder level restores. I think it's more gonna be site level. But that would be,
- 24:56this is one of those scenarios where we talk about,
- 24:59and I've heard clients say it, ah, Microsoft's got everything backed up.
- 25:02It's highly available. They're prepared. Yeah, to a certain extent.
- 25:06But a scenario like this where it's in the recycle bin or had we not caught this
- 25:10right away and we had gone the 90 days,
- 25:12this is where you get yourself in trouble. And torg in the discord chat too,
- 25:17he said he has some users that mass delete directories trying to unsync
- 25:21libraries to their local pc.
- 25:23That one happens quite a bit.
- 25:24You can end up in the same scenario.
- 25:26I'm guilty of that one. I forget. Sometimes it's, yeah, it's tough. So I,
- 25:30I mean I think you're doing the right things.
- 25:33The takeaway is you need to think about that stuff.
- 25:36Maybe you need to have a process to go and have an escalation path in your help
- 25:40desk for end users who delete stuff. Folks are familiar with the recycle bin,
- 25:44they know how to do self-service restores, all those kinds of things.
- 25:48There's only so far that somebody could go as a service provider to stop you
- 25:52from taking out a gun and shooting yourself in the foot. Uh, if you do,
- 25:56it's great. Here's how you're gonna triage that and get yourself back. Yeah.
- 25:59You're just not gonna walk straight ever again. It'll be fine.
- 26:02Scott, we're going all off the rails for politically correct this episode.
- 26:05We're shooting ourselves, we're boiling frogs, beating horses, .
- 26:09, all of it. Yeah. Yeah.
- 26:11It's bad out there for body parts and animals today. That's,
- 26:14that's all I gotta say. Not.
- 26:15A good episode for that. But no, I agree a hundred percent.
- 26:18There are absolutely ways to shoot yourself in the foot with all of this and
- 26:23get yourself in trouble. And to your point, having a plan,
- 26:27how are you gonna handle this? Even some sort of monitoring in place.
- 26:32That's another thing is how do you necessarily know when files are deleted?
- 26:37I don't know that I have a solution for this,
- 26:39but I have absolutely had customers call me before too and say,
- 26:42this file was there yesterday or a week ago or two weeks ago.
- 26:45It's not there today. And it's been one,
- 26:49try to find it. Is it in the recycle bin? Sometimes it's not been deleted.
- 26:53It's been moved. Mm-hmm .
- 26:55And I've used the audit log in compliance center. I.
- 26:58Was gonna say that's what you wanna do.
- 26:59You wanna like kinda like clap and wipe your hands into the audit log. We go,
- 27:03yes. You just had to hope you had the audit log on and that it was there and
- 27:07available for you. But that's not, and that.
- 27:08Could find it because we could also talk about the audit log search and the
- 27:13horrendous of trying to put a path into search for a certain file or folder.
- 27:18It is far from ideal in my experience
- 27:23and perspective. They're coming out with some new search capabilities.
- 27:26I think the new search is there now and the classic search is going away because
- 27:30this is the whole theme of Microsoft lately is we have new and we have classic,
- 27:34whether it's the audit log search or Microsoft Teams or any number of other
- 27:38things. So yes, that is when the audit log becomes your friend.
- 27:42And hopefully you can get searched to work and you have the data there.
- 27:45But that was my SharePoint Restore and it is not fast.
- 27:49,
- 27:50so still have to rely on P M P and sharegate and hope for the best.
- 27:55That was it. But everything's back now. Everything is moving again.
- 27:59My jobs are running successfully and stuff is not being inadvertently deleted
- 28:03before it's moved.
- 28:04And it only took me running PowerShell all night long between getting throttled
- 28:08and just the time it took. Azure.
- 28:11Automation jobs have been updated, logic's been updated, all is accounted for.
- 28:16That's.
- 28:16That.
- 28:16That's that. All right, well we got time for, what do you think? One more.
- 28:21Do you wanna throw in one more? I, oh,
- 28:22I have an announcement but that's really quick.
- 28:24Should we do that at the end or should we throw that in now and then do one
- 28:27more? It's up to.
- 28:28You. It's your.
- 28:28Show. Not really. You had one more. Okay. So really quick. E S P C ,
- 28:33the European SharePoint Conference, they sent me a LinkedIn message.
- 28:37So this is absolutely valid ish.
- 28:40They have these community awards,
- 28:43they're Inspire awards where you can go in and do a nomination for best
- 28:47community contributor, best YouTube channel, best online courses,
- 28:50diversity leader, award tech, trailblazer wellness mentorship,
- 28:54young female STEM award, and the best podcast Scott.
- 28:59So they said they wondered if we would just let people know about this so people
- 29:03could go in and nominate all of those different people.
- 29:05Help kind of get the word out about community.
- 29:09People that you maybe know about,
- 29:12enjoy working with can recognize some of those community members.
- 29:16And naturally having a podcast.
- 29:19I think you should go nominate us for the best podcast. But I'm partial.
- 29:23If you don't nominate us, I won't be hurt.
- 29:25But the link for this is we'll be in the show notes. We threw it in Discord.
- 29:30So if you do wanna go know somebody that's in the community,
- 29:33if you do wanna maybe nominate our podcast, I already did it, Scott.
- 29:37I nominated ourselves and I put right in why we're the best podcast.
- 29:41And it was because I do it and it's my podcast and I'm very partial .
- 29:46Yeah,
- 29:46they just asked if we'd help raise some awareness for people to go out and vote
- 29:50for these Inspire awards and different people that are contributing to the
- 29:54community.
- 29:55Excellent. We'll.
- 29:56Throw that in and then we can do one more.
- 29:58Inspire away.
- 29:58Inspire away. Maybe.
- 30:00We'll have to come back and revisit this one.
- 30:01I don't know how much of a rabbit hole it's gonna send us down.
- 30:04Virtual machines in Azure use virtual machines in Azure. Oh.
- 30:07This one could be a rabbit hole, but we can do a longer up.
- 30:09We could do a longer episode today.
- 30:11I mean it's up to you. It's your show.
- 30:12No it's not. This one's yours. However it.
- 30:14Works out.
- 30:14No, we're gonna do this. We're gonna talk about this.
- 30:16'cause this one is a kind of a big deal I think. I.
- 30:20Don't know that it's a big deal.
- 30:21I think it's interesting 'cause it's something that I've never really thought
- 30:25about and I've always taken for granted. Back to my question.
- 30:30Okay, so what is this? You.
- 30:31Use uh, virtual machines in Azure? Yes or no? Yes. Okay, great.
- 30:35Quite a few. Do.
- 30:36You ever browse the internet from your virtual machines in Azure?
- 30:39Like maybe to go outside and download something,
- 30:42get access to external data that exists outside the purview,
- 30:46not of pun intended, but outside the boundary of your vnet.
- 30:50So you're accessing information on the public internet.
- 30:52Maybe you go to Google being duck to go things like that.
- 30:55100% Of the time. Whether it's to download PowerShell modules or like you said,
- 31:00download software.
- 31:01I don't know that I've ever had a VM in my experience that doesn't,
- 31:04I know clients do. But yeah, I'm always using the internet for my VMs.
- 31:07Why else do you have a computer other than the internet?
- 31:09100000%.
- 31:11I do this as well and I've never really thought about it.
- 31:16Like specifically the way that your virtual machines mm-hmm.
- 31:19automatically get outbound internet access and access
- 31:24to the public internet. So there's, in Azure virtual machine land,
- 31:29there's ways that you can privatize the traffic for your virtual machines.
- 31:33Even from an outbound perspective. Like you could do forced routing,
- 31:37you could go through a nat gateway. There's ways to route through sbs.
- 31:41You can stand up your own public IP and you can say, great,
- 31:46I have a PIP on this vm and therefore the PIP is this.
- 31:49And outbound internet access is gonna drive that way. Yep.
- 31:52But if you just go stand up at a standard vm, it's, oh,
- 31:55I still get an bog standard vm. Like any vm. Oh,
- 31:59I still get outbound internet access.
- 32:01So there's this really interesting update that came out on Azure updates.
- 32:05And the notice is that default to outbound internet
- 32:10access for virtual machines in Azure is being retired.
- 32:15And customers need to go ahead and transition over
- 32:20to a new method of internet access.
- 32:24So in the world today,
- 32:26and up until the time this retirement is driven all the way through
- 32:31in 2025, like it's a ways out. You got time, you just go create a VM and,
- 32:36and you have that access. In the future, that's not going to be the case.
- 32:40You are going to have to explicitly define your
- 32:45method of outbound internet access. And again,
- 32:49going back to things like stand up a nat gateway,
- 32:53create a load balancer and have an outbound rule on that load balancer and then
- 32:57that load balancer gets a PIP on it, all that kind of stuff.
- 33:00Or just go ahead and directly attach a PIP over
- 33:04to your virtual machine. So, uh,
- 33:09I was trying to think like for the number of times that I create a virtual
- 33:11machine and I x x my way through it,
- 33:13or I have just some like basic arm templates, Hey,
- 33:15spin me up like in Ubuntu 20.4 l t s, blah, blah, blah.
- 33:19So I can play with it and do something with it and I gotta go back and adjust
- 33:23that stuff and make sure that I actually have them figured in with
- 33:27things pips in them. Like, Hey,
- 33:29gimme like a basic public IP and associate that with my nick and get it going.
- 33:35If I wasn't doing that already in some way,
- 33:40shape, or form. Yeah. So not like a massive change. Arguably a good thing. Hey,
- 33:45like you get more control and you'll have more insight into what's going on.
- 33:49But it made me do a double take. Like just going back thinking like, huh,
- 33:53I've never actually thought about the way like default outbound internet access
- 33:57works. I always just take it for granted.
- 33:59'cause usually the first thing I do is hop on a VM and then go download
- 34:02something . Let me just reach out. And.
- 34:04And that's mine. And I will say by and large,
- 34:07my VMs tend to have public IP addresses because
- 34:13most of the time I'm just doing an R D P connection into 'em.
- 34:16I am not being super secure.
- 34:17I'm not going and paying for Bastion or just in time or any of those.
- 34:22I just put on a public IP address.
- 34:24I lock the R D P port or the R D P access on port 33 89 down
- 34:30to my public IP address. So I don't have a ton that don't have a public ip,
- 34:34but I absolutely similar type thing have clients where they're using
- 34:39Bastion to access everything and they don't put that public
- 34:44IP address on because they don't want that VM exposed to the internet
- 34:49on a public IP address.
- 34:50100% And totally valid. Right? Right. That's a great.
- 34:53Use case. And that's where, maybe not a huge deal,
- 34:57but I think to the one that I'm using sharegate on,
- 35:00the one that I'm using for this client to move files.
- 35:03It doesn't have a public IP address. I use Bastion,
- 35:06but I'm always going into it and downloading updates to the PowerShell
- 35:11modules, to the p and p command. Lets,
- 35:13or grabbing a sharegate update as they update it, stuff like that.
- 35:18And that particular client, they're not gonna put a public IP address on it.
- 35:22I don't know that they necessarily want to from a security perspective,
- 35:26but that means they are gonna have to go in and they may have some load
- 35:30balancers and Azure firewalls, something like that already.
- 35:34I'm actually not a hundred percent sure, but they're gonna have to,
- 35:37to go in then and reconfigure all of these different machines
- 35:42if we still want them to have internet access.
- 35:44Or some clients that do make it all privatized and they require you to A V P
- 35:49N into Azure or be on the network.
- 35:52And they're using express route to access all their VMs and Azure.
- 35:56Like I think some of those companies that maybe have large footprints in Azure
- 36:00and really have tried to privatize 'em. And to your point when you're like,
- 36:05you locked this down and you're gonna have to figure out another way to
- 36:07internet, I'm like, huh, I had your reaction. Like,
- 36:10I've never thought about that before. If I don't have a public ip,
- 36:12I can still get to the internet.
- 36:14That might be a fairly large change for some of these enterprises that
- 36:19have tried to lock it down, but maybe haven't had that Huh.
- 36:24Moment that you and I just did of, I do still get to the internet with those.
- 36:28It makes me think that I need to go get hands on with Nat Gateway,
- 36:32which I don't think I've done yet. I, I was trying to think a little bit like,
- 36:36have I ever even deployed a Nat Gateway and I haven't gone down that
- 36:41path so far. And I, I think Nat Gateway, like, and when you go read the docs,
- 36:46it's kind of the preferred way to, to go down this path. Like, all right,
- 36:51let's start at the top, secure by default, blah, blah, blah.
- 36:53You start walking the line down and you get to outbound connectivity and all
- 36:56that stuff. And Nat Gateway is kind of the go-to thing.
- 37:01So maybe we'll have to go and play and and get hands on with
- 37:06that one. 'cause Nat,
- 37:07the other thing with Nat Gateway is it's not just for virtual machines. Well, I,
- 37:11I mean it's for units of compute, like private compute.
- 37:16And the reason I'm being kind of cagey and saying units of compute,
- 37:18because there's potentially PAs services that leverage virtual machines as
- 37:23like IAS constructs a k s, Azure Kubernetes service. Yeah.
- 37:27Do functions or web apps on an isolated plan and stand
- 37:32those kinds of things up.
- 37:34App services where you have vnet integrations and things like that come through.
- 37:39Even other like data analytics services like synapse, databricks,
- 37:44all those things.
- 37:45Like they can get on v VNAs and do some kind of basic injection and
- 37:49things like that.
- 37:50And those are all subject and would also work with something like a Nat Gateway
- 37:55as well. So, yeah.
- 37:57So Sean is telling you what's super easy to set up.
- 38:00So if we go try this and we mess something up, Sean's gonna laugh at us. If.
- 38:04We mess it up, it's gonna be in, in your Azure subscription.
- 38:07It's be it'll be be fine. It'll be fine.
- 38:10No, we should, I haven't set up an that gateway either. We'll.
- 38:13Do that one as a a two to the cloud thing and just next extra way through it
- 38:16without any docs should, if Sean says it's easy, it's gotta be easy. Yeah.
- 38:20It could go wrong.
- 38:21I mean it's just something in Azure we can always delete it and recreate it,
- 38:24right?
- 38:25Yeah. Uh, I mean his hour hourly rate so he, he can come back and fix it for us.
- 38:29That's okay.
- 38:29Fix it up. Alright, well yeah, this one interesting. Like you said,
- 38:33you definitely have some time to go to go in and fix it,
- 38:36but it is one that I think is gonna make people go, huh,
- 38:39and have to think through what this actually means for maybe some of their
- 38:44larger deployments. That's about.
- 38:45It. That's it. We'll see if we need to come back and revisit that one. Alright,
- 38:48we got through it. Look at that. We.
- 38:49Did. And we're not too far over our normal allotted time.
- 38:53So with that another day, another week,
- 38:57another episode. Scott. Oh, I should look just a minute.
- 39:01We're not gonna hit it yet. Do you know a milestone? We're about to hit Scott.
- 39:05We are about to hit a milestone on this podcast.
- 39:07A milestone. Let me see. I'm on the backend.
- 39:10This is episode 356. That doesn't mean much to me,
- 39:15it just means that we've been doing this a long time.
- 39:18You have some weird download milestone or something in your head? I do.
- 39:21You got it. But I can't. Oh, there we go. Sign in. Let's go. Look. As of today,
- 39:26we have all time. Friday.
- 39:29October 6th.
- 39:29Friday October 6th.
- 39:31If you wanna know the lag on how long it takes to get these out.
- 39:34. Yeah, we have a little bit of a lag right now.
- 39:36We've kind of gotten ahead. So, but as of today, October 6th, we have
- 39:41996,949
- 39:47total show listens slash downloads since we started the show. Yeah.
- 39:51Listen. Only the ones that come from the official stuff too.
- 39:55I think you get more out of Spotify and Google and all that if.
- 39:58You would go include those. I see. And I think,
- 40:01I don't know if Spotify's included in these or not.
- 40:03I know YouTube listens or not. So we may have already crossed the threshold,
- 40:08but in our official stats tracker on the background over the last
- 40:13six years, we have almost reached that million download mark.
- 40:17There you go. I have to buy you a cake or something.
- 40:20In how many countries do you think it's been downloaded in Scott? Just random.
- 40:24This is random.
- 40:25113. Oh, they.
- 40:28Got rid of my total view. I don't know. ,
- 40:30they used to tell me it's more than, oh no, there it is.
- 40:33190 countries.
- 40:35Some of them only have one download 'cause I don't know why,
- 40:38but we haven't downloaded now in 190 countries across those million downloads.
- 40:43It's kind of fun just to go in and see because not too, Shay, let me tell you,
- 40:48I would never be able to get to 192 countries. So in some strange, weird wayco,
- 40:53we have been in 190 countries or at least our voice has been. There you go.
- 40:57So.
- 40:57With that, go enjoy your weekend. That was my weird milestone,
- 41:01my almost milestone We've hit and we will be back next week with
- 41:06some other topic about something that strikes our fancy .
- 41:10Very descriptive. All right, thanks Ben.
- 41:12All right, thanks Scott. If you enjoyed the podcast,
- 41:17go leave us a five star rating in iTunes.
- 41:19It helps to get the word out so more it pros can learn about Office 365 and
- 41:24Azure.
- 41:25If you have any questions you want us to address on the show or feedback about
- 41:29the show, feel free to reach out via our website, Twitter, or Facebook.
- 41:34Thanks again for listening and have a great day.