What's going on everybody? Today we are going to be starting our MySQL tutorial series. Now the entire MySQL series will be broken up in three smaller series. We'll have our beginner, our intermediate and our advanced. This lesson is the very first lesson in the beginner series where we're going to walk through all of the beginner or the basics of MySQL. Today we're going to be setting everything up. So we'll be installing MySQL and then creating our database that we'll use to actually learn MySQL. Now before we get started I wanted to let you know that I created three full MySQL courses over on analystbuilder.com. I built a crash course for MySQL for people who are going to be interviewing or taking technical interviews. I also created a full MySQL course that's going to cover everything from the basics all the way to the intermediate level. And then lastly I created an advanced course that's going to teach you a lot of the more advanced things that an analyst would typically use. Those courses are going to go really in depth and they're going to have a lot of practice questions along the way and we'll also have full guided projects in there as well. I'll have links in the description to all of those courses if you want to check those out. Now without further ado let's jump on my screen and install MySQL and create our database. All right so let's get started by downloading MySQL. We're going to come right over here to dev.mysql.com forward slash downloads forward slash installer and I will have that link in the description so you don't have to write all that out but you should be seeing this page right here. Now we have to select an operating system. I'm using a Windows machine and if you aren't if you're using Linux or Mac or something else it should populate it for you but if it doesn't just select this drop down and select your operating system. Next we have two different downloads. We can install the MySQL installer community or MySQL installer web community. This one is very small but then you actually do have to download the installer it just gets it from the web. This one I'm going to download the actual installer it's larger but this is the one I'm going to do. I'm going to go ahead and select download. It's going to ask me if I want to log in or create an account and I don't. I'm going to say no thanks just start my download. I'm going to save this in this desktop folder. It doesn't really matter where you save it we're going to save that and it's going to download it should be done in just a few seconds. I'm going to go ahead and click on it and it's going to open it up when it's finished and we should get the interface or the UI for the actual installation for MySQL. So here is the MySQL installer and first thing we need to do is choose a setup type. Now we're going to keep the developer default unless you really know what you're doing and you can select the server only the client only full which is literally everything MySQL has to offer or custom. So we're going to keep this developer default just installing the things that we kind of need. So let's go ahead and select next and for whatever reason on my computer it's saying this path already exists you probably won't get that but I'm just going to go ahead and select next and then I'll select yes it keeps doing that I can't explain why but it keeps doing that for me even though I've deleted it for my computer completely but it just remembers it somewhere in its memory. Now the next thing we need is to check requirements now I just have this one it says I need to download this visual studio I'm not going to do that but on your screen you may have multiple multiple requirements typically you're looking at something like this Microsoft Visual C++ redistributable package what you need to do is download this all you have to do is click download once you download and install that on your computer and then we go back all those should be gone that's the one that I see the most when I'm actually working with these requirements I had to install it myself when I got this new laptop so go ahead and install that if you need to but if yours looks like mine we don't need this visual studio for what we're going to do we want to go ahead and select next it is giving us a prompt that we haven't satisfied all the requirements but that's okay we're going to go ahead and select yes as well now we're ready to install all of these things these are all things that MySQL wants you to install the most important are the server and the workbench but it does not hurt to have all these other things as well some of these connectors are also important so we're going to go ahead and execute this will take just a few minutes I'll skip ahead when they're all done but this should take just a few minutes and then we'll continue on installing MySQL everything just completed and now we're going to select next and now we need to actually configure our product now really the only one that we actually need to configure is the server the router says we need to configure it and the samples and examples say we need to configure it as well but really it's just the server let's go ahead and select next now we're not going to change anything for this type and networking unless you know what you're doing with the port the export to call port we're not going to change any of this we'll go ahead and select next next thing we need to do is select an authentication method I'm going to be using a password I'm not going to be using the legacy authentication method so I'm just going to go ahead and create a password now for you and I keep getting this error and I can't explain why right here for you you should be creating a password at the bottom it's remembering my password somehow and I I really can't explain it but I'm going to create my password or check my password this is one that I already created before I deleted it off my computer but it's still there so it's saying my password is still good but if you need to you should be entering a password and then confirming your password and saving it and then you should also be checking it as well and then we're going to configure this as a MySQL server as a Windows service I'm going to keep that checked and we're going to start the MySQL server at system startup I like that automatically being there I don't want to mess with that so I'm going to keep it as it has it I'm going to go ahead and select next and the last thing we do is just need to execute this and then everything we put in there is going to actually go so let's run this and execute it and that just finished so let's go ahead and select finish now it's configuration complete for the server but we also need to configure these other two let's take a look at these really quickly we're not going to do anything on this it even says we really don't need to do this we just need to click finish and configuration not needed next we'll do samples and examples and we can input our password and all this is really going to do is put in some sample databases for us in our database which if you want you definitely can do that I just connected that worked I'm gonna hit next and execute and it's basically just going to put in a database or two some sample ones for you to look at and the configuration is complete you don't have to do that one but we'll see that in just a second we're gonna select next and now the installation is completely done and we can start my sequel workbench after setup and start my sequel shell after setup now I'm not going to do the shell so I'm going to actually uncheck that and we're going to select finish now my sequel just popped up for us and this is exactly what you should be seeing now there's a lot of things in my sequel to learn and know how to do we're not going to be taking a look at all that stuff today but in future lessons we'll walk through a lot of these different things that kind of correlate with different lessons or things that we're working on in my sequel the first thing that we're going to click on is right over here this is our local instance this is local to just our machine it's not a connection to you know some other database on the cloud or anything like that it's just our local instance we're going to go ahead and click on this so this is what you should be seeing right here this is we're going to actually write all of our sequel code and I'll show you all this in just a second but this is where we can actually create our database and our database is going to go right over here on this left hand side the silica one is actually a sample database it has a bunch of tables and views or procedures functions has all these things in here if you want to go ahead and mess around with that what we're about to do is create our own database that we're going to be using throughout this entire series both the beginner intermediate and advanced we'll use a lot of this and sometimes we'll import some other ones for different use cases but this will serve for most of what we're trying to do throughout this entire series now what i'm going to do is i'm going to go ahead and i'm going to say open a sequel script file in a new query tab and right here it opened up to a folder that i already created this my sequel beginner series folder within it we have this right here the parks and rec create underscore db now in order to get this you just have to go to the github and download this file that's all you have to do we're then going to open this file so let's click on it we're going to say open and what you're now seeing is basically the query editor this is where you can write your code now we're not importing a database we're actually creating it by running code now because this is the first lesson in the beginner series i'm going to assume that you don't know a ton about my sequel really all this is doing is creating the database name and then we're inserting a few tables into that database and then we're inserting data into those tables so this is all of our data that will go into these tables that we create we only have one two three different tables that we're going to be using so all you have to do to run this is click this lightning button right up here we're going to go ahead and execute this if we come down to the bottom and we pull this up this is our output this says six rows affected and we have a bunch of other things like create table create table insert insert create table insert into these things are all working perfectly so now if we go ahead and click refresh in our schemas with this refresh button right here this parks and recreation table is populated if we go under the tables we see all of these things so now that we've actually created our database and our tables that's really all we were trying to do in this lesson but i just want to open up a table really quickly show you what it looks like show you how we can run code and then in the next lesson we'll start actually learning how to query this data so let's go up to employee demographics we're going to right click and select rows limit 1000 this is going to open up a new window right up here and it's going to say select everything from this database dot this table employee demographics and it ends with a semicolon now right down here we have this output window this is the actual data that sits in our table we have columns right here so employee ID first name last name age gender and birth date and then here all of our employees on each row so these are all separate rows we have lisley nope tom haverford and it goes on and on so this is all of our data the most important things to know when we're actually working with this and i'm going to zoom in is if we hover over this query right here and we run it we can select this execute which is this lightning bolt with this eye we're going to execute this and it's going to run this because we're highlighted over it now if we have two queries let's say this one right here but let's change it to employee underscore salary we'll do underscore salary let's say we want to query this table so now if we highlight over this and we go up and select the lightning bolt with the eye now we're looking at a different table but if we select even if we're hovering over this if we selected this button we're going to execute everything in this editor window so let's run this and now you can see at the bottom we have two outputs the employee demographics and the employee salary so this button is going to run everything in this editor window whereas if we select this lightning bolt with the eye we're doing everything that's just under where we have the cursor where we have it highlighted the very last thing that i want to mention is that right over here you may have this up and you probably don't want that we're not going to do any sequel editions in the series you can get rid of that by clicking this button right here so starting in the next lesson we'll have everything ready to go and we will start learning the basics of my sequel i hope you're able to follow along get everything set up how we have it on the screen i am super excited about this series i just i love sequel so i'm really really really excited to get started on this with you guys i will see you guys in the next lesson


