APileofRocks

Did tech culture just begin to care about e-waste? Last time I tuned in, it was all about "UPGRADE UPGRADE UPGRADE" every 6 months.
 
I do agree with the philosophy of Reduce, Reuse, and Recycle and I practice it - but it seems that this kind of criticism comes from one side of the mouth, while careless consumerism comes out the other, least until the issue has gotten bad enough.
 
I know Linus is being genuine, but the pedantic nit-picking of companies for using single-use plastic bags for zip ties isn't going to get much done. People need to vote with their wallet and, - as in Linus' case - their influence. Good video overall, it's just frustrating to see this make headway into the culture and no-one actually act on it.
 
I would 100% agree more people need to actually practice the 3 R's. If done at a large enough scale, we could see this affect e-waste in a positive manner. Idealistic, sure - but that's the way this gets done.

I do agree that right now this is the reality, but have to disagree on gov't regulations being the answer. Regulations come and go, and serve as artificial caps on what a company can do for a time. Main issue with that solution is that people by and large see the regulations as acts of gov't, not themselves, and that disconnect causes people to also disconnect from the consequences of contributing to the problem. These kinds of cultural shifts take generations to occur, but have happened in the past for other large issues, so I don't generally take a pessimistic outlook on the long-term outcome of this.

Did tech culture just begin to care about e-waste? Last time I tuned in, it was all about "UPGRADE UPGRADE UPGRADE" every 6 months.
 
I do agree with the philosophy of Reduce, Reuse, and Recycle and I practice it - but it seems that this kind of criticism comes from one side of the mouth, while careless consumerism comes out the other, least until the issue has gotten bad enough.
 
I know Linus is being genuine, but the pedantic nit-picking of companies for using single-use plastic bags for zip ties isn't going to get much done. People need to vote with their wallet and, - as in Linus' case - their influence. Good video overall, it's just frustrating to see this make headway into the culture and no-one actually act on it.
 
I would 100% agree more people need to actually practice the 3 R's. If done at a large enough scale, we could see this affect e-waste in a positive manner. Idealistic, sure - but that's the way this gets done.

I agree that there is a lot of work to be done in tackling the e-waste issue. And while the upgrade mentality definitely doesn't help, I don't think the desktop PC parts is the worst offender. Yes, there are a lot of people that purchase the newest GPUs right when the come out. But for everyone of those people there are people buying used cards on eBay, I have on several occasions. At the end of the day lots of people just can't afford to buy new. I think the "upgrade" culture is worse in industries such as smartphones, where they have a significantly more limited secondhand lifespan (if one at all).
 
Pushing companies to not use single use plastics is just helping the overall cultural shift, it's still a good thing even if its actual effect is small at the time.

In your original statement "DELETE FROM expense_sheet where oid = delete_entry.get()", delete_entry.get() is not evaluated since it is inside of the string. So you would have to concatenate whatever delete_entry.get() evaluates to with the first part of the statement: "DELETE FROM expense_sheet WHERE oid = " + str(delete_entry.get()). 
 
However, like I mentioned, this is vulnerable to SQL injection. Since delete_entry comes from an input box, someone might enter "5; DROP TABLE expense_sheet;" In which case, the SQL statement becomes "DELETE FROM expense_sheet WHERE oid = 5; DROP TABLE expense_sheet;" There goes all your data. 
 
The ? represents where you want to substitute a value into the statement. You pass in values as a tuple (delete_entry.get(),) as the second argument to execute and you can pass in as many as you want (provided you have the same number of "?" placeholders in the statement). In this case, since it is a single value, you need the trailing comma to disambiguate between it being a tuple or an expression.
(delete_entry.get(),) This is a tuple (delete_entry.get()) This is not Basically instead of sending one SQL command to the server (being the pre formatted string you were originally intending to pass in), it will first send the SQL statement template (DELETE FROM expense_sheet WHERE oid =?) to the database and then it will send the parameters and evaluate the statement. As a result, the SQL injection does not occur, even with bad input like above. 

