News for hackers. Stuff that matters.

dragosion

Learn SQL Podcast - T-SQL Introduction and Installation environment setup S01E01 First video for now https://youtu.be/IjS_FhERBEs

Any feedback is welcomed. I have 19 years of experience working with MSSQL and doing development.

A sneak peek for things to come: DB security and securing applications. Now at the very beginning of installing and showing basic queries.

I'm really sorry for the bad audio. The recorder was using the built-in microphone (on table) instead of the lavalier microphone (on me).... If there is going to be a next episode of this podcast, it will have much better audio.

I try not to ramble too much but can't help it sometimes. I want to show you everything but there are so many things so we leave something for another episode.

Learn SQL From Zero to Hero MSSQL T-SQL Complete Course for DBA and Database Developers.

Learn SQL for beginners starting from zero knowledge all the way to advanced DML and complicated data manipulation for report or data processing. Database administration tips and tricks including database architecture tips and explained relational database normalization and denormalization. SQL and Regex will be your second and third native languages after I'm finished with you haha!

There are so many things to show you. If you have any questions please ask in the videos where you see the details.

Re:Reddit down 502 Bad Gateway on Thursday April 25, 2024 @02:18PM (#40161139)
Have screenshots. user_id missing in monolith index.cjs application....
I sure hope so. No more welcome back with 1 click?
Re:Ask HN: Could you share your personal blog here? on Wednesday July 05, 2023 @11:31AM (#36601812)
https://www.ionhowto.com/

How to fix things around the home car, pc, kitchen.

Whatever I encounter goes on the YouTube channel and some that need extended details reach the website.

Re:Repairing Electronics: A Circular Economy Solution on Thursday June 15, 2023 @06:41AM (#36338612)
This is what makes 80% of my YouTube chnnel.

It's really so satisfying to see someone repairing their phone/shaver/toothbrush and commenting saying thanks for the help. I did some repairs for a few people and the moment the thing works is really what keeps me going.

One was an interesting experiment doing a live stream helping someone do a rtx4090 pc build.

Many thinks have small defects that make the appliance / device unusable yet they are easy to fix at home.

Plastic welds can fix a lot of things around the home.

No access for me I guess
My wife's recipes are ALL tested by me. Multiple times. I even used her recipes to cook myself (rare). Her cooking blog and vlog didn't get any attention other than lots of hate for the Borsch vs Borscht debate and others. Her blog: https://www.rednumberone.com/ Vlog: https://www.youtube.com/@rednumberone1

I really wish she made more of these so I can test interesting food - sacrifice man. Tell her to make more. All made real, all photos are made by her and the videos too.

It takes a lot longer to make a recipe for photos and video. Preparation for photos and video recording gives you a strong reason to make-up recipes 10 / day and hope they go well.

Re:What's wrong with this earthquake survival kit bag on Wednesday February 15, 2023 @08:52AM (#34803767)
I made this last night. What is wrong with it?

In a strong 7+ earthquake as it happened recently in Turkey and Syria.

For staying in and for escape once the quake is finished. What is wrong and what can me improved to increase chances of survival.

Re:I deleted all my GitHub repos on Thursday September 30, 2021 @02:00PM (#28709151)
Would be perfect if they have a filter to replace the real email in past commits also. Should be pretty easy.

Delete is the only real option now as far as I see.

I don't know if any of the other ones do that. It's always good to have a second option.

Re:I deleted all my GitHub repos on Thursday September 30, 2021 @04:42AM (#28704311)
Try to add .patch to one of your commit urls on GitHub. Probably you didn't do the silly mistake I did but some might have.
Re:Problems with Oracle SQL on Friday September 10, 2021 @01:22PM (#28484606)
We need simple 2 line explainers with 10 lines of explainer codes. Show the codes enough fluff and padding. Give the juice.

A wall of text with options and no actual code example that you can try isn't going to help so much.

Options and parameters everywhere.

Linus Torwalds says he uses Fedora. I don't see why you would use Fedora instead of Centos / Oracle Linux / RHEL free dev subscription. Maybe because Fedora gets the cool things first before other get them. For testing.
Re:Ask HN: What's the best Linux distro for fullstack development? on Wednesday September 08, 2021 @12:43PM (#28459618)
I would also like to know anything rhel based.
Re:Show HN: Generate Password and Ctrl+C on Wednesday September 08, 2021 @12:29PM (#28459435)
The Python script is for Windows and Linux. Mac too but not sure. I guess that app is really useful on mac.

It's a literally a double click on a desktop script and the password is ready.

Re:How to Change the Taskbar Size in Windows 11 on Wednesday September 08, 2021 @06:12AM (#28455142)
regedit HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced

TaskbarSi

0 is for the small taskbar 1 for normal size (default) 2 for the big taskbar

Re:Show HN: Generate Password and Ctrl+C on Tuesday September 07, 2021 @12:30PM (#28446707)
I made a script in Python 3. Double click it: Generates a random password using secrets. Copies the password to clipboard. Ready to use. Pretty useful and character sets can be adjusted in the script. Hope it's not too bad.
Re:Check if your PC has TPM 2.0 compatible with Windows 11 on Tuesday September 07, 2021 @04:52AM (#28442512)
How to tell if pc has tpm 2.0 compatible with Windows 11 requirements.

Windows 11 requires TPM 2.0 or it will not install. Other software vendors might follow Microsoft allowing only their software to run only on tmp 2.0 enabled computers. Secure boot and TPM 2.0 might soon become a requirement for many programs.

TPM 2.0 stands for Trusted Platform Module 2.0 and the tpm chip can be used for encryption and the BitLocker.