Hey, this is Brett and this 2020 Chevy Silverado 2500 regular cab, long box, work truck, Alaskan package is stock number 1-4-424Z. I am here at Summit Automotive in Fond du Lac, Wisconsin, you're new and used heavy duty truck headquarters. This 2020 Chevy Silverado 2500 comes with the 6.6 liter V8 gas engine. It puts out 401 horsepower. It is paired up with this six speed automatic transmission. This truck has been fully safety and inspected by our service shop has a fresh oil and filter change. All the fluids have been checked and topped off and this truck is 100% ready to go. I'm going to go all the way around in this video. Inside underneath, started up. Take a look under the hood, show you all the options and give you the most accurate representation that I can of the vehicle. Summit white clear coats of color. Shoot all my videos in 4K. If you like the videos, subscribe to the YouTube channel, click the bell notifications, get updates on the videos I do each and every day, as well as having access to one of the largest catalogs of vehicle and heavy duty truck walk-arounds on YouTube and stay current on our ever changing and vast heavy duty truck inventory here at Summit Automotive. This one comes with the 18 inch painted and polished aluminum wheels. It has Michelin LTX AT tires. These are LT 275 70 R18s. They have a little bit, probably right around half the tread left on them, maybe a little bit less than that. Framing under bodies in pretty nice shape. This is a one owner clean title history, clean car facts out of Ohio. Front fenders in excellent condition. I didn't see any dents or dings on there. Headlight lenses are nice and clear. Front bumper is in pretty nice shape. Looks pretty good for a work truck. I mean, this thing's really nice. Grille is in excellent shape. The hood is in really nice shape as well. Didn't see any major dents or dings on there and the passenger side front fender is in great shape as well. Passenger side front wheel, pretty nice condition. And as you go down this side of this 2020 Chevy Silverado, 2500 regular cab Alaskan work truck, take note of how clean the body is, how reflective and mirror like that paint is. I take these HD videos, so if you are far away or even if you're close by and you just cannot make the trip down, but you're still interested in purchasing the vehicle, you can see the truck, hear the truck and have confidence in what you're looking at before you even get here. So when you do get here, there's absolutely no surprises and you can make a smart and informed buying decision from wherever you're at. Now if this video helps you make that buying decision, let your salesman know that you saw the video that it was helpful and that Brett sent you. Back wheel is in excellent shape. Back tires have just as much tread as the front tires, maybe even a hair bit more. And the frame and underbody is in pretty nice condition. All the box rails look like they're in really great shape. Has all the remaining factory exhaust. And the underbody looks really good. Lower rockers and cab corners are in nice shape. Only thing I really need to note here is there's a little bit of ding there, but nothing terrible. You get the side box steps. You get the Alaskan decal on there. Now those are just decals, so you can take those off if you didn't like them. Coming around to the back of the vehicle, the rear bumper is in great shape. It does have the rear bumper steps. Full towing package, which includes the receiver hitch, four pin and seven pin wiring. The tailgate is in very nice condition as well. Didn't see any major dents or dings on there. It is a power drop down tailgate. Spray and bed liner. This one does come with a gooseneck hitch. That's in pretty nice shape. Couple little dings at the front there. Does not affect the performance of the truck though. And that spray and bed liner goes on to the tailgate. Tailgate's very light, very easy to lift. And going down the driver's side, just as clean as that passenger's side. No major dents or dings in the box. And for full disclosure, this back wheel is in really nice condition as well. Down the rest of this side, cabin doors. Cabin door looks really good. Didn't see any dents or dings on there. It does have the telescopic tow mirrors built in directional signals. They telescope out like that and fold in like so. Inside the work truck package gives you the black cloth interior. 40, 20, 40 split bench seating. No rips, no tears on those seats. They are in very nice condition. You get the heavy duty rubber floors, auto headlamps, cargo lamps, push button, four wheel drive, tilt, steering wheel, power windows, locks, and mirrors. We'll hop inside, check out the miles, the radio, and everything that this one has to offer on the interior. See, this one has 41,053 miles on it. You do get a digital speedometer. Instrument cluster is very nice and clean. Steering wheels in great shape. You get cruise controls on the left. And there is your shifter for that six speed automatic transmission. Those have the optional tap shift. You can see the power drop down tailgate on the key fob there. This one has the Chevy infotainment system. You do get AM, FM, and Bluetooth capabilities. The other really nice thing about this radio is it does have Android Auto and Apple CarPlay. So if you have a nav system on your phone, such as Waze or Google Maps, projected to the screen, and it's like you have nav right in the screen. So that's a really nice system. And then this is also where your backup camera is and you can see that that is working nicely. Down here are your climate controls. Power drop down tailgate button, hazard lights, stability control, factory brake controller, USB, 12 volt PowerPoint, and the heavy duty rubber floors. Passenger side seat is in excellent condition. No rips or tears. The headliners in really nice shape as well. And you do get map lights up here. Let's start it up and take a look under the hood. Starts right out. No check engine lights or anything like that other than my hood is open. I would personally like to thank you for checking out the video today. And hopefully from this HD video, you've been able to verify the quality and condition of this truck inside and out. You can see all the lights are working nicely. And under the hood, we have the 6.6 liter V8 gas engine. And Jinbei is very clean. Runs very smooth, 401 horsepower. And once again, this truck has been fully safety and inspected by our service shop as a fresh oil and filter change. All the fluids have been checked and topped off. The shocks are doing a great job holding that hood up. There is the emission sticker. And once again, I forgot to show the VIN sticker and tire and loading information sticker. Important on trucks like this. So let me show you that. There's the tire and loading information sticker. There's the VIN sticker, no previously owned in Canada trucks here. And then there is the trailering information sticker. Chevy is nice enough to give you that. And there you go. I would highly recommend this truck from a quality and condition standpoint considering the age and miles. And of course, the fact that it is a work truck, it's in really nice shape. And I would highly recommend it. Whoever's gonna get it, it's gonna be really happy with it. And to see more pictures of this truck or one of our other 550 new and used cars, trucks, SCVs, minivans, Wranglers, half tons, three quarter tons, one tons, you name it. We gotta go to the website right there, summitauto.com. Full pictures and descriptions of every single vehicle, all at summitauto.com. If you wanna check out more HD videos, you can go to youtube.com slash summitauto. Click the bell notifications, get updates on the videos I do each and every day, as well as having access to one of the largest catalogs of vehicle and heavy-duty truck walk-arounds on YouTube. And stay current on our ever-changing and vast inventory so you do not miss out on gems like this one. In fact, any second you will see a link to subscribe to my YouTube channel on the upper left. They link to all the Chevy 25 in our truck videos I've ever done in the upper right. Link to this vehicle on our website on the lower left and they link to one of our latest YouTube videos on the lower right. Click those, check us out. We're super excited to help you with this Ultra Clean 2020 Chevy Silverado 2500 Regular Cab Long Box Work Truck Alaskan Package in Summit White Clear Coat. Thank you so much for checking out the video. Remember to like, subscribe and share on the YouTube channel. I really appreciate it. Thanks and have a great day.