Just as an additional note I would advise getting in to SQL profiling and look at the queries that are being run and the breakdown of runtime to see where the largest portions of time is spent and why. Throwing raw hardware power doesn't always get the gains you want or expect so just be careful of a let down, even if not now in a year or so when there is more data and more rows and it slows down again. Not that is will definitely happen but it's a good area to get skilled in regardless.
 
SQL query latency also responds very well to clock speed, most CPU configurations are able to hit the same total queries per second but if you drill down to that query latency it can be as much as half with a CPU that can hit high sustained and boost clocks. I had a good review showing this but a while ago but lost the link. That said the current 'best' MSSQL CPU would be the Xeon 6256 but that is a little pricey, The 6226R you are looking at is fine, the only areas I don't like about it is the much smaller L3 cache and the lower all core and peak boost clocks (it's a 150W TDP part). 6242R and 6246R would be better but both are WAY more expensive, 6242R would also benefit from tuning max parallelism but everything does tbh, if you need to get down to the sort of tuning.
 
Your storage not being hit very hard could also be a sign that your database file/filegroups aren't optimal and is limiting your performance. If you are lucky your database already has the required columns in your tables and you could do something like place each year in their own table partition and file then you'll have much greater usable storage I/O. Unless you are able to split your database in to multiple files you're actually a bit I/O limited, there are different ways to do this but anyway single mdf on a large database doesn't scale well but on the other hand it may not be possible to split data out so that is where NVMe etc come in.
 
Getting the absolute maximum performance out of MSSQL VMs is still a bit of a pain so our larger clusters are actually still baremetal OS using clustering. Our databases sit on all flash Netapp arrays connected using multipath iSCSI. We haven't actually had to yet do much database file partitioning on our physical clusters but on our SQL VMs we have, this is due to how ESXi handle disk I/O and command queues so I would advise looking in to VMware ESXi SQL optimization best practices. Basically you end up with multiple SCSI controllers and virtual disks being split across those and you do actually get way better disk performance.

That's such a generic cop-out, though. Like, really? You don't have anything you have picked up in your lives that you wish someone would have told you? Nobody, at any point in your lives, gave you a nugget of wisdom that you took to heart? Nobody did something that made you think twice about yourselves and consider doing things differently?
 
Some advice that I've acquired, either learned, or passed on.
Dealing with others:
Respect everyone by default. Let them give you a reason to lose or keep that respect. Feel free to cut people out of your life if they are toxic. This includes family. Always give people a chance to prove that they have changed/grown. People develop at different paces, never assume someone knows what you know and vice versa. If you do a kind thing for someone, never expect anything in return. Also, do not hold that over them. Good deeds are not a savings account. Never humiliate your opponent once you've won, in a fight or an argument. Let it end. Also, if you lose, take the loss graciously. Don't pick a fight you know you can easily win. That's being a bully. Nobody is perfect, don't expect them to be. Dealing with yourself:
Nobody is perfect, don't expect it of yourself. Learn a good story, and a dirty joke, and know when to tell which. Never underestimate the power of a good bath. Under promise and over deliver. Keep your promises. No excuses. Be aware of yourself. Your demeanor, your speech, your tics. Let yourself ask for help. Nobody gets through life alone. Don't try to be the first. Be open to criticism. Volunteer at least once. Travel beyond your county/state/province at least once. Treat yourself once in a while. You are your own worst critic, so you probably deserve it well before you feel you do. It's okay to not know everything about anything. When you are conversing, make it clear that something is 'what you remember', or 'how you understand it'. Be open to being wrong. Its how we learn. Read at least 2 books per year. Audio books count. Watch a film in theater at least once a year. Buy at least one good suit, and two pairs of good shoes.  
These may seem cliche, or 'old school', but I've tried to adhere to them. And I feel like they are good pieces of advice.