I'm very delighted to be part of this historic event to flag off the operations of the federal government's rapid response register, RRR, for the COVID-19 cash transfers. This cash transfer project is a national initiative to build a shock-responsive framework for capturing and registering the urban poor and vulnerable populations across Nigeria. The new register complements the already existing platforms under the World Bank-supported National Social Safety Net Project, the NA SSP. Our government launched the National Social Protection Policy in 2017 to provide the framework for institutionalizing the work that we started since 2016 on reducing extreme poverty in Nigeria, based on our administration's vision to create a comprehensive social security program for the poor and vulnerable, and thereafter, the presidential pledge to lift 100 million Nigerians out of poverty in 10 years. In furtherance of these objectives, the Ministry of Humanitarian Affairs, Disaster Management and Social Development was established in August 2019 to coordinate all humanitarian and social protection activities in Nigeria. The National Social Protection Policy established the minimum guarantees for social assistance and social security in Nigeria. It also provided the framework for the implementation of social investment and social safety net programs in the country. Under the NA SSP, Nigeria has been building a social register of its poor and vulnerable populations, starting from the poorest geographies which have been in the largely rural areas. As of 31st December 2020, we have identified and registered about 24.3 million poor and vulnerable individuals in the National Social Register, equivalent to about 5.7 million households. Through this project, we are currently injecting about 10 billion Naira directly into the hands of about 2 million poor and vulnerable households every month. This is about the largest evidence-based effort by any administration on poverty reduction, and its impact on the lives of the poor is huge. By way of improving the livelihoods of beneficiaries through enhanced household purchasing power, smoothing consumption, increasing savings, and acquisition of household assets, and improving the local economy generally. Of course, there are many more ramifications. When the COVID-19 pandemic struck in February 2020, those in the National Social Register, which is an aggregate of all state social registers of the poor and the beneficiaries of the National Cash Transfer Program, were likely rural people. Nonetheless, it quickly became obvious that while the COVID-19 containment action was effective in slowing down the spread of infections, it also impacted the urban informal workers and dwellers, especially those daily wage earners that could not work due to lots of jobs, due to business closures, or restrictions on movement. So from this situation emerged a new set of vulnerable groups of people at risk of falling into poverty. As for this category of people who were not previously captured in the Social Register, the Ministry of Humanitarian Affairs, working with the NASSP, designed an intervention to rapidly identify register and provide them with circle. Hence, the rapid response register, RRR, was born. The rapid response register is designed to focus mainly on the urban poor wards selected using scientifically validated methods of satellite remote sensing technology, and you already heard quite a bit of that from the coordinator of the program. It also includes machine learning algorithms and big data analysis. This social protection method of targeting is the first strategy to be developed and tested in the sub-Saharan Africa region, and Nigeria will be the first country for its implementation. With the rapid response register, which uses a wholly technology-based approach, we are now primed to achieve an end-to-end digital footprint in cash transfers for the urban poor, which also helps us to achieve our financial inclusion policy under the Enhancing Financial Innovation and Access Program. I must commend, most heartily, the Honourable Minister of Humanitarian Affairs and her team, not only for this innovative effort, but for the discipline and resourcefulness that they have brought into the execution of the project to deliver it so promptly and so well. The groundbreaking success of the rapid response register now emboldens us to achieve our aspiration of a social security program for a minimum of 20 million Nigerians in the next few years. This will be the largest of its kind on the continent. This is, at least from the perspective of this tested approach, now well within our reach. The only constraint, of course, is the funding, which we must look for because, certainly, this country deserves a social security scheme that will not merely alleviate poverty, but also create wealth for the millions of those who are waiting for these opportunities. Honourable Minister, distinguished guests, ladies and gentlemen, as a testament to the commitment of the Federal Government of Nigeria to creating opportunities for millions of Nigerians to exit poverty with dignity and hope, it is now my special pleasure and privilege to flag off the COVID-19 cash transfer project to the glory of the Almighty God. Thank you very much.