Hello and welcome to NewsClick. Today we're discussing a very significant international development. We're looking at how the Adani Group has actually managed to get a clearance from the Queensland government in Australia for their cold project. And to talk about the kind of timeline of this entire deal and finally the kind of repercussions that this project is going to have on Queensland, we have with us Paranjoy Guha Thakurtha, senior journalist. And Paranjoy, you've been following this issue very, very closely as well. And my first question is that many people on the ground are saying that the Queensland government has finally given in to the kind of bullying that Adani has been doing to get the clearance for this project. So what has actually happened? How do you see the significance of this clearance? All right. Let's take a few steps back. On Thursday, the 13th of June, the Brisbane where the Queensland government is headquartered gave the approval for this project together with the approval that came from the federal government based in Canberra. Now you must remember that this project was initially proposed almost a decade ago. It was at that time described as the world's biggest green field coal mining project. And among maybe the top 10 or 12 in the world, a project of its kind. Since then, what was originally proposed, it has been fairly drastically scaled down. And the reason why it has been scaled down is on account of the opposition by environmental groups. I'll give you some figures to highlight how it has been scaled down. Initially it was proposed that over 10,000 people would be directly employed and many times that number would be indirectly employed. Now the company says that 1,500 individuals would be directly employed and roughly 6,750 would be indirectly employed. Now the writing on the wall was very clear. Today, Mr. Gautam Adani is predictably exultant. He is very, very happy. I quote what he said. He said today, our remarkable journey of conviction, resilience and commitment in Australia enters a new phase. And the Queensland Premier Anastasia Palace Cook who had been backing this project, she had been really, she said she was fed up because the federal government had been taking its time. Just remember that over the last 18 months, there have been at least a dozen different versions of the groundwater management program. Now why is this very significant? Why is it very significant is because of a number of reasons. But before I go into the environmental aspect, let me flag two or three political points. It became fairly apparent that this project would come through, not only because it was going to create jobs, maybe not 10,000 jobs but 1,500 because in Queensland, this is going to be the first coal mining project of its kind in more than 50 years. Remember this is the biggest investment by an Indian company in Australia historically. But the point that should be noted is that when in May, the Liberal National Coalition won a surprise victory, nobody was expecting it, it was a third consecutive three-year term beating anti-encompassing sentiments and the Prime Minister, Scott Morrison, he defeated his political opponent, Bill Shorten, who is the leader of the opposition and he was heading a Labour Party-led coalition which included the Greens, which were very, very vehemently opposed to the project and the Prime Minister, Scott Morrison, has been a supporter of the mind like the Queensland Premier. So in that sense, once there was the political situation changed in May, one should not have been surprised that this happened. Now you must remember that there were very, very strict environmental guidelines which had to be approved of and one of the important things and this is why the project is very significant that this is a very, very remote area and many would consider to be actually the last of its kind, one of the last unspoiled desert areas of its kind in the world which has one of the largest desert OASIS which is the Dunmabula Springs complex. Secondly, it's also worth noticing that this area is very close to the Great Barrier Reef which is the world's greatest coral reef system, it's a world heritage site, it's a very, very popular tourist destination, people from all over the world, it generates a lot of jobs also. So it was not just the environmental activists and by the way the other important thing was it was very important and a plan, it took some time that it was only recently approved that it was important to protect the habitat of the black-throated finch which is a very it's an endangered species of earth. And last but not the least, just a day before, Thursday before this came, the Australian Conservation Foundation won a major case against the federal government because while evaluating Adani's North Galilee water scheme and its plans to pump out about 12.5 billion litres for from the Sutter River over the following two years of negotiation that's near the mine site called the Pekka Michael mine site and the federal government was hauled up by the court saying they had not properly assessed the representations and submissions given by over 2,000 members of the public. Two other points, initially this coal mine was going to be 60 million tonnes a year then it came down to half the size, less than half, 27.5 and initially it's going to be I think 8 to 10 million tonnes a year. In terms of costs, first it was supposed to be close to 8 billion, 7.8 billion dollars now it's down to 1.5 billion dollars and almost all of it is now going to be funded by Adani himself because the banks are not willing to loan, why the banks are not willing to loan? Because there are huge risks involved, the international prices of coal have not gone up, coal is no longer fashionable, people are moving towards solar and so when in the Paris Climate Agreement Australia pledged to cut down its emissions by 26% the period is 2005 to 2030, many people believe it's hypocritical that it should be supporting this big coal mining project and pledging something else into the international community, yes. So now you're picking up on the kind of reactions that are coming in from environmentalists as well. So there were huge protests and all of this was, would you say that this was ignored and this hypocritical stance was then taken, how has this happened? How has Adani group in terms of their influence has managed to convince this deal to get clearance now? Okay, let's not underestimate Mr. Gautam Adani's power to influence. We know in India how he is rightly wrongly perceived to be an industrialist who is very close to Prime Minister Narendra Modi, the fact is even in Australia he has become almost like a test case, I mean to the environmentalist he is the big villain, to those who support him he is this great creator of jobs, but the fact is interesting, this first mine would actually pave the way for the establishment of six other mining projects, in fact many argue that given the fact that international prices of crude oil, I beg your pardon not crude oil, thermal coal have not really gone up in recent times, the view is that this project becomes viable only if those six other projects come up and importantly the railway line which is supposed to connect that mining area, the Carmichael mining area to the port which is the Abbot Point port which is roughly 400 kilometers away. Now initially Adani wanted to build the entire railway line but now I think he is going to be building about half but it's yet to be finalized, let me put it this way because that coal is going to be exported and much of it Adani at least hopes would be to India to his own power projects some of which are located in the coastal areas and he as you know controls the way in which ports, many many ports function including the Mundra port which is the country's biggest private port. Yeah, so with this development now and keeping all these factors in mind how do you see this planning out in the sense that when do you see this actually taking place and do you actually see that irrespective of the protests this project is actually going to now take off. Yeah, at least that has been claimed by the CEO of Adani Australia, he's saying we are ready to go, we are going to start right now. The point is Adani Australia CEO his name is Lucas Tao, he is saying we are going to go right away and they are going to start work immediately but I believe that they may not be able to proceed at the pace that they originally thought and I think at the same time the environmentalists they are not going to give up that easily. I think they are politically very influential and also they are in that sense far more resourceful and let's see what happens the railway line is yet to be finalized, the local the original inhabitants their association had also protested but it seems somewhere along the line the promise of jobs is really what has prompted both the Queensland government and the Australian federal government to give it because everywhere including this country you know when you promise jobs to become politically popular let's wait and watch and see whether the promise of new jobs and a revival of the economy of that part with the very remote part it's the the north the northeastern part of Australia whether those considerations prevail over considerations where coal is no longer the preferred mineral for generating electricity world over all over the world in Australia in India in China everywhere across the world there's a movement towards renewable sources of energy and then finally at the end of the day the economics of it all I mean I mean at the end of the day you're going to export that coal to other countries in the world but what happens to if the price of coal doesn't go up I mean what happens to the economics of it all and how you're going to fund it all because as we know banks across the world refused to fund it even Chinese banks at one stage thought would bail that project out it hasn't now Adani has no choice but to fund the entire project if you recall there was a very controversial meeting in March 2015 around the time the group of 20 countries met in and Prime Minister Narendra Modi with Mr. Gautam Adani and Mrs. Arun Dhoti Bhattacharya who was then heading India's largest bank the State Bank of India signed an MOU a memorandum of understanding to extend a loan of about a billion dollars for the project which never finally came through it was never formally approved by the State Bank of India so clearly it's not just the environmental aspects which are contentious and controversial it's also the economics of the project which are now I mean which are being questioned and how father that project would be time alone can tell how these considerations would play out. So on that note if the economics of the project and the promise of jobs how is all of this going to play out we are leaving you with these questions and we will keep following the project more closely. Thank you Padanjoy for joining us and giving us insights to the project and how it has actually transpired over the years. Thank you for watching.