British educational youtuber Tom Scott has released a video about common claims made in VPN sponsorship segments.
 
 
Video summary:
You don't need a VPN to hide your password these days since SSL encryption is used almost everywhere. "Military-grade encryption" is what SSL uses as well. Not a wrong claim, but misleading. Your ISP can see what domain names you request, which is something you might want to hide with a VPN. But what they can't see is the whole URL. VPN providers can be compromised by hackers or governments as well. They are great for circumventing geo-blocking and piracy though, but you can't really advertise with that. Originally, this video was sponsored by a VPN provider, but they dropped it last second. tl;dr: VPNs are not a general necessity because of SSL
 
I'm not posting this here as an attack on LTT or anything like that, and I'm aware that many of you will already know most of this. I'm just seeing a lot of channels with less of a tech-focused audience (and owners) do actual scare-mongering that it makes me glad that this easy to understand counterpoint exists.

Nevermind, I saw your speaker's are powered. The cheapest thing I can think of is the Emotiva MC-700
https://emotiva.com/collections/processors/products/mc-700

the only thing I would recommend is if you never experienced a projector then stop at a bestbuy and just walk into one of their demo rooms that has one.

Projectors are good if you need to pack A LOT of people around one screen. But if you're only expecting maybe 4 -6 people I would highly recommend a large tv instead. 4k Projectors cost several times more than a 4k tv and typically don't look as good , but you trade slight visual quality for the shear size of the image it can make. You also need a lot of darkness in a room to get the most out of a projector while a tv can work during a daylit room just fine

thats my 2cents but theres a ton of projector video on youtube and linus has some too

A number of nicer cars actually do use a form of active noise cancelling to help block out outside noise in general. That being said, wind noise generally isn't a huge issue on most modern cars, so there's that.

If you have no experience with Python, start with the Python basics. Then move on to web frameworks.
 
Going directly to coding web backend would be a lot more challenging and difficult if you don't know the basics.

Well... an algorithm is just a procedure to do something, they're not inherently tied to any language or framework. You can make your Django website do anything you want (within the confines of what a website can do) if that's what you're asking.

If you haven't watched Supernatural I recommend it. Whole series is on Netflix. I put off watching it for a while, thinking I wouldn't be a fan. First 5 seasons are 110% awesome, so far the next few seasons are good but more like a 80-90% range of awesome. Just started Season 8 myself.

coding is probably the hardest thing Ie every tried to tackle in my life. But I will stick to it

Cloud computing, in short, is just shifting from me owning and maintaining my hardware to AWS/Azure/GCP owning the hardware and also providing other software services. So what it enables is an easy startup cost to get going. And you have the ability to scale horizontally and vertically in a very dynamic way. So yeah, its probably here to stay.

In terms of the security side of things, it is my opinion that AWS/Azure/GCP is way more secure, on average, than maintaining your own data center. Albeit it depends on other factors as well (who configured the thing, etc).

I honestly can't think of any job in IT that I can see being replaced anytime soon.
 
Network and infrastructure are always going to be hugely important for companies of all sizes. No trend or advancement is suddenly going to eliminate the requirement for a local infrastructure of some sort, and of course that means there will also be a need for people to secure, maintain and extend that network. Is there any specific reasoning as to why you think it's going downhill?

Okay, I figured it out, sorry for the quick turnaround, but if anyone needs the info for future reference:
Select P.ProductModelID, P.Name, CAST(((P.ListPrice - P.StandardCost)/P.StandardCost) AS DECIMAL(18,2)) AS ProfitMargin From Production.Product P Left JOIN Production.ProductSubcategory PS ON P.ProductSubcategoryID = PS.ProductSubcategoryID Right Join Production.ProductCategory PC ON PC.ProductCategoryID = PS.ProductCategoryID Where PC.ProductCategoryID = 1 ORDER BY ProfitMargin DESC  

Then SQLLite is probably simpler. And yes a simple usb wand will read the most common barcodes. Company don't tend to pay for the different barcode types so they use the generic most common ones and all wands should read those. Bookstore dont make that much money to put into simple thing like barcode so they are simple sticker. BTW since you know C#, if they need barcode sticker because a book dont have for some reasons you can use free of charge Crystal report to generate barcodes as it come with the most generic barcode fonts. If they dont want to pay for label printer you can print on normal paper, cut to size and use packing tape or whatever to stick into the book or back cover.