Coming up on DTNS, how the supply chain disruptions will affect your technology. Yahoo starts a cell phone service and whether the internet can handle everybody working from home. This is the Daily Tech News for Wednesday, March 11, 2020 in Los Angeles. I'm Tom Merritt. And from a conference room in the Presidio area of San Francisco. I'm Sarah Lane. From Salt Lake City, Utah. I'm Scott Johnson. And I'm the show's producer, Roger Chang. We were just talking about a lot of the things, both technology and not technology, being affected by the coronavirus, things that are being canceled, talking about all kinds of things on good day internet to become a member. Don't miss out, patreon.com slash DTNS. Let's start with a few tech things you should know. You know that March announcement that Apple was expected to maybe make about possibly an inexpensive iPhone model? Well, cult of max versus say, not going to happen. Delays to the supply chain of pushback production levels and thus new product releases. Also, Apple is located in Santa Clara County in California, which is banned gatherings of more than 1000 people. And Apple executives were reportedly wary of even holding a smaller gathering than that. I feel like I'm not going to get my iPad pro update. A vulnerability in version 3.1.1 of the server message block 3.1.1 for Windows, which is used to share files and printers and such could be exploited by a worm. Yeah, that's right. The flaw effects Windows 10 and Windows Server 2019. Microsoft does not yet have a patch, but vulnerable servers can disable compression to block unauthenticated attackers from exploiting the vulnerability. Microsoft also recommends blocking port 445. That's the bad Microsoft news. The good Microsoft news is that Microsoft, along with a bunch of other folks announced the takedown of the Neckers, Bach net that spelled any CURS believed to have infected more than 9 million computers worldwide. Microsoft teamed with cybersecurity firms, ISPs, domain registries, government certs and law enforcement across 35 countries in the effort. The team broke the botnets algorithm that generated random domain names for their command and control servers used to operate the botnet. So the Microsoft team was able to predict what domains would be registered and then prevent the botnet from registering them. Microsoft also got a court order to take control of some existing domain names hosted in the US by the botnet and ISPs and cert teams are working with Microsoft to notify affected users so they can remove the malware in the UK. They announced in a policy paper that it will begin taxing digital services starting April 1st. Not an April Fool's joke. Search engines, social media services and online marketplaces with revenues of more than 500 million euro will derive at least pounds. What? Sorry. Pounds, not euros. Oh, did I say euros? I meant pounds. That's what I meant. Anyway, who derive at least that or derive at least 25 pound 25 pounds million of the revenue from the UK users will pay 2% of the revenue in tax. Disney Plus is live in India 18 days before the expected launch date of March 29th. Disney owned Hot Star is now called Disney Plus Hot Star. Disney Plus Hot Star premium subscription is currently priced at 299 Indian rupees. It's about $4.05 US dollars per month or 999 rupees or $13.55 per year. All right. Let's talk about one of the more prominent technology cancellations today, Scott. Let's do indeed the entertainment software association or ESA announced Wednesday it will not hold E3 2020, the electronics entertainment expo. This was scheduled for June 9th through 11th in Los Angeles, California. The USA cited the COVID-19 virus as the reason and saying it is looking into quote an online experience to showcase industry announcements and news in June 2020. Microsoft and Ubisoft are among companies indicating they will have their own digital events to replace what they would have done at E3, but with Sony already not being a part of the show well before any COVID-19 news and Nintendo doing their own thing for years now. It was already kind of becoming a bit of a sparse event. One of the announcements ESA had made earlier this year and late last year was they're going to try to make a more fan focused event. They're going to have a lot of influencers there. They're going to try to turn it more fan facing and a little less industry facing. Not going to happen this year. Yeah. A lot of people are wondering if this could be a death blow for E3. I think it's a little early to say that, but yeah, the creative directors had backed out at the end of last month. Jeff Keely had canceled his perennial appearances there. So it certainly was going to change no matter what happened. And this is an unfortunate push in the direction which probably honestly made it easier for them to decide to cancel it. Well, and if E3 has life yet, and if there can be a sort of a successful pivot into something that's a little bit more of a community, you know, let's celebrate games rather than industry thing, like you said, Scott, having another year to regroup could it's almost this is not a good situation that we're in right now, but for E3, you know, and figuring out what the identity of E3 is going forward this year sounded like we're kind of, you know, stumbling toward the finish line here. Maybe in a year, things will look better. Yeah, it may be actually the one silver lining here, the one possibility that they could turn things around. Unfortunately, their plans or their efforts in the past couple of years to make it more fan facing have not been great. They've not been very successful at it. They've been kind of bad events, still some cool stuff happening in there. A lot of us who follow this stuff really wanted to continue. So it's hard to say, but there's no question that this nudges them either to make drastic changes and come out strong in 2021, hopefully, or maybe all this goes digital and we're done with the need for a physical event like this. I don't know. A special Institute for Supply Management survey showed almost 75% of U.S. companies have experienced supply chain disruptions due to COVID-19. 80% expects supply chain impacts with severity of the disruptions increasing after Q1. Lead times have doubled, shortages are compounded by limited air and ocean freight options. Even if the order can be filled, having a hard time getting to anybody. Other notes from the survey, Chinese manufacturers are operating at 50% capacity with 56% of normal staff. 44% of respondents didn't even have a plan to address the supply disruptions. This is an important survey to pay attention to, which is the effects of just what happened in China, which is starting to abate there, haven't been felt worldwide yet. We are just now seeing supplies start to dwindle. Manufacturing is not quite up to replacement levels. And even when they can ship out products, it's getting harder to find options like freight and air to get things places because transportation is being restricted. So it is, you know, I don't like to be alarmist about these sort of things, but it's going to get worse before it gets better as far as the supply chain issues go. And that's something to be aware of, not just in technology, honestly, in a lot of supply chains. And it's easy to look at this and just say, oh, this is only in effect, you know, the apples and the Samsung's of the world or whatever. But I have, this immediately triggers me, this kind of stuff reminding me of an old company I used to work for where we bought and manufactured a bunch of cable products in China.  And it's a huge pain. I cannot imagine what that world looks like right now. So this is affecting not just the big boys, but everybody down to little old cable link I used to work for where they were trying to just get cables out to their buyers. It's hard. TikTok plans to open a transparency center in Los Angeles in May to let experts observe the way the platform moderates content. It will also share details of its source code and independent security measures. These are meant as a way to head off some of the increasing criticism that TikTok has been getting from the United States government officials. Depends on what experts you let in, what you let them see. Right. Like, can you say I'm an expert? Let me in. I want to see your transparency. I'm sure it's more real than a Potemkin village kind of situation. But I don't, I, you know, am I seeing the actual moderation or am I seeing a demonstration of the moderation? That makes big difference. Yeah. Well, so much of TikTok is algorithmic. I did a little test on my own. This is no, by no means scientific and I don't have all the details, but I was very curious how it decided what to show me. And so what I started to do as just an average user of the service is I would stop and watch entire videos that were about a certain kind of subject. So if it was a funny cat video, I would watch the entire cat video. Didn't matter if it was a full minute or anything less, I would watch it. Even if they were bad, I would watch them. And sure enough, over about three days of time, I started getting almost nothing but cat videos. And I'm not changing anything in a search or I'm not changing anything in my preferences or settings. It's all 100% just sort of generated by what it thinks I want and what I like. And so I wonder how much of their transparency will be worth anything. I think it was great that they're doing it. I'm not actually sure what you're going to gather from it, because at the end of the day, that thing is designed to give you what you seem to want. And what else is there? This, this is not about that. Although this opening the source code is partly able to trans to shed light on that. This is not about the algorithm feeding you things. This is about was something censored. What was removed and why? It's about the things you don't see, not about the things you do see. Well, in that case, yeah, I guess it would be good.   I don't know. Hey, that looks like somebody making a political statement. Why are you censoring that? That's going to be, oh, it's critical. I mean, I hope it's just transparent, so transparent China, not the nation. Well, and it's also, it's somewhat odd. It's, it's a physical center, as I understand it, somewhere in LA, you know, it hasn't opened yet, right? So yeah, what is it?  Is there a cafe? Like, what is the experience for the expert in order to feel better on their way out? I imagine it's just them letting you into the moderators doing their work that they already do here, but they're calling it a transparency center to make it sound all fancy. That's my guess. I don't know. It, yeah, it's, it's, I don't want to poo poo it before it exists, but it sounds like something where it's like, okay, now we're all going to act this way because we're in the transparent. Yeah, you know, when the expert's there, even if it's just the normal moderator office, Sarah, if they do have a cafeteria, we all have to dance there. That's the beginning. Verizon has launched a Yahoo branded cellular service in the United States of America called Yahoo Mobile. Remember Yahoo, everybody? Anyway, it offers one plan, unlimited LTE data, limited tethering and Yahoo mail pro for 40 bucks a month. The plan is almost identical to Yahoo's own visible phone service. Verizon charges 65 a month for unlimited data for other plans, but for this Yahoo cellular service way cheaper. Yeah. I mean, and if there is a person who was on the visible service, they're probably saying this is just the same thing. Yes, it is, but it's got Yahoo on the name. I don't know. Yahoo is still more recognizable than visible to people and people do use Yahoo mail. You may not be one of them. You may be making fun of them, but there are a lot of people who use Yahoo mail still for one reason or another. So this is probably got a better chance of somebody walking in or looking up, I guess, not even walking in, but looking up service online and saying, oh, look at that, $40 a month. That's a pretty good deal. It is a pretty good deal. Yeah, it's a great deal. Unlimited LTE, some tethering anyway. Yeah. I mean, what's the throttle limit? How different is that from the Verizon? I want to see some of that fine print, but that's a $25 difference. Still pretty good. I also, I pay more than $65 for my unlimited plan on Verizon. So I had to take another look at that. You call it Verizon and say, hey, what's that? Hey, man. Hey, man. Yeah. Give me that Yahoo deal. As with cable and anything else I've learned over the years that if you don't go in there, they don't go out of their way to let you know that you're on a plan that's aging out or that is that you're paying more for, even though there's a better one, which is still happily continue to take more money than they need to. Yeah, turns out that seems. Yeah. Can you imagine? Hi, this is Verizon. We noticed you're paying $20 over what you really need to pay us per month.  It's not unimaginable. There have been carriers who have sent those kinds of notes and I already hear someone typing the note one time. I got the thing, but it's pretty rare. Usually they hold on to them until you're in there and then they give you a deal to make you feel like you just got some amazing in-house customer service. Yeah, yeah, yeah. That works on me. I'm a sucker for it. Well, anybody who is like me and is constantly almost missing a flight might appreciate this next story. Airport Hospitality Group OTG will adopt Amazon's Just Walkout technology in its stores. The Sebo Express Gourmet Market in Newark, Liberty's Terminal C will be the first to operate the cashierless technology starting March 16th. OTG operates 350 outlets in 10 North American airports, including JFK, Toronto Pearson, Chicago O'Hare, and Houston Intercontinental and others. Yeah, one of those others is LaGuardia. LaGuardia apparently is going to be the next one after Newark to get this. So there'll be one positive thing at LaGuardia. Oh man, LaGuardia, you needed a win. I mean, all kidding aside, we were just talking recently like, ah, the airport thing, that makes a lot of sense. It's just one place where people are, I mean, there are lots of reasons that you would be in a hurry, but its time is so of the essence. And I can't tell you how many times I've been like, gosh, I really want to water, but I don't have time. Anything that would cut down even a minute can be super helpful. Yeah, and if people missed the original story, what Amazon's doing here is it's licensing out its technology that it uses in the Amazon Go Store. That's the one that's not just cashierless, it's checkoutless.  This will work by scanning a credit card when you walk in, then it will track you and you just walk out. If you want a receipt though, you have to go to a kiosk and enter your email address. Once you do that once, you don't have to do it any other times that you visit any of these stores that are powered by just walk out. Even if you're in the Minneapolis airport instead of Newark, once you've done it, it'll, it'll send you that receipt to your email. But, but yeah, it's, it's, it's something that it's going to take some people a little while to understand how it works and probably to trust that they're not actually stealing from, from the place. But this is one of those, you know, those little convenience stores that they have in airports. And if this is pretty easy to scan in, uh, yeah, Sarah, you're absolutely right. Like what, what a deal to just grab a water and not have to stand behind the four people are like, wait, I think I have change here. And you're like, Oh, I gotta get to my flight right now. Yeah. This environment is perfect cause it's a, it's an airport. Everybody's late for everything. And imagine just the, the feeling of walking into a place. Ah, there's the shelf. There's a thing I need. I got my chapstick. I'm out of here and just not think about it. I'm, I'm so ready for this across the board. Let's then integrate it into everything. I don't care if it's Amazon or whoever wants to compete with this and make this possible. Let's go like, yeah. And, and I, I know many cashiers who are just lovely who work in airports, but it's also, I feel like maybe, you know, psychologically, I might be a little bit more inclined to buy like the trashy magazine because you're not going to be judged. Yeah. How many cashiers do you really know? Come on. Listen, some of my best friends are cashiers. And I don't want to, I don't want to poo poo. They're going to be people who are like, this is creepy. This is weird. I still don't feel comfortable about this idea that they know enough about me. I can just walk in and walk out. And I don't want to poo poo on those people. I get it. I get that it's strange and it's new, but I'm, I was ready for this 10 years ago. Let's just go do it. And they will still have employees there though. There are security personnel. There are people to stock the shelves to help you if you have problems and restock and all that sort of thing. Hey folks, if you want to get all the tech headlines each day in about five minutes, be sure to subscribe to DailyTechHeadlines.com. Well, more and more companies telling workers to work from home if they can. Tuesday, Google advised all of its North American workers, not just workers in San Francisco and Seattle, but all North American workers to work from home until at least April 10th. Fortune reported that about 29% of the U.S. workforce could work from home. In other words, the bus driver can't work from home, has to be on the bus, that kind of thing. But 29% of the U.S. workforce could work from home. That's about 42 million people. Add to that, schools either shutting down or going to remote classes means a lot more students of all ages, college students as well, possibly working from home if they're not in dorms, for instance. That's a lot more people on home internet than your ISP is used to, especially during the day. AT&T and Verizon told Fortune that the fiber optic cable that provides the ISP's backhaul should be fine. The volume of traffic isn't expected to change too much. There'll be more video conferencing and such, but they expect that the pattern of change will be the bigger problem. The traffic will be coming from homes, not offices. One network insider told DTNS, a lot of packets will go in odd directions, with odd routes, and people won't be able to address issues quickly enough. It won't break, but get ready for a ride. Some people who live in snowy areas know on snow days, suddenly the internet doesn't always work as consistently because everybody's trying to use it at the same time. Imagine that on nationwide levels. The choke points are lower bandwidth cable and copper wire services. Your corporate network trying to handle all that increased VPN traffic, also companies need to find out if workers at home have sufficient bandwidth and be prepared to invest in things like mobile hotspots and temporarily maybe subsidizing, increasing their data plans. Of course, your home Wi-Fi network, you're not on Wi-Fi 6 in most cases, so you don't have that increased capacity, and if suddenly all the students are home, you're home, everybody's working from home, you're overloading that Wi-Fi network because more devices are using it at once. As I mentioned, video already estimated to be about 70% of network traffic already, and we're going to have more video conferences, so that puts a little more strain on the system. And don't forget apps themselves. The Internet Society notes that individual tools need to provision sufficient compute storage and bandwidth resources to deal with increased users. Yeah, Zoom wants everybody to use Zoom for their video conferencing, but Zoom better make sure that they've got enough bandwidth and cloud resources to handle that. I'm sure they have, but any kind of app you're using from home will need to prepare for that. We have a test case. China has gone through this. Baidu's iQIYI streaming service, an educational application called Sui Xitong, popular office applications, including video conferencing applications, DingTalk, and WeChat Work, online games from Tencent, all reportedly crashed at one time or another due to all the increased traffic of people using them from home. So before we start talking about how we want to approach this, now we want to deal with it, I want to remind people about DownDetector at DownDetector.com. You're going to run into a problem if you're working from home. And to help you figure out whether it's you or the app or your ISP or something else, you might want to bookmark that or just memorize it. DownDetector.com is a good way to check on that kind of stuff. Wow, it's hard to even know where to start with this, but I feel like once in a while we need to be reminded that the Internet isn't just magic air flowing around us and that it has capacities and places where it can bottleneck.  Like you don't think of it in that way, but usage patterns are going to make a huge difference. And I thought a lot about this. This is going to affect so many aspects of Internet usage. I actually think most companies and services are probably up to the challenge. And I'll bet there are some that are even kind of excited about experiencing this. I mean, maybe they aren't, maybe they are, but I think of it from a gamer perspective, there's going to be gnashing of teeth. It's going to get ugly because a lot of those people are going to go home and say, well, that's cool. I'll just play World of Warcraft all weekend. Or I'm just going to, you know, play Modern Warfare, that new battle royale game they released yesterday.  So is everybody else. And they're all going to be fighting for that stuff, not to mention Netflix and Hulu and everybody else is going to be getting a big uptick in usage at times of day. They're not used to, like you could get weird, but I think it's actually a good test of the metal of that industry. You know, we get to see, see how it gets handled. And I don't, I'm weirdly optimistic about it. That's funny way. I feel like I don't know if optimism is what I, what I have a lot of in the short term, but I do, I keep, you know, in so many industries, you know, medical staff having to stay home from their jobs because their kids are out of school and everyone's at home. So who, you know, what else are you going to do kind of thing? You got to stay at home too. There's so many industries that are going to see ripple effects. Now I, you know, it would be ridiculous for me to be like, well, we're all going to show the ISPs that they have to work harder to get us the internet that we need. That's not going to happen in the short term. But I really do think that there are so many instances where if, you know, just the Google employees alone, staying home till April 10th, that's a long time for a huge number of workers. Some of those workers are going to figure out what, or their superiors or their, their teams or whatever. Yeah, this actually worked out better. We're going to change the way that our, our, you know, we have, we have, our team flow works because we were forced to do it a different way. Now it's not, it's in many instances it's going to be like, God, we're all in the office again.  But I think in a lot of cases, this is going to spring forth a new era of how people work and, and, and when and why. And if you are in IT, and I know a lot of you are, if you're not already having these conversations, start having these conversations about how resilient your network is to unusual use cases, your VPN service isn't tuned, at least it wasn't tuned to the kite type of usage it would need to be if you're sending an unusual amount of people to work from home. You know, I, and I know you've probably already thinking about this, but some companies are not quite in that mindset yet. And then of course there's weird use cases, like, like, you know, in the visual effects industry.  What kind of bandwidth do you need from that? Does the company want to provide that? How, how do you figure that sort of things out? So, so there's a lot of preparation that needs to happen and a lot of disaster recovery plans bear on this. If your company has a good disaster recovery plan, you may need to start executing parts of it, because this is in many respects a disaster that you need to adapt to. Yeah, I'm like, and Sarah put it really well that that it's not optimism so much as it is. I don't know, like it becomes just a clear and present problem in the way that it seems to be shaping up to be. I think we're going to, you know, we're going to attack it and go for it. And I don't know, I just, I feel optimistic about our capability to to figure it out and to learn something from it and to be better prepared for this sort of thing next time. And yeah, lessons to be learned across the board for sure. And patience to be had. That would, that's the one thing I want to leave people with is, yeah, if you're, if you're working from home or maybe you work from home regularly, you got a lot more people working from home on your block that might slow down your cable node. So, so be ready, be prepared for that. Hey, you can join in the conversation in our discord. We talk about lots of things, not just pandemics. And you can join by linking to a Patreon account at patreon.com slash DTNS. Let's check out the mailbag. Oh, let's. Yesterday, Tom, you were wondering how an AR app and iOS, which was sort of rumored to maybe have a partnership with Starbucks going forward, how that would work. What would we get out of that? George and Mike both wrote in forwarding an email that they got from Starbucks sent to customers, which reads as follows, Starbucks rewards a Starland over 2.5 million prizes.  Our first game with augmented reality and your chance to win dreamy prizes. Will you be one of the lucky people who takes home $15,000, $15,000 bonus stars or free breakfast every day for a year? So hold on, hold on. What is this? No one knows. No, it used the word augmented reality. And I get why, you know, George and Mike both forwarded this like, Oh, Starbucks and Apple are doing some augmented reality. Maybe this has to do with it. Makes perfect sense. But I don't know what this is. It's also way too early for this to actually be related to iOS 14. So, you know, it may be laying the groundwork for it, but also this is this is one of those things where people just throw around buzzwords like AI, augmented reality. And let's put Starbucks means by get ready to play our newest game means when iOS 14 launches someday. Yeah. This might be very much someday. It's hard to say, but I know this and I'll say it with confidence. It's a terrible game and it will be bad to play. That's all I'll say because these things are never fun. They're not fun games. It's not optimistic. All right. We have a great email from Brendan. Thank you, Brendan, for doing this. He says, Hey, DTS crew, I wanted to share the experience we're having with the Seattle area response to the Corona virus. Brendan on the ground there in Seattle. I work for one of the tech companies up here and have been working from home since leadership directed us to do so. It's been a great experience by most accounts and has actually helped my team collaborate and meet online to discuss work issues and topics. We're a security team covering three continents and our virtual social gatherings have let us get to know each other better. Last night, we were all putting our dogs on camera and swapping stories of wrangling kids while working. My wife works in medicine, so she has obviously been very busy between the influx of patients and our kids doing classroom to the cloud where all the students are learning from home. The school district provided laptops to anyone who needed them and Wi-Fi hotspots for those without internet good school district. I feel this adds to the growing discussion around internet being as important as electricity. The kids have been joining Zoom video conferences and getting classwork through Google classroom. There are some hiccups as some assignments had to be printed and we've had neighbors without printers, but workarounds have been figured out like using the library or good old lined paper and taking a picture to email back to the teacher. My kitchen table has turned into a computer lab with simultaneous conferences. It's giving my fiber internet connection a nice workout. Thanks for the great show and letting me provide some insights. Thank you, Brendan. Yeah, that's uh it just goes right into our our our main discussion uh from just a few minutes ago. Thanks Brendan and thanks to everybody who provides feedback to us every day. Also a special shout out to patrons at our master and grand master levels including Dustin Campbell, Andrew Bradley, and Justin Zellers. Also thanks to none other than the one, the only, Scott Johnson. Scott, what's been going on with you? Well, thank you for saying so. Um, hey uh if you like daily content like the Daily Tech News show, maybe you're already in the mood to get other daily shows and you just sort of just listen to stuff all day. I do a morning show every day, Monday through Thursday. That is that very thing.  So if you're curious as to what that means, go check it out at frogfans.com slash TMS that's short for the morning stream. And we'd love to see some of you there. If you'd like to reach out personally, I'm always online at twitter.com slash Scott Johnson. We have our six year anniversary merch going out. I'm loving seeing these pictures and reports of people getting their mugs, their t-shirts, their stickers, their posters. Uh and if you are at the level where you need to get where you get a t-shirt, don't forget to put your size in. I was talking to NCB about this. He's like, am I getting one of these? And then he realized, oh, I needed to put my size in. So I think it is on its way now, NCB. If you would like to start the clock ticking on getting this, the offer still stands. You just need to back at any level for three months. So go sign up and get the details at patreon.com slash DTNS slash merch. If you've got thoughts or questions or I don't know anything at all, our email address is feedback at daily tech news show dot com. We love hearing from you. We're also live Monday through Friday. That's 4 30 p.m. Eastern 2030 UTC. You can find out more at daily tech news show dot com slash live. Back tomorrow with David Spark as our guest. Talk to you then. This show is part of the Frog Pants Network. Get more at frogpants.com. Bob hopes you have enjoyed this bro.