From San Mateo, it's theCUBE, covering Scalar Innovation Day, brought to you by Scalar. Hello, I'm John Furrier with theCUBE. We are here in San Mateo, California, Special Innovation Day at Scalar's headquarters. We're here with Steve Newman, the founder of Scalar and Jeff Mathis, a software engineer. Guys, thanks for joining me today. Thanks for having us. Thanks, great to have you here. So you guys introduced Power Queries. What is all this about? Yeah, so the vision for Scalar is to become the platform users trust when they want to observe their systems. And Power Queries is a really important step along that journey. Power Queries provide new insights into data with a powerful and expressive query language that's still easy to use. So why is this important? So at Scalar, we like to think that we're all about speed. And a lot of what we're known for is the kind of the raw performance of the query engine that we've built that's sitting underneath this product, which is one measure of speed. But really we like to think of speed as the time from a question in someone's head to an answer on their screen. And so the whole kind of user journey is part of that. And kind of traditionally in our product, we've provided a set of basic capabilities for searching and counting and graphing that are kind of very easy for people to access. So you can get in quickly, pose your question, get an answer without even having to learn a query language. And that's been great, but sometimes the need goes a little bit beyond that. The question that someone wants to ask is a little bit more complicated or the data needs a little bit of massaging. And it just goes beyond the boundaries of what you can do in kind of those basic, the sort of basic set of predefined abilities. And so that's where we wanted to take a step forward and kind of create this more advanced language for those more advanced cases. I love the name Power Queries, I think it's power and it's got to be fast and good. So that aside, query's been around people know search engines, search technology, discovery, finding stuff. But as AI comes around in more scales and that the system seems to be a lot more focused on like inference, intuitive what's happening. This has been a big trend. What's your opinion on that? Because this has become a big opportunity using data. We've seen log file companies go public, we know who they are and they're out there, but there's more data coming.  So what's the innovation that just gonna take Power Queries to the next level? Yeah, so one of the features that I'm really excited about in the future of Power Queries is our autocomplete feature. We've taken a lot of inspiration from just what your nav bar does in the browser. So the idea is to have a context sensitive, predictive autocomplete feature that's going to take into account a number of individual, the syntactic context of where you are in the query, what fields you have available to you, what fields you've searched recently, those kinds of factors. Steve, what's your take before we get to the customer impact? What's the diff, what makes it different? Where is Power Queries gonna shine today and tomorrow? So it's, it was kind of both an interesting and fun challenge for us to design and build this because you're, we're trying to, by definition, this is for the more advanced use cases, the more when you need something more powerful. And so a big part of the design question for us is how do we let people do more sophisticated things with their logs when they have that use case while still making it something, kind of preserving that speed and ease of use that we like to think we're known for. And in particular, that's been something where step one is go read this 300 page reference manual and learn this complicated query language. If that was the approach, then we would have failed before we started. And we have the benefit of a lot of hindsight. There are a lot of different, there's a lot of history of people manipulating data, working with the sophisticated different and different kinds of systems. So there are, we have users coming to us who are used to working with other log management tools. We have users who are more comfortable with SQL. We have users who really, their focus is just on more conventional programming languages, especially because one of the constituencies we serve are, it's a trend nowadays that development engineers are responsible also for keeping their code working well in production. So they're not experts in this stuff. They're not log management experts. They're not telemetry experts. And we want them to be able to come in and kind of casual, come in casually to this tool and get something done. But we had all that context to draw on with these different history of languages that people are used to. So we came up with about a dozen use cases that we thought kind of covered the spectrum of what would people bring people into a scenario like this. And we actually gamed those out. How would you solve this particular question if we were using an SQL-like approach or an approach based on this tool or approach based on that tool? And so we did this like big exploration and we were able to boil down, boil everything down to about 10 fairly simple commands that pretty much covered the gamut. By comparison, there are other solutions that have over 100 commands. And obviously there's just a lot to learn there. At the other end of the spectrum, SQL really does all of this with one command, select. And it's incredibly powerful, but you also really have to be a wizard sometimes to kind of shoehorn that into... Yeah, even though SQL's out there, people know that, but people want it easier. Ultimately, machines are going to be taking over. You get the 10 commands. You almost can get to the efficiency level of simplifying the use cases. What's the customer scenario look like? Why is design important? What's in it for the customer? Yeah, absolutely. So the user experience was a really important focus for us when designing Power Queries. We knew from the start that if a tool took you 10 minutes to relearn every time you wanted to use it, then the query takes 10 minutes to execute. It doesn't take seconds to execute. So one of the ways we approached this problem was to make sure we're constantly giving the user feedback. That starts as soon as you load the page, you've immediately got access to some of the documentation you need to use the feature. If you type incorrect syntax, you'll get feedback from the system about how to fix that problem. And so really focusing on the user experience was a big part of the... Yeah, people don't factor in the time it takes to actually do the query. Write it up if you have to code it up and figure it out, that's time lag right there. You want it to be as fast as possible. Interesting design point, it's logical, right? Right, absolutely. So Steve, how does it go fast? Jeff, how does it go fast? What are you guys looking at here? What's the magic? So let me, I'm gonna step over to the whiteboard. Chalkboard here, and we'll... So Chalk in one hand, Mike in the other will evaluate my juggling skills. But I wanted to start by showing an example of what one of these queries looks like. I talked about how we boil everything down to about 10 commands. So let's talk through a simple scenario. Let's say I'm running a tax site. People come to our website and they're putting their taxes together and they're downloading forms. And tax laws are different in every state. So I have different code that's running for people in California versus people in Michigan or whatever. And it's easy to do things like graph the overall performance and error rate for my site. But I might have a problem with the code for one specific state and it might not show up in those overall statistics very clearly. So I wanna get a sense of how well I'm performing for each of the 50 states. So, and I'm gonna simplify this a little bit, but I might have an access log for this system where we'll see entries like we're loading the tax form. And it's for the state of California. And the status code was 200, which means that was successful. And then we load the tax form and the state is Texas. And again, that was a success. And then we load the tax form for Michigan and the status was a 502, which is a server error. And millions of these mixed in with other kinds of logs from other parts of my system. And so I wanna pull up a report what percentage of requests are succeeding or failing by state. And so let me sketch first what the query would look like for that. And then I'll talk about how we execute this at speed. So first of all, I have to say what, I've drawn just the relevant logs, but this is gonna be mixed in with all the other logs from my system. And I need to say which logs I care about. Well, maybe as simple as just calling out, they all have this page name in them tax form. So that's the first step of my query. I'm searching for tax form. And now I wanna count these, count how many of these there are, how many of them succeeded or failed. And I wanna cluster that by state. So I'm gonna, clustering is with the group command. So I'm gonna say I wanna count the total number of requests, which is just the count. So count is a part of the language. Total is what I'm choosing to name that. And I wanna count the errors, which is also gonna be the count command. But now I'm gonna give it a condition. I want to only count where the status is at least 500. And I don't know that you can see that, but behind the plant is a 500. And I'm gonna group that by state. So we're counting up how many of these values were above 500, and we're grouping it by this field. And what's gonna come out of that is a table that'll say for each state, the total number of requests, the number of errors. Oh, and sorry, actually I left out a couple of steps, but actually let's draw what this would give us so far. So it's gonna show me for California, maybe I had 9,152 requests, 13 of them were errors for Texas, I had, and so on. But I'm still not really there. That might show me that California had, maybe California had 13 errors and Rhode Island had 12 errors. But there were only 12 requests for Rhode Island. Rhode Island is broke. I've broken my code for Rhode Island, but it's only 12 errors because it's a smaller population. So this analysis is still not quite gonna get me where I need to go. So I can now add another command. I've done this group, now I'm gonna say, I'm gonna say let, which triggers a calculation, let error rate equal errors divided by total. And so that's gonna give me the fraction. And so for California, that might be 0.01 or whatever, but for Rhode Island, it's gonna be one, 100% of the requests are failing. And then I can add another command to sort by the error rate and now my problem states are gonna pop to the top. So real easy to use language. It's great for data scientists digging in there. Practitioners, you don't need to be hardcore coder to get into this. Exactly, that's the idea. Group, sort, very simple commands that just directly, kind of match the English description of what you're trying to do. So then, but you asked a great question then, which is how do we take this whole thing and execute it quickly? So, actually I'm gonna erase here. So you're getting at the speed now, right? Yeah. So it's gonna be like the, how you get the speed actually. Exactly. Speed is good. So. Simplicity to use, I get that. So now speed becomes the next challenge. Exactly. And the speed feeds into the simplicity also because step one for any tool like this is learning the tool. And that involves a lot of trial and error. And if the trial and error involves weighting, and then at the end of the wait for a query to run, you learn that oh, you did the query wrong. That's very discouraging to people. So we actually think of speed really then becomes some ease of use. Got it. But all right, so how do we actually do this?  You've got your whole, maybe terabytes of log data. Somewhere in there are the really important stuff, the tax form errors, as well as all the other tax form logs mixed in with a bigger pile of everything else. So step one is to filter from that huge pile of all your logs down to just the tax form logs. And for that, we were able to leverage our existing query engine. And one of the main things that makes that engine, there's kind of two things that make that engine as fast as it is. It's massively parallel, so we segment the data across hundreds of servers, our servers. So all this data is already distributed across all these servers. And once your database, so you guys built your own in-house, okay, got it. Exactly, so this is on our system. So we've already collected, we're collecting the logs in real time, so by the time the user comes and types in that query, we already have the data and it's already spread out across all these servers. Then the first step of that query was just to search for tax form. And so that's our existing query engine. That's not the new thing we built for Power Queries. So that existing, very highly optimized engine, this server scans through these logs, this server scans through these logs, each server does its share. And they collectively produce a smaller set of data, which is just the tax form logs. And that's still distributed by the way, so really each server is doing this independently and is gonna continue locally doing the next step. So we're harnessing the horsepower of all these servers, they each only have to work with a small fraction of the data. Then the next step was that group command, we were counting the requests, counting the errors, and rolling that up by state. So that's the new engine we've built. But again, each server can do just its little share. So this server is gonna take whichever tax form logs it found and produce a little table of accounts by state, this server is gonna do the same thing. So they each produce their little grouping table with just their share of the logs. Got it. And then all of that funnels down to one central server where we do the later steps. We do the division, divide number of errors by total count and then sort it. But by now, here we might have, you might have trillions of log messages down to millions or billions of messages that are relevant to your query. Now here we have 50 records, just one for each state. So suddenly the amount of data is very small. And so the later steps may be kind of interesting from a processing perspective, but they're easy from a speed perspective. So you solve a lot of database challenges by understanding kind of how things flow once you've got everything with the column or databases there. Just give a perspective of like, what if the alternative would be if we, this is like if I just threw in this sort of database and I'm running SQL, trillions of log files. I mean, it's not trivial. I mean, it's a database problem. Then it's a user problem kind of combined. What's order of magnitude difference if I was gonna do the old way? Yeah, so I mean, the truth is there's a hundred old ways now, right? It's a complicated world. How much pain is there out there? If you're gonna, if you try to just throw this all into one SQL server, my SQL or Postgres server on one server, it's just not gonna happen. You've got terabytes of data. And by the way, we're glossing over, the data has to exist, but also it's to get into the system. So when you're checking, am I letting everyone in Rhode Island down on the night before the 15th, you need up to the moment information. But your database is not necessarily, even if it could hold the data, it's not necessarily designed to be pulling that in in real time.  It's not even gonna happen. So now you're sharding the data or you're looking at some other database solution or whatever. It's a heavy lift either way. It's a lot of extra effort taxing on the developers. You guys do the heavy lifting. Okay, what's next? Where's the scale features come in? What do you see this evolving for the customers? So Jeff talked about autocomplete, which we're really excited about because it's gonna, again, a lot of this is for the casual user. They're a power user of JavaScript or Java or something. They're building the code. And then they've gotta come in and solve the problem and get back to what they think of as their real job. And so we think autocomplete. And the way we're doing it, where we're really leveraging both the context of what you're typing, as well as the history of what you and your team have done and queried in the past, as well as the content of your data. We think a little bit like the browser location bar, which somehow you type about two letters and it knows exactly which page you're looking for because it's relying on all those different kinds of cues. Yeah, it seems like this is foundational, heavy lift, minimize all that pain. Then you get the autocomplete, start to get into much more of AI, machine learning kicks in, more intelligent reasoning. You start to get a feel for the data, seems like. Yeah. Steve, thanks for sharing that. There it is on the whiteboard. I'm John Furrier. Thanks for watching this CUBE conversation.