First off, hello LTT community! I've only recently found LTT and have already learned SOOO much. I actually have a build to post in one of the other forum threads, that i was able to save and bring back to life because of what i have learned just from the Youtube channel. i'm hoping to learn even more here.
So onto the question, I'm very knew to programming, I'm still learning Python from the ground up. I've been VERY briefly exposed to C# and now I'm dabbling in SQL. i want my first large program to be a book inventory program. there's a local bookstore in my area with absolutely no inventory list,(they get books by donation or buy them in bulk from liquidation sales). so i figured i would help myself out learning to program, and help out a local business. the program would need to be able to scan the barcodes of books and retrieve information from online. (i know how to access an excel file in python but thats all the further i've gotten, i have no idea how to link the internet into a program yet.) then be able to store the books in a database so that the cashier could type in an author or book title and see if they have it. 
any ideas on how to get started and how to even approach this would be hugely appreciated. 

Bump.
 
I personally know nothing about programming, but I commend you for helping local business with your (eventual) knowledge! 

If they don't have a wand those ranges between 20$-40$ for a simple usb one.
 
The database store the data. The program just read from database, display data, manipulate the data, save to database. You need to pick a database and build the tables and query system around it.
 
You can code every interaction without any visual interface.
 
There are some challenges as to how the Database will work if you have many times the same book with same ISBN or Same title but newer publication. Tracking count of how many of which are in store, where are they and who has which one will be the biggest challenge. IF you want to track who you bought the book from or things like that, the uniqueness of the book will need to be specific to the case scenario you need.
 
First thing first you need to know what they have, What they would need, How they work, What they like and what they don't like about their current way of working. A software need to fix a problem or many problems. Find the needs and fill them. So you will need a sit down with them, that's the PR/Analyst part. Don't forget most people are not tech savvy, they won't understand your "programming" terms. Use simple terms and try to keep it "procedure" oriented. Make question like :
 
If you want to find a book what information can you be looking for ?
What are the most important / common out of those ?
Once you know which book you are looking for what do you in order to have the book in your hands ? Determined the category and get to X/Y shelve ?
 
You see those are not programming terms but with things like that i can know all searchable fields, i know the best indexable one for quick search, i know the most likely to be searched field so UI i can put those first, i know what info to display once i found the book outside the book info like the location in the store for example.

For database you will need a small efficient database. Probably MySQL or SQLLite.
 
For barcode scan the device is called a wand. Usually it's usb and when you scan it send keypress like a keyboard of all the converted characters. If you have a focus in a textbox and click to scan you will see what the barcode represents. Usually it's an ID of some sort like ISBN or database id of the item. Generating Barcode is done with a special font. There are quite a lot but there is 3-4 very popular one. You need to make sure your wand can decode the one you want. Wands usually support a plethora of barcode.

I don't find just going to a course is helpful. You're learning without purpose. Who cares what polymorphism is if you don't have an idea how it plays out when it is applied?
 
Find some project and see it from start to finish. Learn everything you need to do to finish that project.

I would recommend a "will-driven" approach to get started.  Come up with something you want to make that you're really passionate about.  Be reasonable, don't go for a AAA game right off the bat - make it something simple like tic-tac-toe.  Start by looking up the most basic program in your language of choice ("hello world"), and some of the syntax for basic structures like output, if, for, etc.  Then simply look up additional things as needed as you expand the project and make it more complex.  Your needs will guide you to the necessary information.
 
After you've done this with several programs and are comfortable with the basics, that's when I'd recommend starting to read some documentation and more advanced theory to fill out your knowledge and make sure there are no gaps, as well as expand into more complex topics.  I'd recommend not starting with this though because you won't be motivated and you won't have any context for how things actually work, what's important at this stage, etc.