Everybody forced here open 22 23 contenders basketball hobby four box number four Got a key with the Celtics Brian s magic Brian C sons Carson Clippers Christopher J Thunder Harper with the Nets Hilton Pistons hero s heat Jeff a Hornets Gerald a Dubs and Pacers Joe s bucks John B. Jazz Justin P calves Lee Juan spurs Matthew has the Sixers Mike y Grizzlies Patrick T Nuggets wizards Pensions see Kings Robert P Blazers Ryan s Rockets Shift my cards as the next Steven W Raptors Talon H bulls Thomas C Mavericks Thomas are Lakers Tony W Pelicans T Wolves and young with the Hawks. Good luck everybody. Here we go Yeah, I feel like I feel like a Salt Lake City teams do better than the Orlando teams alleys consistently Sweet shots Lillard rookie the air shade on sharp and a rookie ticket on a Tyree smart and for Atlanta First it goes to the Hawks. All right coming up as a finals ticket Malcolm Bogdan 49 for the Celtics It's Carter ticket to the Halls sweet shots Lamello Let's get that next one filled up guys six to go Yeah, we break one the one the one the spots are filled. We won't we won't we don't do breaks if it's not sold out variation rookie ticket Tyree smart and Hawks Keegan Murray rookie of the year Jamal Murray and a very nice blazer shade on sharp playoff ticket variation rookie auto to 99 great hit Blazers That's awesome. Congrats Portland Who's been good man Robert P? Here you go, man Get some magged up for a variation shade on sharp Bulls playoff ticket Zach Levine the 249 One of the play in at least lottery ticket Jang all-star Tatum Yeah, I've went to a couple when they were at the sedges Well, I haven't been in the new stadium yet though She defined time poor zinkus first round ticket to 199 for the Wizards. I'd love to go I'd love to have season tickets to Orlando City and the magic, but working nights Just doesn't it's not it's never gonna happen sweet shots Tatum Walker Kessel rookie of the year for the jazz I'll go to so many games, dude If I had season tickets, I'd imagine I'd go to like 80 percent Luca superstar Chris Paul and a premium edition coming up after Devin Booker is a rookie ticket auto Josh Minot T-Wolves Nuggets playoff ticket to 249 Nicola Yolkic Nicola Lottery ticket J. Dubb Coloco rookie of the year Halliburton variation season ticket for the Pacers Variations are blank still throwing me off and Oshek Baji rookie ticket on card on it.  I'm ready to pull the pillow. Oh, yeah for sure Kyle because there's with the roof There's just less breeze Just check the next one here number five has the Nets Cavs Clippers Nick Sixers and Wizards six to go on sale I think it's him. I think they have like a rendition of it on the on the for the check this would be Blazers first round ticket to 199 is Yosef Narkic Nemard rookie of the year For the Pacers cracked ice is what's up. I want to pull another cracked ice here Go bear ticket to the final sweet shots Donovan Mitchell Tari Easton rookie of the year and legendary auto to 25 Anton Jamison for the Wizards second one of these you pulled today Anton Jamison Wizards Cavaliers Donovan Mitchell playoff ticket to 249 All-star die cut Trey young Atlanta d-way ticket to the hall Deer and Fox variation Season ticket swiper What a Kings kill into this year man. They're going to the playoffs man. They're gonna ho they're gonna host the playoff series Got McCollum lottery tickets shade on sharp and Wow check that out veteran clear ticket one of ten a Keem the dream Elijah one Rockets continuing to eat today That's fire clear ticket to ten a Keem Elijah one Rockets The number didn't miss here at least the veterans they did we'll get that one bagged up, of course Usually clear tickets in basketball weren't numbered. Maybe she's the veteran Beautiful beautiful Telling you man If the Rockets were the Rockets were available when I got here today and like seven of the breaks They were available for a long time Whoever whoever scooped them up in a few of them is is uh, it's probably smiling right now They're probably Chris flexing on us as they would say Jake all Arabia rookie ticket variation Grizzly's I looked up and I saw his name. I was like, oh man flexing Ricky the year AJ Griffin shot Marion Dream was awesome got playoff ticket eight and a two forty nine sons Okay, it kind of yams sweet shots lottery ticket Jade and Ivy Dude, I can't wait to tune in the same going sweet He sold that for me though cuz I did a News top load for me. I think series one or series to release last year or sweet shades and I was like sweet shades So just just let you guys know that Ray Jean Rondo Paul George he's gonna try and say oh, but it's different because it's sweet shots It's the sentiment is the same to bars with junior rookie of the year Rockets a Ryan Rollins rookie ticket out of for the Warriors Do that? Yeah, that's Sacramento playoff game is gonna be wild. There's no way they lose game one, right? But they may they I'm not saying they're gonna guarantee to win the series But game one is pretty much a lock if you're traveling to Sacramento Got a conference finals ticket to 75 Malcolm Brogdon Celtics And the Edwards all-star KD That is gonna do it for the break Another good one, man. We're in some nice cards today. Let's do a quick recap Autos of Ryan Rollins Oshag Baji Tyrese Martin premium edition Josh Minot and Tom James into 25 for the Wizards Yeah, the playoff ticket Shade on Sharpton 99 congrats Blazers on that one and clear ticket to 10 akim Elijah on Rockets Yeah, thanks again, everybody moving on to number five