The idea of sustainable consumption reduction really helps us operationalise and understand how we can achieve sustainable development in breaking it down into what we can do to improve the production efficiency of products but also what we can do to change our demand for products, our consumption of them and the importance of sustainable consumption reduction is understanding the whole supply chain so that products are produced for us to consume and we have a choice and we have a choice whether we buy products which are highly carbon intensive or ones which potentially have a lower impact on the environment or lower carbon output and so it gives us a model to be able to adjust and understand a whole range of options to achieve the deep and radical cuts which we need to achieve a stable climate in the future We analyse the supply chain through using a range of modelling techniques but is mainly or heavily reliant on economic modelling which understands how industry interacts and exchanges products within industry and then how these are delivered to the consumer so this involves us having a detailed understanding of virtually every single country's production structure the way that they interchange their products and materials and then also having a detailed understanding of where they export these products to and who imports them Clearly everything that we consume in Sweden or in the UK, let's say is not produced in the country where we live and so we need a detailed understanding of these trade flows and the associated impacts that they have The trends that we're seeing is that the industrialised countries are actually becoming less industrialised in that they are producing less products We find that we are producing or shifting towards a service-based economy and all the products which we consume are produced abroad and imported Now where this is extremely important is for example with climate change negotiations at the moment the country which produces the product is held responsible for those emissions albeit that they are consumed in a country with greater wealth and also greater opportunities to actually reduce emissions So we start to see China being held responsible for European consumption I think that policymakers need to take responsibility and be more transparent about the decisions that they are making We found that the response in the UK to research on the flows of carbon and what they were responsible for abroad actually led to a defensive response one which said well we're not responsible for these emissions but ultimately we need them to recognise the fact that we might actually have an impact on the rest of the world that at some point we may have to actually help in abatement and in new technologies to the new emerging nations and we may actually need to support them We've built our economies for the last 100 years when carbon was free we're now asking new emerging economies to build their economy on carbon at a price


No one's ever ready for cancer, but at Hackensack Meridian John Thurr Cancer Center, we are. We're smarter than cancer, with the most advanced clinical trials in New Jersey. We innovate faster, pioneering world-leading therapy. And we're stronger, with personalized treatment plans for every patient. We're changing the way cancer is treated, so we're always more than ready.


Next question is from Chai Latte. What correctional exercises would you recommend for clients with knocking knees? Knees. Okay, so if you're just a normal person listening to the podcast, you're interested in health and fitness, and you want kind of a general idea of how to correct poor form or movement in yourself, here's a good rule of thumb. It's not failed proof. This is not like 100% every time. A trainer's always gonna be able to do a better job of this with you. But if you're on your own, here's just kind of an easy way to figure out how to correct a problem. Strengthen the opposite movement, okay? So if your knees go together, then you could technically correct it by strengthening your knees going out. So like clam shells would be an exercise. Any kind of abduction, that's when you bring the leg out so you could get a resistance band, attach it to your foot. Leg swings. Leg swings with no resistance. Like do the opposite of what the problem is. Strengthen, I should say, the opposite. With good form, by the way, because sometimes you can fool yourself. If your form is wrong, you may actually be making the problem worse. So with perfect form, and that's kind of an easy rule of thumb to follow to figure these things out. Now, if you wanna take it a step further, then you could go hire a trainer that tends to be expensive, or if you wanna kind of go in between, then you could do like Maps Prime or Prime Pro where we take you through assessments and then you can kind of figure that out for yourself. Yeah, I think that 100% what you said will at least help. It may not completely fix the root cause. That's the only thing. So knock knees, even strengthening the antagonist muscles like you're talking about right now with two walking leg swings, this will for sure help that issue. But if the root cause is related to the foot, which is what I would say that it is 80% of the time, you've got to work on that. So a lot of times, this was when Dr. Brink like blew my mind cause just as a trainer, when I saw knee stuff, I almost always went to the hip. I don't know why, just wasn't taught well. All of us did, nobody talked about the feet. Yeah, that was like in every certification that you did that. Yeah, so when I met with him and he just picked me to pieces and the first thing we started with was my feet. And it just made so much sense to me too.  It's like, it's very, I'm serious. That's a T-shirt. Right, we- W-A-F? Yeah.   Here, I'm gonna get Max one that says that. That's actually a cool idea. I'm gonna give him a shirt. Picture of the bottom of his foot, he's got like a six pack. No W-A-F, no W-A-F here, right? It's true though, it really is. And it's actually, I talked on the show, this is a major focus for me with him is because we do, we throw them in shoes very early and then we stay in shoes our whole life. Like we never really develop our feet ever. Unless you're some kid that grew up on the farm and didn't have shoes and ran around the dirt and stuff like that, you probably have pretty developed feet. Everybody else, not so much. And so when you have an area like that that's ground that's responsible for connecting you to this earth and they're weak, you know, they fold in, they roll out, one tilts more than the other. And that's what we get here is you get a foot that collapses inward, pronates in and that ends up knocking the knees and internally rotating the femur and it ends up causing knee pain, hip pain, even low back pain all because of this if we don't address it. And part of the fixing is definitely what Sal said. And then the other part is most likely related to foot stuff and then you need to address it. And all this is in Maps Prime Pro.  I'm really connecting to that and I'm enhancing that stability and that portion of, you know, what I want my leg to stabilize and control. And then I see that in my lift improve.  Yeah, it was such a great experience when we met with Brink because it was in our space, it's fitness and it was something that we were all completely ignorant to. We didn't even know that we didn't know. Yeah. Okay, so it wasn't like, oh, I know the feet but you know, there's some stuff I don't know. I didn't even know to look there. I'd never been taught, never did. Everybody I ever trained wore shoes in the gym. It wasn't an issue. I looked at the hips, knees, elbows. You can see wear and tear on their feet where they're holding the most pressure. It was so crazy because once you started, we started paying attention and understanding. I cannot unsee it now. Now if I see someone in sandals or barefoot or even my own feet, I'm like, wow, they are so deformed because of our shoes and because we never walk barefoot. So it's one of those, it's so many things happen from the feet. Unfortunately in the free webinar that I did, the Prime Pro one, I didn't address feet and risks just because in our Prime Pro program, we address every major joint and it would have been way longer than an hour. Camera zoom on your foot. Yeah, yeah, yeah, yeah. And I don't have, I don't have more. You got the prettiest one ever. I don't know, I don't know. I have a special toe. So I don't know if I have the prettiest feet. I think Doug has the prettiest feet out of all of us.  Oh yeah, they're, Have you been looking at everybody's feet? Yeah, I see everybody's feet. Come on, I'm the guy who paints his toenails. Of course I see everybody's feet, you know what I'm saying? So, but my point was that this is all in Prime Pro. So when you talk about corrective exercises, when we, I mean, two of these questions are related to this, corrective exercises, setting your workout out, priming, assessing, like that's what those programs are all about. Like it's, everybody ideally should own those or have those in their library and utilizing them as either a tool that they intermittently go back to and refer to whenever they have issues or the bare minimum with Prime and assessing yourself so that you can set every workout optimally for yourself.