The Majoan Army has assured of its absolute loyalty to President Chinabu as the commander in Chief of the Armed Forces. The Chief of Army Staff, Lieutenant General of Barukhya Highest State at this on Tuesday at the commissioning of some project by the Majoan Army at the Government Day Secondary School, Malam Fashi, Katzena State. I am learning and so I add the presence of staff and students of Government Day Secondary School, Malam Fashi, to properly utilize and maintain the position today in order to enhance the quality of education in the school. I therefore commend the executor, Major General Ezzi Muhammad, the Chief of Trade in the Army for a job well done. Let me once again thank the Gladiman Katzena Justice League of Malam Fashi, the good people of Malam Fashi and Katzena State for their continued support to the Majoan Army. I urge you to continue to be low abiding and provide useful information to the Majoan Army and other service and security agencies to enable us to provide a quiet, safe and secure environment for social and economic activities. At this juncture, I must sincerely thank and appreciate all the distinguished guests here today that have honored us with their esteemed presence. Let me at this juncture once again see the opportunity to congratulate the Excellency President Bola Amitunibu just this year, of our own success at the post and successful integration and swearing in at the President Commander in Chief of Armed Forces to the Republic of Nigeria. May I assure His Excellency, President Bola Amitunibu, of the absolute loyalty of the officers and soldiers of Nigeria Army to the President Commander in Chief and the Constitution of the Federal Republic of Nigeria.