So I'm here from Lawrence Systems and we're going to talk about WireGuard. Specifically WireGuard and PF Sense but I must preface this video with the fact that this is all beta. I can't express that enough because people keep asking when it's ready and it's ready when it's ready and I don't have any predictions as to the day this will be coming out in full production but the testing process has begun which is really important. It is also important for me to say this is a development beta again because people will start putting this in production and wondering why it doesn't work properly. The point of this beta is to have people do the testing. We have begun the testing here at my office and many others I know have joined in around the world with this and it's definitely exciting but there are bugs they will have to be squashed. There was bugs the day one release which day two release fixed those bugs really happily so this is actually day two of testing but I wanted to give some discussion and cover some of the topics related to WireGuard and PF Sense. This is not going to be a full tutorial. The tutorial will come out once it is not beta. I just want to express that very clearly because I know there will be a lot of questions down below of people asking. Now before we dive on to the details let's first. If you'd like to learn more about me or my company head over to LawrenceSystems.com. If you'd like to hire a short project there's a hires button right at the top. If you'd like to help keep this channel sponsor free and thank you to everyone who already has. There is a join button here for YouTube and a Patreon page. Your support is greatly appreciated. If you're looking for deals or discounts on products and services we offer on this channel check out the affiliate links down below. They're in the description of all of our videos including a link to our shirt store. We have a wide variety of shirts that we sell and new designs come out well randomly so check back frequently. And finally our forums. Forums.LauranceSystems.com is where you can have a more in-depth discussion about this video and other tech topics you've seen on this channel. Now back to our content. Now a quick little background. The Getting Started Building Your Own WireGuard VPN Server. I have an entire breakdown video of that with that right up. So it's all time index and stamped and basically I'm using this to build another digital ocean server. The same premise I used in this video here that I walked through how to build your own WireGuard server to get this system connected with PF Sense. Basically I'm only doing the server side here and I skip the whole Linux client side setup because I'm setting up PF Sense instead. If you are interested in a more in-depth tutorial on WireGuard I do have one. Now this is something I want to cover as well. These are questions that came up with the other WireGuard video I did and of course they're going to come up a lot with PF Sense. Very nice. Do you have any details for support for Second Auth Factor? And this is where Jim P right away calls people out and properly so that this is a misconception with WireGuard. I've said this before about WireGuard is people say oh look how lightweight the code is and how few lines of code and etc etc. The challenge really becomes when you don't have all these extra things like a user management system or a 2FA system that yes there's a lot less code because there's a lot less functionality. I know WireGuard at its core is a very lightweight and easier to configure system but I do want to mention that PF Sense is not building at this time per people at PF Sense a entire extra system on top of it to solve all those missing components that's still kind of being left up to third party. They are doing the kernel integration. Speaking of kernel integration if you want to know how the kernel got integrated into BSD kernel that's something you can think that folks at PF Sense for. They literally funded the development and sponsored it as the term to develop all the kernel functions of the WireGuard in BSD. I just freak to bring it up because people look at NetGate as just some open source company but they literally fund some of these things like that and we all benefit from it because for example other BSD projects can now pull the kernel that was sponsored by NetGate that has the updates for the code for WireGuard and take advantage of it. So just zone it out there something to think about and this is a Reddit post where they announced it along with a blog post etc. You can read through people's questions on here but I will address that there's that's problems not going to be solved. Not by PF Sense I should say and someone's already got their caps lock on and typing tail scale three times. No I don't plan to review it it's a closed source proprietary product that does add though the functions that you're referring to of managing WireGuard versus manually managing WireGuard. So I'm aware of the product I just don't really have a use case for it right now so I don't plan to review it if that changes in the future I'll do a video. Now the PF Sense people have put together a WireGuard thing here they also say it has no facilities for dedication there's no service statement a certain stop there's only minimal logging from the kernel and configuration is placed directly on interfaces it has no concept of connection sessions. Some of these are interesting because as a VPN protocol normally that you look at the handshakes of like open VPN and you have a status of it being up it's a lot different just because of the way WireGuard works it's actually a very quiet protocol with the exception of turning on some keep alive pings if you want them being that it's kernel based it doesn't actually create the traffic until you send a packet across so the moment you send a packet the tunnel's up and when the tunnel goes away the tunnel can go away unless you've told it to stay alive so the next time a packet sent it will then build the tunnel again and it stays up as long as that session is going and any subsequent sessions will go over that tunnel but if the tunnel goes away it can just go quiet and it doesn't really matter pretty neat from protocol standpoint but of course it's going to be confusing from users of course setting up in here now before we dive into this part let's quickly cover the setup so you understand when I ping something where it's located this is a Debian lab test machine at <IP_ADDRESS> it is sitting knatted behind my lab pfSense which has a WAN IP of <IP_ADDRESS> a LAN it's got more than one network interface we're narrowing the scope here to what's relevant to the video <IP_ADDRESS> is it is the IP address that's the NAT for this one that's in the same range and then has a wire guard interface that assigned 10.001 slash 24 it is behind my main pfSense just so people know why the WAN on my lab has a private space IP address and it's going to go out to the public internet and hit my digital ocean server which has a WAN IP of 134.122.135 and then a wire guard of 10.009 now this is just the basics to show that one pfSense can ping it and two the Debian lab can ping it so now that you kind of get the lay of the land here of how these are set up let's look at the settings itself and we'll start here ppn wire guard now when you add a tunnel you can all set up this to receive and be like essentially the endpoint for the wire guard so if you have remote clients promoting in or vice versa it will add peers so we can first build the interface here and then you would add each peer so let's look at the ones we do have here now don't worry about me showing all the interface keys because not this moment but after this video i will regenerate new ones because i've clearly compromised my key exposures that you'll end up seeing in here this is all demo stuff anyways but yes i'm aware so here we have i called it wg and call it whatever you want then we have the address then we have the list import and the interface keys now that sets this up so the if i were to use this as receiving but we actually want this to allow clients to connect to the other end but we build the peer the wg digital ocean peer so wg digital ocean there's a public ip address i've just left it at default port there's the public key allowed ip's we don't have to really fill any of this out but what's confusing is where does it tell you that these tunnels are up or not that is where i know there's going to be a little bit of challenge and you kind of just have to look for yourself because wire guard itself now i think this is something hopefully they do integrate is the wg show command so this is the wire guard vpn demo if i do if config you'll see there's the public ip address right here there's the wire guard address down here and if i do a wg show it shows the peers actually i have more than one thing connected this for the demo but only thing relevant is this top here and yes i blurt out my public ip address but there's the peer and that it's connected and up running and working right now we're going to ssh into the 192 1683.217 this is the lab pf sense and hey look we have this wire guard interface we'll get to that in a second let's go to the shell and let's go ahead and ping 10.9 hey look i can ping it and to kind of get you a better idea we can probably do this and if i think if i run ip ip traffic monitor and we're going to focus on this as i said it's a quiet protocol so only when we do something like we're going to ping it again hey look the digital ocean server can see the traffic what about if we were to ssh to root at 10.9 hey look it sees the ssh coming in from 10.1 are assigned to ip to pf sense and then 10.9 here um i don't have the public key so i get a permission denied and for those of you that may have been asking when you ping 10.9 it automatically adds the zero so i'm actually paying 10.009 one of the reasons on my demos i started using this range because i can cheat and type less numbers makes it easier now when pf sense adds these and you build the wire guard tunnel so far this is the way it's going to work where we have wire guard now i went over here to the interface assignments and before and actually we can do it really quickly we'll go here to wire guard and we'll just add a tunnel enable youtube i will just call it youtube address uh 192 168 518 now nice thing is if you notice it's suggesting that you use 51821 because 51820 was used generate keys save now we didn't add peers because this would be like an inbomb one but now if we go over here to interface assignments hey there's another one i can add now we've already added this one that i called wg digital ocean and for those of you familiar with pf sense uh you know that when you add interfaces go to interfaces then well actually then firewall now that it's an interface we can create rules and apply to it and if we added another interface we could add more rules to that one so now you have this ability to build all these multiple interface in here so for the layout and flow really is feels well integrated into pf sense but i know this is still a demo this is development so there may be changes that come along the way which is why this is not at all considered a full tutorial it's just kind of showing people that it's out there and does work and does function matter of fact you can see the packets sent back and forth right here now overall i'm really liking the way it works it does seem relatively fast for the demos i've done but i'm not at all going to waste my time doing speed tests on a development version because well it's going to be all over the place probably um so i'm not going to bother setting that up until it is in production same thing with as i will repeat once more that i'm not going to do the tutorial until it's in production but i do encourage people who want to get started with this start playing with it uh help with the bugs maybe you'll find some use cases that weren't thought of in some you know or use cases that may be specific to you and you can help out by going hey in this scenario it doesn't really work now things that aren't going to work still dhcp server i know this will come up because this came up a lot in my other wire card view and it's me going back to like they have right here it has no concept of connections or sessions minimal logging etc but it also it's it's not like it's going to solve your dhcp problem you still have to for each one of the peers that you add and all the people you add in there it's not like you can connect this to a user manager it's not like you can just hand this over to a dhcp server um that is just not part of the functionality that pfSense is probably going to solve with wire guard as i mentioned this is something wire guard built like the most minimal level of functionality and let's everyone else build their own things on top of it uh this is you know why wire guard i think will probably replace ipsec tunnels and won't necessarily in the short term replace platforms like open vpn it's not like the end user problem because well i know from connecting to uh directory servers and radius servers that we've worked on projects with pfSense this is a common issue you have 300 users that you need authentication that's dynamic and we need it tied to there are other authentication such as active directory and you can do that with pfSense and you can have an external authorization server that then allows these users to connect not so much with wire guard that is a completely different uh engineering problem at the moment and i mentioned i'm aware of tail scale but there's probably going to be more companies coming along that put things on top of wire guard to solve it but that doesn't appear to be something and i don't really think it's the spot so to speak that pfSense solves this there's a lot of engineering and coding that has to go into this versus something like open vpn where you just it's a facility built in you just have to connect it to the directory servers and that works quite well in pfSense and will continue to be the most popular vpn i believe for uh the foreseeable future for doing mass users but for site to sites yeah i'm excited for wire guard to really come in here and be like this is an easy way to get two sites to talk to each other this is an easy way for me to take a server one behind a nat and one public and great this solves that site to site issue you have where sometimes people have dynamic ip address because this is one of the reasons this demo um i didn't need to set public ip in my lab as long as one of the wire guard and points is there i will be able to do it now in the future like i said i will be doing more videos on it i am actively testing it because before i do videos on things i spend time standing these up testing them tearing them down making sure i understand them because i have to understand them very well to condense it down into a video but of course i'll leave links to this i'll leave links to the wire guard and uh just so we can be clear and exactly which version i'm running because it is january 21st and uh this is make it easier for people to read 2.50a20210120.2350 that is the version i did this test on so if you updated the very first implementation of the experimental that came out um you will have some issues because i i did as well and had to modify code to get it working now they pushed that code change in there that now works as of the one i downloaded just before this video which came out sometime several hours ago and i updated it and like hey it fixed all the other little bugs so um that's why i decided to do a video today to raise awareness uh this is only available once again in the latest development snapshots uh this is not for production use i will say once more um would you run this at home tom yeah i would run this at home i will say that because this is something i'll be experimenting in my lab here and me and myself will probably do some testing by setting up some of our home pf sensors with it because you know hey why not seems like a fun thing to play with um and that's how we learn and that's how we'll get better at it so when this does come to production we'll already be well versed on it all right and thanks and thank you for making it to the end of the video if you like this video please give it a thumbs up if you'd like to see more content from the channel hit the subscribe button and hit the bell icon if you like youtube to notify you when new videos come out if you'd like to hire us head over to laurancesystems.com fill out our contact page and let us know what we can help you with and what projects you'd like us to work together on if you want to carry on the discussion head over to forums.laurancesystems.com where we can carry on the discussion about this video other videos or other tech topics in general even suggestions for new videos they're accepted right there on our forums which are free also if you like to help the channel out in other ways head over to our affiliate page we have a lot of great tech offers for you and once again thanks for watching and see you next time


goes 87 yards and the Titans are on the board. Well it's kind of a long story that starts when I got drafted and when you're sitting there as a rookie you could go anywhere in the country you never know. For me to land in this city that had so much energy and vibrance and just excitement was pretty lucky and I always feel pretty blessed to have been here and so when I hung them up and was ready to move on to the next chapter it was really a no-brainer for me. I really didn't think that anything would get me from coming back to Montana where I was born and raised but this city is so exciting there's so much going on there's so much opportunity that it was a no-brainer.  So when I moved into the Gulch in 2011 there was literally almost nothing here. I think station in was here, Sambuca was here and now you look around and see all the building and all the development and all the restaurants and it's just I could never even have imagined it. It's so much fun. It's fun to be a part of. It's fun to live down here in the action in the chaos and in the madness. It's just it's a good time. I know give it to me. This is E.S. Rose Park. This is where Belmont University plays their baseball and softball and soccer games. It's right above my house and it is such a cool park. It's kind of a hidden gem of the city I would say.  Ready? Come on. Lucy is five and a half years of age which is like mid to late 30s and dog years. The first time I met her she would not leave me alone. She just like I was there to look at her brother and she would not leave me alone and I'll show you the picture for the first time we met and I got suckered in instantly. It was done pretty soon we had a dog and I had been married for a month.


What's up everybody? Jason here for jasperjasecasebrakes.com quick random number block randomizer for the chiefs and national treasurer's pick your team number one of collegiate So there are ten spots in this format guys works just like a random number block break But only for the chiefs cards that come out of pick your team number one. So again everybody gets zero through nine as or as a Example if you get randomized number three block you'll get all teams with three being the first number next to the dash on the left side So for example if a card is 243 out 299 pops off for the chiefs You will get that card if you have block 3 13 out of 99 3 out of 25 43 out of 49 etc that'll all go to the number three block if we get a redemption card It'll automatically go to spot zero even if we know it's a one-on-one in the checklist It'll go to spot zero and any non numbered cards are randomized to the group if there is any but I believe everything And Nt should be numbered so quick randomizer here Here the customer name is Joshua Patrick with two Matt Chris Adam K with two EA with two and John D Got last spot mojo. So there you go Very nice So good luck guys Let's roll it and we got ourselves a four and a one for five times One Two three four five four and a one five times Patrick down to Patrick Five times here zero through nine one two three four five four done in eight um I'm not sure Josh. I'd have to talk to the boss man a Patrick with four Eric with EA Sorry with seven because we're calling you Eric. Yeah EA with three John with the zero last spot.  You have five Matt with nine Christopher with one Joshua you have six and Patrick with eight. So there you go Now we're gonna start in a new video Pikachu number one of Nt and number two is like right there right behind it guys There's only a couple spots left. So appreciate it. Jasper's case brings